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