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