KAMOMATZIP

Tables (5)

Place

  • place_id (pk) — long — Primary key — NOT NULL
  • place_name (Field) — string
  • place_location (Field2) — string
  • place_lat (Field3) — double
  • place_lng (Field4) — double
  • place_distance (Field5) — double
  • place_category (Field6) — string
  • place_phone_number (Field7) — string
  • main_image (Field8) — string
  • is_open (Field9) — bool

Place_Tag (Untitled4)

  • tag_id (pk) — long — Foreign key → Tag.tag_id — NOT NULL
  • place_id (pk2) — long — Foreign key → Place.place_id — NOT NULL

Review (Untitled2)

  • review_id (pk) — long — Primary key — NOT NULL
  • user_id (fk1) — long — Foreign key → User.user_id — NOT NULL
  • place_id (fk2) — long — Foreign key → Place.place_id — NOT NULL
  • content (Field) — string
  • people_nums (Field2) — int
  • price_per_people (Field3) — int
  • is_reservation (Field4) — bool
  • meal_time (Field5) — string
  • created (Field6) — DATETIME
  • modified (Field7) — DATETIME

Tag (Untitled3)

  • tag_id (pk) — long — Primary key — NOT NULL
  • tag_name (Field) — string

User (Untitled)

  • user_id (pk) — long — Primary key — NOT NULL
  • email (Field3) — string
  • created (Field4) — DATETIME
  • modified (Field5) — DATETIME