ALTER TABLE SST_VITIMAPARTEATINGIDA ADD (
  LATERALIDADE VARCHAR2(20) DEFAULT NULL NULL
)
/
ALTER TABLE SST_VITIMA ADD (
  NRCATORIGEM VARCHAR2(50) DEFAULT NULL NULL, 
  IDTIPOCAT VARCHAR2(3) DEFAULT NULL NULL, 
  IDINTERNACAO VARCHAR2(1) DEFAULT 'N' NOT NULL
)
/
ALTER TABLE SST_VITIMA ADD CONSTRAINT CKC_IDINTERNACAO_VITIMA CHECK (IDINTERNACAO IN ('N','S'))
/
ALTER TABLE SST_TABRESULTEXAME ADD (
  IDAPTO VARCHAR2(1) DEFAULT '1' NOT NULL
)
/
ALTER TABLE SST_TABRESULTEXAME ADD CONSTRAINT CKC_TABRESULTEXAME_IDAPTO CHECK (IDAPTO IN (1,2))
/
ALTER TABLE SST_TABRESULTEXAME DROP CONSTRAINT CKC_IDRESULTEXAME_SST_ITEMEXAM
/
ALTER TABLE SST_TABRESULTEXAME ADD CONSTRAINT CKC_IDRESULTEXAME_SST_ITEMEXAM CHECK (IDRESULTEXAME IN ('A','E','G', 'N'))
/
ALTER TABLE SST_EXAMEFICHAMED ADD (
  CDPROCTUSS NUMBER(10) DEFAULT NULL NULL, 
  OBSPROCTUSS VARCHAR2(300) DEFAULT NULL NULL, 
  INTERPREXAME NUMBER(10) DEFAULT NULL NULL
)