ㅅㄷㄴㅅ
Tables (17)
answers
- answer_id — bigint — Primary key — NOT NULL
- question_id — bigint — Foreign key → questions.question_id — NOT NULL
- user_id — bigint — Foreign key → questions.user_id — NOT NULL
- lecture_id — bigint — Foreign key → questions.lecture_id — NOT NULL
- content — text — NOT NULL
- reply_date — DATETIME — NOT NULL
attends
- attend_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → members.member_id — NOT NULL
- lecture_id — bigint — Foreign key → lectures.lecture_id — NOT NULL
- is_refundable — boolean — NOT NULL
board_images
- board_image_id — bigint — Primary key — NOT NULL
- question_id — int — NOT NULL
- user_id — int — NOT NULL
- lecture_id — int — NOT NULL
- url — varchar(100) — NOT NULL
carts
- cart_id — bigint — Primary key — NOT NULL
- lecture_id — bigint — Foreign key → lectures.lecture_id — NOT NULL
- user_id — bigint — Foreign key → members.member_id — NOT NULL
lecture_files
- lecture_id — bigint — Foreign key → lectures.lecture_id — NOT NULL
- user_id — bigint — Foreign key → lectures.member_id — NOT NULL
- file_url — text — NOT NULL
lecture_lists
- lecture_list_id — bigint — Primary key — NOT NULL
- lecture_id — bigint — Foreign key → lectures.lecture_id — NOT NULL
- member_id — bigint — Foreign key → lectures.member_id — NOT NULL
- title — varchar(100) — NOT NULL
- description — text — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- finished — boolean — NOT NULL
lectures
- lecture_id — bigint — Primary key — NOT NULL
- member_id — bigint — Foreign key → members.member_id — NOT NULL
- title — varchar(100) — NOT NULL
- profile — text
- description — text — NOT NULL
- description_pic — text
- category — varchar(300) — NOT NULL
- price — int — NOT NULL
- status — boolean — NOT NULL
- link — varchar(300)
- likes — int — NOT NULL
- limit_student — int — NOT NULL
- deadline_time — DATETIME — NOT NULL
- lectures_date — DATETIME — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
lectures_tags
- lecture_id — bigint — Foreign key → lectures.lecture_id — NOT NULL
- tag_id — int — NOT NULL
likes
- lecture_id — bigint — Foreign key → lectures.lecture_id — NOT NULL
- user_id — bigint — Foreign key → members.member_id — NOT NULL
- like_status — boolean — NOT NULL
logs
- log_id — bigint — Primary key — NOT NULL
- request_url — varchar(100) — NOT NULL
- request_method — varchar(10) — NOT NULL
- response_status — int — NOT NULL
- client_ip — varchar(30) — NOT NULL
- request_time — DATETIME — NOT NULL
members
- member_id — bigint — Primary key — NOT NULL
- id — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- profile — TEXT
- email — varchar(100) — NOT NULL
- phone — varchar(100) — NOT NULL
- birth — DATETIME — NOT NULL
- name — varchar(30) — NOT NULL
- role — varchar(30) — NOT NULL
- bank — varchar(100)
- deleted — boolean — NOT NULL
members_tags
- user_id — bigint — Foreign key → members.member_id — NOT NULL
- tag_id — int — NOT NULL
pays
- pay_id — BIGINT — Primary key — NOT NULL
- member_id — bigint — Foreign key → attends.member_id — NOT NULL
- lecture_id — bigint — Foreign key → attends.lecture_id — NOT NULL
- status — boolean — NOT NULL
- pays_date — DATETIME — NOT NULL
- refund_date — DATETIME
questions
- question_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → members.member_id — NOT NULL
- lecture_id — bigint — Foreign key → lectures.lecture_id — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- deleted — boolean — NOT NULL
- board_date — DATETIME — NOT NULL
reviews
- review_id — bigint — Primary key — NOT NULL
- lecture_id — bigint — Foreign key → lectures.lecture_id — NOT NULL
- user_id — bigint — Foreign key → members.member_id — NOT NULL
- content — text — NOT NULL
- status — boolean — NOT NULL
- review_date — DATETIME — NOT NULL
- answer_id — int
students
- member_id — bigint — Foreign key → attends.member_id — NOT NULL
- lecture_list_id — bigint — Foreign key → lecture_lists.lecture_list_id — NOT NULL
- enter_time — DATETIME
- play_time — DATETIME
- out_time — DATETIME
tags
- tag_id — bigint — Primary key — NOT NULL
- tags_name — varchar(200)