CREATE TABLE Accn (
        Transaction_id       int NOT NULL,
        Accn_Type            varchar(35) NOT NULL,
        Accn_Num_Prefix      varchar(10) NULL,
        Accn_Num             int NOT NULL,
        Accn_Num_Suffix      varchar(4) NULL,
        Received_Date        varchar(25) NULL,
        Accn_Status          varchar(20) NOT NULL
 )
go
 
 
 CREATE TABLE Accn_Coll_Event (
        Transaction_id       int NOT NULL,
        Collecting_Event_id  int NOT NULL
 )
go
 
 
 CREATE TABLE Accn_Collector (
        Transaction_id       int NOT NULL,
        Agent_id             int NOT NULL,
        Fieldnotes_fg        tinyint NOT NULL
 )
go
 
 
 CREATE TABLE Accn_Taxonomy (
        Transaction_id       int NOT NULL,
        Taxon_Name_id        int NOT NULL,
        Accn_Taxon_Order     int NOT NULL
 )
go
 
 
 CREATE TABLE Addr (
        Addr_id              int NOT NULL,
        Street_Addr1         varchar(120) NOT NULL,
        Street_Addr2         varchar(120) NULL,
        City                 varchar(30) NOT NULL,
        State                varchar(20) NOT NULL,
        Zip                  varchar(10) NULL,
        Country_Cde          varchar(50) NULL,
        Mail_Stop            varchar(20) NULL,
        Formatted_Addr       varchar(255) NULL
 )
go
 
 
 CREATE TABLE Agent (
        Agent_id             int NOT NULL,
        Agent_Type           varchar(15) NOT NULL,
        Agent_Remarks        varchar(255) NULL,
        Preferred_Agent_Name_id int NOT NULL
 )
go
 
 
 CREATE TABLE Agent_Addr (
        Agent_Addr_id        int NOT NULL,
        Agent_id             int NULL,
        Agent_Addr_Type      varchar(25) NOT NULL,
        Job_Title            varchar(25) NULL,
        Addr_id              int NULL,
        Agent_Addr_Current_fg tinyint NOT NULL,
        Agent_Addr_Remarks   varchar(255) NULL
 )
go
 
 
 CREATE TABLE Agent_Name (
        Agent_Name_id        int NOT NULL,
        Agent_id             int NOT NULL,
        Agent_Name_Type      varchar(18) NOT NULL,
        Donor_Card_Present_fg tinyint NOT NULL,
        Agent_Name           varchar(184) NOT NULL
 )
go
 
 
 CREATE TABLE Agent_Name_Role (
        Agent_Name_id        int NOT NULL,
        Agent_Name_Role_Type varchar(25) NOT NULL
 )
go
 
 
 CREATE TABLE Agent_Relations (
        Agent_id             int NOT NULL,
        Related_Agent_id     int NOT NULL,
        Agent_Relationship   varchar(18) NOT NULL
 )
go
 
 
 CREATE TABLE Biol_Indiv (
        Collection_Object_id int NOT NULL,
        Biological_Individual_Type char(1) NOT NULL,
        Sex_Cde              varchar(25) NOT NULL,
        Sex_Cde_Mod          varchar(20) NULL,
        Age_Class            varchar(21) NULL,
        Numeric_Age          numeric(4,1) NULL,
        Numeric_Age_Units    varchar(6) NULL,
        Weight               numeric(9,2) NULL,
        Weight_Units         varchar(15) NULL,
        Verbatim_Preservation_Date varchar(30) NULL
 )
go
 
 
 CREATE TABLE Biol_Indiv_Relations (
        Collection_Object_id int NOT NULL,
        Related_Coll_Object_id int NOT NULL,
        Biol_Indiv_Relationship varchar(18) NOT NULL
 )
go
 
 
 CREATE TABLE Biol_Indiv_Remark (
        Collection_Object_id int NOT NULL,
        Sex_Det_Method       varchar(255) NULL,
        Sex_Remarks          varchar(255) NULL,
        Repro_Data           varchar(255) NULL,
        Age_Det_Method       varchar(255) NULL,
        Age_Remarks          varchar(255) NULL,
        Stomach_Cont         varchar(255) NULL,
        Measurements         varchar(255) NULL
 )
go
 
 
 CREATE TABLE Biol_Indiv_to_Phantom_Reln (
        Phantom_Biol_Indiv_id int NOT NULL,
        Biol_Indiv_Relationship varchar(18) NOT NULL,
        Collection_Object_id int NOT NULL
 )
go
 
 
 CREATE TABLE Bird (
        Collection_Object_id int NOT NULL,
        Associated_Egg_Nest_id int NULL,
        Tape_Recording_fg    tinyint NOT NULL,
        Fat_Deposition       varchar(35) NULL,
        Molt_Condition       varchar(255) NULL,
        Colors               varchar(255) NULL
 )
go
 
 
 CREATE TABLE Book (
        Publication_id       int NOT NULL,
        Edited_Work_fg       tinyint NOT NULL,
        Volume_Number        int NULL,
        Page_Total           varchar(15) NULL,
        Publisher_Name       varchar(127) NULL
 )
go
 
 
 CREATE TABLE Book_Section (
        Publication_id       int NOT NULL,
        Book_id              int NOT NULL,
        Book_Section_Type    varchar(25) NOT NULL,
        Begins_Page_Number   int NULL,
        Ends_Page_Number     int NULL,
        Book_Section_Order   int NULL
 )
go
 
 
 CREATE TABLE Borrow (
        Transaction_id       int NOT NULL,
        Lenders_Trans_Num_Cde varchar(20) NULL,
        Borrow_Num           int NOT NULL,
        Lenders_Invoice_Returned_fg tinyint NOT NULL,
        Received_Date        datetime NULL,
        Due_Date             datetime NULL,
        Lenders_Loan_Date    datetime NULL,
        Borrow_Status        varchar(20) NULL,
        Lenders_Instructions varchar(255) NULL
 )
go
 
 
 CREATE TABLE Cataloged_Item (
        Collection_Object_id int NOT NULL,
        Cat_Num              int NOT NULL,
        Accn_id              int NOT NULL,
        Accepted_Identification_id int NOT NULL,
        Collecting_Event_id  int NOT NULL,
        Collection_Cde       char(4) NOT NULL,
        Cataloged_Item_Type  char(2) NOT NULL,
        Security_Cde         int NOT NULL
 )
go
 
 
 CREATE TABLE Cataloged_Item_Remark (
        Collection_Object_id int NOT NULL,
        Taxir_Coll_Name      varchar(127) NULL,
        Taxir_Remarks_Verbatim varchar(255) NULL
 )
go
 
 
 CREATE TABLE Citation (
        Publication_id       int NOT NULL,
        Collection_Object_id int NOT NULL,
        Cited_Taxon_Name_id  int NULL,
        Cit_Current_fg       tinyint NOT NULL,
        Occurs_Page_Number   int NULL,
        Type_Status          varchar(20) NULL,
        Citation_Remarks     varchar(255) NULL,
        Citation_Text        varchar(255) NULL,
        rep_Published_Year   int NULL
 )
go
 
 
 CREATE TABLE Coll_Obj_Other_ID_Num (
        Other_ID_Num         varchar(30) NOT NULL,
        Other_ID_Type        varchar(75) NOT NULL,
        Collection_Object_id int NOT NULL
 )
go
 
 
 CREATE TABLE Coll_Object (
        Collection_Object_id int NOT NULL,
        Coll_Object_Type     char(2) NOT NULL,
        Entered_Person_id    int NOT NULL,
        Coll_Object_Entered_Date datetime NOT NULL,
        Last_Edited_Person_id int NOT NULL,
        Last_Edit_Date       datetime NULL,
        Coll_Obj_Disposition varchar(20) NOT NULL,
        Lot_Count            int NOT NULL,
        Barcode_id           int NULL,
        Condition            varchar(255) NOT NULL,
        Flags                varchar(20) NULL
 )
go
 
 
 CREATE TABLE Coll_Object_Habitat (
        Collection_Object_id int NOT NULL,
        Habitat              varchar(255) NULL
 )
go
 
 
 CREATE TABLE Coll_Object_Remark (
        Collection_Object_id int NOT NULL,
        Disposition_Remarks  varchar(255) NULL,
        Coll_Object_Remarks  varchar(255) NULL
 )
go
 
 
 CREATE TABLE Collecting_Event (
        Collecting_Event_id  int NOT NULL,
        Locality_id          int NOT NULL,
        Began_Date           datetime NULL,
        Ended_Date           datetime NULL,
        Verbatim_Date        varchar(30) NULL,
        Verbatim_Locality    varchar(255) NULL,
        Coll_Event_Remarks   varchar(255) NULL,
        Valid_Distribution_fg tinyint NOT NULL,
        Collecting_Source    varchar(15) NOT NULL,
        Collecting_Method    varchar(50) NULL,
        Habitat              varchar(255) NULL
 )
go
 
 
 CREATE TABLE Collection (
        Collection_Cde       char(4) NOT NULL,
        Institution_Acronym  varchar(20) NULL,
        Descr                varchar(255) NULL,
        Collection           varchar(15) NOT NULL
 )
go
 
 
 CREATE TABLE Collector (
        Collection_Object_id int NOT NULL,
        Agent_id             int NOT NULL,
        Collector_Role       char(1) NULL,
        Coll_Num_Prefix      varchar(20) NULL,
        Coll_Num             int NULL,
        Coll_Num_Suffix      varchar(9) NULL,
        Coll_Order           int NOT NULL
 )
go
 
 
 CREATE TABLE Common_Name (
        Taxon_Name_id        int NOT NULL,
        Common_Name          varchar(40) NOT NULL
 )
go
 
 
 CREATE TABLE Container (
        Container_id         int NOT NULL,
        Container_Type       varchar(40) NOT NULL,
        Label                varchar(255) NULL,
        Description          varchar(255) NULL,
        Barcode              varchar(30) NULL
 )
go
 
 
 CREATE TABLE Container_History (
        Container_id         int NOT NULL,
        Parent_Container_id  int NOT NULL,
        Install_Date         datetime NOT NULL
 )
go
 
 
 CREATE TABLE Correspondence (
        Correspondence_id    int NOT NULL,
        Correspondence_Type  varchar(25) NOT NULL,
        From_Agent_Addr_id   int NULL,
        To_Agent_Addr_id     int NULL,
        Written_Date         datetime NULL,
        Folder_Label         varchar(40) NULL,
        Filed_Under_Name     varchar(120) NOT NULL,
        Correspondence_Remarks varchar(255) NULL
 )
go
 
 
 CREATE TABLE Deacc_Item (
        Transaction_id       int NOT NULL,
        Collection_Object_id int NOT NULL,
        Deaccession_Item_Remarks varchar(255) NULL
 )
go
 
 
 CREATE TABLE Deaccn (
        Transaction_id       int NOT NULL,
        Deaccn_Type          varchar(20) NOT NULL,
        Deaccn_Num           int NOT NULL,
        Deaccn_Status        varchar(20) NOT NULL
 )
go
 
 
 CREATE TABLE Digital_Audio_File (
        Digital_Audio_File_id int NOT NULL,
        Tape_id              int NULL
 )
go
 
 
 CREATE TABLE Egg_Nest (
        Collection_Object_id int NOT NULL,
        Egg_Nest_Combo       varchar(20) NOT NULL,
        Multiple_Clutch_fg   tinyint NOT NULL,
        Coll_Egg_Count       int NOT NULL,
        Field_Egg_Count      int NULL,
        Set_Mark             varchar(20) NULL,
        Original_Data_Source varchar(20) NULL
 )
go
 
 
 CREATE TABLE Egg_Nest_Parasite (
        Collection_Object_id int NOT NULL,
        Parasite_Taxon_Name_id int NOT NULL,
        Field_Parasite_Egg_Count int NULL,
        Coll_Parasite_Egg_Count int NOT NULL
 )
go
 
 
 CREATE TABLE Egg_Nest_Remark (
        Collection_Object_id int NOT NULL,
        Egg_Nest_Descr       varchar(255) NULL,
        Incubation_Stage     varchar(255) NULL
 )
go
 
 
 CREATE TABLE Egg_Nest_Temp_Remark (
        Collection_Object_id int NOT NULL,
        Egg_Nest_Remarks     varchar(255) NOT NULL
 )
go
 
 
 CREATE TABLE Electronic_Address (
        Agent_id             int NOT NULL,
        Electronic_Addr      varchar(240) NOT NULL,
        Electronic_Addr_Type varchar(25) NOT NULL
 )
go
 
 
 CREATE TABLE Field_Notebook_Section (
        Publication_id       int NOT NULL,
        Begin_Date           datetime NOT NULL,
        End_Date             datetime NOT NULL,
        Begins_Collectors_Num varchar(15) NULL,
        Ends_Collectors_Num  varchar(15) NULL,
        Field_Notebook_Section_Type varchar(30) NULL
 )
go
 
 
 CREATE TABLE Film (
        Collection_Object_id int NOT NULL,
        Film_Title           varchar(255) NULL
 )
go
 
 
 CREATE TABLE Film_Clip (
        Collection_Object_id int NOT NULL,
        Film_Speed           int NULL,
        Playing_Time         int NULL
 )
go
 
 
 CREATE TABLE Film_Clip_in_Film (
        Film_Clip_id         int NOT NULL,
        Film_id              int NOT NULL,
        Start_Position       varchar(20) NULL
 )
go
 
 
 CREATE TABLE Geog_Auth_Rec (
        Geog_Auth_Rec_id     int NOT NULL,
        Continent_Ocean      varchar(50) NULL,
        Country              varchar(50) NULL,
        State_Prov           varchar(75) NULL,
        County               varchar(50) NULL,
        Quad                 varchar(30) NULL,
        Feature              varchar(50) NULL,
        Island               varchar(50) NULL,
        Island_Group         varchar(50) NULL,
        Sea                  varchar(40) NULL,
        Valid_Catalog_Term_fg tinyint NOT NULL,
        Source_Authority     varchar(45) NOT NULL,
        Higher_Geog          varchar(255) NULL
 )
go
 
 
 CREATE TABLE Geog_Relations (
        Geog_Auth_Rec_id     int NOT NULL,
        Related_Geog_Auth_Rec_id int NOT NULL,
        Geog_Relationship    varchar(20) NOT NULL
 )
go
 
 
 CREATE TABLE Group_Master (
        Agent_id             int NOT NULL
 )
go
 
 
 CREATE TABLE Group_Member (
        Group_Agent_id       int NOT NULL,
        Member_Agent_id      int NOT NULL,
        Member_Order         int NOT NULL
 )
go
 
 
 CREATE TABLE Herp (
        Collection_Object_id int NOT NULL,
        Snout_Vent_Length    numeric(5,1) NULL,
        Snout_Vent_Length_Units varchar(2) NULL,
        Carapace_Length      numeric(5,1) NULL,
        Carapace_Length_Units varchar(2) NULL
 )
go
 
 
 CREATE TABLE Histo_Slide_Series (
        Collection_Object_id int NOT NULL,
        Histo_Derived_From_Biol_Indv int NOT NULL,
        Start_Box_Number     int NULL,
        End_Box_Number       int NULL,
        First_Slide_Number   int NULL,
        Last_Slide_Number    int NULL,
        Slide_Count          int NULL,
        Section_Width        int NULL,
        Card_Number          int NULL,
        Slide_Numbers_Present varchar(30) NULL,
        Part_Name            varchar(30) NULL,
        Study_Name           varchar(30) NULL,
        Embedding_Medium     varchar(30) NULL,
        Section_Orientation  varchar(25) NULL,
        DBW_Notebook_Number  varchar(15) NULL,
        Histo_Stain_Proc     varchar(255) NULL,
        Histo_Prep_Meth      varchar(255) NULL
 )
go
 
 
 CREATE TABLE Identification (
        Identification_id    int NOT NULL,
        Collection_Object_id int NOT NULL,
        Taxon_Name_id        int NOT NULL,
        Identification_Modifier varchar(15) NULL,
        ID_Made_By_Agent_id  int NOT NULL,
        Made_Date            datetime NULL,
        Nature_Of_ID         varchar(30) NOT NULL,
        Accepted_ID_fg       tinyint NOT NULL,
        Identification_Remarks varchar(255) NULL
 )
go
 
 
 CREATE TABLE Image_Content (
        Image_Content_id     int NOT NULL,
        Image_Subject_id     int NULL,
        Image_Content_Type   varchar(16) NOT NULL,
        Agent_id             int NULL,
        Ref_Date             datetime NULL,
        Page_id              int NULL,
        Locality_id          int NULL,
        Collection_Object_id int NULL,
        Referenced_Image_Object_id int NULL,
        Taxon_Name_id        int NULL,
        Image_Content_Descr  varchar(255) NULL,
        Relationship         varchar(25) NOT NULL
 )
go
 
 
 CREATE TABLE Image_Object (
        Collection_Object_id int NOT NULL,
        Image_Subject_id     int NOT NULL,
        Made_Date            datetime NULL,
        Image_Object_Medium  varchar(40) NOT NULL,
        Original_fg          tinyint NOT NULL,
        Made_From_Image_Object_id int NULL,
        Image_Object_Type    varchar(11) NOT NULL,
        Image_Object_Storage_Loc varchar(255) NULL,
        Made_For_Purpose     varchar(255) NULL,
        URL_id               int NULL
 )
go
 
 
 CREATE TABLE Image_Object_Agent_Role (
        Agent_id             int NOT NULL,
        Image_Object_Agent_Role varchar(25) NOT NULL,
        Collection_Object_id int NOT NULL
 )
go
 
 
 CREATE TABLE Image_Subject (
        Image_Subject_id     int NOT NULL,
        Image_Title          varchar(255) NULL,
        Image_Subject        varchar(255) NULL
 )
go
 
 
 CREATE TABLE Image_Subject_Remarks (
        Image_Subject_id     int NOT NULL,
        Expedition           varchar(255) NULL,
        Veg_Species          varchar(255) NULL,
        Image_Pub            varchar(255) NULL,
        Pub_Year             int NULL,
        Exhibition           varchar(255) NULL,
        Other_Use            varchar(255) NULL,
        Subject_Type_1       varchar(255) NULL,
        Subject_Type_2       varchar(255) NULL,
        Veg_Type             varchar(255) NULL,
        Question             varchar(255) NULL,
        Life_Zone            varchar(255) NULL,
        Ref_In_Pub           varchar(255) NULL,
        Entered_Date         datetime NULL,
        print_copies         varchar(255) NULL
 )
go
 
 
 CREATE TABLE Journal (
        Journal_id           int NOT NULL,
        Journal_Abbreviation varchar(50) NOT NULL,
        Publisher_Name       varchar(127) NULL,
        Journal_Name         varchar(150) NOT NULL
 )
go
 
 
 CREATE TABLE Journal_Article (
        Publication_id       int NOT NULL,
        Journal_id           int NULL,
        Begins_Page_Number   int NULL,
        Ends_Page_Number     int NULL,
        Volume_Number        int NULL,
        Issue_Number         int NULL
 )
go
 
 
 CREATE TABLE Karyo_Slide (
        Collection_Object_id int NOT NULL,
        Karyo_Slide_Num      int NULL,
        Karyo_Stain_Proc     varchar(255) NULL,
        Karyo_Derived_From_Biol_Indv int NOT NULL,
        Karyo_Prep_Meth      varchar(40) NULL
 )
go
 
 
 CREATE TABLE Lat_Long (
        Lat_Long_id          int NOT NULL,
        Locality_id          int NOT NULL,
        Lat_Deg              int NULL,
        Dec_Lat_Min          numeric(10,8) NULL,
        Lat_Min              int NULL,
        Lat_Sec              numeric(8,6) NULL,
        Lat_Dir              char(1) NULL,
        Long_Deg             int NULL,
        Dec_Long_Min         numeric(10,8) NULL,
        Long_Min             int NULL,
        Long_Sec             numeric(8,6) NULL,
        Long_Dir             char(1) NULL,
        Dec_Lat              numeric(12,10) NULL,
        Dec_Long             numeric(13,10) NULL,
        Datum                varchar(40) NULL,
        UTM_Zone             varchar(3) NULL,
        UTM_EW               int NULL,
        UTM_NS               int NULL,
        Orig_Lat_Long_Units  varchar(20) NULL,
        Determined_By_Agent_id int NOT NULL,
        Determined_Date      datetime NULL,
        Lat_Long_Ref_Source  varchar(255) NULL,
        Lat_Long_Remarks     varchar(255) NULL,
        Max_Error_Distance   numeric(6,2) NULL,
        Max_Error_Units      varchar(2) NULL,
        Nearest_Named_Place  varchar(255) NULL,
        Lat_Long_For_NNP_fg  tinyint NOT NULL,
        Field_Verified_fg    tinyint NOT NULL,
        Accepted_Lat_Long_fg tinyint NOT NULL
 )
go
 
 
 CREATE TABLE Loan_Installment (
        Transaction_id       int NOT NULL,
        Correspondence_id    int NULL,
        Installment_Due_Date datetime NULL,
        Completed_Date       datetime NULL,
        Loan_Num_Prefix      varchar(10) NULL,
        Loan_Num             int NOT NULL,
        Loan_Num_Suffix      varchar(10) NULL,
        Loan_Installment_Status varchar(20) NOT NULL,
        Installment_Order    int NOT NULL,
        Lender_Inv_Ret_fg    tinyint NOT NULL,
        Borrower_Inv_Ret_fg  tinyint NOT NULL,
        Loan_Type            varchar(25) NOT NULL
 )
go
 
 
 CREATE TABLE Loan_Item (
        Transaction_id       int NOT NULL,
        Collection_Object_id int NOT NULL,
        Container_id         int NOT NULL,
        Reconciled_By_Person_id int NOT NULL,
        Reconciled_Date      datetime NULL,
        Item_Descr           varchar(127) NOT NULL,
        Item_Instructions    varchar(255) NULL,
        Loan_Item_Remarks    varchar(255) NULL
 )
go
 
 
 CREATE TABLE Loan_Request (
        Correspondence_id    int NOT NULL,
        Installment_Count    int NOT NULL,
        Request_Status       varchar(20) NOT NULL,
        Loan_Instructions    varchar(255) NULL,
        Request_Closed_Date  datetime NULL,
        Shipping_Instructions varchar(255) NULL
 )
go
 
 
 CREATE TABLE Locality (
        Locality_id          int NOT NULL,
        Geog_Auth_Rec_id     int NOT NULL,
        Accepted_Lat_Long_id int NOT NULL,
        Maximum_Elevation    numeric(5,0) NULL,
        Minimum_Elevation    numeric(5,0) NULL,
        Orig_Elev_Units      varchar(2) NULL,
        Township             int NULL,
        Township_Direction   char(1) NULL,
        Range                int NULL,
        Range_Direction      char(1) NULL,
        Section              int NULL,
        Section_Part         varchar(25) NULL,
        Spec_Locality        varchar(255) NOT NULL,
        Locality_Remarks     varchar(255) NULL,
        Legacy_Spec_Locality_fg tinyint NOT NULL
 )
go
 
 
 CREATE TABLE Mammal (
        Collection_Object_id int NOT NULL,
        Karyotype_Slides_fg  tinyint NOT NULL,
        Total_Length         numeric(5,1) NULL,
        Tail_Length          numeric(5,1) NULL,
        Hind_Foot_Length     numeric(5,1) NULL,
        Ear_Length           numeric(5,1) NULL,
        Tragus_Length        numeric(5,1) NULL,
        Forearm_Length       numeric(5,1) NULL,
        Length_Units         varchar(2) NULL
 )
go
 
 
 CREATE TABLE Model (
        Collection_Object_id int NOT NULL,
        Model_Descr          varchar(255) NULL
 )
go
 
 
 CREATE TABLE Notes_of_Coll_Event (
        Collecting_Event_id  int NOT NULL,
        Publication_id       int NOT NULL
 )
go
 
 
 CREATE TABLE Org (
        Agent_id             int NOT NULL,
        Dept_Unit            varchar(120) NULL
 )
go
 
 
 CREATE TABLE Page (
        Page_id              int NOT NULL,
        Publication_id       int NULL,
        Section_Page_Order   int NOT NULL,
        Page_Num             varchar(20) NULL
 )
go
 
 
 CREATE TABLE Part_Matrix (
        Collection_Object_id int NOT NULL,
        Biol_Indiv_Type      varchar(5) NOT NULL,
        Sex_Cde              varchar(10) NOT NULL,
        tissue_fg            tinyint NOT NULL,
        herp_wet_flat_skin_fg tinyint NOT NULL,
        herp_dry_flat_skin_fg tinyint NOT NULL,
        skull_fg             tinyint NOT NULL,
        complete_skel_fg     tinyint NOT NULL,
        partial_skel_fg      tinyint NOT NULL,
        herp_whole_alc_fg    tinyint NOT NULL,
        herp_whole_formalin_fg tinyint NOT NULL,
        herp_whole_cs_fg     tinyint NOT NULL,
        herp_whole_other_fluid_fg tinyint NOT NULL,
        bird_study_skin_fg   tinyint NOT NULL,
        bird_body_skin_fg    tinyint NOT NULL,
        bird_flat_skin_fg    tinyint NOT NULL,
        non_herp_fluid_pres_fg tinyint NOT NULL,
        bird_wing_fg         tinyint NOT NULL,
        mammal_skin_fg       tinyint NOT NULL,
        skull_only_fg        tinyint NOT NULL,
        mammal_skin_only_fg  tinyint NOT NULL,
        mammal_skin_and_skull_fg tinyint NOT NULL,
        other_part_fg        tinyint NOT NULL,
        mvzfc                varchar(30) NULL,
        herp_s_no            varchar(30) NULL,
        part_count           tinyint NOT NULL,
        skin_text            varchar(20) NOT NULL,
        skull_text           varchar(20) NOT NULL,
        skel_text            varchar(20) NOT NULL,
        fluid_text           varchar(20) NOT NULL,
        tissue_text          varchar(20) NOT NULL,
        other_part_text      varchar(70) NOT NULL
 )
go
 
 
 CREATE TABLE Permit (
        Permit_id            int NOT NULL,
        Issued_By_Agent_id   int NOT NULL,
        Issued_Date          datetime NULL,
        Issued_To_Agent_id   int NOT NULL,
        Renewed_Date         datetime NULL,
        Exp_Date             datetime NULL,
        Permit_Num           varchar(20) NULL,
        Permit_Type          varchar(50) NOT NULL,
        Permit_Remarks       varchar(255) NULL
 )
go
 
 
 CREATE TABLE Permit_Shipment (
        Permit_id            int NOT NULL,
        Container_id         int NOT NULL
 )
go
 
 
 CREATE TABLE Permit_Trans (
        Permit_id            int NOT NULL,
        Transaction_id       int NOT NULL
 )
go
 
 
 CREATE TABLE Person (
        Person_id            int NOT NULL,
        Prefix               varchar(20) NULL,
        Last_Name            varchar(60) NOT NULL,
        First_Name           varchar(40) NULL,
        Middle_Name          varchar(40) NULL,
        Suffix               varchar(20) NULL,
        Birth_Date           datetime NULL,
        Death_Date           datetime NULL
 )
go
 
 
 CREATE TABLE Phantom_Biol_Indiv (
        Phantom_Biol_Indiv_id int NOT NULL,
        Sex_Cde              varchar(10) NULL,
        Sex_Cde_Mod          varchar(20) NULL,
        Age_Class            varchar(21) NULL,
        Repro_Data           varchar(255) NULL,
        Non_Repro_Behavior   varchar(255) NULL,
        Habitat              varchar(255) NULL
 )
go
 
 
 CREATE TABLE Phantom_Relations (
        Phantom_Biol_Indiv_id int NOT NULL,
        Related_Phantom_Biol_Indiv_id int NOT NULL,
        Biol_Indiv_Relationship varchar(18) NOT NULL
 )
go
 
 
 CREATE TABLE Phone (
        Agent_Addr_id        int NOT NULL,
        Phone_Num            varchar(30) NOT NULL,
        Phone_Label          varchar(30) NOT NULL
 )
go
 
 
 CREATE TABLE Project (
        Project_id           int NOT NULL,
        Start_Date           datetime NULL,
        End_Date             datetime NULL,
        Project_Name         varchar(255) NOT NULL,
        Project_Description  varchar(255) NULL,
        Project_Remarks      varchar(255) NULL
 )
go
 
 
 CREATE TABLE Project_Agent (
        Project_id           int NOT NULL,
        Agent_Name_id        int NOT NULL,
        Project_Agent_Role   varchar(25) NOT NULL,
        Project_Agent_Remarks varchar(255) NULL
 )
go
 
 
 CREATE TABLE Project_Coll_Event (
        Project_id           int NOT NULL,
        Collecting_Event_id  int NOT NULL
 )
go
 
 
 CREATE TABLE Project_Publication (
        Project_id           int NOT NULL,
        Publication_id       int NOT NULL,
        Project_Publication_Remarks varchar(255) NULL
 )
go
 
 
 CREATE TABLE Project_Taxonomy (
        Project_id           int NOT NULL,
        Taxon_Name_id        int NOT NULL,
        Project_Taxon_Role   varchar(25) NOT NULL,
        Project_Taxon_Remarks varchar(255) NULL
 )
go
 
 
 CREATE TABLE Project_Trans (
        Project_id           int NOT NULL,
        Transaction_id       int NOT NULL,
        Project_Trans_Remarks varchar(255) NULL
 )
go
 
 
 CREATE TABLE Publication (
        Publication_id       int NOT NULL,
        Published_Year       int NULL,
        Publication_Type     varchar(21) NOT NULL,
        Publication_Loc      varchar(25) NULL,
        Publication_Title    varchar(255) NULL,
        Publication_Remarks  varchar(255) NULL
 )
go
 
 
 CREATE TABLE Publication_Author_Name (
        Publication_id       int NOT NULL,
        Agent_Name_id        int NOT NULL,
        Author_Position      int NOT NULL
 )
go
 
 
 CREATE TABLE Publication_Year (
        Publication_id       int NOT NULL,
        Pub_Year             int NOT NULL
 )
go
 
 
 CREATE TABLE Sequence_Repos_Article (
        Publication_id       int NOT NULL,
        Sequence_Repository_id int NULL,
        Accn_Num             varchar(40) NOT NULL
 )
go
 
 
 CREATE TABLE Sequence_Repository (
        Sequence_Repository_id int NOT NULL,
        Repository_Name      varchar(30) NOT NULL,
        URL                  varchar(255) NULL
 )
go
 
 
 CREATE TABLE Shipment (
        Container_id         int NOT NULL,
        Transaction_id       int NOT NULL,
        From_Agent_Addr_id   int NOT NULL,
        Packed_By_Agent_id   int NOT NULL,
        Hand_Carried_Agent_Addr_id int NULL,
        Shipped_To_Agent_Addr_id int NOT NULL,
        Shipped_Carrier_Method varchar(30) NOT NULL,
        Carriers_Tracking_Number varchar(20) NULL,
        Shipped_Date         datetime NULL,
        Package_Weight       varchar(10) NULL,
        Hazmat_fg            tinyint NOT NULL,
        Insured_For_Insured_Value money NOT NULL,
        Shipment_Remarks     varchar(255) NULL,
        Contents             varchar(255) NULL,
        Foreign_Shipment_fg  tinyint NOT NULL
 )
go
 
 
 CREATE TABLE Species_Tape (
        Collection_Object_id int NOT NULL,
        Taxon_Name_id        int NOT NULL
 )
go
 
 
 CREATE TABLE Specimen_Part (
        Collection_Object_id int NOT NULL,
        Part_Name            varchar(70) NOT NULL,
        Part_Modifier        varchar(60) NULL,
        Preserv_Method       varchar(25) NULL,
        Preserved_In_ETOH_fg tinyint NOT NULL,
        Specimen_Storage_Loc varchar(30) NULL,
        Transformation_Date  datetime NULL,
        Derived_From_Biol_Indv int NOT NULL
 )
go
 
 
 CREATE TABLE Still_Image (
        Collection_Object_id int NOT NULL,
        Dimensions           varchar(255) NULL,
        Contra_Info          varchar(255) NULL
 )
go
 
 
 CREATE TABLE Tape (
        Collection_Object_id int NOT NULL,
        Tape_Format          varchar(20) NOT NULL,
        Tape_Type            varchar(10) NOT NULL
 )
go
 
 
 CREATE TABLE Tax_Protect_Status (
        Protection_List_Name varchar(50) NOT NULL,
        Taxon_Name_id        int NOT NULL,
        Listed_Date          datetime NULL,
        Protect_Status_Name  varchar(25) NOT NULL,
        Protect_Status_Remarks varchar(255) NULL
 )
go
 
 
 CREATE TABLE Taxon_Relations (
        Taxon_Name_id        int NOT NULL,
        Related_Taxon_Name_id int NOT NULL,
        Taxon_Relationship   varchar(30) NOT NULL
 )
go
 
 
 CREATE TABLE Taxonomy (
        Taxon_Name_id        int NOT NULL,
        Phylclass            varchar(20) NULL,
        Phylorder            varchar(30) NULL,
        Suborder             varchar(30) NULL,
        Family               varchar(30) NULL,
        Subfamily            varchar(30) NULL,
        Genus                varchar(30) NULL,
        Subgenus             varchar(20) NULL,
        Species              varchar(40) NULL,
        Subspecies           varchar(40) NULL,
        Valid_Catalog_Term_fg tinyint NOT NULL,
        Source_Authority     varchar(45) NOT NULL,
        Full_Taxon_Name      varchar(240) NOT NULL,
        Scientific_Name      varchar(110) NULL,
        Author_Text          varchar(60) NULL
 )
go
 
 
 CREATE TABLE Tissue_Prep (
        Collection_Object_id int NOT NULL,
        Prep_From_Prep_id    int NULL,
        Prepared_By_Agent_id int NULL,
        Tissue_Prep_Method   varchar(30) NULL,
        Prepared_Date        datetime NULL,
        DNA_Conc             varchar(20) NULL,
        Prep_Storage_Medium  varchar(20) NOT NULL,
        Original_Volume      varchar(15) NULL,
        Prep_From_Tissue_Sample_id int NULL,
        Tissue_Prep_Num      numeric(8,1) NOT NULL
 )
go
 
 
 CREATE TABLE Tissue_Sample (
        Collection_Object_id int NOT NULL,
        Derived_From_Biol_Indiv int NOT NULL,
        Tissue_Sample_Num    numeric(8,1) NOT NULL,
        Tissue_Preserv_Meth  varchar(20) NOT NULL,
        Tissue_Vial_Type     varchar(15) NOT NULL,
        Tissue_Type          varchar(255) NOT NULL,
        Is_Subsample_fg      tinyint NOT NULL,
        Sampled_From_Obj_id  int NULL
 )
go
 
 
 CREATE TABLE Trans (
        Transaction_id       int NOT NULL,
        Auth_Agent_id        int NULL,
        Trans_Date           datetime NULL,
        Trans_Entered_Agent_id int NOT NULL,
        Received_Agent_id    int NOT NULL,
        Corresp_fg           tinyint NOT NULL,
        Transaction_Type     varchar(18) NOT NULL,
        Nature_Of_Material   varchar(255) NOT NULL,
        Trans_Remarks        varchar(255) NULL
 )
go
 
 
 CREATE TABLE Trans_Agent_Addr (
        Transaction_id       int NOT NULL,
        Agent_Addr_id        int NOT NULL,
        Trans_Agent_Role_Name varchar(20) NOT NULL
 )
go
 
 
 CREATE TABLE Trans_Relations (
        Transaction_id       int NOT NULL,
        Related_Transaction_id int NOT NULL,
        Trans_Relationship   varchar(255) NOT NULL
 )
go
 
 
 CREATE TABLE URL (
        URL_id               int NOT NULL,
        URL                  varchar(255) NULL,
        Filename             varchar(255) NULL,
        URL_Type             varchar(10) NOT NULL,
        Collection_Object_id int NULL,
        Viewer_id            int NULL
 )
go
 
 
 CREATE TABLE Viewer (
        Viewer_id            int NOT NULL,
        Viewer               varchar(255) NOT NULL,
        Path                 varchar(255) NULL,
        Params               varchar(255) NULL
 )
go
 
 
 CREATE TABLE Vocal_Series (
        Collection_Object_id int NOT NULL,
        From_Biol_Indiv_id   int NULL,
        From_Phantom_Biol_Indiv_id int NULL,
        Vocal_Type           varchar(30) NOT NULL,
        Cues_Count           int NULL,
        Indiv_Num_On_Tape    int NOT NULL,
        Vocal_Type_Details   varchar(255) NULL,
        Background_Vocals    varchar(255) NULL,
        Background_Noise     varchar(255) NULL
 )
go
 
 
 CREATE TABLE Vocal_Series_Cut_History (
        Taxon_Name_id        int NOT NULL,
        Taxon_Cut_Num        int NOT NULL,
        Collection_Object_id int NOT NULL
 )
go
 
 
 CREATE TABLE Vocal_Series_On_Tape (
        Tape_id              int NOT NULL,
        Tape_Side            char(1) NULL,
        Tape_id              int NOT NULL,
        Original_fg          tinyint NOT NULL,
        Copied_From_Voc_Series_id int NOT NULL,
        Copied_From_Tape_id  int NOT NULL
 )
go