next up previous contents
Next: About this document Up: Part of GDB Previous: Part of the

Part of the GSDB OPM Schema

OBJECT CLASS Feature
   ID: id
   ATTRIBUTE id: [1,1] table_id
   ATTRIBUTE type: [0,1] VARCHAR(30)
   ATTRIBUTE genes: set-of [1,] Gene
   ATTRIBUTE products: set-of [0,] Product
OBJECT CLASS Gene
   ID: id
   ATTRIBUTE id: [1,1] table_id
   ATTRIBUTE gdb_xref: [0,1] VARCHAR(20)
   ATTRIBUTE mousedb_xref: [0,1] VARCHAR(20)
   ATTRIBUTE name: [0,1] VARCHAR(80)
   ATTRIBUTE oldgsdb_xref: [0,1] INTEGER
OBJECT CLASS Product
   ID: id
   ATTRIBUTE id: [1,1] table_id
   ATTRIBUTE ec_xref: [0,1] VARCHAR(20)
   ATTRIBUTE name: [0,1] VARCHAR(200)
   ATTRIBUTE oldgsdb_xref: [0,1] INTEGER
OBJECT CLASS Reference isa Feature
   ATTRIBUTE feature_id: [1,1] Feature
   ATTRIBUTE medline_xref: [0,1] table_id
   ATTRIBUTE pub_status: [0,1] type_spec
   ATTRIBUTE title: [0,1] VARCHAR(255)
   ATTRIBUTE authors (au_last_name, au_first_name, au_initials,
                      au_suffix, au_summary): list-of [0,]
                     ([1,1] VARCHAR(40),[0,1] VARCHAR(20), (0,1) VARCHAR(10),
                      [0,1] VARCHAR(10), [0,1] VARCHAR(255))
   ATTRIBUTE editors (ed_last_name, ed_first_name, ed_initials,
                      ed_suffix, ed_summary): list-of [0,]
                     ([1,1] VARCHAR(40),[0,1] VARCHAR(20), (0,1) VARCHAR(10),
                      [0,1] VARCHAR(10), [0,1] VARCHAR(255))
OBJECT CLASS Sequence
   ID: id
   ATTRIBUTE id: [1,1] table_id
   ATTRIBUTE sequence: [0,1] TEXT
   ATTRIBUTE length: [0,1] INTEGER
OBJECT CLASS Source isa Feature
   ATTRIBUTE feature_id: [1,1] Feature
   ATTRIBUTE taxonomy_xref: [0,1] table_id
   ATTRIBUTE scientific_name: [0,1] VARCHAR(80)
   ATTRIBUTE common_name: [0,1] VARCHAR(80)
   ATTRIBUTE taxonomy: [0,1] VARCHAR(255)
   ATTRIBUTE gdb_probe_xref: [0,1] table_id



& Markowitz
Wed Jan 17 16:39:09 PST 1996