한빛마트

테이블 (4)

DeletedPosts

  • deleted_post_id — INT
  • post_id — INT — NOT NULL
  • deleted_by_user_id — INT — NOT NULL
  • deleted_at — DATETIME
  • reason — TEXT — NOT NULL
  • is_notified — TINYINT(1) — NOT NULL

Notifications

  • notification_id — INT
  • user_id — INT — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • related_id — INT
  • is_read — TINYINT(1) — NOT NULL
  • created_at — DATETIME

Posts

  • post_id — INT
  • user_id — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • view_count — INT
  • is_deleted — TINYINT(1) — NOT NULL
  • deleted_type — VARCHAR(10)

Users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • role — VARCHAR(20) — NOT NULL