From: Scott C. <sco...@us...> - 2007-01-15 16:26:16
|
Update of /cvsroot/gmod/schema/chado/modules In directory sc8-pr-cvs2.sourceforge.net:/tmp/cvs-serv23449/modules Modified Files: default_nofuncs.sql default_schema.sql nofuncs.html Log Message: updating for new stock module Index: default_schema.sql =================================================================== RCS file: /cvsroot/gmod/schema/chado/modules/default_schema.sql,v retrieving revision 1.42 retrieving revision 1.43 diff -C2 -d -r1.42 -r1.43 *** default_schema.sql 21 Nov 2006 16:12:19 -0000 1.42 --- default_schema.sql 15 Jan 2007 16:25:57 -0000 1.43 *************** *** 5281,5284 **** --- 5281,5541 ---- CREATE INDEX affymetrixprobesetstat_idx7 ON affymetrixprobesetstat (sd); CREATE INDEX affymetrixprobesetstat_idx8 ON affymetrixprobesetstat (n); + -- ============ + -- Stock Module + -- + -- DEPENDENCIES + -- ============ + -- :import cvterm from cv + -- :import pub from pub + -- :import dbxref from general + -- :import organism from organism + -- :import genotype from genetic + + -- ================================================ + -- TABLE: stock + -- ================================================ + -- Any stock can be globally identified by the combination of organism, uniquename and stock type. + -- A stock is the physical entities, either living or preserved, held by collections. Stocks belong to a collection; they have IDs, type, organism, description and may have a genotype. + -- The dbxref_id is an optional primary stable identifier for this stock. Secondary indentifiers and external dbxrefs go in table: stock_dbxref. + -- The organism_id is the organism to which the stock belongs. This column is mandatory. + -- The type_id foreign key links to a controlled vocabulary of stock types. The would include living stock, genomic DNA, preserved specimen. Decondary cvterms for stocks would go in stock_cvterm. + -- The description is the genetic description provided in the stock list. + -- The name is a human-readable local name for a stock. + + create table stock ( + stock_id serial not null, + primary key (stock_id), + dbxref_id int, + foreign key (dbxref_id) references dbxref (dbxref_id) on delete set null INITIALLY DEFERRED, + organism_id int not null, + foreign key (organism_id) references organism (organism_id) on delete cascade INITIALLY DEFERRED, + name varchar(255), + uniquename text not null, + description text, + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, + is_obsolete boolean not null default 'false', + constraint stock_c1 unique (organism_id,uniquename,type_id) + ); + create index stock_name_ind1 on stock (name); + create index stock_idx1 on stock (dbxref_id); + create index stock_idx2 on stock (organism_id); + create index stock_idx3 on stock (type_id); + create index stock_idx4 on stock (uniquename); + + -- ================================================ + -- TABLE: stock_pub + -- ================================================ + -- Provenance. Linking table between stocks and for example a stocklist computer file. + + create table stock_pub ( + stock_pub_id serial not null, + primary key (stock_pub_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + pub_id int not null, + foreign key (pub_id) references pub (pub_id) on delete cascade INITIALLY DEFERRED, + constraint stock_pub_c1 unique (stock_id,pub_id) + ); + create index stock_pub_idx1 on stock_pub (stock_id); + create index stock_pub_idx2 on stock_pub (pub_id); + + -- ================================================ + -- TABLE: stockprop + -- ================================================ + -- A stock can have any number of slot-value property tags attached to it. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible. + -- Unique index stockprop_c1 for any one stock, multivalued property-value pairs must be differentiated by rank. + create table stockprop ( + stockprop_id serial not null, + primary key (stockprop_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, + value text null, + rank int not null default 0, + constraint stockprop_c1 unique (stock_id,type_id,rank) + ); + create index stockprop_idx1 on stockprop (stock_id); + create index stockprop_idx2 on stockprop (type_id); + + -- ================================================ + -- TABLE: stockprop_pub + -- ================================================ + -- Provenance. Any stockprop assignment can optionally be supported by a publication. + + create table stockprop_pub ( + stockprop_pub_id serial not null, + primary key (stockprop_pub_id), + stockprop_id int not null, + foreign key (stockprop_id) references stockprop (stockprop_id) on delete cascade INITIALLY DEFERRED, + pub_id int not null, + foreign key (pub_id) references pub (pub_id) on delete cascade INITIALLY DEFERRED, + constraint stockprop_pub_c1 unique (stockprop_id,pub_id) + ); + create index stockprop_pub_idx1 on stockprop_pub (stockprop_id); + create index stockprop_pub_idx2 on stockprop_pub (pub_id); + + -- ================================================ + -- TABLE: stock_relationship + -- ================================================ + -- stock_relationship.subject_id is the subject of the subj-predicate-obj sentence. This is typically the substock. + -- stock_relationship.object_id is the object of the subj-predicate-obj sentence. This is typically the container stock. + -- stock_relationship.type_id is relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed. + -- stock_relationship.rank is the ordering of subject stocks with respect to the object stock may be important where rank is used to order these; starts from zero. + -- stock_relationship.value is Additional notes/comments. + + create table stock_relationship ( + stock_relationship_id serial not null, + primary key (stock_relationship_id), + subject_id int not null, + foreign key (subject_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + object_id int not null, + foreign key (object_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, + value text null, + rank int not null default 0, + constraint stock_relationship_c1 unique (subject_id,object_id,type_id,rank) + ); + create index stock_relationship_idx1 on stock_relationship (subject_id); + create index stock_relationship_idx2 on stock_relationship (object_id); + create index stock_relationship_idx3 on stock_relationship (type_id); + + -- ================================================ + -- TABLE: stock_relationship_pub + -- ================================================ + -- stock_relationship_pub Provenance. Attach optional evidence to a stock_relationship in the form of a publication. + + create table stock_relationship_pub ( + stock_relationship_pub_id serial not null, + primary key (stock_relationship_pub_id), + stock_relationship_id int not null, + foreign key (stock_relationship_id) references stock_relationship (stock_relationship_id) on delete cascade INITIALLY DEFERRED, + pub_id int not null, + foreign key (pub_id) references pub (pub_id) on delete cascade INITIALLY DEFERRED, + constraint stock_relationship_pub_c1 unique (stock_relationship_id,pub_id) + ); + create index stock_relationship_pub_idx1 on stock_relationship_pub (stock_relationship_id); + create index stock_relationship_pub_idx2 on stock_relationship_pub (pub_id); + + -- ================================================ + -- TABLE: stock_dbxref + -- ================================================ + -- stock_dbxref links a stock to dbxrefs. This is for secondary identifiers; primary identifiers should use stock.dbxref_id. + -- stock_dbxref.is_current the is_current boolean indicates whether the linked dbxref is the current -official- dbxref for the linked stock. + + create table stock_dbxref ( + stock_dbxref_id serial not null, + primary key (stock_dbxref_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + dbxref_id int not null, + foreign key (dbxref_id) references dbxref (dbxref_id) on delete cascade INITIALLY DEFERRED, + is_current boolean not null default 'true', + constraint stock_dbxref_c1 unique (stock_id,dbxref_id) + ); + create index stock_dbxref_idx1 on stock_dbxref (stock_id); + create index stock_dbxref_idx2 on stock_dbxref (dbxref_id); + + -- ================================================ + -- TABLE: stock_cvterm + -- ================================================ + -- stock_cvterm links a stock to cvterms. This is for secondary cvterms; primary cvterms should use stock.type_id. + + create table stock_cvterm ( + stock_cvterm_id serial not null, + primary key (stock_cvterm_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + cvterm_id int not null, + foreign key (cvterm_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, + pub_id int not null, + foreign key (pub_id) references pub (pub_id) on delete cascade INITIALLY DEFERRED, + constraint stock_cvterm_c1 unique (stock_id,cvterm_id,pub_id) + ); + create index stock_cvterm_idx1 on stock_cvterm (stock_id); + create index stock_cvterm_idx2 on stock_cvterm (cvterm_id); + create index stock_cvterm_idx3 on stock_cvterm (pub_id); + + -- ================================================ + -- TABLE: stock_genotype + -- ================================================ + -- simple table linking a stock to a genotype + -- features can with genotypes can be linked to stocks thru feature_genotype -> genotype -> stock_genotype -> stock + + create table stock_genotype ( + stock_genotype_id serial not null, + primary key (stock_genotype_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade, + genotype_id int not null, + foreign key (genotype_id) references genotype (genotype_id) on delete cascade, + constraint stock_genotype_c1 unique (stock_id, genotype_id) + ); + create index stock_genotype_idx1 on stock_genotype (stock_id); + create index stock_genotype_idx2 on stock_genotype (genotype_id); + + -- ================================================ + -- TABLE: stockcollection + -- ================================================ + -- stockcollection The lab or stock center distributing the stocks in their collection. + --uniqename is the value of the collection_FBcv + --type_id is the collection_type_FBcv + --name is the collection + --contact_id links to the contact info for the collection. + + create table stockcollection ( + stockcollection_id serial not null, + primary key (stockcollection_id), + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id) on delete cascade, + contact_id int null, + foreign key (contact_id) references contact (contact_id) on delete set null INITIALLY DEFERRED, + name varchar(255), + uniquename text not null, + constraint stockcollection_c1 unique (uniquename,type_id) + ); + create index stockcollection_name_ind1 on stockcollection (name); + create index stockcollection_idx1 on stockcollection (contact_id); + create index stockcollection_idx2 on stockcollection (type_id); + create index stockcollection_idx3 on stockcollection (uniquename); + + -- ================================================ + -- TABLE: stockcollectionprop + -- ================================================ + -- The table stockcollectionprop contains the value of the stockcollection such as website/email URLs; the value of the stockcollection order URLs. + -- The cv for the type_id is 'stockcollection property type' + + create table stockcollectionprop ( + stockcollectionprop_id serial not null, + primary key (stockcollectionprop_id), + stockcollection_id int not null, + foreign key (stockcollection_id) references stockcollection (stockcollection_id) on delete cascade INITIALLY DEFERRED, + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id), + value text null, + rank int not null default 0, + constraint stockcollectionprop_c1 unique (stockcollection_id,type_id,rank) + ); + create index stockcollectionprop_idx1 on stockcollectionprop (stockcollection_id); + create index stockcollectionprop_idx2 on stockcollectionprop (type_id); + + -- ================================================ + -- TABLE: stockcollection_stock + -- ================================================ + -- stockcollection_stock links a stockcollection to the stocks which are contained in the collection. + + create table stockcollection_stock ( + stockcollection_stock_id serial not null, + primary key (stockcollection_stock_id), + stockcollection_id int not null, + foreign key (stockcollection_id) references stockcollection (stockcollection_id) on delete cascade INITIALLY DEFERRED, + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + constraint stockcollection_stock_c1 unique (stockcollection_id,stock_id) + ); + create index stockcollection_stock_idx1 on stockcollection_stock (stockcollection_id); + create index stockcollection_stock_idx2 on stockcollection_stock (stock_id); -- VIEW gffatts: a view to get feature attributes in a format that -- will make it easy to convert them to GFF attributes Index: default_nofuncs.sql =================================================================== RCS file: /cvsroot/gmod/schema/chado/modules/default_nofuncs.sql,v retrieving revision 1.18 retrieving revision 1.19 diff -C2 -d -r1.18 -r1.19 *** default_nofuncs.sql 29 Dec 2006 16:26:08 -0000 1.18 --- default_nofuncs.sql 15 Jan 2007 16:25:57 -0000 1.19 *************** *** 2714,2715 **** --- 2714,2972 ---- COMMENT ON TABLE studyfactorvalue IS NULL; + -- ============ + -- Stock Module + -- + -- DEPENDENCIES + -- ============ + -- :import cvterm from cv + -- :import pub from pub + -- :import dbxref from general + -- :import organism from organism + -- :import genotype from genetic + + -- ================================================ + -- TABLE: stock + -- ================================================ + -- Any stock can be globally identified by the combination of organism, uniquename and stock type. + -- A stock is the physical entities, either living or preserved, held by collections. Stocks belong to a collection; they have IDs, type, organism, description and may have a genotype. + -- The dbxref_id is an optional primary stable identifier for this stock. Secondary indentifiers and external dbxrefs go in table: stock_dbxref. + -- The organism_id is the organism to which the stock belongs. This column is mandatory. + -- The type_id foreign key links to a controlled vocabulary of stock types. The would include living stock, genomic DNA, preserved specimen. Decondary cvterms for stocks would go in stock_cvterm. + -- The description is the genetic description provided in the stock list. + -- The name is a human-readable local name for a stock. + + create table stock ( + stock_id serial not null, + primary key (stock_id), + dbxref_id int, + foreign key (dbxref_id) references dbxref (dbxref_id) on delete set null INITIALLY DEFERRED, + organism_id int not null, + foreign key (organism_id) references organism (organism_id) on delete cascade INITIALLY DEFERRED, + name varchar(255), + uniquename text not null, + description text, + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, + is_obsolete boolean not null default 'false', + constraint stock_c1 unique (organism_id,uniquename,type_id) + ); + create index stock_name_ind1 on stock (name); + create index stock_idx1 on stock (dbxref_id); + create index stock_idx2 on stock (organism_id); + create index stock_idx3 on stock (type_id); + create index stock_idx4 on stock (uniquename); + + -- ================================================ + -- TABLE: stock_pub + -- ================================================ + -- Provenance. Linking table between stocks and for example a stocklist computer file. + + create table stock_pub ( + stock_pub_id serial not null, + primary key (stock_pub_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + pub_id int not null, + foreign key (pub_id) references pub (pub_id) on delete cascade INITIALLY DEFERRED, + constraint stock_pub_c1 unique (stock_id,pub_id) + ); + create index stock_pub_idx1 on stock_pub (stock_id); + create index stock_pub_idx2 on stock_pub (pub_id); + + -- ================================================ + -- TABLE: stockprop + -- ================================================ + -- A stock can have any number of slot-value property tags attached to it. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible. + -- Unique index stockprop_c1 for any one stock, multivalued property-value pairs must be differentiated by rank. + create table stockprop ( + stockprop_id serial not null, + primary key (stockprop_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, + value text null, + rank int not null default 0, + constraint stockprop_c1 unique (stock_id,type_id,rank) + ); + create index stockprop_idx1 on stockprop (stock_id); + create index stockprop_idx2 on stockprop (type_id); + + -- ================================================ + -- TABLE: stockprop_pub + -- ================================================ + -- Provenance. Any stockprop assignment can optionally be supported by a publication. + + create table stockprop_pub ( + stockprop_pub_id serial not null, + primary key (stockprop_pub_id), + stockprop_id int not null, + foreign key (stockprop_id) references stockprop (stockprop_id) on delete cascade INITIALLY DEFERRED, + pub_id int not null, + foreign key (pub_id) references pub (pub_id) on delete cascade INITIALLY DEFERRED, + constraint stockprop_pub_c1 unique (stockprop_id,pub_id) + ); + create index stockprop_pub_idx1 on stockprop_pub (stockprop_id); + create index stockprop_pub_idx2 on stockprop_pub (pub_id); + + -- ================================================ + -- TABLE: stock_relationship + -- ================================================ + -- stock_relationship.subject_id is the subject of the subj-predicate-obj sentence. This is typically the substock. + -- stock_relationship.object_id is the object of the subj-predicate-obj sentence. This is typically the container stock. + -- stock_relationship.type_id is relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed. + -- stock_relationship.rank is the ordering of subject stocks with respect to the object stock may be important where rank is used to order these; starts from zero. + -- stock_relationship.value is Additional notes/comments. + + create table stock_relationship ( + stock_relationship_id serial not null, + primary key (stock_relationship_id), + subject_id int not null, + foreign key (subject_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + object_id int not null, + foreign key (object_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, + value text null, + rank int not null default 0, + constraint stock_relationship_c1 unique (subject_id,object_id,type_id,rank) + ); + create index stock_relationship_idx1 on stock_relationship (subject_id); + create index stock_relationship_idx2 on stock_relationship (object_id); + create index stock_relationship_idx3 on stock_relationship (type_id); + + -- ================================================ + -- TABLE: stock_relationship_pub + -- ================================================ + -- stock_relationship_pub Provenance. Attach optional evidence to a stock_relationship in the form of a publication. + + create table stock_relationship_pub ( + stock_relationship_pub_id serial not null, + primary key (stock_relationship_pub_id), + stock_relationship_id int not null, + foreign key (stock_relationship_id) references stock_relationship (stock_relationship_id) on delete cascade INITIALLY DEFERRED, + pub_id int not null, + foreign key (pub_id) references pub (pub_id) on delete cascade INITIALLY DEFERRED, + constraint stock_relationship_pub_c1 unique (stock_relationship_id,pub_id) + ); + create index stock_relationship_pub_idx1 on stock_relationship_pub (stock_relationship_id); + create index stock_relationship_pub_idx2 on stock_relationship_pub (pub_id); + + -- ================================================ + -- TABLE: stock_dbxref + -- ================================================ + -- stock_dbxref links a stock to dbxrefs. This is for secondary identifiers; primary identifiers should use stock.dbxref_id. + -- stock_dbxref.is_current the is_current boolean indicates whether the linked dbxref is the current -official- dbxref for the linked stock. + + create table stock_dbxref ( + stock_dbxref_id serial not null, + primary key (stock_dbxref_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + dbxref_id int not null, + foreign key (dbxref_id) references dbxref (dbxref_id) on delete cascade INITIALLY DEFERRED, + is_current boolean not null default 'true', + constraint stock_dbxref_c1 unique (stock_id,dbxref_id) + ); + create index stock_dbxref_idx1 on stock_dbxref (stock_id); + create index stock_dbxref_idx2 on stock_dbxref (dbxref_id); + + -- ================================================ + -- TABLE: stock_cvterm + -- ================================================ + -- stock_cvterm links a stock to cvterms. This is for secondary cvterms; primary cvterms should use stock.type_id. + + create table stock_cvterm ( + stock_cvterm_id serial not null, + primary key (stock_cvterm_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + cvterm_id int not null, + foreign key (cvterm_id) references cvterm (cvterm_id) on delete cascade INITIALLY DEFERRED, + pub_id int not null, + foreign key (pub_id) references pub (pub_id) on delete cascade INITIALLY DEFERRED, + constraint stock_cvterm_c1 unique (stock_id,cvterm_id,pub_id) + ); + create index stock_cvterm_idx1 on stock_cvterm (stock_id); + create index stock_cvterm_idx2 on stock_cvterm (cvterm_id); + create index stock_cvterm_idx3 on stock_cvterm (pub_id); + + -- ================================================ + -- TABLE: stock_genotype + -- ================================================ + -- simple table linking a stock to a genotype + -- features can with genotypes can be linked to stocks thru feature_genotype -> genotype -> stock_genotype -> stock + + create table stock_genotype ( + stock_genotype_id serial not null, + primary key (stock_genotype_id), + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade, + genotype_id int not null, + foreign key (genotype_id) references genotype (genotype_id) on delete cascade, + constraint stock_genotype_c1 unique (stock_id, genotype_id) + ); + create index stock_genotype_idx1 on stock_genotype (stock_id); + create index stock_genotype_idx2 on stock_genotype (genotype_id); + + -- ================================================ + -- TABLE: stockcollection + -- ================================================ + -- stockcollection The lab or stock center distributing the stocks in their collection. + --uniqename is the value of the collection_FBcv + --type_id is the collection_type_FBcv + --name is the collection + --contact_id links to the contact info for the collection. + + create table stockcollection ( + stockcollection_id serial not null, + primary key (stockcollection_id), + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id) on delete cascade, + contact_id int null, + foreign key (contact_id) references contact (contact_id) on delete set null INITIALLY DEFERRED, + name varchar(255), + uniquename text not null, + constraint stockcollection_c1 unique (uniquename,type_id) + ); + create index stockcollection_name_ind1 on stockcollection (name); + create index stockcollection_idx1 on stockcollection (contact_id); + create index stockcollection_idx2 on stockcollection (type_id); + create index stockcollection_idx3 on stockcollection (uniquename); + + -- ================================================ + -- TABLE: stockcollectionprop + -- ================================================ + -- The table stockcollectionprop contains the value of the stockcollection such as website/email URLs; the value of the stockcollection order URLs. + -- The cv for the type_id is 'stockcollection property type' + + create table stockcollectionprop ( + stockcollectionprop_id serial not null, + primary key (stockcollectionprop_id), + stockcollection_id int not null, + foreign key (stockcollection_id) references stockcollection (stockcollection_id) on delete cascade INITIALLY DEFERRED, + type_id int not null, + foreign key (type_id) references cvterm (cvterm_id), + value text null, + rank int not null default 0, + constraint stockcollectionprop_c1 unique (stockcollection_id,type_id,rank) + ); + create index stockcollectionprop_idx1 on stockcollectionprop (stockcollection_id); + create index stockcollectionprop_idx2 on stockcollectionprop (type_id); + + -- ================================================ + -- TABLE: stockcollection_stock + -- ================================================ + -- stockcollection_stock links a stockcollection to the stocks which are contained in the collection. + + create table stockcollection_stock ( + stockcollection_stock_id serial not null, + primary key (stockcollection_stock_id), + stockcollection_id int not null, + foreign key (stockcollection_id) references stockcollection (stockcollection_id) on delete cascade INITIALLY DEFERRED, + stock_id int not null, + foreign key (stock_id) references stock (stock_id) on delete cascade INITIALLY DEFERRED, + constraint stockcollection_stock_c1 unique (stockcollection_id,stock_id) + ); + create index stockcollection_stock_idx1 on stockcollection_stock (stockcollection_id); + create index stockcollection_stock_idx2 on stockcollection_stock (stock_id); Index: nofuncs.html =================================================================== RCS file: /cvsroot/gmod/schema/chado/modules/nofuncs.html,v retrieving revision 1.4 retrieving revision 1.5 diff -C2 -d -r1.4 -r1.5 *** nofuncs.html 29 Dec 2006 16:26:09 -0000 1.4 --- nofuncs.html 15 Jan 2007 16:25:58 -0000 1.5 *************** *** 18,22 **** <!-- ! Table listing (107 tables) --> --- 18,22 ---- <!-- ! Table listing (119 tables) --> [...2284 lines suppressed...] + <td>NOT NULL</td> + <td>stock_id</td> + </tr> + + <tr class="IndexCell"> + <td>FOREIGN KEY</td> + <td>stock_id</td> + </tr> + + <tr class="IndexCell"> + <td>UNIQUE</td> + <td>stockcollection_id, stock_id</td> + </tr> + + </table> + + <hr /> + Created by <a href="http://sqlfairy.sourceforge.net"> SQL::Translator 0.08_01</a> |