CREATE TABLE Accn (
       Transaction_id       INTEGER NOT NULL,
       Accn_Type            VARCHAR2(35) NOT NULL,
       Accn_Num_Prefix      VARCHAR2(10) NULL,
       Accn_Num             INTEGER NOT NULL,
       Accn_Num_Suffix      VARCHAR2(4) NULL,
       Received_Date        VARCHAR2(25) NULL,
       Accn_Status          VARCHAR2(20) NOT NULL
);


CREATE TABLE Accn_Coll_Event (
       Transaction_id       INTEGER NOT NULL,
       Collecting_Event_id  INTEGER NOT NULL
);


CREATE TABLE Accn_Collector (
       Transaction_id       INTEGER NOT NULL,
       Agent_id             INTEGER NOT NULL,
       Fieldnotes_fg        SMALLINT NOT NULL
);


CREATE TABLE Accn_Taxonomy (
       Transaction_id       INTEGER NOT NULL,
       Taxon_Name_id        NUMBER NOT NULL,
       Accn_Taxon_Order     NUMBER NOT NULL
);


CREATE TABLE Addr (
       Addr_id              INTEGER NOT NULL,
       Street_Addr1         VARCHAR2(120) NOT NULL,
       Street_Addr2         VARCHAR2(120) NULL,
       City                 VARCHAR2(30) NOT NULL,
       State                VARCHAR2(20) NOT NULL,
       Zip                  VARCHAR2(10) NULL,
       Country_Cde          VARCHAR2(50) NULL,
       Mail_Stop            VARCHAR2(20) NULL,
       Formatted_Addr       VARCHAR2(255) NULL
);


CREATE TABLE Agent (
       Agent_id             INTEGER NOT NULL,
       Agent_Type           VARCHAR2(15) NOT NULL,
       Agent_Remarks        VARCHAR2(255) NULL,
       Preferred_Agent_Name_id NUMBER NOT NULL
);


CREATE TABLE Agent_Addr (
       Agent_Addr_id        NUMBER NOT NULL,
       Agent_id             INTEGER NULL,
       Agent_Addr_Type      VARCHAR2(25) NOT NULL,
       Job_Title            VARCHAR2(25) NULL,
       Addr_id              INTEGER NULL,
       Agent_Addr_Current_fg SMALLINT NOT NULL,
       Agent_Addr_Remarks   VARCHAR2(255) NULL
);


CREATE TABLE Agent_Name (
       Agent_Name_id        NUMBER NOT NULL,
       Agent_id             INTEGER NOT NULL,
       Agent_Name_Type      VARCHAR2(18) NOT NULL,
       Donor_Card_Present_fg SMALLINT NOT NULL,
       Agent_Name           VARCHAR2(184) NOT NULL
);


CREATE TABLE Agent_Name_Role (
       Agent_Name_id        NUMBER NOT NULL,
       Agent_Name_Role_Type VARCHAR2(25) NOT NULL
);


CREATE TABLE Agent_Relations (
       Agent_id             INTEGER NOT NULL,
       Related_Agent_id     INTEGER NOT NULL,
       Agent_Relationship   VARCHAR2(18) NOT NULL
);


CREATE TABLE Biol_Indiv (
       Collection_Object_id INTEGER NOT NULL,
       Biological_Individual_Type CHAR(1) NOT NULL,
       Sex_Cde              VARCHAR2(25) NOT NULL,
       Sex_Cde_Mod          VARCHAR2(20) NULL,
       Age_Class            VARCHAR2(21) NULL,
       Numeric_Age          NUMBER(4,1) NULL,
       Numeric_Age_Units    VARCHAR2(6) NULL,
       Weight               NUMBER(9,2) NULL,
       Weight_Units         VARCHAR2(15) NULL,
       Verbatim_Preservation_Date VARCHAR2(30) NULL
);


CREATE TABLE Biol_Indiv_Relations (
       Collection_Object_id INTEGER NOT NULL,
       Related_Coll_Object_id NUMBER NOT NULL,
       Biol_Indiv_Relationship VARCHAR2(18) NOT NULL
);


CREATE TABLE Biol_Indiv_Remark (
       Collection_Object_id INTEGER NOT NULL,
       Sex_Det_Method       VARCHAR2(255) NULL,
       Sex_Remarks          VARCHAR2(255) NULL,
       Repro_Data           VARCHAR2(255) NULL,
       Age_Det_Method       VARCHAR2(255) NULL,
       Age_Remarks          VARCHAR2(255) NULL,
       Stomach_Cont         VARCHAR2(255) NULL,
       Measurements         VARCHAR2(255) NULL
);


CREATE TABLE Biol_Indiv_to_Phantom_Reln (
       Phantom_Biol_Indiv_id NUMBER NOT NULL,
       Biol_Indiv_Relationship VARCHAR2(18) NOT NULL,
       Collection_Object_id INTEGER NOT NULL
);


CREATE TABLE Bird (
       Collection_Object_id INTEGER NOT NULL,
       Associated_Egg_Nest_id NUMBER NULL,
       Tape_Recording_fg    SMALLINT NOT NULL,
       Fat_Deposition       VARCHAR2(35) NULL,
       Molt_Condition       VARCHAR2(255) NULL,
       Colors               VARCHAR2(255) NULL
);


CREATE TABLE Book (
       Publication_id       INTEGER NOT NULL,
       Edited_Work_fg       SMALLINT NOT NULL,
       Volume_Number        INTEGER NULL,
       Page_Total           VARCHAR2(15) NULL,
       Publisher_Name       VARCHAR2(127) NULL
);


CREATE TABLE Book_Section (
       Publication_id       INTEGER NOT NULL,
       Book_id              INTEGER NOT NULL,
       Book_Section_Type    VARCHAR2(25) NOT NULL,
       Begins_Page_Number   INTEGER NULL,
       Ends_Page_Number     INTEGER NULL,
       Book_Section_Order   NUMBER NULL
);


CREATE TABLE Borrow (
       Transaction_id       INTEGER NOT NULL,
       Lenders_Trans_Num_Cde VARCHAR2(20) NULL,
       Borrow_Num           INTEGER NOT NULL,
       Lenders_Invoice_Returned_fg SMALLINT NOT NULL,
       Received_Date        DATE NULL,
       Due_Date             DATE NULL,
       Lenders_Loan_Date    DATE NULL,
       Borrow_Status        VARCHAR2(20) NULL,
       Lenders_Instructions VARCHAR2(255) NULL
);


CREATE TABLE Cataloged_Item (
       Collection_Object_id INTEGER NOT NULL,
       Cat_Num              INTEGER NOT NULL,
       Accn_id              INTEGER NOT NULL,
       Accepted_Identification_id INTEGER NOT NULL,
       Collecting_Event_id  INTEGER NOT NULL,
       Collection_Cde       CHAR(4) NOT NULL,
       Cataloged_Item_Type  CHAR(2) NOT NULL,
       Security_Cde         NUMBER NOT NULL
);


CREATE TABLE Cataloged_Item_Remark (
       Collection_Object_id INTEGER NOT NULL,
       Taxir_Coll_Name      VARCHAR2(127) NULL,
       Taxir_Remarks_Verbatim VARCHAR2(255) NULL
);


CREATE TABLE Citation (
       Publication_id       INTEGER NOT NULL,
       Collection_Object_id INTEGER NOT NULL,
       Cited_Taxon_Name_id  NUMBER NULL,
       Cit_Current_fg       SMALLINT NOT NULL,
       Occurs_Page_Number   INTEGER NULL,
       Type_Status          VARCHAR2(20) NULL,
       Citation_Remarks     VARCHAR2(255) NULL,
       Citation_Text        VARCHAR2(255) NULL,
       rep_Published_Year   NUMBER NULL
);


CREATE TABLE Coll_Obj_Other_ID_Num (
       Other_ID_Num         VARCHAR2(30) NOT NULL,
       Other_ID_Type        VARCHAR2(75) NOT NULL,
       Collection_Object_id INTEGER NOT NULL
);


CREATE TABLE Coll_Object (
       Collection_Object_id INTEGER NOT NULL,
       Coll_Object_Type     CHAR(2) NOT NULL,
       Entered_Person_id    INTEGER NOT NULL,
       Coll_Object_Entered_Date DATE NOT NULL,
       Last_Edited_Person_id INTEGER NOT NULL,
       Last_Edit_Date       DATE NULL,
       Coll_Obj_Disposition VARCHAR2(20) NOT NULL,
       Lot_Count            INTEGER NOT NULL,
       Barcode_id           NUMBER NULL,
       Condition            VARCHAR2(255) NOT NULL,
       Flags                VARCHAR2(20) NULL
);


CREATE TABLE Coll_Object_Habitat (
       Collection_Object_id INTEGER NOT NULL,
       Habitat              VARCHAR2(255) NULL
);


CREATE TABLE Coll_Object_Remark (
       Collection_Object_id INTEGER NOT NULL,
       Disposition_Remarks  VARCHAR2(255) NULL,
       Coll_Object_Remarks  VARCHAR2(255) NULL
);


CREATE TABLE Collecting_Event (
       Collecting_Event_id  INTEGER NOT NULL,
       Locality_id          INTEGER NOT NULL,
       Began_Date           DATE NULL,
       Ended_Date           DATE NULL,
       Verbatim_Date        VARCHAR2(30) NULL,
       Verbatim_Locality    VARCHAR2(255) NULL,
       Coll_Event_Remarks   VARCHAR2(255) NULL,
       Valid_Distribution_fg SMALLINT NOT NULL,
       Collecting_Source    VARCHAR2(15) NOT NULL,
       Collecting_Method    VARCHAR2(50) NULL,
       Habitat              VARCHAR2(255) NULL
);


CREATE TABLE Collection (
       Collection_Cde       CHAR(4) NOT NULL,
       Institution_Acronym  VARCHAR2(20) NULL,
       Descr                VARCHAR2(255) NULL,
       Collection           VARCHAR2(15) NOT NULL
);


CREATE TABLE Collector (
       Collection_Object_id INTEGER NOT NULL,
       Agent_id             INTEGER NOT NULL,
       Collector_Role       CHAR(1) NULL,
       Coll_Num_Prefix      VARCHAR2(20) NULL,
       Coll_Num             INTEGER NULL,
       Coll_Num_Suffix      VARCHAR2(9) NULL,
       Coll_Order           INTEGER NOT NULL
);


CREATE TABLE Common_Name (
       Taxon_Name_id        NUMBER NOT NULL,
       Common_Name          VARCHAR2(40) NOT NULL
);


CREATE TABLE Container (
       Container_id         INTEGER NOT NULL,
       Container_Type       VARCHAR2(40) NOT NULL,
       Label                VARCHAR2(255) NULL,
       Description          VARCHAR2(255) NULL,
       Barcode              VARCHAR2(30) NULL
);


CREATE TABLE Container_History (
       Container_id         INTEGER NOT NULL,
       Parent_Container_id  NUMBER NOT NULL,
       Install_Date         DATE NOT NULL
);


CREATE TABLE Correspondence (
       Correspondence_id    INTEGER NOT NULL,
       Correspondence_Type  VARCHAR2(25) NOT NULL,
       From_Agent_Addr_id   NUMBER NULL,
       To_Agent_Addr_id     NUMBER NULL,
       Written_Date         DATE NULL,
       Folder_Label         VARCHAR2(40) NULL,
       Filed_Under_Name     VARCHAR2(120) NOT NULL,
       Correspondence_Remarks VARCHAR2(255) NULL
);


CREATE TABLE Deacc_Item (
       Transaction_id       INTEGER NOT NULL,
       Collection_Object_id INTEGER NOT NULL,
       Deaccession_Item_Remarks VARCHAR2(255) NULL
);


CREATE TABLE Deaccn (
       Transaction_id       INTEGER NOT NULL,
       Deaccn_Type          VARCHAR2(20) NOT NULL,
       Deaccn_Num           INTEGER NOT NULL,
       Deaccn_Status        VARCHAR2(20) NOT NULL
);


CREATE TABLE Digital_Audio_File (
       Digital_Audio_File_id INTEGER NOT NULL,
       Tape_id              INTEGER NULL
);


CREATE TABLE Egg_Nest (
       Collection_Object_id INTEGER NOT NULL,
       Egg_Nest_Combo       VARCHAR2(20) NOT NULL,
       Multiple_Clutch_fg   SMALLINT NOT NULL,
       Coll_Egg_Count       INTEGER NOT NULL,
       Field_Egg_Count      INTEGER NULL,
       Set_Mark             VARCHAR2(20) NULL,
       Original_Data_Source VARCHAR2(20) NULL
);


CREATE TABLE Egg_Nest_Parasite (
       Collection_Object_id INTEGER NOT NULL,
       Parasite_Taxon_Name_id NUMBER NOT NULL,
       Field_Parasite_Egg_Count INTEGER NULL,
       Coll_Parasite_Egg_Count INTEGER NOT NULL
);


CREATE TABLE Egg_Nest_Remark (
       Collection_Object_id INTEGER NOT NULL,
       Egg_Nest_Descr       VARCHAR2(255) NULL,
       Incubation_Stage     VARCHAR2(255) NULL
);


CREATE TABLE Egg_Nest_Temp_Remark (
       Collection_Object_id INTEGER NOT NULL,
       Egg_Nest_Remarks     VARCHAR2(255) NOT NULL
);


CREATE TABLE Electronic_Address (
       Agent_id             INTEGER NOT NULL,
       Electronic_Addr      VARCHAR2(240) NOT NULL,
       Electronic_Addr_Type VARCHAR2(25) NOT NULL
);


CREATE TABLE Field_Notebook_Section (
       Publication_id       INTEGER NOT NULL,
       Begin_Date           DATE NOT NULL,
       End_Date             DATE NOT NULL,
       Begins_Collectors_Num VARCHAR2(15) NULL,
       Ends_Collectors_Num  VARCHAR2(15) NULL,
       Field_Notebook_Section_Type VARCHAR2(30) NULL
);


CREATE TABLE Film (
       Collection_Object_id INTEGER NOT NULL,
       Film_Title           VARCHAR2(255) NULL
);


CREATE TABLE Film_Clip (
       Collection_Object_id INTEGER NOT NULL,
       Film_Speed           INTEGER NULL,
       Playing_Time         INTEGER NULL
);


CREATE TABLE Film_Clip_in_Film (
       Film_Clip_id         INTEGER NOT NULL,
       Film_id              NUMBER NOT NULL,
       Start_Position       VARCHAR2(20) NULL
);


CREATE TABLE Geog_Auth_Rec (
       Geog_Auth_Rec_id     INTEGER NOT NULL,
       Continent_Ocean      VARCHAR2(50) NULL,
       Country              VARCHAR2(50) NULL,
       State_Prov           VARCHAR2(75) NULL,
       County               VARCHAR2(50) NULL,
       Quad                 VARCHAR2(30) NULL,
       Feature              VARCHAR2(50) NULL,
       Island               VARCHAR2(50) NULL,
       Island_Group         VARCHAR2(50) NULL,
       Sea                  VARCHAR2(40) NULL,
       Valid_Catalog_Term_fg SMALLINT NOT NULL,
       Source_Authority     VARCHAR2(45) NOT NULL,
       Higher_Geog          VARCHAR2(255) NULL
);


CREATE TABLE Geog_Relations (
       Geog_Auth_Rec_id     INTEGER NOT NULL,
       Related_Geog_Auth_Rec_id INTEGER NOT NULL,
       Geog_Relationship    VARCHAR2(20) NOT NULL
);


CREATE TABLE Group_Master (
       Agent_id             INTEGER NOT NULL
);


CREATE TABLE Group_Member (
       Group_Agent_id       INTEGER NOT NULL,
       Member_Agent_id      INTEGER NOT NULL,
       Member_Order         INTEGER NOT NULL
);


CREATE TABLE Herp (
       Collection_Object_id INTEGER NOT NULL,
       Snout_Vent_Length    NUMBER(5,1) NULL,
       Snout_Vent_Length_Units VARCHAR2(2) NULL,
       Carapace_Length      NUMBER(5,1) NULL,
       Carapace_Length_Units VARCHAR2(2) NULL
);


CREATE TABLE Histo_Slide_Series (
       Collection_Object_id INTEGER NOT NULL,
       Histo_Derived_From_Biol_Indv NUMBER NOT NULL,
       Start_Box_Number     INTEGER NULL,
       End_Box_Number       INTEGER NULL,
       First_Slide_Number   INTEGER NULL,
       Last_Slide_Number    INTEGER NULL,
       Slide_Count          INTEGER NULL,
       Section_Width        INTEGER NULL,
       Card_Number          INTEGER NULL,
       Slide_Numbers_Present VARCHAR2(30) NULL,
       Part_Name            VARCHAR2(30) NULL,
       Study_Name           VARCHAR2(30) NULL,
       Embedding_Medium     VARCHAR2(30) NULL,
       Section_Orientation  VARCHAR2(25) NULL,
       DBW_Notebook_Number  VARCHAR2(15) NULL,
       Histo_Stain_Proc     VARCHAR2(255) NULL,
       Histo_Prep_Meth      VARCHAR2(255) NULL
);


CREATE TABLE Identification (
       Identification_id    INTEGER NOT NULL,
       Collection_Object_id INTEGER NOT NULL,
       Taxon_Name_id        NUMBER NOT NULL,
       Identification_Modifier VARCHAR2(15) NULL,
       ID_Made_By_Agent_id  INTEGER NOT NULL,
       Made_Date            DATE NULL,
       Nature_Of_ID         VARCHAR2(30) NOT NULL,
       Accepted_ID_fg       SMALLINT NOT NULL,
       Identification_Remarks VARCHAR2(255) NULL
);


CREATE TABLE Image_Content (
       Image_Content_id     INTEGER NOT NULL,
       Image_Subject_id     INTEGER NULL,
       Image_Content_Type   VARCHAR2(16) NOT NULL,
       Agent_id             INTEGER NULL,
       Ref_Date             DATE NULL,
       Page_id              NUMBER NULL,
       Locality_id          INTEGER NULL,
       Collection_Object_id INTEGER NULL,
       Referenced_Image_Object_id INTEGER NULL,
       Taxon_Name_id        NUMBER NULL,
       Image_Content_Descr  VARCHAR2(255) NULL,
       Relationship         VARCHAR2(25) NOT NULL
);


CREATE TABLE Image_Object (
       Collection_Object_id INTEGER NOT NULL,
       Image_Subject_id     INTEGER NOT NULL,
       Made_Date            DATE NULL,
       Image_Object_Medium  VARCHAR2(40) NOT NULL,
       Original_fg          SMALLINT NOT NULL,
       Made_From_Image_Object_id NUMBER NULL,
       Image_Object_Type    VARCHAR2(11) NOT NULL,
       Image_Object_Storage_Loc VARCHAR2(255) NULL,
       Made_For_Purpose     VARCHAR2(255) NULL,
       URL_id               NUMBER NULL
);


CREATE TABLE Image_Object_Agent_Role (
       Agent_id             INTEGER NOT NULL,
       Image_Object_Agent_Role VARCHAR2(25) NOT NULL,
       Collection_Object_id INTEGER NOT NULL
);


CREATE TABLE Image_Subject (
       Image_Subject_id     INTEGER NOT NULL,
       Image_Title          VARCHAR2(255) NULL,
       Image_Subject        VARCHAR2(255) NULL
);


CREATE TABLE Image_Subject_Remarks (
       Image_Subject_id     INTEGER NOT NULL,
       Expedition           VARCHAR2(255) NULL,
       Veg_Species          VARCHAR2(255) NULL,
       Image_Pub            VARCHAR2(255) NULL,
       Pub_Year             NUMBER NULL,
       Exhibition           VARCHAR2(255) NULL,
       Other_Use            VARCHAR2(255) NULL,
       Subject_Type_1       VARCHAR2(255) NULL,
       Subject_Type_2       VARCHAR2(255) NULL,
       Veg_Type             VARCHAR2(255) NULL,
       Question             VARCHAR2(255) NULL,
       Life_Zone            VARCHAR2(255) NULL,
       Ref_In_Pub           VARCHAR2(255) NULL,
       Entered_Date         DATE NULL,
       print_copies         VARCHAR2(255) NULL
);


CREATE TABLE Journal (
       Journal_id           NUMBER NOT NULL,
       Journal_Abbreviation VARCHAR2(50) NOT NULL,
       Publisher_Name       VARCHAR2(127) NULL,
       Journal_Name         VARCHAR2(150) NOT NULL
);


CREATE TABLE Journal_Article (
       Publication_id       INTEGER NOT NULL,
       Journal_id           NUMBER NULL,
       Begins_Page_Number   INTEGER NULL,
       Ends_Page_Number     INTEGER NULL,
       Volume_Number        INTEGER NULL,
       Issue_Number         INTEGER NULL
);


CREATE TABLE Karyo_Slide (
       Collection_Object_id INTEGER NOT NULL,
       Karyo_Slide_Num      INTEGER NULL,
       Karyo_Stain_Proc     VARCHAR2(255) NULL,
       Karyo_Derived_From_Biol_Indv NUMBER NOT NULL,
       Karyo_Prep_Meth      VARCHAR2(40) NULL
);


CREATE TABLE Lat_Long (
       Lat_Long_id          INTEGER NOT NULL,
       Locality_id          INTEGER NOT NULL,
       Lat_Deg              INTEGER NULL,
       Dec_Lat_Min          NUMBER(10,8) NULL,
       Lat_Min              INTEGER NULL,
       Lat_Sec              NUMBER(8,6) NULL,
       Lat_Dir              CHAR(1) NULL,
       Long_Deg             INTEGER NULL,
       Dec_Long_Min         NUMBER(10,8) NULL,
       Long_Min             INTEGER NULL,
       Long_Sec             NUMBER(8,6) NULL,
       Long_Dir             CHAR(1) NULL,
       Dec_Lat              NUMBER(12,10) NULL,
       Dec_Long             NUMBER(13,10) NULL,
       Datum                VARCHAR2(40) NULL,
       UTM_Zone             VARCHAR2(3) NULL,
       UTM_EW               INTEGER NULL,
       UTM_NS               INTEGER NULL,
       Orig_Lat_Long_Units  VARCHAR2(20) NULL,
       Determined_By_Agent_id INTEGER NOT NULL,
       Determined_Date      DATE NULL,
       Lat_Long_Ref_Source  VARCHAR2(255) NULL,
       Lat_Long_Remarks     VARCHAR2(255) NULL,
       Max_Error_Distance   NUMBER(6,2) NULL,
       Max_Error_Units      VARCHAR2(2) NULL,
       Nearest_Named_Place  VARCHAR2(255) NULL,
       Lat_Long_For_NNP_fg  SMALLINT NOT NULL,
       Field_Verified_fg    SMALLINT NOT NULL,
       Accepted_Lat_Long_fg SMALLINT NOT NULL
);


CREATE TABLE Loan_Installment (
       Transaction_id       INTEGER NOT NULL,
       Correspondence_id    INTEGER NULL,
       Installment_Due_Date DATE NULL,
       Completed_Date       DATE NULL,
       Loan_Num_Prefix      VARCHAR2(10) NULL,
       Loan_Num             NUMBER NOT NULL,
       Loan_Num_Suffix      VARCHAR2(10) NULL,
       Loan_Installment_Status VARCHAR2(20) NOT NULL,
       Installment_Order    NUMBER NOT NULL,
       Lender_Inv_Ret_fg    SMALLINT NOT NULL,
       Borrower_Inv_Ret_fg  SMALLINT NOT NULL,
       Loan_Type            VARCHAR2(25) NOT NULL
);


CREATE TABLE Loan_Item (
       Transaction_id       INTEGER NOT NULL,
       Collection_Object_id INTEGER NOT NULL,
       Container_id         INTEGER NOT NULL,
       Reconciled_By_Person_id INTEGER NOT NULL,
       Reconciled_Date      DATE NULL,
       Item_Descr           VARCHAR2(127) NOT NULL,
       Item_Instructions    VARCHAR2(255) NULL,
       Loan_Item_Remarks    VARCHAR2(255) NULL
);


CREATE TABLE Loan_Request (
       Correspondence_id    INTEGER NOT NULL,
       Installment_Count    NUMBER NOT NULL,
       Request_Status       VARCHAR2(20) NOT NULL,
       Loan_Instructions    VARCHAR2(255) NULL,
       Request_Closed_Date  DATE NULL,
       Shipping_Instructions VARCHAR2(255) NULL
);


CREATE TABLE Locality (
       Locality_id          INTEGER NOT NULL,
       Geog_Auth_Rec_id     INTEGER NOT NULL,
       Accepted_Lat_Long_id NUMBER NOT NULL,
       Maximum_Elevation    NUMBER(5,0) NULL,
       Minimum_Elevation    NUMBER(5,0) NULL,
       Orig_Elev_Units      VARCHAR2(2) NULL,
       Township             INTEGER NULL,
       Township_Direction   CHAR(1) NULL,
       Range                INTEGER NULL,
       Range_Direction      CHAR(1) NULL,
       Section              INTEGER NULL,
       Section_Part         VARCHAR2(25) NULL,
       Spec_Locality        VARCHAR2(255) NOT NULL,
       Locality_Remarks     VARCHAR2(255) NULL,
       Legacy_Spec_Locality_fg SMALLINT NOT NULL
);


CREATE TABLE Mammal (
       Collection_Object_id INTEGER NOT NULL,
       Karyotype_Slides_fg  SMALLINT NOT NULL,
       Total_Length         NUMBER(5,1) NULL,
       Tail_Length          NUMBER(5,1) NULL,
       Hind_Foot_Length     NUMBER(5,1) NULL,
       Ear_Length           NUMBER(5,1) NULL,
       Tragus_Length        NUMBER(5,1) NULL,
       Forearm_Length       NUMBER(5,1) NULL,
       Length_Units         VARCHAR2(2) NULL
);


CREATE TABLE Model (
       Collection_Object_id INTEGER NOT NULL,
       Model_Descr          VARCHAR2(255) NULL
);


CREATE TABLE Notes_of_Coll_Event (
       Collecting_Event_id  INTEGER NOT NULL,
       Publication_id       INTEGER NOT NULL
);


CREATE TABLE Org (
       Agent_id             INTEGER NOT NULL,
       Dept_Unit            VARCHAR2(120) NULL
);


CREATE TABLE Page (
       Page_id              NUMBER NOT NULL,
       Publication_id       INTEGER NULL,
       Section_Page_Order   NUMBER NOT NULL,
       Page_Num             VARCHAR2(20) NULL
);


CREATE TABLE Part_Matrix (
       Collection_Object_id INTEGER NOT NULL,
       Biol_Indiv_Type      VARCHAR2(5) NOT NULL,
       Sex_Cde              VARCHAR2(10) NOT NULL,
       tissue_fg            SMALLINT NOT NULL,
       herp_wet_flat_skin_fg SMALLINT NOT NULL,
       herp_dry_flat_skin_fg SMALLINT NOT NULL,
       skull_fg             SMALLINT NOT NULL,
       complete_skel_fg     SMALLINT NOT NULL,
       partial_skel_fg      SMALLINT NOT NULL,
       herp_whole_alc_fg    SMALLINT NOT NULL,
       herp_whole_formalin_fg SMALLINT NOT NULL,
       herp_whole_cs_fg     SMALLINT NOT NULL,
       herp_whole_other_fluid_fg SMALLINT NOT NULL,
       bird_study_skin_fg   SMALLINT NOT NULL,
       bird_body_skin_fg    SMALLINT NOT NULL,
       bird_flat_skin_fg    SMALLINT NOT NULL,
       non_herp_fluid_pres_fg SMALLINT NOT NULL,
       bird_wing_fg         SMALLINT NOT NULL,
       mammal_skin_fg       SMALLINT NOT NULL,
       skull_only_fg        SMALLINT NOT NULL,
       mammal_skin_only_fg  SMALLINT NOT NULL,
       mammal_skin_and_skull_fg SMALLINT NOT NULL,
       other_part_fg        SMALLINT NOT NULL,
       mvzfc                VARCHAR2(30) NULL,
       herp_s_no            VARCHAR2(30) NULL,
       part_count           SMALLINT NOT NULL,
       skin_text            VARCHAR2(20) NOT NULL,
       skull_text           VARCHAR2(20) NOT NULL,
       skel_text            VARCHAR2(20) NOT NULL,
       fluid_text           VARCHAR2(20) NOT NULL,
       tissue_text          VARCHAR2(20) NOT NULL,
       other_part_text      VARCHAR2(70) NOT NULL
);


CREATE TABLE Permit (
       Permit_id            INTEGER NOT NULL,
       Issued_By_Agent_id   INTEGER NOT NULL,
       Issued_Date          DATE NULL,
       Issued_To_Agent_id   INTEGER NOT NULL,
       Renewed_Date         DATE NULL,
       Exp_Date             DATE NULL,
       Permit_Num           VARCHAR2(20) NULL,
       Permit_Type          VARCHAR2(50) NOT NULL,
       Permit_Remarks       VARCHAR2(255) NULL
);


CREATE TABLE Permit_Shipment (
       Permit_id            INTEGER NOT NULL,
       Container_id         INTEGER NOT NULL
);


CREATE TABLE Permit_Trans (
       Permit_id            INTEGER NOT NULL,
       Transaction_id       INTEGER NOT NULL
);


CREATE TABLE Person (
       Person_id            INTEGER NOT NULL,
       Prefix               VARCHAR2(20) NULL,
       Last_Name            VARCHAR2(60) NOT NULL,
       First_Name           VARCHAR2(40) NULL,
       Middle_Name          VARCHAR2(40) NULL,
       Suffix               VARCHAR2(20) NULL,
       Birth_Date           DATE NULL,
       Death_Date           DATE NULL
);


CREATE TABLE Phantom_Biol_Indiv (
       Phantom_Biol_Indiv_id NUMBER NOT NULL,
       Sex_Cde              VARCHAR2(10) NULL,
       Sex_Cde_Mod          VARCHAR2(20) NULL,
       Age_Class            VARCHAR2(21) NULL,
       Repro_Data           VARCHAR2(255) NULL,
       Non_Repro_Behavior   CHAR(18) NULL,
       Habitat              VARCHAR2(255) NULL
);


CREATE TABLE Phantom_Relations (
       Phantom_Biol_Indiv_id NUMBER NOT NULL,
       Related_Phantom_Biol_Indiv_id NUMBER NOT NULL,
       Biol_Indiv_Relationship VARCHAR2(18) NOT NULL
);


CREATE TABLE Phone (
       Agent_Addr_id        NUMBER NOT NULL,
       Phone_Num            VARCHAR2(30) NOT NULL,
       Phone_Label          VARCHAR2(30) NOT NULL
);


CREATE TABLE Project (
       Project_id           INTEGER NOT NULL,
       Start_Date           DATE NULL,
       End_Date             DATE NULL,
       Project_Name         VARCHAR2(255) NOT NULL,
       Project_Description  VARCHAR2(255) NULL,
       Project_Remarks      VARCHAR2(255) NULL
);


CREATE TABLE Project_Agent (
       Project_id           INTEGER NOT NULL,
       Agent_Name_id        NUMBER NOT NULL,
       Project_Agent_Role   VARCHAR2(25) NOT NULL,
       Project_Agent_Remarks VARCHAR2(255) NULL
);


CREATE TABLE Project_Coll_Event (
       Project_id           INTEGER NOT NULL,
       Collecting_Event_id  INTEGER NOT NULL
);


CREATE TABLE Project_Publication (
       Project_id           INTEGER NOT NULL,
       Publication_id       INTEGER NOT NULL,
       Project_Publication_Remarks VARCHAR2(255) NULL
);


CREATE TABLE Project_Taxonomy (
       Project_id           INTEGER NOT NULL,
       Taxon_Name_id        NUMBER NOT NULL,
       Project_Taxon_Role   VARCHAR2(25) NOT NULL,
       Project_Taxon_Remarks VARCHAR2(255) NULL
);


CREATE TABLE Project_Trans (
       Project_id           INTEGER NOT NULL,
       Transaction_id       INTEGER NOT NULL,
       Project_Trans_Remarks VARCHAR2(255) NULL
);


CREATE TABLE Publication (
       Publication_id       INTEGER NOT NULL,
       Published_Year       INTEGER NULL,
       Publication_Type     VARCHAR2(21) NOT NULL,
       Publication_Loc      VARCHAR2(25) NULL,
       Publication_Title    VARCHAR2(255) NULL,
       Publication_Remarks  VARCHAR2(255) NULL
);


CREATE TABLE Publication_Author_Name (
       Publication_id       INTEGER NOT NULL,
       Agent_Name_id        NUMBER NOT NULL,
       Author_Position      INTEGER NOT NULL
);


CREATE TABLE Publication_Year (
       Publication_id       INTEGER NOT NULL,
       Pub_Year             NUMBER NOT NULL
);


CREATE TABLE Sequence_Repos_Article (
       Publication_id       INTEGER NOT NULL,
       Sequence_Repository_id NUMBER NULL,
       Accn_Num             VARCHAR2(40) NOT NULL
);


CREATE TABLE Sequence_Repository (
       Sequence_Repository_id NUMBER NOT NULL,
       Repository_Name      VARCHAR2(30) NOT NULL,
       URL                  CHAR(18) NULL
);


CREATE TABLE Shipment (
       Container_id         INTEGER NOT NULL,
       Transaction_id       INTEGER NOT NULL,
       From_Agent_Addr_id   NUMBER NOT NULL,
       Packed_By_Agent_id   INTEGER NOT NULL,
       Hand_Carried_Agent_Addr_id NUMBER NULL,
       Shipped_To_Agent_Addr_id NUMBER NOT NULL,
       Shipped_Carrier_Method VARCHAR2(30) NOT NULL,
       Carriers_Tracking_Number VARCHAR2(20) NULL,
       Shipped_Date         DATE NULL,
       Package_Weight       VARCHAR2(10) NULL,
       Hazmat_fg            SMALLINT NOT NULL,
       Insured_For_Insured_Value NUMBER NOT NULL,
       Shipment_Remarks     VARCHAR2(255) NULL,
       Contents             VARCHAR2(255) NULL,
       Foreign_Shipment_fg  SMALLINT NOT NULL
);


CREATE TABLE Species_Tape (
       Collection_Object_id INTEGER NOT NULL,
       Taxon_Name_id        NUMBER NOT NULL
);


CREATE TABLE Specimen_Part (
       Collection_Object_id INTEGER NOT NULL,
       Part_Name            VARCHAR2(70) NOT NULL,
       Part_Modifier        VARCHAR2(60) NULL,
       Preserv_Method       VARCHAR2(25) NULL,
       Preserved_In_ETOH_fg SMALLINT NOT NULL,
       Specimen_Storage_Loc VARCHAR2(30) NULL,
       Transformation_Date  DATE NULL,
       Derived_From_Biol_Indv NUMBER NOT NULL
);


CREATE TABLE Still_Image (
       Collection_Object_id INTEGER NOT NULL,
       Dimensions           VARCHAR2(255) NULL,
       Contra_Info          VARCHAR2(255) NULL
);


CREATE TABLE Tape (
       Collection_Object_id INTEGER NOT NULL,
       Tape_Format          VARCHAR2(20) NOT NULL,
       Tape_Type            VARCHAR2(10) NOT NULL
);


CREATE TABLE Tax_Protect_Status (
       Protection_List_Name VARCHAR2(50) NOT NULL,
       Taxon_Name_id        NUMBER NOT NULL,
       Listed_Date          DATE NULL,
       Protect_Status_Name  VARCHAR2(25) NOT NULL,
       Protect_Status_Remarks VARCHAR2(255) NULL
);


CREATE TABLE Taxon_Relations (
       Taxon_Name_id        NUMBER NOT NULL,
       Related_Taxon_Name_id NUMBER NOT NULL,
       Taxon_Relationship   VARCHAR2(30) NOT NULL
);


CREATE TABLE Taxonomy (
       Taxon_Name_id        NUMBER NOT NULL,
       Phylclass            VARCHAR2(20) NULL,
       Phylorder            VARCHAR2(30) NULL,
       Suborder             VARCHAR2(30) NULL,
       Family               VARCHAR2(30) NULL,
       Subfamily            VARCHAR2(30) NULL,
       Genus                VARCHAR2(30) NULL,
       Subgenus             VARCHAR2(20) NULL,
       Species              VARCHAR2(40) NULL,
       Subspecies           VARCHAR2(40) NULL,
       Valid_Catalog_Term_fg SMALLINT NOT NULL,
       Source_Authority     VARCHAR2(45) NOT NULL,
       Full_Taxon_Name      VARCHAR2(240) NOT NULL,
       Scientific_Name      VARCHAR2(110) NULL,
       Author_Text          VARCHAR2(60) NULL
);


CREATE TABLE Tissue_Prep (
       Collection_Object_id INTEGER NOT NULL,
       Prep_From_Prep_id    NUMBER NULL,
       Prepared_By_Agent_id INTEGER NULL,
       Tissue_Prep_Method   VARCHAR2(30) NULL,
       Prepared_Date        DATE NULL,
       DNA_Conc             VARCHAR2(20) NULL,
       Prep_Storage_Medium  VARCHAR2(20) NOT NULL,
       Original_Volume      VARCHAR2(15) NULL,
       Prep_From_Tissue_Sample_id INTEGER NULL,
       Tissue_Prep_Num      NUMBER(8,1) NOT NULL
);


CREATE TABLE Tissue_Sample (
       Collection_Object_id INTEGER NOT NULL,
       Derived_From_Biol_Indiv NUMBER NOT NULL,
       Tissue_Sample_Num    NUMBER(8,1) NOT NULL,
       Tissue_Preserv_Meth  VARCHAR2(20) NOT NULL,
       Tissue_Vial_Type     VARCHAR2(15) NOT NULL,
       Tissue_Type          VARCHAR2(255) NOT NULL,
       Is_Subsample_fg      SMALLINT NOT NULL,
       Sampled_From_Obj_id  NUMBER NULL
);


CREATE TABLE Trans (
       Transaction_id       INTEGER NOT NULL,
       Auth_Agent_id        INTEGER NULL,
       Trans_Date           DATE NULL,
       Trans_Entered_Agent_id INTEGER NOT NULL,
       Received_Agent_id    INTEGER NOT NULL,
       Corresp_fg           SMALLINT NOT NULL,
       Transaction_Type     VARCHAR2(18) NOT NULL,
       Nature_Of_Material   VARCHAR2(255) NOT NULL,
       Trans_Remarks        VARCHAR2(255) NULL
);


CREATE TABLE Trans_Agent_Addr (
       Transaction_id       INTEGER NOT NULL,
       Agent_Addr_id        NUMBER NOT NULL,
       Trans_Agent_Role_Name VARCHAR2(20) NOT NULL
);


CREATE TABLE Trans_Relations (
       Transaction_id       INTEGER NOT NULL,
       Related_Transaction_id INTEGER NOT NULL,
       Trans_Relationship   CHAR(18) NOT NULL
);


CREATE TABLE URL (
       URL_id               NUMBER NOT NULL,
       URL                  VARCHAR2(255) NULL,
       Filename             VARCHAR2(255) NULL,
       URL_Type             VARCHAR2(10) NOT NULL,
       Collection_Object_id INTEGER NULL,
       Viewer_id            NUMBER NULL
);


CREATE TABLE Viewer (
       Viewer_id            NUMBER NOT NULL,
       Viewer               VARCHAR2(255) NOT NULL,
       Path                 VARCHAR2(255) NULL,
       Params               VARCHAR2(255) NULL
);


CREATE TABLE Vocal_Series (
       Collection_Object_id INTEGER NOT NULL,
       From_Biol_Indiv_id   NUMBER NULL,
       From_Phantom_Biol_Indiv_id NUMBER NULL,
       Vocal_Type           VARCHAR2(30) NOT NULL,
       Cues_Count           INTEGER NULL,
       Indiv_Num_On_Tape    INTEGER NOT NULL,
       Vocal_Type_Details   VARCHAR2(255) NULL,
       Background_Vocals    VARCHAR2(255) NULL,
       Background_Noise     VARCHAR2(255) NULL
);


CREATE TABLE Vocal_Series_Cut_History (
       Taxon_Name_id        NUMBER NOT NULL,
       Taxon_Cut_Num        NUMBER NOT NULL,
       Collection_Object_id INTEGER NOT NULL
);


CREATE TABLE Vocal_Series_On_Tape (
       Tape_id              INTEGER NOT NULL,
       Tape_Side            CHAR(1) NULL,
       Tape_id              INTEGER NOT NULL,
       Original_fg          SMALLINT NOT NULL,
       Copied_From_Voc_Series_id NUMBER NOT NULL,
       Copied_From_Tape_id  NUMBER NOT NULL
);