CafeMap

Tables (4)

Account (1)

  • id (Key) — Primary key — NOT NULL
  • username (Field)
  • name (Field2)
  • password (Field3)
  • email (Field4)
  • authority (Field5)

Cafe (2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • roadAddress (Field2)
  • jibunAddress (Field3)
  • englishAddress (Field4)
  • postalCode (Field5)
  • sangseAddress (Field6)

Menu (4)

  • id (Key) — Primary key — NOT NULL
  • category (Field)
  • name (Field2)
  • cost (Field3)
  • cafeId (Field4)

Review (3)

  • id (Key) — Primary key — NOT NULL
  • accountId (Field)
  • cafeId (Field2)
  • starRating (Field3)
  • content (Field4)