# BioCode Moorea Project
# JG - May 2007


DROP TABLE biocode_sequence;

CREATE TABLE biocode_sequence (

seq_num                 serial,

gen_locus               varchar(128),
trace_num1              int,
trace_num2              int,
trace_num3              int,
trace_num4              int,
trace_num5              int,
contig_num              varchar(128),         # points to binary file
seq_fasta               varchar(128),         # points to text file


GeneratingInstitution   varchar(255),
Generating_method       varchar(255),
OtherCatalogNum         varchar(255),

entry_date              date,                 # date last entered or edited
year                    mediumint unsigned,   # Darwin Core = "Year"
month                   mediumint unsigned,   # Darwin Core = "Month"
day                     mediumint unsigned,   # Darwin Core = "Day"

person_sequencing       varchar(128),

molecular_id            varchar(255),         # BOLD "processID" number (ie, MBFA001-07)

notes                   text

);