Tripick
Tables (9)
location (Untitled8)
- Key — Primary key — NOT NULL
- title (Field) — varchar
place (Untitled)
- id (Key) — int8 — Primary key — NOT NULL
- location_key (Key2) — int8 — Foreign key → location.Key — NOT NULL
- title (Field) — varchar
- content (Field2) — text
- location (Field3) — float
- image (Field4) — text
place_planner (Untitled6)
- id (Key) — Primary key — NOT NULL
- planner_id (Key2) — int8 — Foreign key → planner.id — NOT NULL
- user_Id (Key22) — int8 — Foreign key → planner.user_Id — NOT NULL
- place_id (Key3) — int8 — Foreign key → place.id — NOT NULL
- Key (Key23) — Foreign key → place.location_key — NOT NULL
place_tag (Untitled4)
- Key — int8 — Primary key — NOT NULL
- place_id (Key2) — int8 — Foreign key → place.id — NOT NULL
- tag_id (Key3) — int8 — Foreign key → tag.id — NOT NULL
- Key (Key22) — Foreign key → place.location_key — NOT NULL
planner (Untitled5)
- id (Key) — int8 — Primary key — NOT NULL
- user_Id (Key2) — int8 — Foreign key → user.Id — NOT NULL
- title (Field) — varchar
- content (Field2) — text
- start_date (Field3) — date
- end_date (Field4) — date
- budget (Field5) — int8
- people (Field6) — int8
review (Untitled3)
- id (Key) — int8 — Primary key — NOT NULL
- place_id (Key2) — int8 — Foreign key → place.id — NOT NULL
- user_Id (Key3) — int8 — Foreign key → user.Id — NOT NULL
- location_key (Key22) — int8 — Foreign key → place.location_key — NOT NULL
- content (Field2) — text
- rating (Field3) — float
tag (Untitled2)
- id (Key) — int8 — Primary key — NOT NULL
- category (Field) — text
user (Untitled7)
- Id (Key) — int8 — Primary key — NOT NULL
- email (Field) — text
- display_name (Field2) — varchar
- createAt (Field3) — data
- avata_url (Field5) — text
- provider (Field6) — varchar
- provider_type (Field7) — varchar
user_place (favorite)
- id (Key3) — Primary key — NOT NULL
- user_id (Key) — int8 — Foreign key → user.Id — NOT NULL
- place_id (Key2) — int8 — Foreign key → place.id — NOT NULL
- location_key (Key22) — int8 — Foreign key → place.location_key — NOT NULL