CREATE TABLE IACUC_SUBMISSION_TYPE (
    SUBMISSION_TYPE_CODE VARCHAR2(3) NOT NULL,
    DESCRIPTION VARCHAR2(200) NOT NULL,
    UPDATE_TIMESTAMP DATE NOT NULL,
    UPDATE_USER VARCHAR2(60) NOT NULL,
    VER_NBR NUMBER(8,0) DEFAULT 1 NOT NULL 
    OBJ_ID VARCHAR2(36) NOT NULL)
/
ALTER TABLE IACUC_SUBMISSION_TYPE
ADD CONSTRAINT PK_IACUC_SUBMISSION_TYPE
PRIMARY KEY (SUBMISSION_TYPE_CODE)
/

CREATE TABLE IACUC_SUBMISSION_TYPE (
    SUBMISSION_TYPE_CODE VARCHAR2(3) NOT NULL,
    DESCRIPTION VARCHAR2(200) NOT NULL,
    UPDATE_TIMESTAMP DATE NOT NULL,
    UPDATE_USER VARCHAR2(60) NOT NULL,
    VER_NBR NUMBER(8,0) DEFAULT 1 NOT NULL,
    OBJ_ID VARCHAR2(36) NOT NULL)
/
ALTER TABLE IACUC_SUBMISSION_TYPE
ADD CONSTRAINT PK_IACUC_SUBMISSION_TYPE
PRIMARY KEY (SUBMISSION_TYPE_CODE)
/

Create initial tables for IACUC protocol submission (bloody spaces...)
KCIAC-39: Create initial tables for IACUC protocol submission (bloody spaces...)
