CREATE TABLE SIT_CONTRATO (
  NRSITCONTRATO NUMBER(10) NOT NULL, 
  NRORGINT NUMBER(10) NOT NULL, 
  IDCONTRATIV VARCHAR2(1) DEFAULT 'S' NOT NULL, 
  IDCONSNUT VARCHAR2(1) DEFAULT 'S' NOT NULL, 
  IDFATCORR VARCHAR2(1) DEFAULT 'N' NOT NULL, 
  NRCONTRTEK VARCHAR2(10) DEFAULT NULL NULL, 
  NRORG NUMBER(10) DEFAULT 1 NOT NULL, 
  IDATIVO VARCHAR2(1) DEFAULT 'S' NOT NULL, 
  DTINCLUSAO DATE DEFAULT NULL NULL, 
  DTULTATU DATE DEFAULT NULL NULL, 
  NRORGINCLUSAO NUMBER(10) DEFAULT 1 NULL, 
  CDOPERINCLUSAO VARCHAR2(12) DEFAULT '1' NULL, 
  NRORGULTATU NUMBER(10) DEFAULT 1 NULL, 
  CDOPERULTATU VARCHAR2(12) DEFAULT '1' NULL,
  CONSTRAINT PK_SITCONTRATO PRIMARY KEY(NRSITCONTRATO, NRORG)
)
/
ALTER TABLE SIT_CONTRATO ADD CONSTRAINT CKC_IDATIVO_SITCONTRATO CHECK (IDATIVO IN ('S','N'))
/
ALTER TABLE SIT_CONTRATO ADD CONSTRAINT CKC_IDCONTRATIV_SITCONTRATO CHECK (IDCONTRATIV IN ('S','N'))
/
ALTER TABLE SIT_CONTRATO ADD CONSTRAINT CKC_IDCONSNUT_SITCONTRATO CHECK (IDCONSNUT IN ('S','N'))
/
ALTER TABLE SIT_CONTRATO ADD CONSTRAINT CKC_IDFATCORR_SITCONTRATO CHECK (IDFATCORR IN ('S','N'))