Study

Tables (6)

Application (Registration)

  • Registration_id — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • status — varchar(9) — NOT NULL
  • email — varchar(20) — Foreign key → user.email — NOT NULL
  • study_id — INT — Foreign key → study.study_id — NOT NULL

attendance (Untitled)

  • Key — Primary key — NOT NULL
  • study_id — INT — Foreign key → study.study_id — NOT NULL
  • email — varchar(20) — Foreign key → user.email — NOT NULL
  • date — date

board

  • board_id — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • study_id — INT — Foreign key → study.study_id — NOT NULL
  • title — varchar(50) — NOT NULL
  • content — varchar(5000) — NOT NULL

comment

  • comment_id — INT — Primary key — NOT NULL — AUTO_INCREMENT
  • email — varchar(20) — Foreign key → user.email — NOT NULL
  • board_id — INT — Foreign key → board.board_id — NOT NULL
  • content — varchar(500)

study

  • study_id — INT — Primary key — NOT NULL
  • title — varchar(50) — NOT NULL
  • description — varchar(1000)
  • status — varchar(8) — NOT NULL
  • email (creater_email) — varchar(20) — Foreign key → user.email — NOT NULL

user

  • email — varchar(20) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • role — varchar(8) — NOT NULL
  • password — varchar(20) — NOT NULL