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