wer

Tables (11)

ams_tag (Untitled2)

  • tag_id (Key) — Primary key — NOT NULL

ams_tagset_category (Untitled3)

  • tagset_category_id (Key) — Primary key — NOT NULL

ums_dashboard (Untitled8)

  • dashboard_id (Key) — Primary key — NOT NULL
  • place_id (Key2) — Foreign key → ums_place.place_id — NOT NULL

ums_dashboard_relation_system_tag (Untitled9)

  • dashboard_id (Key) — Foreign key → ums_dashboard.dashboard_id — NOT NULL
  • system_tag_id (Key2) — Foreign key → ums_system_tag.system_tag_id — NOT NULL
  • value (Field)

ums_favorite_relation_system_tag (Untitled10)

  • favorite_id (Key) — uuid — Foreign key → ums_favorites.favorite_id — NOT NULL
  • system_tag_id (Key3) — Foreign key → ums_system_tag.system_tag_id — NOT NULL
  • value (Field)

ums_favorites (Untitled)

  • favorite_id (Key) — uuid — Primary key — NOT NULL
  • place_id (Key2) — Foreign key → ums_place.place_id — NOT NULL
  • favorite_name (Field) — string
  • target (Field3) — string
  • operation (Field5)
  • keyword (Field6) — List <Text>

ums_favorites_relation_tag (Untitled5)

  • favorite_id (Key) — uuid — Foreign key → ums_favorites.favorite_id — NOT NULL
  • tag_id (Key2) — Foreign key → ams_tag.tag_id — NOT NULL

ums_favorites_relation_tagset_category (Untitled4)

  • favorite_id (Key) — Foreign key → ums_favorites.favorite_id — NOT NULL
  • tagset_category_id (Key2) — Foreign key → ams_tagset_category.tagset_category_id — NOT NULL

ums_place (Untitled6)

  • place_id (Key) — Primary key — NOT NULL

ums_place_relation_system_tag (Untitled11)

  • place_id (Key) — Foreign key → ums_place.place_id — NOT NULL
  • system_tag_id (Key2) — Foreign key → ums_system_tag.system_tag_id — NOT NULL
  • value (Field) — String

ums_system_tag (Untitled7)

  • system_tag_id (Key) — integer — Primary key — NOT NULL
  • type (Field)
  • target (Field2)
  • key (Field3)
  • description (Field4)