ALTER TABLE ORGANIZACAO ADD NRSCORE NUMBER
/
ALTER TABLE ORGANIZACAO ADD IDALERTA VARCHAR2(1)
/
ALTER TABLE ORGANIZACAO ADD DSDIRETORCLIE VARCHAR2(500)
/
ALTER TABLE ORGANIZACAO ADD DSRESPTICLIE VARCHAR2(500)
/

ALTER TABLE ORGANIZACAO ADD CDOPERPADRINHO VARCHAR2(12)
/
ALTER TABLE ORGANIZACAO ADD CONSTRAINT FK_ORG_OPER_CDOPERPAD FOREIGN KEY (CDOPERPADRINHO) REFERENCES OPERADOR (CDOPERADOR)
/
ALTER TABLE ORGANIZACAO ADD CDOPERGERENTE VARCHAR2(12)
/
ALTER TABLE ORGANIZACAO ADD CONSTRAINT FK_ORG_OPER_CDOPERGER FOREIGN KEY (CDOPERGERENTE) REFERENCES OPERADOR (CDOPERADOR)
/
ALTER TABLE ORGANIZACAO ADD IDOPERGERPROJ VARCHAR2(12)
/
ALTER TABLE ORGANIZACAO ADD CONSTRAINT CKC_ORG_IDOPERGERPROJ CHECK (IDOPERGERPROJ IN ('S', 'N'))
/