컨텐츠 결재 승인
테이블 (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