CREATE TABLE ZH_WORDS (
  ID NUMBER(10) NOT NULL, 
  VALUE VARCHAR2(4000) NOT NULL, 
  IS_ACTIVE VARCHAR2(1) DEFAULT 'Y' NOT NULL, 
  CREATED DATE NOT NULL, 
  UPDATED DATE NOT NULL, 
  CREATED_BY VARCHAR2(255) NOT NULL, 
  ORGANIZATION_ID VARCHAR2(255) NOT NULL, 
  UPDATED_BY VARCHAR2(255) NOT NULL,
  CONSTRAINT WORDS_PK PRIMARY KEY(ID)
)
/
ALTER TABLE ZH_WORDS ADD CONSTRAINT CHECK_WORDS_ACTIVE CHECK (("IS_ACTIVE"='N' OR "IS_ACTIVE"='Y'))

