Book Report
Tables (5)
Board (Untitled2)
- board_id (Key) — NUMBER — Primary key — NOT NULL
- book_id (Field) — Number — Primary key
- user_id (Key2) — Number — Foreign key → User.user_id — NOT NULL
- picture_url (Field3) — VARCHAR(40)
- content (Field4) — VARCHAR(200)
- like (Field5) — NUMBER
Book (Untitled3)
- book_id (Key) — NUMBER — Primary key — NOT NULL
- board_id (Key2) — NUMBER — Foreign key → Board.board_id — NOT NULL
- user_id (Key22) — Number — Foreign key → Board.user_id — NOT NULL
- Title (Field) — VARCHAR(20)
- Author (Field2) — VARCHAR(30)
Comment (Untitled4)
- comment_id (Key) — NUMBER — Primary key — NOT NULL
- board_id (Forien Key) — NUMBER
- user_id (Field) — NUMBER
- comment (Field2) — VARCHAR(40)
Like (Untitled5)
- board_id (Field) — NUMBER
- user_id (Field2) — NUMBER
User (Untitled)
- user_id (Key) — Number — Primary key — NOT NULL
- id (Field) — VARCHAR(20)
- password (Field2) — VARCHAR(30)
- name (Field3) — VARCHAR(20)