졸작
테이블 (6)
Attraction (Untitled2)
- attractionName (Key) — 기본 키 — NOT NULL
- rating (Field)
- reviewCount (Field2)
- sorting (Field3)
- address (Field4)
- description (Field5)
- category (Field6)
cart
- cartId (Key) — 기본 키 — NOT NULL
- hotelId (Key2) — 외래 키 → hotel.hotelId — NOT NULL
- restaurantId (Key3) — 외래 키 → restaurant.restaurantId — NOT NULL
- attractionName (Key22) — 외래 키 → restaurant.attractionName — NOT NULL
- memberId (Key4) — 외래 키 → member.memberId — NOT NULL
hotel (Untitled3)
- hotelId (Key) — 기본 키 — NOT NULL
- hotelName (Field)
- rating (Field2)
- sotring (Field3)
- distance (Field4)
- cost (Field5)
- address (Field6)
- description (Field7)
- kindness (Field8)
- clean (Field9)
- convenient (Field10)
- pageUrl (Field11)
- image (Field12)
member (Untitled5)
- memberId (Key) — 기본 키 — NOT NULL
restaurant (Untitled)
- restaurantId (Key) — 기본 키 — NOT NULL
- attractionName (Key2) — 외래 키 → Attraction.attractionName — NOT NULL
- restaurantName (Field2)
- rating (Field3)
- classification (Field4)
- sorting (Field5)
- address (Field6)
- description (Field7)
- pageUrl (Field8)
- image (Field9)
review (Untitled4)
- reviewId (Key2) — 기본 키 — NOT NULL
- attractionName (Key) — 외래 키 → Attraction.attractionName — NOT NULL
- memberId (Key3) — 외래 키 → member.memberId — NOT NULL
- review_title (Field)
- review_body (Field2)