컨텐츠 결재 승인

테이블 (3)

approval_group (승인담당자 그룹)

  • 그룹 ID (id) — 기본 키 — NOT NULL
  • CP ID (cp_unit_id) — FK(cp_unit)
  • 승인 단계 (approval_step)
  • 담당자 ID (user_id) — FK(user)

uploaded_contents_group (업로드 콘텐츠(그룹승인))

  • 콘텐츠 ID (id) — 기본 키 — NOT NULL
  • 큐 ID (queue_id) — 외래 키 → uploaded_queue_group.큐 ID — NOT NULL
  • 승인 유저 (enter_approved_by) — ex) [1, 2,3] user_id 리스트로 변경
  • (suuid)
  • (cp_unit_id) — FK(cp_unit)
  • (status)
  • (base_service_site)
  • (file_base)
  • (file_ext_original)
  • (file_types)
  • (file_errors)
  • (media_count)
  • (listable_count)
  • (keywords)
  • (license_type)
  • (media_type)
  • (media_type_sub)
  • (enter_refused_memo_ko)
  • (enter_refused_memo_en)
  • (model_relese)
  • (property_release)
  • (model_codes)
  • Field (property_codes)
  • (meta_file_keywords_ko)
  • (meta_file_keywords_en)
  • (caption_ko)
  • (caption_en)
  • (shoot_date)
  • (photographer)
  • (location)
  • (video_template_version)
  • (credit)
  • (preview_size)
  • (preview_width)
  • (preview_height)
  • (thumb_size)
  • (thumb_width)
  • (thumb_height)
  • (registered_at)
  • (registered_by)
  • (revision_at)
  • (revision_by)
  • (children_web_files_dict)

uploaded_queue_group (업로드 큐(그룹승인))

  • 큐 ID (id) — 기본 키 — NOT NULL
  • (is_ftp)
  • (suuid)
  • (cp_unit_id) — FK(cp_unit)
  • Field