# BioCode Moorea Project
# JG - May 2007


DROP TABLE biocode_extract;

CREATE TABLE biocode_extract (

seq_num               serial,
bnhm_id               char(24) NOT NULL,
extract_num           int unsigned,

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

DateFirstEntered      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_extracting     varchar(128),
container             varchar(50),
method                varchar(50),          # DNAzol, CTAB, Qicjen, hgh salt
elution_buffer        varchar(50),
dilution              varchar(50),          # added Feb 5, 2009

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

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

notes                 text,

from_tissue_seq_num   varchar(40),          # id of tissue from which this extract came (guid -- changed to this Aug 2009)
from_specimen         varchar(55),          # id of specimen from which this extract came
from_extract          varchar(55),          # id of extract from which this extract came

extract_barcode       varchar(255),         # for the actual barcode on the bottom of the 
                                            # little tubes that come with the matrix boxes 
                                            # - each tube has a little 2d unique barcode
                                            # Also known as extract ID.
                                            # Generated from extractor at Gump (for example).   

extract_remaining     tinyint unsigned,      # yes/no [1/0] -- is there any extract remaining

DateLastModified      date

);


create index be_bnhm_id on biocode_extract(bnhm_id);