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)