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

20 votes333 views6 answers
Creating a table in sql
SQL
2 votes313 views3 answers
Postgres remove foreign key constraint
SQL
8 votes328 views2 answers
Grant all privileges database postgres to user
SQL
0 vote410 views1 answer
Sqlite display headers on columns
SQL
0 vote340 views1 answer
Search In the Database using Text
SQL
1 vote352 views1 answer
Drop primary key oracle
SQL
1 vote349 views1 answer
Pl sql create table from another table
SQL
0 vote315 views1 answer
Mysql date time string format python
SQL
0 vote325 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
1 vote346 views1 answer
Oracle sql first day of year
SQL