asd
Tables (17)
answers
- answer_id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → questions.question_id — NOT NULL
- member_id — BIGINT — NOT NULL
- lecture_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- reply_date — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
attends
- attend_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.member_id — NOT NULL
- lecture_id — BIGINT — NOT NULL
- is_refundable — BOOLEAN — NOT NULL
board_images
- board_image_id — BIGINT — Primary key — NOT NULL
- question_id — INT — NOT NULL
- member_id — BIGINT — 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
- member_id — BIGINT — NOT NULL
lecture_files
- member_id — BIGINT — Primary key — NOT NULL
- lecture_id — BIGINT — Foreign key → lectures.lecture_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 — 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
- deleted — BOOLEAN — NOT NULL
lectures_tags
- tag_id — INT — Primary key — NOT NULL
- lecture_id — BIGINT — Foreign key → lectures.lecture_id — NOT NULL
likes
- member_id — BIGINT — Primary key — NOT NULL
- lecture_id — BIGINT — Foreign key → lectures.lecture_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
- tag_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.member_id — NOT NULL
pays
- pay_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.member_id — NOT NULL
- lecture_id — BIGINT — NOT NULL
- status — BOOLEAN — NOT NULL
- pays_date — DATETIME — NOT NULL
- refund_date — DATETIME
questions
- question_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.member_id — NOT NULL
- lecture_id — BIGINT — 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
- member_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- status — BOOLEAN — NOT NULL
- review_date — DATETIME — NOT NULL
- answer_id — INT
- deleted — BOOLEAN — NOT NULL
students
- lecture_list_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → members.member_id — NOT NULL
- enter_time — DATETIME
- play_time — DATETIME
- out_time — DATETIME
tags
- tag_id — BIGINT — Primary key — NOT NULL
- tags_name — VARCHAR(200)