PinterestClone
Tables (5)
Board (Untitled2)
- Board ID (board_id) — int(11) — Primary key — NOT NULL
- Name (board_name) — varchar(30)
- Like (like_count) — int(11)
- Create Date (create_date) — timestamp
- Delete Date (delete_date) — timestamp
- Modify Date (modified_date) — timestamp
- Delete Status (delete_status) — int(11)
- Id (id2) — varchar(20) — Foreign key → User-Board.Id — NOT NULL
Board-Pin (Untitled4)
- Board ID (board_id) — int(11) — Foreign key → Board.Board ID — NOT NULL
- Pin ID (pin_id) — int(11) — Foreign key → Pin.Pin ID — NOT NULL
Pin (Untitled3)
- Pin ID (pin_id) — int(11) — Primary key — NOT NULL
- Pin Name (pin_name) — varchar(30)
- Description (description) — varchar(100)
- Image Address (image_address) — varchar(100)
- Source Address (source_address) — varchar(100)
- Like (like_count) — int(11)
- Create Date (create_date) — timestamp
- Delete Date (delete_date) — timestamp
- Modify Date (modifed_date) — timestamp
- Delete Status (delete_status) — int(11)
User (Untitled)
- Id (id) — varchar(20) — Primary key — NOT NULL
- Password (password) — varchar(30)
- Last Name (last_name) — varchar(30)
- First Name (first_name) — varchar(30)
- User Id (user_id) — varchar(30)
- Birthday (birthday) — varchar(10)
- Create Date (create_date) — timestamp
- Delete Date (delete_date) — timestamp
- Modify Date (modified_date) — timestamp
- Delete Status (delete_status) — int(11)
User-Board (Untitled5)
- Id (id) — varchar(20) — Foreign key → User.Id — NOT NULL