스키마 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