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