맞춤검색

¿À¶óŬ ½ºÅ°¸¶ »ý¼º

CREATE SEQUENCE F_ID 
 INCREMENT BY 1 
 START WITH 1 
 CACHE 10
;

CREATE TABLE COM_CD_DTLD (
       MSTR_CD              VARCHAR2(5) NOT NULL,
       DTLD_CD              VARCHAR2(6) NOT NULL,
       DTLD_CD_NM           VARCHAR2(100) NOT NULL,
       DTLD_CD_NM1          VARCHAR2(100) NULL,
       DTLD_CD_NM2          VARCHAR2(100) NULL,
       DTLD_CD_EXPL         VARCHAR2(1000) NULL,
       ETC_CD1              VARCHAR2(50) NULL,
       ETC_CD2              VARCHAR2(50) NULL,
       USE_YN               VARCHAR2(1) DEFAULT 'Y' NOT NULL,
       ARA                  NUMBER NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL
);

COMMENT ON TABLE COM_CD_DTLD IS '°øÅë_ÄÚµå»ó¼¼';
COMMENT ON COLUMN COM_CD_DTLD.MSTR_CD IS '¸¶½ºÅÍÄÚµå';
COMMENT ON COLUMN COM_CD_DTLD.DTLD_CD IS '»ó¼¼ÄÚµå';
COMMENT ON COLUMN COM_CD_DTLD.DTLD_CD_NM IS '»ó¼¼ÄÚµå¸í';
COMMENT ON COLUMN COM_CD_DTLD.DTLD_CD_NM1 IS '»ó¼¼ÄÚµå¸í1';
COMMENT ON COLUMN COM_CD_DTLD.DTLD_CD_NM2 IS '»ó¼¼ÄÚµå¸í2';
COMMENT ON COLUMN COM_CD_DTLD.DTLD_CD_EXPL IS '»ó¼¼Äڵ弳¸í';
COMMENT ON COLUMN COM_CD_DTLD.ETC_CD1 IS '±âŸÄÚµå1';
COMMENT ON COLUMN COM_CD_DTLD.ETC_CD2 IS '±âŸÄÚµå2';
COMMENT ON COLUMN COM_CD_DTLD.USE_YN IS '»ç¿ë¿©ºÎ';
COMMENT ON COLUMN COM_CD_DTLD.ARA IS 'Á¤·Ä';
COMMENT ON COLUMN COM_CD_DTLD.REGR_ID IS 'µî·ÏÀÚ¾ÆÀ̵ð';
COMMENT ON COLUMN COM_CD_DTLD.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN COM_CD_DTLD.UPDR_ID IS '¼öÁ¤ÀÚ¾ÆÀ̵ð';
COMMENT ON COLUMN COM_CD_DTLD.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE UNIQUE INDEX PK_COM_CD_DTLD ON COM_CD_DTLD
(
       MSTR_CD                        ASC,
       DTLD_CD                        ASC
);

CREATE INDEX IF1_COM_CD_DTLD ON COM_CD_DTLD
(
       MSTR_CD                        ASC
);


ALTER TABLE COM_CD_DTLD
       ADD  ( PRIMARY KEY (MSTR_CD, DTLD_CD) ) ;


CREATE TABLE COM_CD_MSTR (
       MSTR_CD              VARCHAR2(5) NOT NULL,
       MSTR_NM              VARCHAR2(50) NOT NULL,
       CD_STRC              VARCHAR2(10) NULL,
       MAIN_TBL_NM          VARCHAR2(50) NULL,
       USE_YN               VARCHAR2(1) DEFAULT 'Y' NOT NULL,
       COL_NM               VARCHAR2(50) NULL,
       CLF_EXPL             VARCHAR2(1000) NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL
);

COMMENT ON TABLE COM_CD_MSTR IS '°øÅë_Äڵ帶½ºÅÍ';
COMMENT ON COLUMN COM_CD_MSTR.MSTR_CD IS '¸¶½ºÅÍÄÚµå';
COMMENT ON COLUMN COM_CD_MSTR.MSTR_NM IS '¸¶½ºÅÍÄÚµå¸í';
COMMENT ON COLUMN COM_CD_MSTR.CD_STRC IS 'Äڵ屸Á¶';
COMMENT ON COLUMN COM_CD_MSTR.MAIN_TBL_NM IS '¸ÞÀÎÅ×À̺í¸í';
COMMENT ON COLUMN COM_CD_MSTR.USE_YN IS '»ç¿ë¿©ºÎ';
COMMENT ON COLUMN COM_CD_MSTR.COL_NM IS 'Ä÷³¸í';
COMMENT ON COLUMN COM_CD_MSTR.CLF_EXPL IS 'ºÐ·ù¼³¸í';
COMMENT ON COLUMN COM_CD_MSTR.REGR_ID IS 'µî·ÏÀÚ¾ÆÀ̵ð';
COMMENT ON COLUMN COM_CD_MSTR.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN COM_CD_MSTR.UPDR_ID IS '¼öÁ¤ÀÚ¾ÆÀ̵ð';
COMMENT ON COLUMN COM_CD_MSTR.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE UNIQUE INDEX PK_COM_CD_MSTR ON COM_CD_MSTR
(
       MSTR_CD                        ASC
);


ALTER TABLE COM_CD_MSTR
       ADD  ( PRIMARY KEY (MSTR_CD) ) ;


CREATE TABLE COM_FILEUPLOAD (
       F_ID                 INTEGER NOT NULL,
       F_SEQ                NUMBER(3,0) NOT NULL,
       FILENAME             VARCHAR2(256 BYTE) NOT NULL,
       FILESIZE             NUMBER NOT NULL,
       CONTENT_TYPE         VARCHAR2(200 BYTE) NULL,
       FILEEXT              VARCHAR2(10 BYTE) NULL,
       UPLOADED_FILENAME    VARCHAR2(256 BYTE) NOT NULL,
       UPLOADED_DIRECTORY   VARCHAR2(256 BYTE) NULL,
       DOWN_CNT             NUMBER DEFAULT 0 NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       IMAGE_WIDTH          NUMBER NULL,
       IMAGE_HEIGHT         NUMBER NULL,
       THUMBNAIL_FILENAME   VARCHAR2(256 BYTE) NULL,
       FORM_NM              VARCHAR2(10) NULL,
       REF_TABLE            VARCHAR2(100) NULL
);

COMMENT ON TABLE COM_FILEUPLOAD IS '°Ô½Ã¹°_÷ºÎÆÄÀÏ';
COMMENT ON COLUMN COM_FILEUPLOAD.F_ID IS '÷ºÎÆÄÀÏID';
COMMENT ON COLUMN COM_FILEUPLOAD.F_SEQ IS 'ÆÄÀÏÀϷùøÈ£';
COMMENT ON COLUMN COM_FILEUPLOAD.FILENAME IS 'ÆÄÀϸí';
COMMENT ON COLUMN COM_FILEUPLOAD.FILESIZE IS 'ÆÄÀÏ»çÀÌÁî';
COMMENT ON COLUMN COM_FILEUPLOAD.CONTENT_TYPE IS 'CONTENTŸÀÔ';
COMMENT ON COLUMN COM_FILEUPLOAD.FILEEXT IS 'ÆÄÀÏÈ®ÀåÀÚ';
COMMENT ON COLUMN COM_FILEUPLOAD.UPLOADED_FILENAME IS '¾÷·ÎµåÆÄÀϸí';
COMMENT ON COLUMN COM_FILEUPLOAD.UPLOADED_DIRECTORY IS '¾÷·Îµåµð·ºÅ丮';
COMMENT ON COLUMN COM_FILEUPLOAD.DOWN_CNT IS '´Ù¿î·Îµå¼ö';
COMMENT ON COLUMN COM_FILEUPLOAD.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN COM_FILEUPLOAD.IMAGE_WIDTH IS 'À̹ÌÁö°¡·Î»çÀÌÁî';
COMMENT ON COLUMN COM_FILEUPLOAD.IMAGE_HEIGHT IS 'À̹ÌÁö¼¼·Î»çÀÌÁî';
COMMENT ON COLUMN COM_FILEUPLOAD.THUMBNAIL_FILENAME IS '½æ³×ÀÏÆÄÀϸí';
COMMENT ON COLUMN COM_FILEUPLOAD.FORM_NM IS 'FORM¸í';
COMMENT ON COLUMN COM_FILEUPLOAD.REF_TABLE IS 'ÂüÁ¶Å×À̺í¸í';

ALTER TABLE COM_FILEUPLOAD
       ADD  ( PRIMARY KEY (F_ID, F_SEQ) ) ;


CREATE TABLE COM_MENU (
       MENU_ID              VARCHAR2(50) NOT NULL,
       LEAF                 NUMBER(1,0) NULL,
       CLS                  VARCHAR2(20) NULL,
       MENU_NODE            VARCHAR2(50) NULL,
       MENU_NM              VARCHAR2(100) NULL,
       DEPTH                NUMBER(3,0) NULL,
       HREF                 VARCHAR2(256) NULL,
       TARGET               VARCHAR2(20) NULL,
       MENU_TEXT            VARCHAR2(1000) NULL,
       SORT_ORD             NUMBER(6) NULL,
       USE_YN               VARCHAR2(1) NULL
);

COMMENT ON COLUMN COM_MENU.MENU_ID IS '¸Þ´ºID';
COMMENT ON COLUMN COM_MENU.LEAF IS 'LEAF';
COMMENT ON COLUMN COM_MENU.CLS IS 'CLS';
COMMENT ON COLUMN COM_MENU.MENU_NODE IS '»óÀ§¸Þ´ºID';
COMMENT ON COLUMN COM_MENU.MENU_NM IS '¸Þ´º¸í';
COMMENT ON COLUMN COM_MENU.DEPTH IS 'DEPTH';
COMMENT ON COLUMN COM_MENU.HREF IS '¸µÅ©ÁÖ¼Ò';
COMMENT ON COLUMN COM_MENU.TARGET IS '¸µÅ©Å¸ÄÏ';
COMMENT ON COLUMN COM_MENU.MENU_TEXT IS '¸Þ´ºÃâ·ÂTXT';
COMMENT ON COLUMN COM_MENU.SORT_ORD IS 'Á¤·Ä¼ø¼­';
COMMENT ON COLUMN COM_MENU.USE_YN IS 'USE_YN';
CREATE UNIQUE INDEX XPKCOM_MENU ON COM_MENU
(
       MENU_ID                        ASC
);


ALTER TABLE COM_MENU
       ADD  ( PRIMARY KEY (MENU_ID) ) ;


CREATE TABLE COM_SAMPLE (
       SEQ                  NUMBER NOT NULL,
       USER_ID              VARCHAR2(20) NOT NULL,
       USER_NM              VARCHAR2(20) NOT NULL,
       PWD                  VARCHAR2(20) NOT NULL,
       RRN                  VARCHAR2(13) NULL,
       BIRTH_DAY            VARCHAR2(8) NULL,
       MAX_NUMBER           NUMBER(5,0) NULL,
       MIN_NUMBER           NUMBER(5,0) NULL,
       SELF_DESC            VARCHAR(4000) NULL,
       HTML_DESC            CLOB NULL,
       F_ID                 INTEGER NULL,
       REGR_ID              VARCHAR2(10) NULL,
       REG_TM               DATE DEFAULT sysdate NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL
);

COMMENT ON COLUMN COM_SAMPLE.SEQ IS 'ÀϷùøÈ£';
COMMENT ON COLUMN COM_SAMPLE.USER_ID IS '»ç¿ëÀÚID';
COMMENT ON COLUMN COM_SAMPLE.USER_NM IS '»ç¿ëÀÚ¸í';
COMMENT ON COLUMN COM_SAMPLE.PWD IS 'ºñ¹Ð¹øÈ£';
COMMENT ON COLUMN COM_SAMPLE.RRN IS 'Áֹεî·Ï¹øÈ£';
COMMENT ON COLUMN COM_SAMPLE.BIRTH_DAY IS '»ý³â¿ùÀÏ';
COMMENT ON COLUMN COM_SAMPLE.MAX_NUMBER IS 'ÃÖ´ë°ª';
COMMENT ON COLUMN COM_SAMPLE.MIN_NUMBER IS 'ÃÖ¼Ò°ª';
COMMENT ON COLUMN COM_SAMPLE.SELF_DESC IS 'ÀÚ±â¼Ò°³';
COMMENT ON COLUMN COM_SAMPLE.HTML_DESC IS 'HTML_DESC';
COMMENT ON COLUMN COM_SAMPLE.F_ID IS '÷ºÎÆÄÀÏID';
COMMENT ON COLUMN COM_SAMPLE.REGR_ID IS 'µî·ÏÀÚID';
COMMENT ON COLUMN COM_SAMPLE.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN COM_SAMPLE.UPDR_ID IS '¼öÁ¤ÀÚID';
COMMENT ON COLUMN COM_SAMPLE.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE UNIQUE INDEX XPKCOM_SAMPLE ON COM_SAMPLE
(
       SEQ                            ASC
);


ALTER TABLE COM_SAMPLE
       ADD  ( PRIMARY KEY (SEQ) ) ;


CREATE TABLE HP_BOARD (
       B_ID                 VARCHAR2(20 BYTE) NOT NULL,
       B_SEQ                NUMBER NOT NULL,
       THREAD               NUMBER NOT NULL,
       DEPTH                NUMBER(3,0) DEFAULT 0 NOT NULL,
       CTGRY_CD             VARCHAR2(20) NULL,
       P_B_SEQ              NUMBER NULL,
       TITLE                VARCHAR2(200 BYTE) NULL,
       CNTS                 CLOB NULL,
       TITLE_HTML_YN        VARCHAR2(1) NULL,
       RPLY_CNTS            VARCHAR2(4000) NULL,
       CNTS_HTML_YN         VARCHAR2(1 BYTE) DEFAULT 'N' NULL,
       RPLY_HTML_YN         VARCHAR2(1) NULL,
       SECRET_YN            VARCHAR2(1) NULL,
       PSWD                 VARCHAR2(50) NULL,
       READ_CNT             NUMBER(5,0) DEFAULT 0 NULL,
       EMAIL                VARCHAR2(50) NULL,
       HMPG                 VARCHAR2(100) NULL,
       RPLY_CNT             NUMBER(3,0) NULL,
       ESTM_AVG             NUMBER(2,1) DEFAULT 3.0 NULL,
       POINT_VAL            NUMBER(5,0) DEFAULT 0 NULL,
       GOOD_CNT             NUMBER(3,0) DEFAULT 0 NULL,
       GOOD_RPLY_B_SEQ      NUMBER NULL,
       FILE_CNT             NUMBER(3,0) DEFAULT 0 NULL,
       LINK_URL1            VARCHAR2(256) NULL,
       LINK_URL2            VARCHAR2(256) NULL,
       POPUP_SDATE          DATE NULL,
       POPUP_EDATE          DATE NULL,
       POPUP_WIDTH          VARCHAR2(4 BYTE) NULL,
       POPUP_HEIGHT         VARCHAR2(4 BYTE) NULL,
       POLL_TYPE_DVS        VARCHAR2(10) NULL,
       REGR_NM              VARCHAR2(20) NULL,
       DEL_YN               VARCHAR2(1) DEFAULT 'N' NULL,
       STATUS               VARCHAR2(2) NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       REGR_IP_ADDR         VARCHAR2(15) NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE NULL
);

COMMENT ON TABLE HP_BOARD IS '°Ô½Ã¹°';
COMMENT ON COLUMN HP_BOARD.B_ID IS '°Ô½ÃÆÇID';
COMMENT ON COLUMN HP_BOARD.B_SEQ IS '°Ô½Ã¹°ÀϷùøÈ£';
COMMENT ON COLUMN HP_BOARD.THREAD IS 'THREAD';
COMMENT ON COLUMN HP_BOARD.DEPTH IS 'DEPTH';
COMMENT ON COLUMN HP_BOARD.CTGRY_CD IS 'Ä«Å×°í¸®ÄÚµå';
COMMENT ON COLUMN HP_BOARD.P_B_SEQ IS '»óÀ§°Ô½Ã¹°ÀϷùøÈ£';
COMMENT ON COLUMN HP_BOARD.TITLE IS 'Á¦¸ñ';
COMMENT ON COLUMN HP_BOARD.CNTS IS '³»¿ë';
COMMENT ON COLUMN HP_BOARD.TITLE_HTML_YN IS 'Á¦¸ñHTML¿©ºÎ';
COMMENT ON COLUMN HP_BOARD.RPLY_CNTS IS '´äº¯³»¿ë';
COMMENT ON COLUMN HP_BOARD.CNTS_HTML_YN IS '³»¿ëHTML¿©ºÎ';
COMMENT ON COLUMN HP_BOARD.RPLY_HTML_YN IS '´äº¯HTML¿©ºÎ';
COMMENT ON COLUMN HP_BOARD.SECRET_YN IS 'ºñ¹Ð±Û¿©ºÎ';
COMMENT ON COLUMN HP_BOARD.PSWD IS 'ºñ¹Ð¹øÈ£';
COMMENT ON COLUMN HP_BOARD.READ_CNT IS 'Á¶È¸¼ö';
COMMENT ON COLUMN HP_BOARD.EMAIL IS 'À̸ÞÀÏ';
COMMENT ON COLUMN HP_BOARD.HMPG IS 'ȨÆäÀÌÁöÁÖ¼Ò';
COMMENT ON COLUMN HP_BOARD.RPLY_CNT IS '´äº¯¼ö';
COMMENT ON COLUMN HP_BOARD.ESTM_AVG IS 'Æò°¡ÆòÁ¡¼ö';
COMMENT ON COLUMN HP_BOARD.POINT_VAL IS '¹èÆÃÆ÷ÀÎÆ®¼ö';
COMMENT ON COLUMN HP_BOARD.GOOD_CNT IS 'Ãßõ¼ö';
COMMENT ON COLUMN HP_BOARD.GOOD_RPLY_B_SEQ IS '´äº¯Ã¤ÅðԽù°ÀϷùøÈ£';
COMMENT ON COLUMN HP_BOARD.FILE_CNT IS 'ÆÄÀϼö';
COMMENT ON COLUMN HP_BOARD.LINK_URL1 IS '¸µÅ©1';
COMMENT ON COLUMN HP_BOARD.LINK_URL2 IS '¸µÅ©2';
COMMENT ON COLUMN HP_BOARD.POPUP_SDATE IS 'Æ˾÷½ÃÀÛÀÏÀÚ';
COMMENT ON COLUMN HP_BOARD.POPUP_EDATE IS 'Æ˾÷Á¾·áÀÏÀÚ';
COMMENT ON COLUMN HP_BOARD.POPUP_WIDTH IS 'Æ˾÷°¡·Î»çÀÌÁî';
COMMENT ON COLUMN HP_BOARD.POPUP_HEIGHT IS 'Æ˾÷¼¼·Î»çÀÌÁî';
COMMENT ON COLUMN HP_BOARD.POLL_TYPE_DVS IS '¼³¹®À¯Çü';
COMMENT ON COLUMN HP_BOARD.REGR_NM IS 'µî·ÏÀÚ¸í';
COMMENT ON COLUMN HP_BOARD.DEL_YN IS '»èÁ¦¿©ºÎ';
COMMENT ON COLUMN HP_BOARD.STATUS IS '»óÅÂ';
COMMENT ON COLUMN HP_BOARD.REGR_ID IS 'µî·ÏÀÚID';
COMMENT ON COLUMN HP_BOARD.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN HP_BOARD.REGR_IP_ADDR IS 'µî·ÏÀÚIPÁÖ¼Ò';
COMMENT ON COLUMN HP_BOARD.UPDR_ID IS '¼öÁ¤ÀÚID';
COMMENT ON COLUMN HP_BOARD.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE INDEX XIF1HP_BOARD ON HP_BOARD
(
       B_ID                           ASC
);


ALTER TABLE HP_BOARD
       ADD  ( PRIMARY KEY (B_ID, B_SEQ) ) ;


CREATE TABLE HP_BOARD_CTGRY (
       CTGRY_CD             VARCHAR2(6) NOT NULL,
       CTGRY_GRP_SEQ        NUMBER NOT NULL,
       CTGRY_NM             VARCHAR2(50) NOT NULL,
       CTGRY_EXPL           VARCHAR2(100) NULL,
       SORT_ORDR            NUMBER NULL,
       USE_YN               VARCHAR2(1) DEFAULT 'Y' NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL
);

COMMENT ON TABLE HP_BOARD_CTGRY IS '°Ô½ÃÆÇ_Ä«Å×°í¸®';
COMMENT ON COLUMN HP_BOARD_CTGRY.CTGRY_CD IS 'Ä«Å×°í¸®ÄÚµå';
COMMENT ON COLUMN HP_BOARD_CTGRY.CTGRY_GRP_SEQ IS 'Ä«Å×°í¸®±×·ìÀϷùøÈ£(¼ø¹ø)';
COMMENT ON COLUMN HP_BOARD_CTGRY.CTGRY_NM IS 'Ä«Å×°í¸®¸í';
COMMENT ON COLUMN HP_BOARD_CTGRY.CTGRY_EXPL IS 'Ä«Å×°í¸®¼³¸í';
COMMENT ON COLUMN HP_BOARD_CTGRY.SORT_ORDR IS 'Á¤·Ä¼ø¼­';
COMMENT ON COLUMN HP_BOARD_CTGRY.USE_YN IS '»ç¿ë¿©ºÎ';
COMMENT ON COLUMN HP_BOARD_CTGRY.REGR_ID IS 'µî·ÏÀÚID';
COMMENT ON COLUMN HP_BOARD_CTGRY.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN HP_BOARD_CTGRY.UPDR_ID IS '¼öÁ¤ÀÚID';
COMMENT ON COLUMN HP_BOARD_CTGRY.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE UNIQUE INDEX HP_BOARD_CTGRY_PK ON HP_BOARD_CTGRY
(
       CTGRY_CD                       ASC,
       CTGRY_GRP_SEQ                  ASC
);

CREATE INDEX XIF1HP_BOARD_CTGRY ON HP_BOARD_CTGRY
(
       CTGRY_GRP_SEQ                  ASC
);


ALTER TABLE HP_BOARD_CTGRY
       ADD  ( PRIMARY KEY (CTGRY_CD, CTGRY_GRP_SEQ) ) ;


CREATE TABLE HP_BOARD_CTGRY_GRP (
       CTGRY_GRP_SEQ        NUMBER NOT NULL,
       CTGRY_GRP_NM         VARCHAR2(50) NOT NULL,
       CTGRY_GRP_EXPL       VARCHAR2(100) NULL,
       USE_YN               VARCHAR2(1) DEFAULT 'Y' NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL
);

COMMENT ON TABLE HP_BOARD_CTGRY_GRP IS '°Ô½ÃÆÇ_Ä«Å×°í¸®±×·ì';
COMMENT ON COLUMN HP_BOARD_CTGRY_GRP.CTGRY_GRP_SEQ IS 'Ä«Å×°í¸®±×·ìÀϷùøÈ£(¼ø¹ø)';
COMMENT ON COLUMN HP_BOARD_CTGRY_GRP.CTGRY_GRP_NM IS 'Ä«Å×°í¸®±×·ì¸í';
COMMENT ON COLUMN HP_BOARD_CTGRY_GRP.CTGRY_GRP_EXPL IS 'Ä«Å×°í¸®±×·ì¼³¸í';
COMMENT ON COLUMN HP_BOARD_CTGRY_GRP.USE_YN IS '»ç¿ë¿©ºÎ';
COMMENT ON COLUMN HP_BOARD_CTGRY_GRP.REGR_ID IS 'µî·ÏÀÚID';
COMMENT ON COLUMN HP_BOARD_CTGRY_GRP.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN HP_BOARD_CTGRY_GRP.UPDR_ID IS '¼öÁ¤ÀÚID';
COMMENT ON COLUMN HP_BOARD_CTGRY_GRP.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE UNIQUE INDEX HP_BOARD_CTGRY_GRP_PK ON HP_BOARD_CTGRY_GRP
(
       CTGRY_GRP_SEQ                  ASC
);


ALTER TABLE HP_BOARD_CTGRY_GRP
       ADD  ( PRIMARY KEY (CTGRY_GRP_SEQ) ) ;


CREATE TABLE HP_BOARD_FILE (
       B_ID                 VARCHAR2(20 BYTE) NOT NULL,
       B_SEQ                NUMBER NOT NULL,
       F_SEQ                NUMBER NOT NULL,
       FILENAME             VARCHAR2(256 BYTE) NOT NULL,
       FILESIZE             NUMBER NOT NULL,
       CONTENT_TYPE         VARCHAR2(200 BYTE) NULL,
       FILEEXT              VARCHAR2(10 BYTE) NULL,
       UPLOADED_FILENAME    VARCHAR2(256 BYTE) NOT NULL,
       UPLOADED_DIRECTORY   VARCHAR2(256 BYTE) NULL,
       IMAGE_WIDTH          NUMBER NULL,
       IMAGE_HEIGHT         NUMBER NULL,
       DOWN_CNT             NUMBER DEFAULT 0 NULL,
       THUMBNAIL_FILENAME   VARCHAR2(256 BYTE) NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL
);

COMMENT ON TABLE HP_BOARD_FILE IS '°Ô½Ã¹°_÷ºÎÆÄÀÏ';
COMMENT ON COLUMN HP_BOARD_FILE.B_ID IS '°Ô½ÃÆÇID';
COMMENT ON COLUMN HP_BOARD_FILE.B_SEQ IS '°Ô½Ã¹°ÀϷùøÈ£';
COMMENT ON COLUMN HP_BOARD_FILE.F_SEQ IS 'ÆÄÀÏÀϷùøÈ£';
COMMENT ON COLUMN HP_BOARD_FILE.FILENAME IS 'ÆÄÀϸí';
COMMENT ON COLUMN HP_BOARD_FILE.FILESIZE IS 'ÆÄÀÏ»çÀÌÁî';
COMMENT ON COLUMN HP_BOARD_FILE.CONTENT_TYPE IS 'CONTENTŸÀÔ';
COMMENT ON COLUMN HP_BOARD_FILE.FILEEXT IS 'ÆÄÀÏÈ®ÀåÀÚ';
COMMENT ON COLUMN HP_BOARD_FILE.UPLOADED_FILENAME IS '¾÷·ÎµåÆÄÀϸí';
COMMENT ON COLUMN HP_BOARD_FILE.UPLOADED_DIRECTORY IS '¾÷·Îµåµð·ºÅ丮';
COMMENT ON COLUMN HP_BOARD_FILE.IMAGE_WIDTH IS 'À̹ÌÁö°¡·Î»çÀÌÁî';
COMMENT ON COLUMN HP_BOARD_FILE.IMAGE_HEIGHT IS 'À̹ÌÁö¼¼·Î»çÀÌÁî';
COMMENT ON COLUMN HP_BOARD_FILE.DOWN_CNT IS '´Ù¿î·Îµå¼ö';
COMMENT ON COLUMN HP_BOARD_FILE.THUMBNAIL_FILENAME IS '½æ³×ÀÏÆÄÀϸí';
COMMENT ON COLUMN HP_BOARD_FILE.REGR_ID IS 'µî·ÏÀÚID';
COMMENT ON COLUMN HP_BOARD_FILE.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN HP_BOARD_FILE.UPDR_ID IS '¼öÁ¤ÀÚID';
COMMENT ON COLUMN HP_BOARD_FILE.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE INDEX XIF1HP_BOARD_FILE ON HP_BOARD_FILE
(
       B_SEQ                          ASC,
       B_ID                           ASC
);


ALTER TABLE HP_BOARD_FILE
       ADD  ( PRIMARY KEY (B_ID, B_SEQ, F_SEQ) ) ;


CREATE TABLE HP_BOARD_GRP (
       B_GRP_SEQ            NUMBER(2,0) NOT NULL,
       B_GRP_NM             VARCHAR2(40) NOT NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL
);

COMMENT ON TABLE HP_BOARD_GRP IS '°Ô½ÃÆDZ׷ì';
COMMENT ON COLUMN HP_BOARD_GRP.B_GRP_SEQ IS '°Ô½ÃÆDZ׷ìID';
COMMENT ON COLUMN HP_BOARD_GRP.B_GRP_NM IS '°Ô½ÃÆDZ׷ì¸í';
COMMENT ON COLUMN HP_BOARD_GRP.REGR_ID IS 'µî·ÏÀÚID';
COMMENT ON COLUMN HP_BOARD_GRP.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN HP_BOARD_GRP.UPDR_ID IS '¼öÁ¤ÀÚID';
COMMENT ON COLUMN HP_BOARD_GRP.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE UNIQUE INDEX HP_BOARD_GRP_PK ON HP_BOARD_GRP
(
       B_GRP_SEQ                      ASC
);


ALTER TABLE HP_BOARD_GRP
       ADD  ( PRIMARY KEY (B_GRP_SEQ) ) ;


CREATE TABLE HP_BOARD_MEMO (
       B_ID                 VARCHAR2(20 BYTE) NOT NULL,
       B_SEQ                NUMBER NOT NULL,
       M_SEQ                NUMBER NOT NULL,
       M_NM                 VARCHAR2(10) NULL,
       M_PSWD               VARCHAR2(20) NULL,
       M_CNTS               VARCHAR2(200 BYTE) NULL,
       ESTM_VAL             NUMBER(1,0) NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       REGR_IP_ADDR         VARCHAR2(15) NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL
);

COMMENT ON TABLE HP_BOARD_MEMO IS '°Ô½Ã¹°_´ñ±Û';
COMMENT ON COLUMN HP_BOARD_MEMO.B_ID IS '°Ô½ÃÆÇID';
COMMENT ON COLUMN HP_BOARD_MEMO.B_SEQ IS '°Ô½Ã¹°ÀϷùøÈ£';
COMMENT ON COLUMN HP_BOARD_MEMO.M_SEQ IS '´ñ±ÛÀϷùøÈ£(¼ø¹ø)';
COMMENT ON COLUMN HP_BOARD_MEMO.M_NM IS '¼º¸í';
COMMENT ON COLUMN HP_BOARD_MEMO.M_PSWD IS 'ºñ¹Ð¹øÈ£';
COMMENT ON COLUMN HP_BOARD_MEMO.M_CNTS IS '³»¿ë';
COMMENT ON COLUMN HP_BOARD_MEMO.ESTM_VAL IS 'Æò°¡¸¸Á·µµ¼ö';
COMMENT ON COLUMN HP_BOARD_MEMO.REGR_ID IS 'µî·ÏÀÚID';
COMMENT ON COLUMN HP_BOARD_MEMO.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN HP_BOARD_MEMO.REGR_IP_ADDR IS 'µî·ÏÀÚIPÁÖ¼Ò';
COMMENT ON COLUMN HP_BOARD_MEMO.UPDR_ID IS '¼öÁ¤ÀÚID';
COMMENT ON COLUMN HP_BOARD_MEMO.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE INDEX XIF1HP_BOARD_MEMO ON HP_BOARD_MEMO
(
       B_SEQ                          ASC,
       B_ID                           ASC
);


ALTER TABLE HP_BOARD_MEMO
       ADD  ( PRIMARY KEY (B_ID, B_SEQ, M_SEQ) ) ;


CREATE TABLE HP_BOARD_NTC (
       SEQ                  NUMBER NOT NULL,
       B_ID                 VARCHAR2(20 BYTE) NOT NULL,
       TITLE                VARCHAR2(200 BYTE) NOT NULL,
       CNTS                 CLOB NOT NULL,
       TITLE_HTML_YN        VARCHAR2(1) NULL,
       CNTS_HTML_YN         VARCHAR2(1 BYTE) DEFAULT 'N' NULL,
       READ_CNT             NUMBER(5) DEFAULT 0 NULL,
       NTC_SDATE            VARCHAR2(10 BYTE) NULL,
       NTC_EDATE            VARCHAR2(10 BYTE) NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL
);

COMMENT ON TABLE HP_BOARD_NTC IS '°Ô½ÃÆǺ°°øÁö±Û';
COMMENT ON COLUMN HP_BOARD_NTC.SEQ IS 'ÀϷùøÈ£(¼ø¹ø)';
COMMENT ON COLUMN HP_BOARD_NTC.B_ID IS '°Ô½ÃÆÇID';
COMMENT ON COLUMN HP_BOARD_NTC.TITLE IS 'Á¦¸ñ';
COMMENT ON COLUMN HP_BOARD_NTC.CNTS IS '³»¿ë';
COMMENT ON COLUMN HP_BOARD_NTC.TITLE_HTML_YN IS 'Á¦¸ñHTML¿©ºÎ';
COMMENT ON COLUMN HP_BOARD_NTC.CNTS_HTML_YN IS '³»¿ëHTML¿©ºÎ';
COMMENT ON COLUMN HP_BOARD_NTC.READ_CNT IS 'Á¶È¸¼ö';
COMMENT ON COLUMN HP_BOARD_NTC.NTC_SDATE IS '°øÁö½ÃÀÛÀÏÀÚ';
COMMENT ON COLUMN HP_BOARD_NTC.NTC_EDATE IS '°øÁöÁ¾·áÀÏÀÚ';
COMMENT ON COLUMN HP_BOARD_NTC.REGR_ID IS 'µî·ÏÀÚID';
COMMENT ON COLUMN HP_BOARD_NTC.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN HP_BOARD_NTC.UPDR_ID IS '¼öÁ¤ÀÚID';
COMMENT ON COLUMN HP_BOARD_NTC.UPD_TM IS '¼öÁ¤ÀϽÃ';
CREATE UNIQUE INDEX HP_BOARD_NTC_PK ON HP_BOARD_NTC
(
       SEQ                            ASC,
       B_ID                           ASC
);

CREATE INDEX XIF1HP_BOARD_NTC ON HP_BOARD_NTC
(
       B_ID                           ASC
);


ALTER TABLE HP_BOARD_NTC
       ADD  ( PRIMARY KEY (SEQ, B_ID) ) ;


CREATE TABLE HP_BOARD_TYPE (
       B_ID                 VARCHAR2(20 BYTE) NOT NULL,
       BOARD_TYPE           VARCHAR2(10 BYTE) NOT NULL,
       MCHN_CD              VARCHAR2(7) NULL,
       TREE_USE_YN          VARCHAR2(1) NULL,
       BOARD_NM             VARCHAR2(100 BYTE) NOT NULL,
       BOARD_DESC           VARCHAR2(200 BYTE) NULL,
       SKIN_NM              VARCHAR2(20 BYTE) NOT NULL,
       FILE_ABLE_CNT        NUMBER(2) DEFAULT 0 NULL,
       TOP_PRT_CNTS         VARCHAR2(4000 BYTE) NULL,
       BTM_PRT_CNTS         VARCHAR2(4000 BYTE) NULL,
       TOP_INC_URL          VARCHAR2(256) NULL,
       PAGESIZE             NUMBER(2,0) DEFAULT 10 NULL,
       DEF_AUTH             VARCHAR2(5 BYTE) NULL,
       BTM_INC_URL          VARCHAR2(256) NULL,
       FILE_ACCESS_EXT      VARCHAR2(256 BYTE) NULL,
       ADMIN_ID             VARCHAR2(100) NULL,
       FILE_SIZE_LIMIT      NUMBER(2,0) NULL,
       USE_SDATE            DATE NULL,
       B_GRP_SEQ            NUMBER(2,0) NULL,
       REGR_ID              VARCHAR2(10) NOT NULL,
       REG_TM               DATE DEFAULT sysdate NOT NULL,
       UPDR_ID              VARCHAR2(10) NULL,
       UPD_TM               DATE DEFAULT sysdate NULL,
       CTGRY_GRP_SEQ        NUMBER NULL,
       USE_IMG_PRT_YN       VARCHAR2(1) NULL,
       USE_DEPT_YN          VARCHAR2(1) NULL,
       NEW_DAY_CNT          NUMBER NULL,
       HOT_READ_CNT         NUMBER NULL,
       USE_YN               VARCHAR2(1) DEFAULT 'Y' NULL,
       USE_DEL_FLAG_YN      VARCHAR2(1) NULL
);

COMMENT ON TABLE HP_BOARD_TYPE IS '°Ô½ÃÆÇ';
COMMENT ON COLUMN HP_BOARD_TYPE.B_ID IS '°Ô½ÃÆÇID';
COMMENT ON COLUMN HP_BOARD_TYPE.BOARD_TYPE IS '°Ô½ÃÆÇÀ¯Çü';
COMMENT ON COLUMN HP_BOARD_TYPE.MCHN_CD IS '±â°üÄÚµå';
COMMENT ON COLUMN HP_BOARD_TYPE.TREE_USE_YN IS '°èÃþ±¸Á¶»ç¿ë¿©ºÎ';
COMMENT ON COLUMN HP_BOARD_TYPE.BOARD_NM IS '°Ô½ÃÆǸí';
COMMENT ON COLUMN HP_BOARD_TYPE.BOARD_DESC IS '°Ô½ÃÆǼ³¸í';
COMMENT ON COLUMN HP_BOARD_TYPE.SKIN_NM IS 'SKIN¸í';
COMMENT ON COLUMN HP_BOARD_TYPE.FILE_ABLE_CNT IS '÷ºÎ°¡´ÉÆÄÀϼö';
COMMENT ON COLUMN HP_BOARD_TYPE.TOP_PRT_CNTS IS '°Ô½ÃÆÇ»ó´ÜHTML';
COMMENT ON COLUMN HP_BOARD_TYPE.BTM_PRT_CNTS IS '°Ô½ÃÆÇÇÏ´ÜHTML';
COMMENT ON COLUMN HP_BOARD_TYPE.TOP_INC_URL IS '°Ô½ÃÆÇ»ó´Üinclude URL';
COMMENT ON COLUMN HP_BOARD_TYPE.PAGESIZE IS '°Ô½ÃÆÇpagesize';
COMMENT ON COLUMN HP_BOARD_TYPE.DEF_AUTH IS 'ºñȸ¿ø»ç¿ë±ÇÇÑ';
COMMENT ON COLUMN HP_BOARD_TYPE.BTM_INC_URL IS '°Ô½ÃÆÇÇÏ´Üinclude URL';
COMMENT ON COLUMN HP_BOARD_TYPE.FILE_ACCESS_EXT IS '÷ºÎ°¡´ÉÈ®ÀåÀÚ¸í';
COMMENT ON COLUMN HP_BOARD_TYPE.ADMIN_ID IS '°ü¸®ÀÚID';
COMMENT ON COLUMN HP_BOARD_TYPE.FILE_SIZE_LIMIT IS '÷ºÎ°¡´ÉÆÄÀÏ»çÀÌÁî';
COMMENT ON COLUMN HP_BOARD_TYPE.USE_SDATE IS '»ç¿ë½ÃÀÛÀÏÀÚ';
COMMENT ON COLUMN HP_BOARD_TYPE.B_GRP_SEQ IS '°Ô½ÃÆDZ׷ìID';
COMMENT ON COLUMN HP_BOARD_TYPE.REGR_ID IS 'µî·ÏÀÚID';
COMMENT ON COLUMN HP_BOARD_TYPE.REG_TM IS 'µî·ÏÀϽÃ';
COMMENT ON COLUMN HP_BOARD_TYPE.UPDR_ID IS '¼öÁ¤ÀÚID';
COMMENT ON COLUMN HP_BOARD_TYPE.UPD_TM IS '¼öÁ¤ÀϽÃ';
COMMENT ON COLUMN HP_BOARD_TYPE.CTGRY_GRP_SEQ IS 'Ä«Å×°í¸®±×·ìÀϷùøÈ£(¼ø¹ø)';
COMMENT ON COLUMN HP_BOARD_TYPE.USE_IMG_PRT_YN IS 'À̹ÌÁö»ç¿ë¿©ºÎ';
COMMENT ON COLUMN HP_BOARD_TYPE.USE_DEPT_YN IS '¼Ò¼ÓÃâ·Â¿©ºÎ';
COMMENT ON COLUMN HP_BOARD_TYPE.NEW_DAY_CNT IS '»õ±ÛÇ¥½Ã±âÁØÀϼö';
COMMENT ON COLUMN HP_BOARD_TYPE.HOT_READ_CNT IS 'ÇÖÇ¥½Ã±âÁØÀϼö';
COMMENT ON COLUMN HP_BOARD_TYPE.USE_YN IS '»ç¿ë¿©ºÎ';
COMMENT ON COLUMN HP_BOARD_TYPE.USE_DEL_FLAG_YN IS '»èÁ¦Ç÷¡±×¿©ºÎ';
CREATE INDEX XIF1HP_BOARD_TYPE ON HP_BOARD_TYPE
(
       B_GRP_SEQ                      ASC
);

CREATE INDEX XIF2HP_BOARD_TYPE ON HP_BOARD_TYPE
(
       CTGRY_GRP_SEQ                  ASC
);


ALTER TABLE HP_BOARD_TYPE
       ADD  ( PRIMARY KEY (B_ID) ) ;


ALTER TABLE COM_CD_DTLD
       ADD  ( FOREIGN KEY (MSTR_CD)
                             REFERENCES COM_CD_MSTR ) ;


ALTER TABLE HP_BOARD
       ADD  ( FOREIGN KEY (B_ID)
                             REFERENCES HP_BOARD_TYPE ) ;


ALTER TABLE HP_BOARD_CTGRY
       ADD  ( FOREIGN KEY (CTGRY_GRP_SEQ)
                             REFERENCES HP_BOARD_CTGRY_GRP ) ;


ALTER TABLE HP_BOARD_FILE
       ADD  ( FOREIGN KEY (B_ID, B_SEQ)
                             REFERENCES HP_BOARD ) ;


ALTER TABLE HP_BOARD_MEMO
       ADD  ( FOREIGN KEY (B_ID, B_SEQ)
                             REFERENCES HP_BOARD ) ;


ALTER TABLE HP_BOARD_NTC
       ADD  ( FOREIGN KEY (B_ID)
                             REFERENCES HP_BOARD_TYPE ) ;


ALTER TABLE HP_BOARD_TYPE
       ADD  ( FOREIGN KEY (CTGRY_GRP_SEQ)
                             REFERENCES HP_BOARD_CTGRY_GRP ) ;


CREATE TABLE COM_ZIP_CD
(
  ZIP_CD   VARCHAR2(6 BYTE)                     NOT NULL,
  AREA_NO  VARCHAR2(3 BYTE)                     NOT NULL,
  SD_NM    VARCHAR2(30 BYTE),
  SGG_NM   VARCHAR2(30 BYTE),
  EMD_NM   VARCHAR2(30 BYTE),
  RI_NM    VARCHAR2(30 BYTE),
  BLD_NM   VARCHAR2(100 BYTE),
  ST_BG    VARCHAR2(30 BYTE),
  END_BG   VARCHAR2(30 BYTE),
  REGR_ID  VARCHAR2(20 BYTE)                    ,
  REG_TM   DATE                                 DEFAULT sysdate,
  UPDR_ID  VARCHAR2(20 BYTE)                    ,
  UPD_TM   DATE                                 DEFAULT sysdate 
);

CREATE UNIQUE INDEX PK_COM_ZIP_CD ON COM_ZIP_CD
(ZIP_CD, AREA_NO);



ALTER TABLE COM_ZIP_CD ADD (
  CONSTRAINT COM_ZIP_CD_PK
 PRIMARY KEY
 (ZIP_CD, AREA_NO));


 CREATE TABLE COM_USER
(
  USER_ID  VARCHAR2(20 BYTE)                    NOT NULL,
  USER_NM  VARCHAR2(100 BYTE),
  USE_YN   VARCHAR2(1 BYTE),
  PWD      VARCHAR2(20 BYTE),
  F_ID     INTEGER
);


CREATE UNIQUE INDEX COM_USER_PK ON COM_USER
(USER_ID);


ALTER TABLE COM_USER ADD (
  CONSTRAINT COM_USER_PK
 PRIMARY KEY
 (USER_ID));



CREATE TABLE PJT_MNG
(
  SEQ              INTEGER                      NOT NULL,
  PJT_NM           VARCHAR2(200 BYTE)           NOT NULL,
  PJT_DESC         CLOB,
  PJT_MEMBER       VARCHAR2(200 BYTE)           NOT NULL,
  PRPS_SDATE       DATE,
  PRPS_EDATE       DATE,
  PJT_ID           VARCHAR2(20 BYTE)            NOT NULL,
  PJT_PWD          VARCHAR2(20 BYTE)            NOT NULL,
  PJT_FOLDER_PATH  VARCHAR2(1000 BYTE)          NOT NULL
);

COMMENT ON COLUMN PJT_MNG.SEQ IS 'ÀϷùøÈ£';

COMMENT ON COLUMN PJT_MNG.PJT_NM IS 'ÇÁ·ÎÁ§Æ®¸í';

COMMENT ON COLUMN PJT_MNG.PJT_DESC IS 'ÇÁ·ÎÁ§Æ®¼³¸í';

COMMENT ON COLUMN PJT_MNG.PJT_MEMBER IS 'Á¦¾ÈÂü¿©ÀηÂ';

COMMENT ON COLUMN PJT_MNG.PRPS_SDATE IS 'Á¦¾ÈÀÔÂû°ø°íÀÏ';

COMMENT ON COLUMN PJT_MNG.PRPS_EDATE IS 'Á¦¾ÈÁ¦ÃâÀÏ';

COMMENT ON COLUMN PJT_MNG.PJT_ID IS '»ç¿ëÀÚID';

COMMENT ON COLUMN PJT_MNG.PJT_PWD IS 'Æнº¿öµå';


CREATE UNIQUE INDEX PJT_MNG_IDX ON PJT_MNG
(PJT_ID);


CREATE UNIQUE INDEX PJT_MNG_PK ON PJT_MNG
(SEQ);


CREATE UNIQUE INDEX PJT_MNG_IDX2 ON PJT_MNG
(PJT_FOLDER_PATH);


ALTER TABLE PJT_MNG ADD (
  CONSTRAINT PJT_MNG_PK
 PRIMARY KEY
 (SEQ));





Tracked by ClickAider