shp2
Tables (14)
BCG_COMMON_FILE
- BCF_NO — NUMBER(20,0) — NOT NULL
- BCF_SEQ — NUMBER(20,1) — NOT NULL
- BCF_CD — VARCHAR2(100) — NOT NULL
- BCF_PATH — VARCHAR2(100)
- BCF_REAL_NM — VARCHAR2(100)
- BCF_SERVER_NM — VARCHAR2(100)
- BCF_FILE_EXT — VARCHAR2(4)
- BCF_FILE_SIZE — VARCHAR2(15)
COMTNFILEDETAIL
- ATCH_FILE_ID — CHAR(20) — NOT NULL
- FILE_SN — VARCHAR2(10) — NOT NULL
- FILE_STRE_COURS — VARCHAR2(2000) — NOT NULL
- STRE_FILE_NM — VARCHAR2(255) — NOT NULL
- ORIGNL_FILE_NM — VARCHAR2(255 CHAR)
- FILE_EXTSN — VARCHAR2(20) — NOT NULL
- FILE_MG — NUMBER(10,0)
- FILE_CN — CLOB
- SER_SEQ — NUMBER(20,0) — NOT NULL
SHP_ASSETS_PHOTO
- SAP_SEQ — NUMBER(20,0)
- SAP_TITLE — VARCHAR2(200)
- SAP_CONTENT — CLOB
- SAP_VIEW — NUMBER
- SAP_PRIZE — VARCHAR2(100)
- SAP_OPEN — CHAR(1)
- SAP_DEL_DATE — DATE
- USE_AT — CHAR(1)
- BCF_NO — NUMBER(20,0) — NOT NULL — 파일순번
SHP_ASSETS_PHOTO_LIKE
- SAPL_ID — VARCHAR2(50)
- SAP_SEQ — NUMBER(20,0)
- SAP_SEQ2 — NUMBER(20,0)
SHP_ASSETS_RESERV
- SAR_SEQ — NUMBER(20,0) — NOT NULL
- SAR_GUBUN — CHAR(4) — NOT NULL
- SAR_ID — VARCHAR2(30) — NOT NULL
- SAR_WRITER — VARCHAR2(100) — NOT NULL
- SAR_TEL — VARCHAR2(200) — NOT NULL
- SAR_EMAIL — VARCHAR2(200)
- SAR_NAME — VARCHAR2(500) — NOT NULL
- SAR_OPERATOR — VARCHAR2(500) — NOT NULL
- SAR_CONTENT — VARCHAR2(4000) — NOT NULL
- SAR_CALL — CHAR(1)
- SAR_CONFIRM — CHAR(1)
- SAR_CANCEL — CHAR(1)
- SAR_COMPLETE — CHAR(1)
- SAR_FILE — VARCHAR2(200)
- SAR_FILE_PATH — VARCHAR2(200)
- SAR_SDATE — DATE
- SAR_EDATE — DATE
- SAR_RDATE — DATE
- SAR_UDATE — DATE
- SAR_FILE_IMAGE — VARCHAR2(200)
- SAR_FILE_IMAGE_PATH — VARCHAR2(200)
- SAR_FILE_MOVIE — VARCHAR2(200)
- SAR_FILE_MOVIE_PATH — VARCHAR2(200)
- SAP_SEQ — NUMBER(20,0)
- SAV_SEQ — NUMBER(20,0)
SHP_ASSETS_VIDEO
- SAV_SEQ — NUMBER(20,0)
- SAV_TITLE — VARCHAR2(200)
- SAV_CONTENT — CLOB
- SAV_VIEW — NUMBER
- SAV_PRIZE — VARCHAR2(100)
- SAV_LINK — VARCHAR2(300)
- SAV_OPEN — CHAR(1)
- SAV_DEL_DATE — DATE
- USE_AT — CHAR(1)
- BCF_NO — NUMBER(20,0) — NOT NULL — 파일순번
SHP_ASSETS_VIDEO_LIKE
- SAVL_ID — VARCHAR2(50)
- SAV_SEQ — NUMBER(20,0)
- SAV_SEQ2 — NUMBER(20,0)
SHP_BOOK_MST
- SBM_SEQ — NUMBER(20,0) — NOT NULL
- SBM_GUBUN — CHAR(4) — NOT NULL
- SBM_LANG — CHAR(3) — NOT NULL
- SBM_NAME — VARCHAR2(100) — NOT NULL
- SBM_PUBLISHER — VARCHAR2(100)
- SBM_YEAR — VARCHAR2(4)
- SBM_AUTHOR — VARCHAR2(100)
- SBM_TRANSLATOR — VARCHAR2(100)
- SBM_USE — CHAR(1)
- SBM_RDATE — DATE
- SBM_UDATE — DATE
SHP_EVENT_SCHEDULE
- SES_SEQ — NUMBER(20,0) — NOT NULL
- SES_NAME — VARCHAR2(200) — NOT NULL
- SES_URL — VARCHAR2(200) — NOT NULL
- SES_GUBUN — CHAR(4) — NOT NULL
- SES_USE — CHAR(1) — NOT NULL
- SES_SDATE — DATE — NOT NULL
- SES_EDATE — DATE — NOT NULL
- SES_RDATE — DATE — NOT NULL
- SES_UDATE — DATE — NOT NULL
SHP_EXHIBIT_RESERV
- SER_SEQ — NUMBER(20,0) — NOT NULL
- SER_GUBUN — CHAR(4) — NOT NULL
- SER_ID — VARCHAR2(30) — NOT NULL
- SER_WRITER — VARCHAR2(100) — NOT NULL
- SER_TEL — VARCHAR2(200) — NOT NULL
- SER_EMAIL — VARCHAR2(200)
- SER_NAME — VARCHAR2(500) — NOT NULL
- SER_OPERATOR — VARCHAR2(500) — NOT NULL
- SER_CONTENT — VARCHAR2(4000) — NOT NULL
- SER_CALL — CHAR(1)
- SER_CONFIRM — CHAR(1)
- SER_CANCEL — CHAR(1)
- SER_COMPLETE — CHAR(1)
- SER_FILE — VARCHAR2(200)
- SER_FILE_PATH — VARCHAR2(200)
- SER_SDATE — DATE
- SER_EDATE — DATE
- SER_RDATE — DATE
- SER_UDATE — DATE
SHP_GREAT_HANOK
- SGH_SEQ — NUMBER — NOT NULL
- SGH_NAME — VARCHAR2(50)
- SGH_IMG — VARCHAR2(50)
- SGH_PLACE — VARCHAR2(50)
- SGH_SORT — VARCHAR2(50)
- SGH_AREA — VARCHAR2(50)
- SGH_DESIGN — VARCHAR2(50)
- SGH_CONSTRUCT — VARCHAR2(50)
- SGH_DESC — CLOB
- SGH_REG_ID — VARCHAR2(20)
- SGH_REG_DATE — DATE
- SGH_UPD_ID — VARCHAR2(20)
- SGH_UPD_DATE — DATE
- SGH_IMG_PATH — VARCHAR2(50)
- SGH_LANG — VARCHAR2(20)
- SGH_YEAR — VARCHAR2(50)
- SGH_DOIMG — VARCHAR2(50)
- SGH_DOIMG_PATH — VARCHAR2(50)
- SGH_THIMG_PATH — VARCHAR2(50)
- SGH_THIMG — VARCHAR2(50)
- SGH_BUILD — VARCHAR2(50)
- SGH_PART — VARCHAR2(4000)
- SGH_VIEW — NUMBER(9,0)
- SGH_DESC_MAIN — VARCHAR2(4000)
- SGH_DEL_DATE — DATE
- USE_AT — CHAR(1)
- BCF_NO — NUMBER(20,0) — NOT NULL
SHP_GREAT_HANOK_LIKE
- SGHL_SEQ — NUMBER(20,0) — NOT NULL
- SGHL_ID — VARCHAR2(50)
- SGH_SEQ — NUMBER — NOT NULL
SHP_INCONV_REPORT
- SIR_SEQ — NUMBER(20,0) — NOT NULL
- SIR_ID — VARCHAR2(30) — NOT NULL
- SIR_WRITER — VARCHAR2(30) — NOT NULL
- SIR_TEL — VARCHAR2(200) — NOT NULL
- SIR_EMAIL — VARCHAR2(30)
- SIR_GUBUN — VARCHAR2(200) — NOT NULL
- SIR_CONTENT — VARCHAR2(2000) — NOT NULL
- SIR_CALL — CHAR(1)
- SIR_CANCEL — CHAR(1)
- SIR_COMPLETE — CHAR(1)
- SIR_CDATE — DATE
- SIR_RDATE — DATE
- SIR_UDATE — DATE
SHP_IP_POLICY
- SIP_SEQ — NUMBER — NOT NULL
- SIP_IP — VARCHAR2(20)
- SIP_LOCATION — VARCHAR2(20)
- SIP_RDATE — DATE
- SIP_UDATE — DATE