test
Tables (50)
ADM
- ADM_SN — INT — Primary key — NOT NULL
- ADM_NM — VARCHAR(40)
- ID — VARCHAR(40)
- PWD — VARCHAR(40)
- GNDR — VARCHAR
- TEL_NO — VARCHAR
- BDAY — CHAR
- OGDP — VARCHAR(40)
- IBPS — VARCHAR
- ADM_PICT_PATH — VARCHAR
- ADM_PICT_FN — VARCHAR(40)
- EML — VARCHAR
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
- LOGIN_IP — VARCHAR
- LAST_LOGIN_DT — DATETIME
ADM_AUTH
- ADM_AUTH_SN — INT — Primary key — NOT NULL
- ADM_AUTH_TTL_SN — INT — Foreign key → ADM_AUTH_TTL.ADM_AUTH_TTL_SN — NOT NULL
- ADM_AUTH_NM — VARCHAR
ADM_AUTH_ASSGN
- ADM_AUTH_ASSGN — INT — Primary key — NOT NULL
- ADM_AUTH_DTL_SN — INT — Foreign key → ADM_AUTH_DTL.ADM_AUTH_DTL_SN — NOT NULL
- ADM_SN — INT — Foreign key → ADM.ADM_SN — NOT NULL
ADM_AUTH_DTL
- ADM_AUTH_DTL_SN — INT — Primary key — NOT NULL
- ADM_AUTH_SN — INT — Foreign key → ADM_AUTH.ADM_AUTH_SN — NOT NULL
- ADM_AUTH_DTL_NM — VARCHAR
- ADM_AUTH_DTL_DSCRT — VARCHAR
- ADM_AUTH_DTL_STT — CHAR
ADM_AUTH_TTL
- ADM_AUTH_TTL_SN — INT — Primary key — NOT NULL
- ADM_AUTH_TTL_NM — VARCHAR
ADM_LOGIN_HIST
- HIST_SN — INT — Primary key — NOT NULL
- ADM_SN — INT — Foreign key → ADM.ADM_SN — NOT NULL
- LOGIN_IP — VARCHAR
- LOGIN_DT — DATETIME
ANS
- EXMP_SN — INT — Primary key — NOT NULL
- QSTN_SN — INT — Foreign key → QSTN.QSTN_SN — NOT NULL
- SURV_SN — INT — Foreign key → QSTN.SURV_SN — NOT NULL
- EXMP_SN2 — INT — Foreign key → EXMP.EXMP_SN — NOT NULL
- SURV_SN2 — INT — Foreign key → EXMP.SURV_SN — NOT NULL
- EXMP_CN — VARCHAR
- CRT_DT — DATETIME
CLS
- CLS_SN — INT — Primary key — NOT NULL
- CRS_SN — INT — Foreign key → CRS.CRS_SN — NOT NULL
- INSTR_SN2 — INT — Foreign key → INSTR.INSTR_SN — NOT NULL
- CRS_NM — VARCHAR(40)
- INSTR_SN — INT
- INSTR_NM — VARCHAR(40)
- CLS_TYPE — CHAR
- CLSRM_LOC — VARCHAR
- POI_SN — INT
- CLS_DATE — CHAR
- DSCRT — CHAR
- RCRT_GDLN — CHAR
- CLS_VID_PATH — VARCHAR
- CLS_VID_FN — VARCHAR(40)
- CLS_STT — CHAR
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
CLS_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- CLS_SN — INT — Foreign key → CLS.CLS_SN — NOT NULL
- INSTR_SN2 — INT — Foreign key → CLS.INSTR_SN2 — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
CMMNT
- CMMNT_SN — INT — Primary key — NOT NULL
- CMMNT_RPRSV_SN — INT
- CMMNT_NM — VARCHAR(40)
- CMMNT_CN — TEXT
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
CMMNT_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- CMMNT_SN — INT — Foreign key → CMMNT.CMMNT_SN — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
CMMNT_POST
- POST_SN — INT — Primary key — NOT NULL
- CMMNT_SN — INT — Foreign key → CMMNT.CMMNT_SN — NOT NULL
- MBR_SN — INT — Foreign key → MBR.MBR_SN — NOT NULL
- POST_NM — VARCHAR(40)
- POST_CN — TEXT
- HITS — INT
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
CMMNT_POST_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- POST_SN — INT — Foreign key → CMMNT_POST.POST_SN — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
CMMN_CD
- MENU_SN — INT — Primary key — NOT NULL
- CD_SN — INT
- CLSSFY_NM — VARCHAR
- INTM_CLSSFY — VARCHAR(40)
- CD — VARCHAR
- CD_NM — VARCHAR(40)
CRS
- CRS_SN — INT — Primary key — NOT NULL
- CRS_NM — VARCHAR(40)
- CRS_NOPE — INT
- MNPE — INT
- RCRT_BGNG_DATE — CHAR
- RCRT_END_DATE — CHAR
- CRS_BGNG_DATE — CHAR
- CRS_END_DATE — CHAR
- DSCRT — TEXT
- RCRT_GDLN — TEXT
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
CRS_APLY
- CRS_APLY_SN — INT — Primary key — NOT NULL
- MBR_SN — INT — Foreign key → MBR.MBR_SN — NOT NULL
- CRS_SN — INT — Foreign key → CRS.CRS_SN — NOT NULL
- ADM_SN — INT — Foreign key → ADM.ADM_SN — NOT NULL
- CRS_APLY_NM — VARCHAR(40)
- APLY_CN — TEXT
- APLY_STT — CHAR
- PRCS_CN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
CRS_APLY_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- CRS_APLY_SN — INT — Foreign key → CRS_APLY.CRS_APLY_SN — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
CRS_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- CRS_SN — INT — Foreign key → CRS.CRS_SN — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
CRS_MNGR
- CRS_MNGR_SN — INT — Primary key — NOT NULL
- CRS_SN — INT — Foreign key → CRS.CRS_SN — NOT NULL
- MBR_SN — INT — Foreign key → MBR.MBR_SN — NOT NULL
- MNGR_NM — VARCHAR(40)
- MNGR_DSGN — VARCHAR(40)
- MNGR_ROLE — VARCHAR(40)
CopyOfCMMNT
- CMMNT_MBR_SN — INT — Primary key — NOT NULL
- CMMNT_SN — INT — Foreign key → CMMNT.CMMNT_SN — NOT NULL
- MBR_SN — INT — Foreign key → MBR.MBR_SN — NOT NULL
- MBR_TYPE — CHAR
- HITS — INT
- MBR_STT — CHAR
- JOIN_DT — DATETIME
- WDR_DT — DATETIME
EXMP
- EXMP_SN — INT — Primary key — NOT NULL
- SURV_SN — INT — Foreign key → QSTN.SURV_SN — NOT NULL
- EXMP_ODR — INT
- EXMP_TYPE — CHAR
- EXMP_CN — VARCHAR
- EXMP_CHC_CNT — INT
- CRT_DT — DATETIME
- MOD_DT — DATETIME
INSTR
- INSTR_SN — INT — Primary key — NOT NULL
- PRFL_FILE_PATH — VARCHAR
- PRFL_FILE_NM — VARCHAR(40)
- PRFL_FILE_URL — VARCHAR(40)
- INSTR_NM — VARCHAR(40)
- INSTR_HIST — VARCHAR
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
MBR
- MBR_SN — INT — Primary key — NOT NULL
- MBR_NM — VARCHAR(40)
- ID — VARCHAR(40)
- PWD — VARCHAR(40)
- SNS_ID — VARCHAR(40)
- SNS_TYPE — VARCHAR
- GNDR — VARCHAR
- TEL_NO — VARCHAR
- BDAY — CHAR
- ADDR — VARCHAR
- DTL_ADDR — VARCHAR
- MBR_PICT_PATH — VARCHAR
- MBR_PICT_FN — VARCHAR(40)
- EML — VARCHAR(40)
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
- LOGIN_IP — VARCHAR(40)
- LAST_LOGIN_DT — DATETIME
MBR_AUTH
- MBR_AUTH_SN — INT — Primary key — NOT NULL
- MBR_AUTH_NM — VARCHAR
MBR_AUTH_ASSGN
- MBR_AUTH_ASSGN_SN — INT — Primary key — NOT NULL
- MBR_AUTH_DTL_SN — INT — Foreign key → MBR_AUTH_DTL.MBR_AUTH_DTL_SN — NOT NULL
- MBR_SN — INT — Foreign key → MBR.MBR_SN — NOT NULL
- AUTH_STT — CHAR
MBR_AUTH_DTL
- MBR_AUTH_DTL_SN — INT — Primary key — NOT NULL
- MBR_AUTH_SN — INT — Foreign key → MBR_AUTH.MBR_AUTH_SN — NOT NULL
- AUTH_NM — VARCHAR
- AUTH_CN — VARCHAR
- Field — VARCHAR(255)
MBR_MENU
- MENU_SN — INT — Primary key — NOT NULL
- Field — INT
- Field2 — CHAR
- URL — VARCHAR(40)
- MENU_TYPE — VARCHAR
- ICON — VARCHAR(40)
NTC
- NTC_SN — INT — Primary key — NOT NULL
- NTC_CTGR_SN — INT — Foreign key → NTC_CTGR.NTC_CTGR_SN — NOT NULL
- WRTR_SN — INT — Foreign key → ADM.ADM_SN — NOT NULL
- WRTR_NM — VARCHAR
- NTC_TITLE — VARCHAR(40)
- HITS — INT
- CMNT_YN — CHAR
- TOPFIX_YN — CHAR
- NTC_CN — TEXT
- POI_SN — INT
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
NTC_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- NTC_SN — INT — Foreign key → NTC.NTC_SN — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
NTC_CTGR
- NTC_CTGR_SN — INT — Primary key — NOT NULL
- ODR — INT
- NTC_CTGR_NM — VARCHAR(40)
PCON_SCHD
- PCON_SCHD_SN — INT — Primary key — NOT NULL
- ADM_SN — INT — Foreign key → ADM.ADM_SN — NOT NULL
- PCON_NM — VARCHAR(40)
- PCON_CN — TEXT
- DIC — VARCHAR(40)
- PCON_BGNG_DATE — CHAR
- PCON_LAST_DATE — CHAR
- HITS — INT
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
POST_CMNT
- CMNT_SN — INT — Primary key — NOT NULL
- POST_SN — INT — Foreign key → CMMNT_POST.POST_SN — NOT NULL
- MBR_SN — INT — Foreign key → MBR.MBR_SN — NOT NULL
- PRNT_CMNT_SN — INT
- CMNT_CN — VARCHAR(40)
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- DEL_DT — DATETIME
PRMAT
- MBR_SN — INT — Primary key — NOT NULL
- PRMAT_CTGR_SN — INT — Foreign key → PRMAT_CTGR.PRMAT_CTGR_SN — NOT NULL
- PIC_SN — INT — Foreign key → ADM.ADM_SN — NOT NULL
- RELITM_CD — VARCHAR(40)
- RELITM_SN — VARCHAR(40)
- PRMAT_NM — VARCHAR(40)
- PRMAT_CN — TEXT
- DIC — VARCHAR(40)
- PRMAT_BGNG_DATE — CHAR
- PRMAT_LAST_DATE — CHAR
- PRMAT_EXP_YN — CHAR
- PRMAT_POPUP_LINK — VARCHAR(100)
- PRMAT_FILE_PATH — VARCHAR
- PAMAT_FILE_NM — VARCHAR(40)
- PRMAT_FILE_URL — VARCHAR(40)
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
PRMAT_CTGR
- PRMAT_CTGR_SN — INT — Primary key — NOT NULL
- ORD — INT
- PRMAT_CTGR_NM — VARCHAR(40)
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
PROJ_INFM
- PROJ_INFM_SN — INT — Primary key — NOT NULL
- MOD_ADM_SN — INT — Foreign key → ADM.ADM_SN — NOT NULL
- PROJ_CLSSFY — CHAR
- PROJ_CODE — CHAR
- POI_SN — INT
- PROJ_CN — TEXT
- CRT_DT — DATETIME
- MOD_DT — DATETIME
QSTN
- QSTN_SN — INT — Primary key — NOT NULL
- SURV_SN — INT — Foreign key → SURV.SURV_SN — NOT NULL
- QSTN_ODR — INT
- QSTN_TYPE — CHAR
- QSTN_CN — VARCHAR
- QSTN_DSCRT — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
RSDT_PCON
- RSDT_PCON_SN — INT — Primary key — NOT NULL
- ADM_SN2 — INT — Foreign key → ADM.ADM_SN — NOT NULL
- RSDT_PCON_NM — VARCHAR(40)
- PCON_CN — TEXT
- PCON_BGNG_DATE — CHAR
- PCON_BGNG_TIME — CHAR
- PCON_END_DATE — CHAR
- PCON_END_TIME — CHAR
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
RSDT_PCON_APLY
- RSDT_PCON_APLY_SN — INT — Primary key — NOT NULL
- MBR_SN — INT — Foreign key → MBR.MBR_SN — NOT NULL
- RSDT_PCON_SN — INT — Foreign key → RSDT_PCON.RSDT_PCON_SN — NOT NULL
- ADM_SN2 — INT — Foreign key → RSDT_PCON.ADM_SN2 — NOT NULL
- APLY_NM — VARCHAR(40)
- APLY_CN — TEXT
- CRT_DT — DATETIME
- MOD_DT — DATETIME
RSDT_PCON_APLY_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- RSDT_PCON_APLY_SN — INT — Foreign key → RSDT_PCON_APLY.RSDT_PCON_APLY_SN — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
RSDT_PCON_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- RSDT_PCON_SN — INT — Foreign key → RSDT_PCON.RSDT_PCON_SN — NOT NULL
- ADM_SN2 — INT — Foreign key → RSDT_PCON.ADM_SN2 — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
SBMT
- CRS_SN — INT — Primary key — NOT NULL
- TASK_SN — INT — Foreign key → TASK.TASK_SN — NOT NULL
- INSTR_SN2 — INT — Foreign key → TASK.INSTR_SN2 — NOT NULL
- MBR_SN — INT — Foreign key → MBR.MBR_SN — NOT NULL
- SBMT_NM — VARCHAR(40)
- SBMT_CN — VARCHAR
- SBMT_DATE — CHAR
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
SBMT_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- CRS_SN — INT — Foreign key → SBMT.CRS_SN — NOT NULL
- INSTR_SN2 — INT — Foreign key → SBMT.INSTR_SN2 — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
STDNT
- STDNT_SN — INT — Primary key — NOT NULL
- CRS_APLY_SN — INT — Foreign key → CRS_APLY.CRS_APLY_SN — NOT NULL
- MBR_SN2 — INT — Foreign key → CRS_APLY.MBR_SN — NOT NULL
- CRS_SN2 — INT — Foreign key → CRS_APLY.CRS_SN — NOT NULL
- CRS_APLY_NM — VARCHAR(40)
- APLY_CN — TEXT
- APLY_STT — CHAR
- PRCS_CN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
SURV
- SURV_SN — INT — Primary key — NOT NULL
- RELITM_CD — CHAR
- RELITM_SN — INT
- SURV_NM — VARCHAR(40)
- SURV_CN — TEXT
- SURV_CMPTN_CNT — INT
- SURV_BGNG_DATE — CHAR
- SURV_END_DATE — CHAR
- SURV_EXP_YN — VARCHAR
- RES_EXP_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- POI_SN — INT
SVC
- SVC_SN — INT — Primary key — NOT NULL
- ADM_SN — INT — Foreign key → ADM.ADM_SN — NOT NULL
- SVC_NM — VARCHAR(40)
- SVC_CN — TEXT
- DIC — VARCHAR(40)
- SVC_BGNG_DATE — CHAR
- SVC_LAST_DATE — CHAR
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
SVC_DOC
- SVC_DOC_SN — INT — Primary key — NOT NULL
- SVC_SN — INT — Foreign key → SVC.SVC_SN — NOT NULL
- ADM_SN — INT — Foreign key → ADM.ADM_SN — NOT NULL
- DOC_NM — VARCHAR(40)
- DOC_CN — TEXT
- HITS — INT
- DEL_YN — VARCHAR
- CRT_DT — DATETIME
- MOD_DT — DATETIME
- DEL_DT — DATETIME
SVC_DOC_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- SVC_DOC_SN — INT — Foreign key → SVC_DOC.SVC_DOC_SN — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
TASK
- TASK_SN — INT — Primary key — NOT NULL
- CLS_SN — INT — Foreign key → CLS.CLS_SN — NOT NULL
- INSTR_SN2 — INT — Foreign key → CLS.INSTR_SN2 — NOT NULL
- TASK_NM — VARCHAR(40)
- TASK_CN — VARCHAR
- TASK_DL — DATETIME
TASK_ATCHFILE
- ATCHFILE_SN — INT — Primary key — NOT NULL
- TASK_SN — INT — Foreign key → TASK.TASK_SN — NOT NULL
- INSTR_SN2 — INT — Foreign key → TASK.INSTR_SN2 — NOT NULL
- ATCHFILE_PATH — VARCHAR
- ATCHFILE_NM — VARCHAR(40)
- ATCHFILE_URL — VARCHAR(40)
- FILE_TYPE — VARCHAR(40)
- FILE_SIZE — INT
TKCLS
- TKCLS_SN — INT — Primary key — NOT NULL
- CLS_SN — INT — Foreign key → CLS.CLS_SN — NOT NULL
- INSTR_SN2 — INT — Foreign key → CLS.INSTR_SN2 — NOT NULL
- MBR_SN — INT — Foreign key → MBR.MBR_SN — NOT NULL
- TKCLS_STT — CHAR
- WTCHTM — INT
- FRST_WTCHTM — DATETIME
- LAST_WTCHTM — DATETIME