6
PRIMARY KEY(lname, fname)
8
NOTICE: CREATE TABLE will create implicit sequence "users_userid_seq" for serial column "users.userid"
9
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"
10
CREATE INDEX users_username_idx ON users(username);
11
CREATE INDEX users_fname_idx ON users(fname);
12
CREATE INDEX users_lname_idx ON users(lname);
13
CREATE INDEX users_userid_idx ON users(userid);
14
CREATE TABLE taxonomy (
15
id serial primary key,
18
NOTICE: CREATE TABLE will create implicit sequence "taxonomy_id_seq" for serial column "taxonomy.id"
19
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "taxonomy_pkey" for table "taxonomy"
20
NOTICE: CREATE TABLE / UNIQUE will create implicit index "taxonomy_name_key" for table "taxonomy"
22
accession text not null primary key,
24
txid int2 not null references taxonomy(id)
26
NOTICE: CREATE TABLE will create implicit sequence "entry_eid_seq" for serial column "entry.eid"
27
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "entry_pkey" for table "entry"
28
NOTICE: CREATE TABLE / UNIQUE will create implicit index "entry_eid_key" for table "entry"
29
CREATE TABLE sequences (
30
eid int4 not null references entry(eid),
31
pid serial primary key,
32
product text not null,
33
sequence text not null,
34
multipart bool default 'false'
36
NOTICE: CREATE TABLE will create implicit sequence "sequences_pid_seq" for serial column "sequences.pid"
37
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sequences_pkey" for table "sequences"
38
CREATE INDEX sequences_product_idx ON sequences(product) ;
39
CREATE TABLE xsequences (
40
pid int4 not null references sequences(pid),
41
sequence text not null
43
CREATE INDEX xsequences_pid_idx ON xsequences(pid) ;