졸작

테이블 (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)