d

Tables (15)

ams_tag (Untitled8)

  • tag_id (Key) — Primary key — NOT NULL

ams_tagset_category (Untitled7)

  • tagset_category_key (Key) — Primary key — NOT NULL

ums_favorites (Untitled3)

  • favorite_id (Key) — Primary key — NOT NULL
  • place_id (Key3) — Foreign key → ums_place.place_id — NOT NULL

ums_file (Untitled13)

  • file_id (Key) — Primary key — NOT NULL
  • organizaion_id (Key2) — Foreign key → ums_organization.organizaion_id — NOT NULL
  • file_size (Field)
  • resolution (Field2)
  • format (Field4) — mimetype
  • thumbnail_id (Field5)
  • created_time (Field3)
  • file_type (Field6) — LOGO
  • file_name (Field7)

ums_organization (Untitled12)

  • organizaion_id (Key) — Primary key — NOT NULL
  • organizaion_meta_id (Key2) — Foreign key → ums_organization_meta.organizaion_meta_id — NOT NULL

ums_organization_meta (Untitled14)

  • organizaion_meta_id (Key) — Primary key — NOT NULL
  • organizaion_title_type (Field) — NAME, LOGO_IMAGE

ums_place (Untitled)

  • place_id (Key) — Primary key — NOT NULL
  • organizaion_id (Key2) — Foreign key → ums_organization.organizaion_id — NOT NULL

ums_place_dashboard_configuration (Untitled15)

  • dashboard_id (Key) — Primary key — NOT NULL
  • place_id (Key2) — Foreign key → ums_place.place_id — NOT NULL
  • use_storage (Field) — Boolean
  • use_quick_glance (Field2) — Boolean
  • user_energy_consumption (Field3) — Boolean
  • updated_time (Field4)

ums_place_data_statistics (Untitled16)

  • statistics_id (Key2) — Primary key — NOT NULL
  • place_id (Key) — Foreign key → ums_place.place_id — NOT NULL
  • video_storage (Field)
  • image_storage (Field2)
  • canvas_storage (Field3)
  • office_storage (Field4)
  • web_html_storage (Field5)
  • content_total_storage (Field6)

ums_place_quick_glance (Untitled2)

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

ums_quick_glance_relation_favorites (Untitled4)

  • quick_glance_id (Key) — Foreign key → ums_place_quick_glance.quick_glance_id — NOT NULL
  • favorite_id (Key3) — Foreign key → ums_favorites.favorite_id — NOT NULL

ums_quick_glance_relation_system_tag (CopyOfUntitled11)

  • quick_glance_id (Key) — Foreign key → ums_place_quick_glance.quick_glance_id — NOT NULL
  • system_tag_id (Key2) — Foreign key → ums_system_tag.system_tag_id — NOT NULL

ums_quick_glance_relation_tag (Untitled11)

  • quick_glance_id (Key) — Foreign key → ums_place_quick_glance.quick_glance_id — NOT NULL
  • tag_id (Key3) — Foreign key → ams_tag.tag_id — NOT NULL

ums_quick_glance_relation_tagset_category (Untitled9)

  • quick_glance_id (Key) — Foreign key → ums_place_quick_glance.quick_glance_id — NOT NULL
  • tagset_category_key (Key2) — Foreign key → ams_tagset_category.tagset_category_key — NOT NULL

ums_system_tag (Untitled10)

  • system_tag_id (Key) — Primary key — NOT NULL