22
Tables (15)
BBS_DATA_OPTN
- BDO_PROPT_KEY — VARCHAR(50) — Foreign key → BBS_PROPTY_OPTN.BPO_PROPT_KEY — NOT NULL
- BDO_OPTN_KEY — VARCHAR(50) — Foreign key → BBS_PROPTY_OPTN.BPO_OPTN_KEY — NOT NULL
- BDO_ORD_IDX — INTEGER — Foreign key → BBS_PROPTY_OPTN.BPO_ORD_IDX — NOT NULL
- BDO_BBS_KEY — VARCHAR(50) — Foreign key → BBS_POST_DATA.BPD_BBS_KEY — NOT NULL
- BDO_OPTN_VAL — TEXT
BBS_POST_DATA
- BPD_BBS_KEY — VARCHAR(50) — Foreign key → BBS_POST_DATA.BPD_BBS_KEY — NOT NULL
- BPD_PROPT_KEY — VARCHAR(50) — Foreign key → BBS_PROPTY_INFO.BPI_PROPT_KEY — NOT NULL
- BPD_DATA_DEPTH — VARCHAR(50)
- BPD_MAIN_TTL — VARCHAR(500)
- BPD_SUB_TTL — VARCHAR(500)
- BPD_ORD_IDX — INTEGER
- BPD_OPEN_YN — VARCHAR(50)
- BPD_PASS_WRD — VARCHAR(500)
- BPD_USER_NM — VARCHAR(500)
- BPD_VIEW_CNT — INTEGER
- BPD_LIKE_CNT — INTEGER
- BPD_NOTI_YN — VARCHAR(50)
- BPD_START_DT — VARCHAR(50)
- BPD_END_DT — VARCHAR(50)
- BPD_REG_DT — DATETIME
- BPD_REG_ID — VARCHAR(50)
- BPD_MOD_DT — DATETIME
- BPD_MOD_ID — VARCHAR(50)
- BPD_USE_YN — VARCHAR(50)
- BPD_FILE_KEY — VARCHAR(50) — Foreign key → SITE_FILE_DATA.SFD_FILE_KEY
- BPD_MAIN_CONT — TEXT
BBS_PROPTY_INFO
- BPI_PROPT_KEY — VARCHAR(50) — Primary key — NOT NULL
- BPI_PROPT_NM — VARCHAR(500)
- BPI_BBS_TYPE — VARCHAR(50) — Foreign key → SITE_COMM_CODE.SCC_CODE_KEY
- BPI_BBS_CONT — TEXT
- BPI_WRITE_YN — VARCHAR(50)
- BPI_SECRT_YN — VARCHAR(50)
- BPI_GUEST_YN — VARCHAR(50)
- BPI_REPLY_YN — VARCHAR(50)
- BPI_USE_YN — VARCHAR(50)
- BPI_REG_DT — DATETIME
- BPI_REG_ID — VARCHAR(50)
- BPI_MOD_DT — DATETIME
- BPI_MOD_ID — VARCHAR(50)
- BPI_FILE_YN — VARCHAR(50)
BBS_PROPTY_OPTN
- BPO_OPTN_KEY — VARCHAR(50) — Primary key — NOT NULL
- BPO_ORD_IDX — INTEGER — Primary key — NOT NULL
- BPO_PROPT_KEY — VARCHAR(50) — Foreign key → BBS_PROPTY_INFO.BPI_PROPT_KEY — NOT NULL
- BPO_OPTN_NM — VARCHAR(500)
- BPO_OPTN_TYPE — VARCHAR(150)
- BPO_SUB_HTML — TEXT
- BPO_REQRD_YN — VARCHAR(50)
- BPO_LIST_YN — VARCHAR(50)
- BPO_SRCH_YN — VARCHAR(50)
- BPO_FONT_YN — VARCHAR(50)
CMS_BNNR_INFO
- CBI_BNNR_KEY — VARCHAR(50) — Primary key — NOT NULL
- CBI_SITE_KEY — VARCHAR(50) — Foreign key → SITE_COMM_CODE.SCC_CODE_KEY
- CBI_MAIN_TTL — VARCHAR(500)
- CBI_MAIN_CONT — TEXT
- CBI_START_DT — VARCHAR(50)
- CBI_END_DT — VARCHAR(50)
- CBI_USE_YN — VARCHAR(50)
- CBI_SUB_TTL — VARCHAR(500)
- CBI_PC_IMG — VARCHAR(1500)
- CBI_MB_IMG — VARCHAR(1500)
- CBI_REG_DT — DATETIME
- CBI_REG_ID — VARCHAR(50)
- CBI_MOD_DT — DATETIME
- CBI_MOD_ID — VARCHAR(50)
- CBI_ORD_IDX — INTEGER
- CBI_URL_LINK — VARCHAR(50)
- CBI_URL_TGT — VARCHAR(50)
CMS_PAGE_DATA
- CPD_PAGE_KEY — VARCHAR(50) — Primary key — NOT NULL
- CPD_VER_IDX — INTEGER — Primary key — NOT NULL
- CPD_PAGE_NM — VARCHAR(500)
- CPD_MENU_NAV — VARCHAR(2500)
- CPD_PAGE_CONT — TEXT
- CPD_USE_YN — VARCHAR(50)
- CPD_START_DT — DATETIME
- CPD_END_DT — DATETIME
- CPD_WITHIN_CONT — TEXT
- CPD_POST_CONT — TEXT
- CPD_REG_DT — DATETIME
- CPD_REG_ID — VARCHAR(50)
- CPD_MOD_DT — DATETIME
- CPD_MOD_ID — VARCHAR(50)
- CPD_SITE_KEY — VARCHAR(50) — Foreign key → SITE_COMM_CODE.SCC_CODE_KEY
CMS_POPUP_INFO
- CPI_POPUP_KEY — VARCHAR(50) — Primary key — NOT NULL
- CPI_SITE_KEY — VARCHAR(50) — Foreign key → SITE_COMM_CODE.SCC_CODE_KEY
- CPI_MAIN_TTL — VARCHAR(500)
- CPI_MAIN_CONT — TEXT
- CPI_LYR_W — INTEGER
- CPI_LYR_H — INTEGER
- CPI_LYR_L — INTEGER
- CPI_LYR_T — INTEGER
- CPI_START_DT — VARCHAR(50)
- CPI_END_DT — VARCHAR(50)
- CPI_ORD_IDX — INTEGER
- CPI_URL_LINK — VARCHAR(1500)
- CPI_URL_TRT — VARCHAR(50)
- CPI_REG_DT — DATETIME
- CPI_REG_ID — VARCHAR(50)
- CPI_MOD_DT — DATETIME
- CPI_MOD_ID — VARCHAR(50)
- CPI_USE_YN — VARCHAR(50)
DOC_FORM_MNG
- DFM_FRM_KEY — VARCHAR(50) — Primary key — NOT NULL
- DFM_FRM_TTL — VARCHAR(500)
- DFM_REG_DT — DATETIME
- DFM_REG_ID — VARCHAR(50)
- DFM_MOD_DT — DATETIME
- DFM_MOD_ID — VARCHAR(50)
- DFM_USE_YN — VARCHAR(1)
DOC_REG_LDGR
- DRL_REG_KEY — VARCHAR(50) — Primary key — NOT NULL
- DRL_FRM_KEY — VARCHAR(50) — Foreign key → DOC_FORM_MNG.DFM_FRM_KEY
- DRL_REP_NO — VARCHAR(50)
- DRL_REP_DT — VARCHAR(50)
- DRL_ISSUE_DT — VARCHAR(50)
- DRL_STEP_CD — VARCHAR(50)
- DRL_ANML_NO — VARCHAR(150)
- DRL_USE_YN — VARCHAR(1)
- DRL_USER_ID — VARCHAR(50) — Foreign key → SITE_USER_INFO.SUI_USER_ID
- DRL_FILE_KEY — VARCHAR(50) — Foreign key → SITE_FILE_DATA.SFD_FILE_KEY
- DRL_ANML_NM — VARCHAR(500)
- DRL_REG_DT — DATETIME
- DRL_REG_ID — VARCHAR(50)
- DRL_MOD_DT — DATETIME
- DRL_MOD_ID — VARCHAR(50)
SITE_ACCS_LOG
- SAL_USER_ID — VARCHAR(50) — Foreign key → SITE_USER_INFO.SUI_USER_ID
- SAL_REG_DT — DATETIME
- SAL_IP_ADDR — VARCHAR(50)
- SAL_ACCS_URL — TEXT
- SAL_LOG_DIV — VARCHAR(50)
- SAL_LOG_KEY — BIGINT — NOT NULL
- SAL_LOG_DTL — VARCHAR(2500)
- SAL_BRWSR_AGNT — VARCHAR(2500)
- SAL_EXC_QRY — VARCHAR(50)
- SAL_EXC_CNT — VARCHAR(50)
- SAL_DEPT_NM — VARCHAR(350)
- SAL_TASK_NM — VARCHAR(500)
- SAL_DWN_YN — VARCHAR(1)
- SAL_DWN_RSN — VARCHAR(500)
- SAL_PRIV_NM — VARCHAR(50)
- SAL_ROW_CNT — VARCHAR(50)
- SAL_CRE_DT — VARCHAR(50)
- SAL_DEL_DT — VARCHAR(50)
- SAL_DEL_RSN — VARCHAR(500)
- SAL_PRCS_ID — VARCHAR(50)
- SAL_APRV_ID — VARCHAR(50)
- SAL_OV14_YN — VARCHAR(1)
SITE_COMM_CODE
- SCC_CODE_KEY — VARCHAR(50) — Primary key — NOT NULL
- SCC_PARENT_KEY — VARCHAR(50) — Foreign key → SITE_COMM_CODE.SCC_CODE_KEY
- SCC_CODE_TTL — VARCHAR(350)
- SCC_CODE_DESC — VARCHAR(2500)
- SCC_USE_YN — VARCHAR(50)
- SCC_CODE_REF — VARCHAR(2500)
- SCC_ORD_IDX — INTEGER
- SCC_REG_DT — DATETIME
- SCC_REG_ID — VARCHAR(50)
- SCC_MOD_DT — DATETIME
- SCC_MOD_ID — VARCHAR(50)
SITE_FILE_DATA
- SFD_FILE_KEY — VARCHAR(50) — Primary key — NOT NULL
- SFD_USE_YN — VARCHAR(50)
- SFD_REG_DT — DATETIME
SITE_FILE_SET
- SFS_ORD_IDX — INTEGER — Primary key — NOT NULL
- SFS_FILE_KEY — VARCHAR(50) — Foreign key → SITE_FILE_DATA.SFD_FILE_KEY — NOT NULL
- SFS_SAVE_PATH — VARCHAR(2500)
- SFS_SAVE_NM — VARCHAR(500)
- SFS_REAL_NM — VARCHAR(500)
- SFS_WEB_PATH — VARCHAR(2500)
- SFS_MIME_TYPE — VARCHAR(50)
- SFS_FILE_SIZE — VARCHAR(50)
- SFS_DOWN_CNT — INTEGER
- SFS_REG_DT — DATETIME
SITE_MENU_INFO
- SMI_MENU_KEY — VARCHAR(50) — Primary key — NOT NULL
- SMI_PARENT_KEY — VARCHAR(50) — Foreign key → SITE_MENU_INFO.SMI_MENU_KEY
- SMI_MENU_NM — VARCHAR(500)
- SMI_ORD_IDX — INTEGER
- SMI_LINK_URL — VARCHAR(2500)
- SMI_LINK_TRT — VARCHAR(2500)
- SMI_SITE_KEY — VARCHAR(50) — Foreign key → SITE_COMM_CODE.SCC_CODE_KEY
- SMI_USE_YN — VARCHAR(50)
- SMI_METHOD_TYPE — VARCHAR(50)
- SMI_MENU_ICON — VARCHAR(250)
- SMI_PROPT_KEY — VARCHAR(50) — Foreign key → BBS_PROPTY_INFO.BPI_PROPT_KEY
- SMI_PAGE_KEY — VARCHAR(50) — Foreign key → CMS_PAGE_DATA.CPD_PAGE_KEY
- SMI_VER_IDX — INTEGER — Foreign key → CMS_PAGE_DATA.CPD_VER_IDX
- SMI_READ_PERM — TEXT
- SMI_WRITE_PERM — TEXT
- SMI_ADMIN_PERM — TEXT
- SMI_REG_DT — DATETIME
- SMI_REG_ID — VARCHAR(50)
- SMI_MOD_DT — DATETIME
- SMI_MOD_ID — VARCHAR(50)
SITE_USER_INFO
- SUI_USER_ID — VARCHAR(50) — Primary key — NOT NULL
- SUI_USER_NM — VARCHAR(500)
- SUI_PASS_WRD — VARCHAR(500)
- SUI_PWD_HINT — VARCHAR(500)
- SUI_PWD_SALT — VARCHAR(50)
- SUI_HP_NO — VARCHAR(500)
- SUI_EMAIL_ADDR — VARCHAR(500)
- SUI_LOGIN_DT — DATETIME
- SUI_CI_VAL — VARCHAR(500)
- SUI_USE_YN — VARCHAR(50)
- SUI_REG_DT — DATETIME
- SUI_MOD_DT — DATETIME
- SUI_GRADE_KEY — VARCHAR(50) — Foreign key → SITE_COMM_CODE.SCC_CODE_KEY
- SUI_ZIP_CD — VARCHAR(50)
- SUI_ADDR_FST — VARCHAR(500)
- SUI_ADDR_DETL — VARCHAR(500)
- SUI_BIZ_NM — VARCHAR(250)
- SUI_BIZ_THUMB — VARCHAR(2500)
- SUI_REP_NM — VARCHAR(150)