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)