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

1 vote397 views1 answer
Sql random sampling per group
SQL
0 vote378 views1 answer
000webhost database values insert
SQL
0 vote360 views1 answer
Teller stamp , bmo , PDF
SQL
3 votes394 views6 answers
DB::table('users')->get();
SQL
0 vote379 views3 answers
CONTACT FORM SQL
SQL
1 vote377 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote377 views1 answer
Python sql last insertend
SQL
6 votes439 views2 answers
Install psql mac
SQL
0 vote341 views2 answers
Null value in column violates not-null constraint
SQL
0 vote371 views1 answer
Firebase sql
SQL