CREATE TABLE ZH_REPOSITORY (
  ID NUMBER(10) NOT NULL, 
  URL VARCHAR2(500) NOT NULL, 
  IS_PUBLIC VARCHAR2(1) DEFAULT 'Y' NOT NULL, 
  FRONT_PATH VARCHAR2(300) DEFAULT NULL NULL, 
  DEFAULT_LANGUAGE NUMBER(10) DEFAULT NULL NULL, 
  ORGANIZATION_ID NUMBER(10) NOT NULL, 
  CREATED_BY NUMBER(10) NOT NULL, 
  CREATED DATE DEFAULT SYSDATE NOT NULL, 
  UPDATED_BY NUMBER(10) NOT NULL, 
  UPDATED DATE DEFAULT SYSDATE NOT NULL,
  CONSTRAINT ZH_REPO_PK PRIMARY KEY(ID)
)
/
ALTER TABLE ZH_REPOSITORY ADD CONSTRAINT CHECK_12555 CHECK (IS_PUBLIC IN ('Y','N'))
/
CREATE SEQUENCE ZH_REPOSITORY_ID_SEQ START WITH 1 MINVALUE 1 INCREMENT BY 1