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

0 vote289 views1 answer
Implicit inner join table alias
SQL
0 vote274 views1 answer
Regex mongoose
SQL
0 vote297 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote268 views1 answer
Comma seperated join mssql
SQL
0 vote292 views4 answers
First max salary in sql
SQL
10 votes269 views2 answers
Sql merge statement
SQL
2 votes285 views2 answers
Sql percentage
SQL
93 votes370 views4 answers
Create database postgres
SQL
1 vote287 views1 answer
Alter add syntax
SQL
1 vote271 views1 answer
Get rows affected mysql python
SQL