ALTER TABLE PROJECT_TYPE ADD (
  STATUS VARCHAR2(1) DEFAULT 'A' NOT NULL
)
/
ALTER TABLE PROJECT_TYPE ADD CONSTRAINT CKC_PROJECT_TYPE_STATUS CHECK (STATUS in ('A','I','D'))
/