URTeacher

Tables (9)

file

  • id — bigint(20) — Primary key — NOT NULL
  • lecture_id — bigint(20) — Foreign key → lectures.lecture_id — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • path — VARCHAR(255) — NOT NULL

lecture_description (desired_dates)

  • id — bigint(20) — Primary key — NOT NULL
  • lecture_id — bigint(20) — Foreign key → lectures.lecture_id — NOT NULL
  • Field (desired_date) — DATETIME — NOT NULL

lecture_evaluation

  • evaluation_id — int(10) — Primary key — NOT NULL
  • lecture_id — int(10) — Foreign key → lectures.lecture_id — NOT NULL
  • evaluation_content — VARCHAR(255) — NOT NULL
  • evaluation_date — DATE — NOT NULL
  • user_code — bigint(20) — Foreign key → users.user_code — NOT NULL

lectures

  • lecture_id — bigint(20) — Primary key — NOT NULL
  • lecture_name — VARCHAR(45) — NOT NULL
  • Field (price) — int(10) — NOT NULL
  • Field (description) — LONGTEXT — NOT NULL
  • lecture_thumbnail — VARCHAR(255)
  • Field (student_num) — bigint(20)
  • user_code — bigint(20) — Foreign key → users.user_code — NOT NULL

like_lectures

  • id — bigint(20) — Primary key — NOT NULL
  • lecture_id — bigint(20) — Foreign key → lectures.lecture_id — NOT NULL
  • like_date — DATE — NOT NULL
  • user_code — bigint(20) — Foreign key → users.user_code — NOT NULL

registration_lectures

  • id — bigint(20) — Primary key — NOT NULL
  • registration_date — DATE — NOT NULL
  • Field (due_date) — DATE — NOT NULL
  • Field (lesson_date) — DATETIME — NOT NULL

request_lectures

  • id — bigint(20) — Primary key — NOT NULL
  • lecture_id — bigint(20) — Foreign key → lectures.lecture_id — NOT NULL
  • lesson_date — DATETIME — NOT NULL
  • requirement — VARCHAR(255)
  • Field (flag) — tinyint(1) — 과외 성사여부
  • user_code — bigint(20) — Foreign key → users.user_code — NOT NULL

user_role

  • role_id — bigint(20) — Primary key — NOT NULL
  • user_code — bigint(20) — Foreign key → users.user_code — NOT NULL
  • role_name — VARCHAR(45) — NOT NULL

users

  • user_code — bigint(20) — Primary key — NOT NULL
  • user_id — VARCHAR(45) — NOT NULL
  • user_pw — VARCHAR(45) — NOT NULL
  • Field (role) — VARCHAR(45) — NOT NULL — 학생, 강사
  • user_name — VARCHAR(45) — NOT NULL
  • address — VARCHAR(255)
  • join_day — DATE
  • gender — ENUM('M','F')
  • phone_number — VARCHAR(45)
  • birthday — DATE