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