test

Tables (15)

ASSIGNMENT

  • ID — BIGINT
  • TITLE — VARCHAR(255) — NOT NULL
  • CONTENT — VARCHAR(3000)
  • COURSE_ID — BIGINT — NOT NULL
  • START_TIME — DATETIME
  • END_TIME — DATETIME
  • CREATED_TIME — DATETIME
  • DEL_YN — CHAR(1) — NOT NULL

ASSIGNMENT_OUTPUT

  • ID — BIGINT
  • CONTENT — VARCHAR(3000)
  • ASSIGNMENT_ID — BIGINT — NOT NULL
  • STUDENT_ID — BIGINT — NOT NULL
  • SCORE — TINYINT
  • FEEDBACK — VARCHAR(300)
  • SUBMIT_DATE — DATETIME
  • DEL_YN — CHAR(1) — NOT NULL

COURSE_QUESTION

  • ID — BIGINT
  • TITLE — VARCHAR(255) — NOT NULL
  • CONTENT — VARCHAR(3000)
  • COURSE_ID — BIGINT — NOT NULL
  • CREATED_TIME — DATETIME
  • DEL_YN — CHAR(1) — NOT NULL

COURSE_RESPONSE

  • ID — BIGINT
  • CONTENT — VARCHAR(3000)
  • C_QUESTION_ID — BIGINT — NOT NULL
  • CREATED_TIME — DATETIME
  • DEL_YN — CHAR(1) — NOT NULL

FA

  • id — bigint — Primary key — NOT NULL
  • title — varchar(255)
  • content — TEXT
  • created_date — datetime
  • del_yn — CHAR(1)

attendance

  • id — bigint — Primary key — NOT NULL
  • student_id — bigint
  • lecture_id — bigint
  • state — char(1)
  • view_date — datetime
  • del_yn — CHAR(1)

course

  • id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(8000) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • category — VARCHAR(255) — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • instructor_id — BIGINT — Foreign key → user.id — NOT NULL
  • created_date — DATETIME
  • del_yn — char(1)

course_register

  • id — bigint(20) — Primary key — NOT NULL
  • student_id — bigint(20) — Foreign key → user.id
  • course_id — bigint(20) — Foreign key → course.id
  • completed_state — char(1)
  • created_time — datetime
  • del_yn — char(1)

exam

  • id — bigint(20) — Primary key — NOT NULL
  • course_id — bigint(20) — Foreign key → course.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — varchar(3000)
  • exam_date — datetime — NOT NULL
  • limited_time — datetime
  • created_date — datetime
  • del_yn — char(1)

exam_outpput

  • id — bigint(20) — Primary key — NOT NULL
  • exam_id — bigint(20) — Foreign key → exam.id — NOT NULL
  • student_id — bigint(20) — Foreign key → user.id — NOT NULL
  • content — varchar(3000) — NOT NULL
  • score — int(11)
  • created_date — datetime
  • del_yn — char(1)

lecture

  • id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • content — VARCHAR(255)
  • course_id — BIGINT — Foreign key → course.id — NOT NULL
  • running_time — TIME — NOT NULL
  • created_date — DATETIME
  • del_yn — char(1)

payment

  • id — bigint — Primary key — NOT NULL
  • register_id — bigint
  • payment_id — bigint
  • del_yn — CHAR(1)

payment_method

  • id — bigint(20) — Primary key — NOT NULL
  • student_id — bigint(20) — Foreign key → user.id — NOT NULL
  • card_category — varchar(45)
  • card_number — char(16)
  • created_date — datetime
  • del_yn — char(1)

review

  • id — bigint — Primary key — NOT NULL
  • course_id — bigint
  • student_id — bigint
  • content — TEXT
  • star — int
  • created_date — datetime
  • del_yn — CHAR(1)

user

  • id — BIGINT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • name — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(255) — NOT NULL
  • role — ENUM('학생', '강사', '관리자') — NOT NULL
  • created_date — DATETIME
  • del_yn — char(1)