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