Sqlite unique multiple columns

create table projects (
    _id integer primary key autoincrement,
    project_type text not null,
    name text not null,
    description text,
    last_updated datetime default current_timestamp,
    date_created datetime default current_timestamp,
    unique (project_type, name)
);

Similar codes

3 votes152 views1 answer
Only join in sql
SQL
0 vote149 views1 answer
Oracle gather table statistics
SQL
2 votes178 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
16 votes151 views3 answers
Delete row psql
SQL
0 vote155 views2 answers
Sql auto update dupdated_at
SQL
0 vote153 views1 answer
How to use query in nosql
SQL
1 vote187 views1 answer
Sql where max date
SQL
0 vote166 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
1 vote148 views1 answer
Sql only five first row
SQL
2 votes149 views1 answer
Sql to char function with date
SQL