sgc-portal/mobile-src/docs/DB_SQL.sql

CREATE TABLE SGC.TCS_SITE_DHS (
	CMPN_CD VARCHAR(10) NOT NULL,
	SITE_CD VARCHAR(20) NOT NULL,
	DONG VARCHAR(100) NOT NULL,
	HSNO VARCHAR(100) NOT NULL,
	CNTPR_OCPH_NM VARCHAR(100),
	CP_NO VARCHAR(100),
	WRTE_DT DATE DEFAULT sysdate,
	WRTE_PR VARCHAR(20),
	MDFT_DT DATE,
	MDFT_PR VARCHAR(20)
)
TABLESPACE TS_SGCDATA
PCTFREE 10
INITRANS 2
STORAGE (
	MAXEXTENTS UNLIMITED
)
LOGGING
NOPARALLEL;
COMMENT ON TABLE SGC.TCS_SITE_DHS IS '하자) 현장 동호수';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.CMPN_CD IS '회사 코드';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.CNTPR_OCPH_NM IS '계약 입주 자';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.CP_NO IS '핸드폰 번호';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.DONG IS '동';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.HSNO IS '호수';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.MDFT_DT IS '수정 일자';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.MDFT_PR IS '수정 자';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.SITE_CD IS '현장코드';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.WRTE_DT IS '작성 일자';
COMMENT ON COLUMN SGC.TCS_SITE_DHS.WRTE_PR IS '작성 자';

CREATE UNIQUE INDEX SGC.PK_TCS_SITE_DHS ON SGC.TCS_SITE_DHS (
	CMPN_CD ASC,
	SITE_CD ASC,
	DONG ASC,
	HSNO ASC
)
LOGGING
TABLESPACE TS_SGCIDX
PCTFREE 10
INITRANS 2;

ALTER TABLE SGC.TCS_SITE_DHS ADD CONSTRAINT PK_TCS_SITE_DHS
PRIMARY KEY (
	CMPN_CD,
	SITE_CD,
	DONG,
	HSNO
);