spring_board

Tables (3)

board (게시글)

  • bo_id (Key) — int — Primary key — NOT NULL
  • user_bo_id (Key3) — int — Foreign key → user.user_id — NOT NULL
  • bo_title (Field) — varchar(50)
  • bo_content (Field2) — TEXT
  • bo_like (Field3) — int
  • bo_dislike (Field4) — int
  • bo_date (Field5) — TIMESTAMP

review (댓글)

  • review_id (Key) — int — Primary key — NOT NULL
  • bo_id (Key2) — int — Foreign key → board.bo_id — NOT NULL
  • user_bo_id (Key3) — int — Foreign key → board.user_bo_id — NOT NULL
  • user_id (Key4) — int — Foreign key → user.user_id — NOT NULL
  • review_content (Field) — TEXT
  • review_like (Field2) — int
  • review_dislike (Field3) — int

user (사용자)

  • user_id (Key) — int — Primary key — NOT NULL
  • user_name (Field) — varchar(30)
  • user_pw (Field2) — varchar(30)
  • user_create_at (Field3) — TIMESTAMP