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