hello-krafton

테이블 (3)

게시판 (posts)

  • ID (id) — BIGINT — 기본 키 — NOT NULL
  • Category (category) — VARCHAR(20) — NOT NULL — notice/general
  • Title (title) — VARCHAR(200) — NOT NULL
  • Content (content) — TEXT — NOT NULL
  • Author Id (author_id) — BIGINT — 외래 키 → 사용자.ID — NOT NULL
  • View Count (view_count) — INT — NOT NULL
  • Created at (created_at) — TIMESTAMP — NOT NULL — DEFAULT
  • Updated at (updated_at) — TIMESTAMP — NOT NULL — ON UPDATE
  • Deleted at (deleted_at) — TIMESTAMP

사용자 (users)

  • ID (id) — BIGINT — 기본 키 — NOT NULL
  • Email (email) — VARCHAR(200) — NOT NULL
  • Password (password) — VARCHAR(255) — NOT NULL
  • Name (name) — VARCHAR(100) — NOT NULL
  • Department (department) — VARCHAR(100)
  • Created At (created_at) — TIMESTAMP — NOT NULL — DEFAULT
  • Updated At (updated_at) — TIMESTAMP — ON UPDATE
  • Deleted At (deleted_at) — TIMESTAMP

첨부파일 (files)

  • ID (id) — BIGINT — 기본 키 — NOT NULL
  • Post Id (post_id) — BIGINT — 외래 키 → 게시판.ID — NOT NULL
  • Name (name) — VARCHAR(255) — NOT NULL — notice/general
  • Path (path) — VARCHAR(500) — NOT NULL
  • Size (size) — BIGINT — NOT NULL
  • Type (type) — VARCHAR(100) — NOT NULL
  • Created at (created_at) — TIMESTAMP — NOT NULL — DEFAULT
  • Updated at (updated_at) — TIMESTAMP — NOT NULL — ON UPDATE
  • Deleted at (deleted_at) — TIMESTAMP