1CREATE TABLE users ( 2 fname text not null, 3 lname text not null, 4 username text, 5 userid serial, 6 PRIMARY KEY(lname, fname) 7 ) ; 8 9CREATE INDEX users_username_idx ON users(username); 10CREATE INDEX users_fname_idx ON users(fname); 11CREATE INDEX users_lname_idx ON users(lname); 12CREATE INDEX users_userid_idx ON users(userid); 13 14 15CREATE TABLE taxonomy ( 16 id serial primary key, 17 name text unique 18 ) ; 19 20CREATE TABLE entry ( 21 accession text not null primary key, 22 eid serial unique, 23 txid int2 not null references taxonomy(id) 24 ) ; 25 26CREATE TABLE sequences ( 27 eid int4 not null references entry(eid), 28 pid serial primary key, 29 product text not null, 30 sequence text not null, 31 multipart bool default 'false' 32 ) ; 33CREATE INDEX sequences_product_idx ON sequences(product) ; 34 35CREATE TABLE xsequences ( 36 pid int4 not null references sequences(pid), 37 sequence text not null 38 ) ; 39CREATE INDEX xsequences_pid_idx ON xsequences(pid) ; 40