ALTER TABLE FCT_ITCOMPSERVICO ADD IDAPARECEPROPOSTA CHAR(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE FCT_ITCOMPSERVICO ADD CONSTRAINT CKC_IDAPARECEPROP_ITCOMPSERV CHECK (IDAPARECEPROPOSTA IN ('S', 'N'))
/

ALTER TABLE FCT_TRABSERVORCAMENTO ADD IDAPARECEPROPOSTA CHAR(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE FCT_TRABSERVORCAMENTO ADD CONSTRAINT CKC_IDAPARECEPROP_TRABSERVPROP CHECK (IDAPARECEPROPOSTA IN ('S', 'N'))
/

ALTER TABLE FCT_RELACMEDIDAPROPOSTA ADD IDAPARECEPROPOSTA CHAR(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE FCT_RELACMEDIDAPROPOSTA ADD CONSTRAINT CKC_IDAPARECEPROP_RELMEDPROP CHECK (IDAPARECEPROPOSTA IN ('S', 'N'))
/

ALTER TABLE FCT_ITEMORCAMENTO ADD IDAPARECEPROPOSTA CHAR(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE FCT_ITEMORCAMENTO ADD CONSTRAINT CKC_IDAPARECEPROP_ITEMORCA CHECK (IDAPARECEPROPOSTA IN ('S', 'N'))
/

ALTER TABLE FCT_TRABSERVCONTRATO ADD IDAPARECEPROPOSTA CHAR(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE FCT_TRABSERVCONTRATO ADD CONSTRAINT CKC_IDAPARECEPROP_TRABSERVCONT CHECK (IDAPARECEPROPOSTA IN ('S', 'N'))
/

ALTER TABLE FCT_RELACMEDIDACONTRATO ADD IDAPARECEPROPOSTA CHAR(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE FCT_RELACMEDIDACONTRATO ADD CONSTRAINT CKC_IDAPARECEPROP_RELMEDCONT CHECK (IDAPARECEPROPOSTA IN ('S', 'N'))
/

ALTER TABLE FCT_ITEMCONTRATO ADD IDAPARECEPROPOSTA CHAR(1) DEFAULT 'S' NOT NULL
/

ALTER TABLE FCT_ITEMCONTRATO ADD CONSTRAINT CKC_IDAPARECEPROP_ITEMCONT CHECK (IDAPARECEPROPOSTA IN ('S', 'N'))
/