test

Tables (4)

boards

  • board_id — INTEGER
  • name — TEXT — NOT NULL
  • description — TEXT
  • created_at — DATETIME

comments

  • comment_id — INTEGER
  • post_id — INTEGER — Foreign key → posts.post_id — NOT NULL
  • author_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • parent_id — INTEGER — Foreign key → comments.comment_id
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • deleted_at — DATETIME

posts

  • post_id — INTEGER
  • board_id — INTEGER — Foreign key → boards.board_id — NOT NULL
  • author_id — INTEGER — Foreign key → users.user_id — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INTEGER
  • is_notice — INTEGER
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

users

  • user_id — INTEGER
  • username — TEXT — NOT NULL
  • email — TEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • role — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME