board

Tables (6)

ADMINS

  • admin_id — BIGINT — Primary key — NOT NULL
  • admin_login_id — VARCHAR(255) — NOT NULL
  • admin_login_password — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

BOARDS

  • board_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBERS.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • is_deleted — BOOLEAN — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • views — BIGINT — NOT NULL

COMMENTS

  • comment_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → BOARDS.board_id — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBERS.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • is_deleted — BOOLEAN — NOT NULL
  • content — TEXT — NOT NULL

IMAGES

  • image_id — BIGINT — Primary key — NOT NULL
  • board_id — BIGINT — Foreign key → BOARDS.board_id — NOT NULL
  • origin_name — VARCHAR(255) — NOT NULL
  • stored_name — VARCHAR(255) — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • storage_path — VARCHAR(500) — NOT NULL
  • extension — VARCHAR(20) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • sort_order — INT — NOT NULL
  • is_thumbnail — BOOLEAN — NOT NULL

LOGS

  • log_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → MEMBERS.member_id
  • access_time — TIMESTAMP — NOT NULL
  • access_ip — VARCHAR(45) — NOT NULL
  • login_success — BOOLEAN — NOT NULL
  • fail_reason — VARCHAR(255)

MEMBERS

  • member_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • is_deleted — BOOLEAN — NOT NULL
  • login_id — VARCHAR(255) — NOT NULL
  • login_password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • is_banned — BOOLEAN — NOT NULL