projectex01 - 2021-05-28 03:33:18
Tables (7)
board (Untitled2)
- board_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key — NOT NULL
- reg_date (Field)
- title (Field2)
- board_content (Field3)
comment (CopyOfUntitled3)
- member_id (Key) — Foreign key — NOT NULL
- content (Field)
- reg_date (Field2)
member (Untitled)
- member_id (Key) — Primary key — NOT NULL
- product_id (Key2) — Foreign key — NOT NULL
- pw (Field)
- nick (Field2)
- email (Field3)
- phonenumber (Field4)
- sms_agree (Field5)
- email_agree (Field6)
- profile_img (Field7)
- member_level (Field8)
- join_date (Field9)
notice (CopyOfUntitled2)
- notice_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key — NOT NULL
- reg_date (Field)
- title (Field2)
- notice_content (Field3)
product (CopyOfUntitled)
- product_id (Key) — Primary key — NOT NULL
- member_id (FK)
- product_img1 (Field)
- product_img2 (Field2)
- product_img3 (Field3)
- address (Field4)
- product_content (Field5)
- host_email (Field6)
- host_number (Field7)
reservation (Untitled3)
- reservation_id (Key) — Primary key — NOT NULL
- product_id (Key2) — Foreign key — NOT NULL
- member_id (FK)
- product_id (FK2)
- booking_date (Field3)
review (CopyOfUntitled22)
- review_id (Key) — Primary key — NOT NULL
- product_id (Key2) — Foreign key — NOT NULL
- member_id (Key3) — Foreign key — NOT NULL
- review_star (Field2)
- reg_date (Field3)
- content (Field4)