vddemosolution
Tables (12)
Untitled (user_history)
- Key (id) — Primary key — NOT NULL
- Field (login_id) — NOT NULL
- Field2 (password) — NOT NULL
- Field3 (name) — NOT NULL
- Field (infomation)
- Field (is_active) — NOT NULL
- Field2 (created_at) — NOT NULL
- Field3 (updated_at) — NOT NULL
- Field4 (deleted_at)
- Key (group_id) — Foreign key → Untitled2.Key — NOT NULL
- Key (subsidiary_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (subsidiary_list)
- Key (id) — Primary key — NOT NULL
- Field (code) — NOT NULL
- Field (infomation) — NOT NULL
- Field2 (created_at) — NOT NULL
- Field3 (updated_at) — NOT NULL
- Field4 (deleted_at)
- Key (group_id) — Foreign key → Untitled2.Key — NOT NULL
- Key (region_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (tv_history)
- Key (id) — Primary key — NOT NULL
- Field (duid) — NOT NULL
- Field (language) — NOT NULL
- Field (status) — NOT NULL
- Field2 (device_model) — NOT NULL
- Field3 (retailer) — NOT NULL
- Field4 (store_name) — NOT NULL
- Field (tv_name) — NOT NULL
- Field2 (pdp) — NOT NULL
- Field3 (scenario) — NOT NULL
- Field4 (loop_type)
- Field (img_duration_time)
- Field (play_type)
- Field (period_start_date)
- Field (period_end_date)
- Field (created_at) — NOT NULL
- Field (updated_at) — NOT NULL
- Field (deleted_at)
- Key (subsidiary_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (region_list)
- Key (id) — Primary key — NOT NULL
- Field (code) — NOT NULL
- Field2 (name) — NOT NULL
Untitled (file_history)
- Key (id) — Primary key — NOT NULL
- Field (s3_object_key) — NOT NULL
- Field2 (url) — NOT NULL
- Field3 (original_name) — NOT NULL
- Field (created_at) — NOT NULL
- Field3 (updated_at) — NOT NULL
- Field (deleted_at)
Untitled (project_list)
- Key (id) — Primary key — NOT NULL
- Field (name) — NOT NULL
- Field2 (created_at) — NOT NULL
- Field3 (updated_at) — NOT NULL
- Field (deleted_at)
Untitled (language_list)
- Key (id) — Primary key — NOT NULL
- Field (name) — NOT NULL
- Key (file_id) — Foreign key → Untitled.Key — NOT NULL
- Key (subsidiary_id) — Foreign key → Untitled.Key — NOT NULL
- Key (project_id) — Foreign key → Untitled.Key — NOT NULL
Untitled (project_group_list)
- Key (project_id) — Foreign key → Untitled.Key — NOT NULL
- Key (group_id) — Foreign key → Untitled2.Key — NOT NULL
Untitled2 (group_list)
- Key (id) — Primary key — NOT NULL
- Field (name) — NOT NULL
Untitled2 (tv_img_history)
- Key (id) — Primary key — NOT NULL
- Field (order) — NOT NULL
- Key (file_id) — Foreign key → Untitled.Key — NOT NULL
- Key (tv_id) — Foreign key → Untitled.Key — NOT NULL
Untitled3 (permission_info)
- Key (user_id) — Foreign key → Untitled.Key — NOT NULL
- Field (create_user) — NOT NULL
- Field3 (create_subsidiary) — NOT NULL
- Field4 (developer_mode) — NOT NULL
- Field (modify_localization) — NOT NULL
- Field2 (view_tv_list) — NOT NULL
Untitled3 (tv_video_history)
- Key (id) — Primary key — NOT NULL
- Field (order) — NOT NULL
- Key (file_id) — Foreign key → Untitled.Key — NOT NULL
- Key (tv_id) — Foreign key → Untitled.Key — NOT NULL