tabara

Tables (8)

FoundObject (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • picture_id (Key2) — Foreign key → StreetPicture.id — NOT NULL
  • object_id (Key3) — Foreign key → book.id — NOT NULL

StreetPicture (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • image_url (Field)
  • destination (Key2) — Foreign key → destination.id — NOT NULL

book (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • object_name (Field)
  • found (Field2)
  • description (Field3)

destination (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • uuid (Key2) — Foreign key → user.uuid — NOT NULL
  • map_id (Key3) — Foreign key → position.id — NOT NULL
  • start_date (Field)
  • finish_date (Field2)

notice (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • create_date (Field3)
  • uuid (Key2) — Foreign key → user.uuid — NOT NULL

park (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)

position (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • longtitude (Field)
  • latitude (Field2)
  • name (Field3)
  • create_date (Field4)
  • park_id (Key2) — Foreign key → park.id — NOT NULL

user (Untitled)

  • uuid (Key) — Primary key — NOT NULL
  • username (Field)
  • password (Field2)
  • email (Field3)