ㅅㄷㄴㅅ

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)