CREATE TABLE FCT_DADOSSUSPCONTR (
    NRDADOSSUSPCONTR       	NUMBER  NOT NULL,
    NRSEQCONTRATO          	NUMBER,
    DTSUSPENSAO            	DATE, 
    CDOPERSOLSUSPENSAO     	VARCHAR2(12),
    DSJUSTIFCASUSPENSAO    	VARCHAR2(4000),
    NRORG              		NUMBER 	     DEFAULT         SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
    IDATIVO           		VARCHAR2(1)     DEFAULT 'S' NOT NULL
      CONSTRAINT CKC_IDATIVO_DADOSSUSPCONT CHECK (IDATIVO IN ('S','N')),
    DTINCLUSAO        		DATE                  			NULL,
    DTULTATU          		DATE                  			NULL,
    NRORGINCLUSAO     		NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERINCLUSAO    		VARCHAR2(12)    DEFAULT '1' 		NULL,
    NRORGULTATU       		NUMBER          DEFAULT SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERULTATU      		VARCHAR2(12)    DEFAULT '1'
)
/  

ALTER TABLE FCT_DADOSSUSPCONTR ADD CONSTRAINT PK_FCT_DADOSSUSPCONTR PRIMARY KEY (NRDADOSSUSPCONTR)
/

CREATE INDEX SM00330_FK ON FCT_DADOSSUSPCONTR (NRSEQCONTRATO ASC)
/

ALTER TABLE FCT_DADOSSUSPCONTR
    ADD CONSTRAINT FKSM00330CONT_DADOSSUSPCONT FOREIGN KEY (NRSEQCONTRATO)
      REFERENCES FCT_CONTRATO (NRSEQCONTRATO)
/