CREATE TABLE ZH_LANGUAGE (
  ID NUMBER(10) NOT NULL, 
  SHORT_NAME VARCHAR2(6) NOT NULL, 
  LANGUAGE_ISO VARCHAR2(5) NOT NULL, 
  COUNTRY_CODE VARCHAR2(2) NOT NULL, 
  NAME VARCHAR2(120) NOT NULL, 
  DESCRIPTION VARCHAR2(510) NOT NULL, 
  HELP VARCHAR2(2000) NOT NULL, 
  IS_ACTIVE VARCHAR2(1) DEFAULT 'Y' NOT NULL, 
  ORGANIZATION_ID VARCHAR2(255) NOT NULL, 
  CREATED DATE NOT NULL, 
  UPDATED DATE NOT NULL, 
  CREATED_BY VARCHAR2(255) NOT NULL, 
  UPDATED_BY VARCHAR2(255) NOT NULL,
  CONSTRAINT LANGUAGE_PK PRIMARY KEY(ID)
)
/
ALTER TABLE ZH_LANGUAGE ADD CONSTRAINT CHECK_LANGUAGE_ACTIVE CHECK (("IS_ACTIVE"='N' OR "IS_ACTIVE"='Y'))

