board

Tables (6)

Attachments (attachments)

  • file_id — INT — Primary key — NOT NULL
  • original_name — VARCHAR(255)
  • save_name — VARCHAR(255)
  • file_path — VARCHAR(255)
  • file_size — BIGINT
  • post_id — INT — Foreign key → Posts.post_id — NOT NULL

Categories (categories)

  • category_id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • slug — VARCHAR(255)

Comments (comments)

  • comment_id — INT — Primary key — NOT NULL
  • content — VARCHAR(255)
  • created_at — DATETIME
  • post_id — INT — Foreign key → Posts.post_id — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • parent_id — INT — Foreign key → Comments.comment_id

Likes (likes)

  • like_id — INT — Primary key — NOT NULL
  • created_at — DATETIME
  • post_id — INT — Foreign key → Posts.post_id — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL

Posts (posts)

  • post_id — INT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — LONGTEXT
  • view_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • category_id — INT — Foreign key → Categories.category_id — NOT NULL

Users (users)

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(255)
  • nickname — VARCHAR(100)
  • phone_number — VARCHAR(20)
  • role — VARCHAR(20)
  • created_at — DATETIME