스키마 final
테이블 (11)
article
- id — int — 기본 키 — NOT NULL
- board_id — tinyint — 외래 키 → board.id — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- author_id — int — 외래 키 → user.id — NOT NULL
- views — int — NOT NULL
- is_private — boolean — NOT NULL
- is_pinned — boolean — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
article_file
- id — int — 기본 키 — NOT NULL
- article_id — int — 외래 키 → user.id — NOT NULL
- user_id — int — 외래 키 → user.id — NOT NULL
- name — varchar(255) — NOT NULL
- size — int — NOT NULL
- mime_type — varchar(255) — NOT NULL
board
- id — tinyint — 기본 키 — NOT NULL
- name — varchar(30) — NOT NULL
- text_kor — varchar(30) — NOT NULL
- text_eng — varchar(30) — NOT NULL
- is_comment — boolean — NOT NULL
- is_file — boolean — NOT NULL
comment
- id — int — 기본 키 — NOT NULL
- article_id — int — 외래 키 → article.id — NOT NULL
- author_id — int — 외래 키 → user.id — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
login_log
- id — int — 기본 키 — NOT NULL
- user_id — int — 외래 키 → user.id — NOT NULL
- password — varchar(255) — NOT NULL
- ip — varchar(50) — NOT NULL
- is_success — boolean — NOT NULL
- created_at — datetime — NOT NULL
permission
- id — int — 기본 키 — NOT NULL
- student_id — int — 외래 키 → student.user_id — NOT NULL
- professor_id — int — 외래 키 → user.id — NOT NULL
- stage — tinyint — NOT NULL
- result — tinyint — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
phase
- id — tinyint — 기본 키 — NOT NULL
- name — varchar(30) — NOT NULL
- begin — datetime — NOT NULL
- end — datetime — NOT NULL
student
- user_id — int — 외래 키 → user.id — NOT NULL
- phase_id — tinyint — 외래 키 → phase.id — NOT NULL
- locked — boolean — NOT NULL
- professor_id — int — 외래 키 → user.id
user
- id — int — 기본 키 — NOT NULL
- type — tinyint — NOT NULL
- user_name — varchar(10) — NOT NULL
work
- student_id — int — 외래 키 → student.user_id — NOT NULL
- is_paper — boolean — NOT NULL
- is_personal — boolean — NOT NULL
- title — varchar(255) — NOT NULL
- is_excellent — boolean — NOT NULL
- commentary — text — NOT NULL
- note — text — NOT NULL
work_file
- id — int — 기본 키 — NOT NULL
- student_id — int — 외래 키 → student.user_id — NOT NULL
- name — varchar(255) — NOT NULL
- size — int — NOT NULL
- mime_type — varchar(255) — NOT NULL
- submit_type — tinyint — NOT NULL