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