284 lines
16 KiB
Plaintext
284 lines
16 KiB
Plaintext
--------------------------------------------------------------------------------
|
||
-- ?곸슜?쒖뒪?쒕챸 : ?댁쁺怨?ORACLE)
|
||
-- ?뚯씠釉?: ZT_?듯빀肄붾뱶
|
||
-- ?뚯씠釉봊D : ZT_UNFC_CD
|
||
--------------------------------------------------------------------------------
|
||
CREATE TABLE S_NNZ.ZT_UNFC_CD
|
||
(
|
||
UNFC_CD_ID VARCHAR2(50) NOT NULL,
|
||
UNFC_CD_NM VARCHAR2(100) NULL,
|
||
UNFC_CD_HAN_NM VARCHAR2(100) NULL,
|
||
UNFC_CD_ENG_NM VARCHAR2(100) NULL,
|
||
UNFC_CD_DS VARCHAR2(4000) NULL,
|
||
META_SYST_CD VARCHAR2(3) NOT NULL,
|
||
META_DUTJ_TYPE_CD VARCHAR2(5) NOT NULL,
|
||
PUSE_YN VARCHAR2(1) NOT NULL,
|
||
SPPO_UNFC_CD_ID VARCHAR2(50) NULL,
|
||
DATA_LOAD_DT DATE NULL,
|
||
SYST_RGI_DT DATE NOT NULL,
|
||
SYST_RGI_PRAF_NO VARCHAR2(8) NOT NULL,
|
||
SYST_RGI_OGNZ_NO VARCHAR2(7) NOT NULL,
|
||
SYST_RGI_SYST_CD VARCHAR2(3) NOT NULL,
|
||
SYST_RGI_PRGR_ID VARCHAR2(100) NOT NULL,
|
||
SYST_CHG_DT DATE NOT NULL,
|
||
SYST_CHG_PRAF_NO VARCHAR2(8) NOT NULL,
|
||
SYST_CHG_OGNZ_NO VARCHAR2(7) NOT NULL,
|
||
SYST_CHG_SYST_CD VARCHAR2(3) NOT NULL,
|
||
SYST_CHG_PRGR_ID VARCHAR2(100) NOT NULL
|
||
)
|
||
TABLESPACE TS_ZT_D01;
|
||
|
||
|
||
|
||
COMMENT ON TABLE S_NNZ.ZT_UNFC_CD IS 'ZT_?듯빀肄붾뱶';
|
||
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.UNFC_CD_ID IS '?듯빀肄붾뱶ID';
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.UNFC_CD_NM IS '?듯빀肄붾뱶紐?;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.UNFC_CD_HAN_NM IS '?듯빀肄붾뱶?쒓?紐?;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.UNFC_CD_ENG_NM IS '?듯빀肄붾뱶?곷Ц紐?;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.UNFC_CD_DS IS '?듯빀肄붾뱶?ㅻ챸';
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.META_SYST_CD IS '硫뷀??쒖뒪?쒖퐫??;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.META_DUTJ_TYPE_CD IS '硫뷀??낅Т?좏삎肄붾뱶';
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.PUSE_YN IS '?ъ슜?щ?';
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SPPO_UNFC_CD_ID IS '?곸쐞?듯빀肄붾뱶ID';
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.DATA_LOAD_DT IS '?곗씠?곗쟻?ъ씪??;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_RGI_DT IS '?쒖뒪?쒕벑濡앹씪??;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_RGI_PRAF_NO IS '?쒖뒪?쒕벑濡앹씤?щ쾲??;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_RGI_OGNZ_NO IS '?쒖뒪?쒕벑濡앹“吏곷쾲??;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_RGI_SYST_CD IS '?쒖뒪?쒕벑濡앹떆?ㅽ뀥肄붾뱶';
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_RGI_PRGR_ID IS '?쒖뒪?쒕벑濡앺봽濡쒓렇?쭵D';
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_CHG_DT IS '?쒖뒪?쒕?寃쎌씪??;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_CHG_PRAF_NO IS '?쒖뒪?쒕?寃쎌씤?щ쾲??;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_CHG_OGNZ_NO IS '?쒖뒪?쒕?寃쎌“吏곷쾲??;
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_CHG_SYST_CD IS '?쒖뒪?쒕?寃쎌떆?ㅽ뀥肄붾뱶';
|
||
COMMENT ON COLUMN S_NNZ.ZT_UNFC_CD.SYST_CHG_PRGR_ID IS '?쒖뒪?쒕?寃쏀봽濡쒓렇?쭵D';
|
||
|
||
|
||
|
||
-- 媛쒕퀎沅뚰븳 Role
|
||
GRANT SELECT ON S_NNZ.ZT_UNFC_CD TO RL_A_EAI_NNZ_SEL;
|
||
|
||
GRANT INSERT,UPDATE,DELETE ON S_NNZ.ZT_UNFC_CD TO RL_A_EAI_NNZ_IUD;
|
||
|
||
-- Default Role
|
||
GRANT SELECT ON S_NNZ.ZT_UNFC_CD TO RL_NNZ_SEL;
|
||
|
||
GRANT INSERT,UPDATE,DELETE ON S_NNZ.ZT_UNFC_CD TO RL_NNZ_IUD;
|
||
|
||
|
||
|
||
CREATE INDEX S_NNZ.IX_ZT_UNFC_CD_01 ON S_NNZ.ZT_UNFC_CD
|
||
(UNFC_CD_NM)
|
||
TABLESPACE TS_ZT_I01;
|
||
|
||
CREATE INDEX S_NNZ.IX_ZT_UNFC_CD_02 ON S_NNZ.ZT_UNFC_CD
|
||
(UNFC_CD_HAN_NM)
|
||
TABLESPACE TS_ZT_I01;
|
||
|
||
CREATE INDEX S_NNZ.IX_ZT_UNFC_CD_03 ON S_NNZ.ZT_UNFC_CD
|
||
(UNFC_CD_ENG_NM)
|
||
TABLESPACE TS_ZT_I01;
|
||
|
||
|
||
CREATE UNIQUE INDEX S_NNZ.PK_ZT_UNFC_CD ON S_NNZ.ZT_UNFC_CD
|
||
(UNFC_CD_ID)
|
||
TABLESPACE TS_ZT_I01;
|
||
|
||
ALTER TABLE S_NNZ.ZT_UNFC_CD ADD (
|
||
CONSTRAINT PK_ZT_UNFC_CD
|
||
PRIMARY KEY (UNFC_CD_ID)
|
||
USING INDEX S_NNZ.PK_ZT_UNFC_CD);
|
||
|
||
--------------------------------------------------------------------------------
|
||
-- ?곸슜?쒖뒪?쒕챸 : 媛쒕컻怨?ORACLE)
|
||
-- ?뚯씠釉?: ZT_?듯빀肄붾뱶?곸꽭
|
||
-- ?뚯씠釉봊D : ZT_UNFC_CD_DTPT
|
||
--------------------------------------------------------------------------------
|
||
CREATE TABLE S_TFG.ZT_UNFC_CD_DTPT
|
||
(
|
||
UNFC_CD_ID VARCHAR2(50) NOT NULL,
|
||
CD_VLDT_VALU VARCHAR2(50) NOT NULL,
|
||
CD_VLDT_VALU_INQR_SEQ NUMBER(5) NULL,
|
||
CD_VLDT_VALU_NM VARCHAR2(400) NULL,
|
||
CD_VLDT_VALU_HNGL_ABR_NM VARCHAR2(200) NULL,
|
||
CD_VLDT_VALU_ENGC_ABR_NM VARCHAR2(200) NULL,
|
||
CD_VLDT_VALU_HAN_NM VARCHAR2(400) NULL,
|
||
CD_VLDT_VALU_ENG_NM VARCHAR2(400) NULL,
|
||
CD_VLDT_VALU_DS VARCHAR2(4000) NULL,
|
||
CD_ASRT_TYPE_BIT_CD VARCHAR2(20) NOT NULL,
|
||
SPPO_CD_VLDT_VALU VARCHAR2(50) NULL,
|
||
SPPO_UNFC_CD_ID VARCHAR2(50) NULL,
|
||
VLDT_STRT_YMD DATE NOT NULL,
|
||
VLDT_END_YMD DATE NOT NULL,
|
||
USER_DEF_VALU_1 VARCHAR2(100) NULL,
|
||
USER_DEF_VALU_2 VARCHAR2(100) NULL,
|
||
SYST_RGI_DT DATE NOT NULL,
|
||
SYST_RGI_PRAF_NO VARCHAR2(8) NOT NULL,
|
||
SYST_RGI_OGNZ_NO VARCHAR2(7) NOT NULL,
|
||
SYST_RGI_SYST_CD VARCHAR2(3) NOT NULL,
|
||
SYST_RGI_PRGR_ID VARCHAR2(100) NOT NULL,
|
||
SYST_CHG_DT DATE NOT NULL,
|
||
SYST_CHG_PRAF_NO VARCHAR2(8) NOT NULL,
|
||
SYST_CHG_OGNZ_NO VARCHAR2(7) NOT NULL,
|
||
SYST_CHG_SYST_CD VARCHAR2(3) NOT NULL,
|
||
SYST_CHG_PRGR_ID VARCHAR2(100) NOT NULL,
|
||
DATA_LOAD_DT DATE NOT NULL
|
||
)
|
||
TABLESPACE TS_TFG_D01;
|
||
|
||
|
||
|
||
COMMENT ON TABLE S_TFG.ZT_UNFC_CD_DTPT IS 'ZT_?듯빀肄붾뱶?곸꽭';
|
||
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.UNFC_CD_ID IS '?듯빀肄붾뱶ID';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.CD_VLDT_VALU IS '肄붾뱶?좏슚媛?;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.CD_VLDT_VALU_INQR_SEQ IS '肄붾뱶?좏슚媛믪“?뚯닚??;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.CD_VLDT_VALU_NM IS '肄붾뱶?좏슚媛믩챸';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.CD_VLDT_VALU_HNGL_ABR_NM IS '肄붾뱶?좏슚媛믫븳湲?쎌뼱紐?;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.CD_VLDT_VALU_ENGC_ABR_NM IS '肄붾뱶?좏슚媛믪쁺臾몄빟?대챸';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.CD_VLDT_VALU_HAN_NM IS '肄붾뱶?좏슚媛믫븳湲紐?;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.CD_VLDT_VALU_ENG_NM IS '肄붾뱶?좏슚媛믪쁺臾몃챸';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.CD_VLDT_VALU_DS IS '肄붾뱶?좏슚媛믪꽕紐?;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.CD_ASRT_TYPE_BIT_CD IS '肄붾뱶遺꾨쪟?좏삎鍮꾪듃肄붾뱶';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SPPO_CD_VLDT_VALU IS '?곸쐞肄붾뱶?좏슚媛?;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SPPO_UNFC_CD_ID IS '?곸쐞?듯빀肄붾뱶ID';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.VLDT_STRT_YMD IS '?좏슚?쒖옉?쇱옄';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.VLDT_END_YMD IS '?좏슚醫낅즺?쇱옄';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.USER_DEF_VALU_1 IS '?ъ슜?먯젙?섍컪1';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.USER_DEF_VALU_2 IS '?ъ슜?먯젙?섍컪2';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_RGI_DT IS '?쒖뒪?쒕벑濡앹씪??;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_RGI_PRAF_NO IS '?쒖뒪?쒕벑濡앹씤?щ쾲??;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_RGI_OGNZ_NO IS '?쒖뒪?쒕벑濡앹“吏곷쾲??;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_RGI_SYST_CD IS '?쒖뒪?쒕벑濡앹떆?ㅽ뀥肄붾뱶';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_RGI_PRGR_ID IS '?쒖뒪?쒕벑濡앺봽濡쒓렇?쭵D';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_CHG_DT IS '?쒖뒪?쒕?寃쎌씪??;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_CHG_PRAF_NO IS '?쒖뒪?쒕?寃쎌씤?щ쾲??;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_CHG_OGNZ_NO IS '?쒖뒪?쒕?寃쎌“吏곷쾲??;
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_CHG_SYST_CD IS '?쒖뒪?쒕?寃쎌떆?ㅽ뀥肄붾뱶';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.SYST_CHG_PRGR_ID IS '?쒖뒪?쒕?寃쏀봽濡쒓렇?쭵D';
|
||
COMMENT ON COLUMN S_TFG.ZT_UNFC_CD_DTPT.DATA_LOAD_DT IS '?곗씠?곗쟻?ъ씪??;
|
||
|
||
|
||
|
||
-- Default Role
|
||
GRANT INSERT,UPDATE,DELETE ON S_TFG.ZT_UNFC_CD_DTPT TO RL_TFG_IUD;
|
||
|
||
GRANT SELECT ON S_TFG.ZT_UNFC_CD_DTPT TO RL_TFG_SEL;
|
||
|
||
|
||
|
||
CREATE UNIQUE INDEX S_TFG.PK_ZT_UNFC_CD_DTPT ON S_TFG.ZT_UNFC_CD_DTPT
|
||
(UNFC_CD_ID,CD_VLDT_VALU)
|
||
TABLESPACE TS_TFG_I01;
|
||
|
||
ALTER TABLE S_TFG.ZT_UNFC_CD_DTPT ADD (
|
||
CONSTRAINT PK_ZT_UNFC_CD_DTPT
|
||
PRIMARY KEY (UNFC_CD_ID,CD_VLDT_VALU)
|
||
USING INDEX S_TFG.PK_ZT_UNFC_CD_DTPT);
|
||
|
||
-------------------------------------------------------------------------------------------
|
||
-- ZT_MENU ?뚯씠釉??앹꽦 (硫붾돱 湲곕낯 ?뺣낫 ???
|
||
CREATE TABLE ZT_MENU (
|
||
MENU_ID INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, -- ?먮룞 利앷? ID (PK)
|
||
PARENT_MENU_ID INTEGER, -- 遺紐?硫붾돱 ID (FK, NULL 媛??for 猷⑦듃 硫붾돱)
|
||
NAME VARCHAR(100), -- 而댄룷?뚰듃 ?대쫫 (?듭뀛??
|
||
PATH VARCHAR(255) NOT NULL, -- ?쇱슦??寃쎈줈 (?꾩닔)
|
||
TITLE VARCHAR(100) NOT NULL, -- 硫붾돱 ?대쫫 (meta.title, ?꾩닔)
|
||
ICON VARCHAR(50), -- 硫붾돱 ?꾩씠肄?(?듭뀛??
|
||
SHOW_BADGE VARCHAR(1) DEFAULT 'N' CHECK (SHOW_BADGE IN ('Y', 'N')), -- 諛곗? ?쒖떆 ?щ? (Y/N, ?듭뀛??
|
||
SHOW_TEXT_BADGE VARCHAR(50), -- ?띿뒪??諛곗? ?쒖떆 (?듭뀛??
|
||
IS_HIDE VARCHAR(1) DEFAULT 'N' CHECK (IS_HIDE IN ('Y', 'N')), -- 硫붾돱 ?④? ?щ? (Y/N, ?듭뀛??
|
||
IS_HIDE_TAB VARCHAR(1) DEFAULT 'N' CHECK (IS_HIDE_TAB IN ('Y', 'N')),-- ???④? ?щ? (Y/N, ?듭뀛??
|
||
LINK VARCHAR(255), -- 留곹겕 (?듭뀛??
|
||
IS_IFRAME VARCHAR(1) DEFAULT 'N' CHECK (IS_IFRAME IN ('Y', 'N')), -- iframe ?щ? (Y/N, ?듭뀛??
|
||
KEEP_ALIVE VARCHAR(1) DEFAULT 'N' CHECK (KEEP_ALIVE IN ('Y', 'N')), -- 罹먯떆 ?щ? (Y/N, ?듭뀛??
|
||
ORDER_SEQ INTEGER DEFAULT 0 NOT NULL, -- 硫붾돱 ?쒖떆 ?쒖꽌 (?뺣젹?? ?꾩닔)
|
||
IS_ACTIVE VARCHAR(1) DEFAULT 'Y' CHECK (IS_ACTIVE IN ('Y', 'N')), -- ?쒖꽦 ?щ? (Y/N, 湲곕낯 Y)
|
||
SYST_RGI_DT DATE, -- ?쒖뒪?쒕벑濡앹씪??
|
||
SYST_RGI_PRAF_NO VARCHAR(50), -- ?쒖뒪?쒕벑濡앹씤?щ쾲??
|
||
SYST_RGI_OGNZ_NO VARCHAR(50), -- ?쒖뒪?쒕벑濡앹“吏곷쾲??
|
||
SYST_RGI_SYST_CD VARCHAR(50), -- ?쒖뒪?쒕벑濡앹떆?ㅽ뀥肄붾뱶
|
||
SYST_RGI_PRGR_ID VARCHAR(50), -- ?쒖뒪?쒕벑濡앺봽濡쒓렇?쭵D
|
||
SYST_CHG_DT DATE, -- ?쒖뒪?쒕?寃쎌씪??
|
||
SYST_CHG_PRAF_NO VARCHAR(50), -- ?쒖뒪?쒕?寃쎌씤?щ쾲??
|
||
SYST_CHG_OGNZ_NO VARCHAR(50), -- ?쒖뒪?쒕?寃쎌“吏곷쾲??
|
||
SYST_CHG_SYST_CD VARCHAR(50), -- ?쒖뒪?쒕?寃쎌떆?ㅽ뀥肄붾뱶
|
||
SYST_CHG_PRGR_ID VARCHAR(50) -- ?쒖뒪?쒕?寃쏀봽濡쒓렇?쭵D
|
||
);
|
||
|
||
-- ?쒖빟 議곌굔 異붽?
|
||
ALTER TABLE ZT_MENU ADD CONSTRAINT FK_ZT_MENU_PARENT FOREIGN KEY (PARENT_MENU_ID) REFERENCES ZT_MENU (MENU_ID) ON DELETE CASCADE; -- 遺紐???젣 ???먯떇????젣 (怨꾩링 ??젣 吏??
|
||
|
||
-- ?몃뜳???앹꽦 (議고쉶 理쒖쟻??
|
||
CREATE INDEX IDX_ZT_MENU_PARENT ON ZT_MENU (PARENT_MENU_ID);
|
||
CREATE INDEX IDX_ZT_MENU_PATH ON ZT_MENU (PATH);
|
||
|
||
-- 而щ읆 肄붾찘??異붽?
|
||
COMMENT ON COLUMN ZT_MENU.MENU_ID IS '硫붾돱 ID (PK)';
|
||
COMMENT ON COLUMN ZT_MENU.PARENT_MENU_ID IS '遺紐?硫붾돱 ID (FK)';
|
||
COMMENT ON COLUMN ZT_MENU.NAME IS '而댄룷?뚰듃 ?대쫫';
|
||
COMMENT ON COLUMN ZT_MENU.PATH IS '?쇱슦??寃쎈줈';
|
||
COMMENT ON COLUMN ZT_MENU.TITLE IS '硫붾돱 ?대쫫';
|
||
COMMENT ON COLUMN ZT_MENU.ICON IS '硫붾돱 ?꾩씠肄?;
|
||
COMMENT ON COLUMN ZT_MENU.SHOW_BADGE IS '諛곗? ?쒖떆 ?щ? (Y/N)';
|
||
COMMENT ON COLUMN ZT_MENU.SHOW_TEXT_BADGE IS '?띿뒪??諛곗? ?쒖떆';
|
||
COMMENT ON COLUMN ZT_MENU.IS_HIDE IS '硫붾돱 ?④? ?щ? (Y/N)';
|
||
COMMENT ON COLUMN ZT_MENU.IS_HIDE_TAB IS '???④? ?щ? (Y/N)';
|
||
COMMENT ON COLUMN ZT_MENU.LINK IS '留곹겕';
|
||
COMMENT ON COLUMN ZT_MENU.IS_IFRAME IS 'iframe ?щ? (Y/N)';
|
||
COMMENT ON COLUMN ZT_MENU.KEEP_ALIVE IS '罹먯떆 ?щ? (Y/N)';
|
||
COMMENT ON COLUMN ZT_MENU.ORDER_SEQ IS '硫붾돱 ?쒖떆 ?쒖꽌';
|
||
COMMENT ON COLUMN ZT_MENU.IS_ACTIVE IS '?쒖꽦 ?щ? (Y/N)';
|
||
COMMENT ON COLUMN ZT_MENU.SYST_RGI_DT IS '?쒖뒪?쒕벑濡앹씪??;
|
||
COMMENT ON COLUMN ZT_MENU.SYST_RGI_PRAF_NO IS '?쒖뒪?쒕벑濡앹씤?щ쾲??;
|
||
COMMENT ON COLUMN ZT_MENU.SYST_RGI_OGNZ_NO IS '?쒖뒪?쒕벑濡앹“吏곷쾲??;
|
||
COMMENT ON COLUMN ZT_MENU.SYST_RGI_SYST_CD IS '?쒖뒪?쒕벑濡앹떆?ㅽ뀥肄붾뱶';
|
||
COMMENT ON COLUMN ZT_MENU.SYST_RGI_PRGR_ID IS '?쒖뒪?쒕벑濡앺봽濡쒓렇?쭵D';
|
||
COMMENT ON COLUMN ZT_MENU.SYST_CHG_DT IS '?쒖뒪?쒕?寃쎌씪??;
|
||
COMMENT ON COLUMN ZT_MENU.SYST_CHG_PRAF_NO IS '?쒖뒪?쒕?寃쎌씤?щ쾲??;
|
||
COMMENT ON COLUMN ZT_MENU.SYST_CHG_OGNZ_NO IS '?쒖뒪?쒕?寃쎌“吏곷쾲??;
|
||
COMMENT ON COLUMN ZT_MENU.SYST_CHG_SYST_CD IS '?쒖뒪?쒕?寃쎌떆?ㅽ뀥肄붾뱶';
|
||
COMMENT ON COLUMN ZT_MENU.SYST_CHG_PRGR_ID IS '?쒖뒪?쒕?寃쏀봽濡쒓렇?쭵D';
|
||
|
||
-- ZT_MENU_AUTH ?뚯씠釉??앹꽦 (硫붾돱 沅뚰븳 紐⑸줉 ???
|
||
CREATE TABLE ZT_MENU_AUTH (
|
||
AUTH_ID INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, -- ?먮룞 利앷? ID (PK)
|
||
MENU_ID INTEGER NOT NULL, -- 硫붾돱 ID (FK)
|
||
TITLE VARCHAR(100) NOT NULL, -- 沅뚰븳 ?쒕ぉ (e.g., ''異붽?'', ''?몄쭛'')
|
||
AUTH_MARK VARCHAR(100) NOT NULL, -- 沅뚰븳 留덊겕 (e.g., ''add'', ''edit'')
|
||
ORDER_SEQ INTEGER DEFAULT 0 NOT NULL, -- 沅뚰븳 ?쒖떆 ?쒖꽌 (?뺣젹??
|
||
SYST_RGI_DT DATE, -- ?쒖뒪?쒕벑濡앹씪??
|
||
SYST_RGI_PRAF_NO VARCHAR(50), -- ?쒖뒪?쒕벑濡앹씤?щ쾲??
|
||
SYST_RGI_OGNZ_NO VARCHAR(50), -- ?쒖뒪?쒕벑濡앹“吏곷쾲??
|
||
SYST_RGI_SYST_CD VARCHAR(50), -- ?쒖뒪?쒕벑濡앹떆?ㅽ뀥肄붾뱶
|
||
SYST_RGI_PRGR_ID VARCHAR(50), -- ?쒖뒪?쒕벑濡앺봽濡쒓렇?쭵D
|
||
SYST_CHG_DT DATE, -- ?쒖뒪?쒕?寃쎌씪??
|
||
SYST_CHG_PRAF_NO VARCHAR(50), -- ?쒖뒪?쒕?寃쎌씤?щ쾲??
|
||
SYST_CHG_OGNZ_NO VARCHAR(50), -- ?쒖뒪?쒕?寃쎌“吏곷쾲??
|
||
SYST_CHG_SYST_CD VARCHAR(50), -- ?쒖뒪?쒕?寃쎌떆?ㅽ뀥肄붾뱶
|
||
SYST_CHG_PRGR_ID VARCHAR(50) -- ?쒖뒪?쒕?寃쏀봽濡쒓렇?쭵D
|
||
);
|
||
|
||
-- ?쒖빟 議곌굔 異붽?
|
||
ALTER TABLE ZT_MENU_AUTH ADD CONSTRAINT FK_ZT_MENU_AUTH_MENU FOREIGN KEY (MENU_ID) REFERENCES ZT_MENU (MENU_ID) ON DELETE CASCADE; -- 硫붾돱 ??젣 ??沅뚰븳????젣
|
||
|
||
-- ?몃뜳???앹꽦
|
||
CREATE INDEX IDX_ZT_MENU_AUTH_MENU ON ZT_MENU_AUTH (MENU_ID);
|
||
|
||
-- 而щ읆 肄붾찘??異붽?
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.AUTH_ID IS '沅뚰븳 ID (PK)';
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.MENU_ID IS '硫붾돱 ID (FK)';
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.TITLE IS '沅뚰븳 ?쒕ぉ';
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.AUTH_MARK IS '沅뚰븳 留덊겕';
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.ORDER_SEQ IS '沅뚰븳 ?쒖떆 ?쒖꽌';
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_RGI_DT IS '?쒖뒪?쒕벑濡앹씪??;
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_RGI_PRAF_NO IS '?쒖뒪?쒕벑濡앹씤?щ쾲??;
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_RGI_OGNZ_NO IS '?쒖뒪?쒕벑濡앹“吏곷쾲??;
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_RGI_SYST_CD IS '?쒖뒪?쒕벑濡앹떆?ㅽ뀥肄붾뱶';
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_RGI_PRGR_ID IS '?쒖뒪?쒕벑濡앺봽濡쒓렇?쭵D';
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_CHG_DT IS '?쒖뒪?쒕?寃쎌씪??;
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_CHG_PRAF_NO IS '?쒖뒪?쒕?寃쎌씤?щ쾲??;
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_CHG_OGNZ_NO IS '?쒖뒪?쒕?寃쎌“吏곷쾲??;
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_CHG_SYST_CD IS '?쒖뒪?쒕?寃쎌떆?ㅽ뀥肄붾뱶';
|
||
COMMENT ON COLUMN ZT_MENU_AUTH.SYST_CHG_PRGR_ID IS '?쒖뒪?쒕?寃쏀봽濡쒓렇?쭵D';
|