# BioCode Moorea Project
# JG - May 2007


DROP TABLE biocode_trace;

CREATE TABLE biocode_trace (

seq_num                 serial,
bnhm_id                 char(24),
trace_num               int unsigned,
from_extract            varchar(55),          # id of extract from which this trace came

GeneratingInstitution   varchar(255),
OtherCatalogNum         varchar(255),         # JG1  "collector code"

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),

format_name96         varchar(128),         # 96 format name
well_number96         varchar(10),          # 96 well number

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

forward_PCR_primer    varchar(128),
reverse_PCR_primer    varchar(128),

seq_primer            varchar(128),

trace_file            varchar(128),         # pointer to binary file in filesystem

target_locus          varchar(128),         # pointer to text file in filesystem
phred_file            varchar(128),         # pointer to text file in filesystem


notes                 text

);