bbb

Tables (7)

Attachment

  • file_id — INT — Primary key
  • post_id — INT — Foreign key → Post.post_id
  • user_id — INT — Foreign key → Post.user_id
  • board_id — INT — Foreign key → Post.board_id
  • file_name — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(255) — NOT NULL

Board

  • board_id — INT — Primary key
  • board_name — VARCHAR(100) — NOT NULL
  • description — TEXT

Comment

  • comment_id — INT — Primary key
  • user_id — INT — Foreign key → User.user_id
  • post_id — INT — Foreign key → Post.post_id
  • board_id — INT — Foreign key → Post.board_id
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

Like

  • like_id — INT — Primary key
  • comment_id — INT — Foreign key → Comment.comment_id
  • user_id — INT — Foreign key → Comment.user_id
  • post_id — INT — Foreign key → Comment.post_id
  • board_id — INT — Foreign key → Comment.board_id
  • target_id — INT

Post

  • post_id — INT — Primary key
  • user_id — INT — Foreign key → User.user_id
  • board_id — INT — Foreign key → Board.board_id
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • created_at — TIMESTAMP

Recommendation

  • rec_id — INT — Primary key
  • user_id — INT — Foreign key → User.user_id
  • post_id — INT — Foreign key → Post.post_id
  • board_id — INT — Foreign key → Post.board_id
  • created_at — TIMESTAMP

User

  • user_id — INT — Primary key
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP