ㅁㅁ

Tables (4)

Boards

  • board_id — INT
  • writer_id — VARCHAR(100) — Foreign key → Members.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_date — DATETIME — NOT NULL
  • updated_date — DATETIME
  • deleted_date — DATETIME

Files

  • file_id — INT
  • board_id — INT — Foreign key → Boards.board_id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • path — VARCHAR(255) — NOT NULL

Members

  • id — VARCHAR(100)
  • password_hash — VARCHAR(255) — NOT NULL

Replies

  • reply_id — INT
  • board_id — INT — Foreign key → Boards.board_id — NOT NULL
  • writer_id — VARCHAR(100) — Foreign key → Members.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_date — DATETIME — NOT NULL
  • updated_date — DATETIME
  • deleted_date — DATETIME