| DDL Code |
CREATE TABLE CNMS_PRPSL.PROPOSAL(
PRPSL_ID VARCHAR2(10) NOT NULL,
USER_ACCESS_ID VARCHAR2(20),
RAPID_ACC_IND CHAR(1) DEFAULT 'N' NOT NULL,
RA_JUST VARCHAR2(2000),
STAT_ID VARCHAR2(20) NOT NULL,
REVIEW_STAT_ID VARCHAR2(20),
TITLE VARCHAR2(128) NOT NULL,
REASON_USE VARCHAR2(500),
CY_ID VARCHAR2(25),
STAFF_CONT_IND CHAR(1) DEFAULT 'N',
INST_ID NUMBER(38, 0) NOT NULL,
PERSON_ID VARCHAR2(10) NOT NULL,
REQ_BEGIN_WORK_DTE DATE NOT NULL,
REQ_DAY_NBR NUMBER(3, 0),
ACT_DAY_NBR NUMBER(3, 0),
PRPSL_CAT_ID VARCHAR2(25),
PRPSL_DTE DATE DEFAULT sysdate NOT NULL,
MOD_DATE DATE NOT NULL,
APEX_PAGE_NBR NUMBER(4, 0),
SPEC_COND VARCHAR2(4000),
PART_USER_DESCR VARCHAR2(255),
RSS_ID NUMBER(38, 0),
RSS_CMNT VARCHAR2(2000),
GRP_LEAD_APRV_IND CHAR(1) DEFAULT 'N' NOT NULL,
CONSTRAINT PK_PROPOSAL PRIMARY KEY (PRPSL_ID)
USING INDEX
LOGGING,
CONSTRAINT fk_proposal_to_person FOREIGN KEY (PERSON_ID)
REFERENCES XF_ADMIN.PERSON(PERSON_ID),
CONSTRAINT fk_proposal_to_institute FOREIGN KEY (INST_ID)
REFERENCES XF_ADMIN.INST(INST_ID),
CONSTRAINT fk_proposal_to_prpsl_stat FOREIGN KEY (STAT_ID)
REFERENCES CNMS_PRPSL.PRPSL_STAT(STAT_ID),
CONSTRAINT fk_proposal_to_prpsl_cat FOREIGN KEY (PRPSL_CAT_ID)
REFERENCES CNMS_PRPSL.PRPSL_CAT(PRPSL_CAT_ID),
CONSTRAINT fk_proposal_to_expt_cycle FOREIGN KEY (CY_ID)
REFERENCES CNMS_PRPSL.EXPT_CYCLE(CY_ID),
CONSTRAINT fk_prpsl_to_user_access_mode FOREIGN KEY (USER_ACCESS_ID)
REFERENCES CNMS_PRPSL.USER_ACESS_MODE(USER_ACCESS_ID)
)
LOGGING
NOPARALLEL
NOCACHE
NOCOMPRESS
;
|
