Tables

The ``tables'' in a relational database are

• two dimensional, consisting of rows and columns
• columns are typically named
• ordering of columns are unimportant
• ordering of rows are unimportant
• the value of a column in a row must be atomic, like a number or a string
• all values within a column must be of the same type, either all are numbers or all are strings

Example tables:

genpepts: {
  (#accn: "T41727", 
   #uid:   7490551,
   #title: "F-box domain protein Pof3p - fission yeast",
   #seq:   "mnnyqvkaik...",
   #fid:   101),
  (#accn: "T41727", 
   #uid:   7490551,
   #title: "F-box domain protein Pof3p - fission yeast",
   #seq:   "mnnyqvkaik...",
   #fid:   102), ... }

features: {
  (#fid:   101,
   #start: 0,
   #end:   576,
   #name:  "source",
   #anno:  "organism='schizosaccharomyces pombe'; db_xref='taxon:4896'"),
  (#fid:   101,
   #start: 0,
   #end:   576,
   #name:  "protein",
   #anno:  "product='F-box domain protein Pof3p'"), ...}