sds
Tables (12)
USER
- USER_NO — VARCHAR(10) — Primary key — NOT NULL
- LOGIN_ID — VARCHAR(50)
- USER_NAME — VARCHAR(50)
- PW — VARCHAR(512)
- ADMIN_YN — VARCHAR(2)
- FIR_YN — VARCHAR(2)
- PW_ERR_CNT — VARCHAR(255)
- PW_CHG_DT — VARCHAR(255)
- RCNT_ACC_DT — VARCHAR(255)
board
- BOARD_NUM — int — Primary key — NOT NULL
- Field — varchar(50)
- BOARD_NAME — varchar(255)
board_file
- FILE_ID — int — Primary key — NOT NULL
- FILE_SEQ — varchar(255) — Primary key — NOT NULL
- CREATED_DATETIME — datetime
- DELETED_YN — varchar(2)
- FILE_SIZE — bigint
- FILE_PATH — varchar(255)
- UPDATED_DATETIME — datetime
- NOTICE_ID — int
- POST_NUM — int — NOT NULL
chapter
- sereal_num — int — Primary key — NOT NULL
- Key — varchar(50) — Foreign key → contents_manage.con_num — NOT NULL
- chap_name — varchar(50)
- chap_start_time — VARCHAR(255)
comment
- COMMENT_NUM — int — Primary key — NOT NULL
- P_COMMENT_NUM — int — NOT NULL
- COMMENT_CONTENTS — varchar(255)
- EMAIL — varchar(255)
- COMMENT_CREATED — varchar(255)
- COMMENT_UPDATE — varchar(255)
- POST_NUM — int — NOT NULL
contents_manage
- con_num — int — Primary key — NOT NULL
- con_name — varchar(50)
- con_desc — text
- video_id — varchar(50)
- con_play_time — varchar(50)
- lec_name — varchar(50)
- thumb_url — varchar(200)
lecture_info
- lec_num — varchar(50) — Primary key — NOT NULL
- lec_start_date — datetime
- lec_end_date — datetime
- lec_name — varchar(50)
- lec_ex — text
post
- POST_NUM — int — Primary key — NOT NULL
- P_POST_NUM — int — NOT NULL
- POST_TITLE — varchar(255)
- POST_CONTENTS — varchar(255)
- CREATED_DATETIME — varchar(255)
- UPDATE_DATETME — varchar(255)
- HIT_CNT — int
- BOARD_NUM — int — NOT NULL
- USER_NO — VARCHAR(10) — NOT NULL
section_info
- sec_num — int — Primary key — NOT NULL
- lec_num — varchar(50) — Foreign key → lecture_info.lec_num — NOT NULL
- con_num — int — NOT NULL
- sec_name — varchar(50)
section_progress
- sec_num — varchar(50) — Foreign key → section_info.sec_num — NOT NULL
- lec_num — varchar(50) — Foreign key → section_info.lec_num — NOT NULL
- USER_NO — VARCHAR(10) — Foreign key → USER.USER_NO — NOT NULL
- learning_time — varchar(50)
- FNL_S — VARCHAR(255)
- MAX_S — VARCHAR(255)
stu_sub_tb
- USER_NO — VARCHAR(10) — Foreign key → USER.USER_NO — NOT NULL
- lec_num — varchar(50) — Foreign key → lecture_info.lec_num — NOT NULL
- id — int
sugang_reg
- lec_num — varchar(50) — Foreign key → lecture_info.lec_num — NOT NULL
- USER_NO — VARCHAR(10) — Foreign key → USER.USER_NO — NOT NULL
- lec_sub_date — datetime
- lec_check — VARCHAR(255)