artwork

Tables (31)

artist_spotlight

  • id — BIGINT — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • quote — VARCHAR(80) — NOT NULL
  • starts_at — TIMESTAMPTZ — NOT NULL
  • ends_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

artwork

  • id — BIGINT — Primary key — NOT NULL — 작품 ID
  • artist_id — BIGINT — NOT NULL — 작가 회원 ID - 회원 서비스 값, FK 없음
  • title — VARCHAR(200) — 제목
  • description — TEXT — 설명
  • width_mm — INTEGER — 가로 mm, 0보다 큼
  • height_mm — INTEGER — 세로 mm, 0보다 큼
  • depth_mm — INTEGER — 깊이 mm, 평면 작품은 NULL
  • production_year — SMALLINT — 제작연도
  • demo_seed — BOOLEAN — NOT NULL — 시연용 시드 작품 여부
  • status — VARCHAR(20) — NOT NULL — DRAFT, PROCESSING, INSPECTING, REVIEW_PENDING, PUBLISHED, REJECTED, HIDDEN
  • content_revision — BIGINT — NOT NULL — 작품 버전. 제출마다 1 증가, 제출 전 0
  • media_ready_revision — BIGINT — 미디어 준비 충족 버전 - INSPECTING부터 현재 버전과 같아야 함
  • inspection_done_revision — BIGINT — 필수 검사 완료 충족 버전 - REVIEW_PENDING부터
  • review_approved_revision — BIGINT — 검수 승인 충족 버전 - PUBLISHED는 현재 버전과 같아야 함
  • published_at — TIMESTAMPTZ — 처음 공개된 시각 UTC, PUBLISHED면 필수
  • version — BIGINT — NOT NULL — 낙관적 잠금 버전, 이벤트 aggregateVersion
  • created_at — TIMESTAMPTZ — NOT NULL — 생성 시각 UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정 시각 UTC
  • material_category — VARCHAR(30)
  • condition_note — VARCHAR(500)
  • main_image_from_front — BOOLEAN — NOT NULL
  • hidden_reason — VARCHAR(30)
  • hidden_at — TIMESTAMPTZ
  • hidden_by — BIGINT
  • certificate_consent_at — TIMESTAMPTZ
  • certificate_consent_version — VARCHAR(50)
  • discarded_at — TIMESTAMPTZ

artwork_bookmark

  • member_id — BIGINT — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • bookmarked_at — TIMESTAMPTZ — NOT NULL

artwork_comment

  • id — BIGINT — Primary key — NOT NULL — 댓글 ID
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL — 작품 ID
  • parent_id — BIGINT — Foreign key → artwork_comment.id — 부모 최상위 댓글 ID, 최상위면 NULL. 답글 1단계
  • author_id — BIGINT — NOT NULL — 작성자 회원 ID, FK 없음, 닉네임 미저장
  • body — VARCHAR(500) — 본문 1~500자. DELETED일 때만 NULL
  • body_hash — VARCHAR(64) — 공백 정리 본문 SHA-256, 반복 감시용
  • status — VARCHAR(20) — NOT NULL — VISIBLE, DELETED 작성자 삭제, HIDDEN 운영자 숨김
  • open_report_count — INTEGER — NOT NULL — 처리 전 신고 수, 검토 큐 정렬용
  • hidden_by — BIGINT — 숨긴 운영자 회원 ID, HIDDEN이면 필수
  • hidden_reason_code — VARCHAR(30) — SPAM, ABUSE, INAPPROPRIATE, OTHER. HIDDEN이면 필수
  • edited_at — TIMESTAMPTZ — 마지막 수정 시각
  • deleted_at — TIMESTAMPTZ — 작성자 삭제 시각
  • hidden_at — TIMESTAMPTZ — 운영자 숨김 시각
  • version — BIGINT — NOT NULL — 낙관적 잠금 버전
  • created_at — TIMESTAMPTZ — NOT NULL — 생성 시각 UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정 시각 UTC

artwork_comment_report

  • reporter_id — BIGINT — Primary key — NOT NULL — 신고 회원 ID, FK 없음
  • comment_id — BIGINT — Foreign key → artwork_comment.id — NOT NULL — 댓글 ID
  • reporter_is_artist — BOOLEAN — NOT NULL — 신고 시점에 작품 작가였는지, 큐 우선순위
  • reason_code — VARCHAR(30) — NOT NULL — SPAM, ABUSE, INAPPROPRIATE, OTHER
  • created_at — TIMESTAMPTZ — NOT NULL — 신고 시각 UTC
  • resolved_at — TIMESTAMPTZ — 운영자 처리 시각, NULL이면 처리 전
  • resolution — VARCHAR(20) — KEPT, HIDDEN

artwork_daily_stat

  • stat_date — DATE — Primary key — NOT NULL
  • source — VARCHAR(20) — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • play_count — BIGINT — NOT NULL
  • completed_count — BIGINT — NOT NULL
  • detail_visit_count — BIGINT — NOT NULL

artwork_engagement

  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL — 작품 ID - 작품당 1행
  • like_count — BIGINT — NOT NULL — 좋아요 수, 0 이상
  • comment_count — BIGINT — NOT NULL — 보이는 댓글 수 - 최상위와 답글
  • view_count — BIGINT — NOT NULL — 누적 조회수, Redis 증분을 30초마다 더함
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정 시각 UTC

artwork_inspection

  • id — BIGINT — Primary key — NOT NULL — 검사 ID
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL — 작품 ID - 작품·버전·종류 unique
  • content_revision — BIGINT — NOT NULL — 검사 대상 작품 버전
  • inspection_type — VARCHAR(30) — NOT NULL — IMAGE_SIMILARITY, VIDEO_MATCH, TAGGING
  • status — VARCHAR(20) — NOT NULL — REQUESTED, COMPLETED, FAILED, SUPERSEDED
  • outcome — VARCHAR(20) — CLEAR, SUSPECTED - 완료된 유사도·영상 일치만
  • result — JSONB — AI 근거 원문
  • attempts — INTEGER — NOT NULL — 요청 횟수
  • last_error_code — VARCHAR(100) — 마지막 실패 코드
  • requested_at — TIMESTAMPTZ — NOT NULL — 마지막 요청 시각
  • completed_at — TIMESTAMPTZ — 종료 시각
  • version — BIGINT — NOT NULL — 낙관적 잠금 버전
  • created_at — TIMESTAMPTZ — NOT NULL — 생성 시각 UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정 시각 UTC

artwork_like

  • member_id — BIGINT — Primary key — NOT NULL — 회원 ID, FK 없음
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL — 작품 ID
  • liked — BOOLEAN — NOT NULL — 현재 상태. 취소해도 행을 지우지 않음
  • like_version — BIGINT — NOT NULL — 상태 변경마다 1 증가, 이벤트 aggregateVersion
  • liked_at — TIMESTAMPTZ — 마지막으로 켠 시각, liked면 필수
  • created_at — TIMESTAMPTZ — NOT NULL — 생성 시각 UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정 시각 UTC

artwork_moderation_action

  • id — BIGINT — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • action — VARCHAR(20) — NOT NULL
  • operator_id — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

artwork_resale_decision

  • id — BIGINT — Primary key — NOT NULL
  • resale_review_id — BIGINT — Foreign key → artwork_resale_review.id — NOT NULL
  • photo_revision — INTEGER — NOT NULL
  • decision — VARCHAR(20) — NOT NULL
  • reason_code — VARCHAR(30)
  • reason — VARCHAR(500)
  • reviewer_id — BIGINT — NOT NULL
  • decided_at — TIMESTAMPTZ — NOT NULL

artwork_resale_photo

  • id — BIGINT — Primary key — NOT NULL
  • resale_review_id — BIGINT — Foreign key → artwork_resale_review.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • object_key — VARCHAR(1024) — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • size_bytes — BIGINT — NOT NULL
  • rejected_reason — VARCHAR(50)
  • upload_expires_at — TIMESTAMPTZ — NOT NULL
  • uploaded_at — TIMESTAMPTZ
  • preview_object_key — VARCHAR(1024)
  • thumbnail_object_key — VARCHAR(1024)
  • preview_width_px — INTEGER
  • preview_height_px — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

artwork_resale_review

  • id — BIGINT — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • auction_id — BIGINT — NOT NULL
  • requester_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • photo_revision — INTEGER — NOT NULL
  • reason_code — VARCHAR(30)
  • reason — VARCHAR(500)
  • submitted_at — TIMESTAMPTZ
  • decided_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • version — BIGINT — NOT NULL

artwork_review

  • id — BIGINT — Primary key — NOT NULL — 검수 ID
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL — 작품 ID - 작품·버전 unique
  • content_revision — BIGINT — NOT NULL — 결정 대상 작품 버전
  • decision — VARCHAR(20) — NOT NULL — APPROVED, REJECTED
  • reason — VARCHAR(1000) — 사유, 반려면 필수
  • reviewer_id — BIGINT — NOT NULL — 운영자 회원 ID, FK 없음
  • decided_at — TIMESTAMPTZ — NOT NULL — 결정 시각 UTC
  • reason_code — VARCHAR(30)

artwork_share_visit

  • id — BIGINT — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • visitor_key — UUID — NOT NULL
  • member_id — BIGINT
  • visited_at — TIMESTAMPTZ — NOT NULL

artwork_tag

  • tag_code — VARCHAR(40) — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • axis — VARCHAR(20) — NOT NULL
  • position — SMALLINT — NOT NULL
  • content_revision — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

artwork_tagging

  • id — BIGINT — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • content_revision — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • attempts — INTEGER — NOT NULL
  • next_attempt_at — TIMESTAMPTZ — NOT NULL
  • last_error_code — VARCHAR(50)
  • model — VARCHAR(100)
  • requested_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

artwork_view_hourly

  • bucket_start — TIMESTAMPTZ — Primary key — NOT NULL — UTC 정시
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL — 작품 ID
  • view_count — BIGINT — NOT NULL — 해당 시간 조회수

artwork_view_pending

  • id — BIGINT — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • counted — BOOLEAN — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • completed — BOOLEAN — NOT NULL
  • occurred_at — TIMESTAMPTZ — NOT NULL

artwork_view_receipt

  • playback_id — UUID — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL
  • member_id — BIGINT
  • visitor_key — UUID
  • counted — BOOLEAN — NOT NULL
  • window_start — TIMESTAMPTZ — NOT NULL
  • received_at — TIMESTAMPTZ — NOT NULL

artwork_visit_receipt

  • visitor_key — UUID — Primary key — NOT NULL
  • source — VARCHAR(20) — Primary key — NOT NULL
  • window_start — TIMESTAMPTZ — Primary key — NOT NULL
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL

comment_moderation_action

  • id — BIGINT — Primary key — NOT NULL
  • comment_id — BIGINT — Foreign key → artwork_comment.id — NOT NULL
  • action — VARCHAR(20) — NOT NULL
  • reason_code — VARCHAR(30)
  • spam_alert_id — BIGINT — Foreign key → comment_spam_alert.id
  • closed_report_count — INTEGER — NOT NULL
  • operator_id — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

comment_spam_alert

  • id — BIGINT — Primary key — NOT NULL — 감시 기록 ID
  • member_id — BIGINT — NOT NULL — 감지된 회원 ID, FK 없음, 회원·규칙당 OPEN 1건
  • rule_code — VARCHAR(30) — NOT NULL — RAPID_POSTING 1분 5개, REPEATED_BODY 같은 본문 10분 3번
  • status — VARCHAR(20) — NOT NULL — OPEN, ACTIONED, DISMISSED
  • hit_count — INTEGER — NOT NULL — 열린 동안 감지 횟수
  • first_detected_at — TIMESTAMPTZ — NOT NULL — 처음 감지 시각 UTC
  • last_detected_at — TIMESTAMPTZ — NOT NULL — 마지막 감지 시각 UTC
  • resolved_by — BIGINT — 처리 운영자 회원 ID
  • resolved_at — TIMESTAMPTZ — 처리 시각

media_asset

  • id — BIGINT — Primary key — NOT NULL — 원본 ID
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL — 작품 ID
  • role — VARCHAR(20) — NOT NULL — FRONT_IMAGE, SIGNATURE_IMAGE, BACK_IMAGE, PROCESS_VIDEO
  • status — VARCHAR(20) — NOT NULL — PENDING_UPLOAD, UPLOADED, REJECTED, REPLACED - 작품·역할별 UPLOADED 1개, PENDING_UPLOAD 1개
  • uploader_id — BIGINT — NOT NULL — 업로드 회원 ID, FK 없음
  • object_key — VARCHAR(1024) — NOT NULL — 비공개 버킷 객체 키, unique
  • content_type — VARCHAR(100) — NOT NULL — 신고한 형식
  • size_bytes — BIGINT — NOT NULL — 신고한 크기 바이트
  • sha256 — VARCHAR(64) — SHA-256 16진수 소문자
  • width_px — INTEGER — 가로 px
  • height_px — INTEGER — 세로 px
  • duration_ms — INTEGER — 영상 길이 ms, 최대 60초
  • rejected_reason — VARCHAR(50) — 거부 사유 코드, REJECTED일 때만
  • upload_expires_at — TIMESTAMPTZ — NOT NULL — 업로드 URL 만료 시각, URL은 저장하지 않음
  • uploaded_at — TIMESTAMPTZ — 업로드 확인 시각, UPLOADED·REPLACED면 필수
  • created_at — TIMESTAMPTZ — NOT NULL — 생성 시각 UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정 시각 UTC
  • slot — SMALLINT — NOT NULL
  • cover_time_ms — INTEGER

media_derivative

  • id — BIGINT — Primary key — NOT NULL — 가공본 ID
  • media_job_id — BIGINT — Foreign key → media_job.id — NOT NULL — 만든 작업 ID
  • source_asset_id — BIGINT — Foreign key → media_asset.id — NOT NULL — 원본 ID - 원본·종류·순번 unique
  • kind — VARCHAR(30) — NOT NULL — PREVIEW_IMAGE, THUMBNAIL, HLS_PLAYLIST, INSPECTION_FRAME, SHARE_VIDEO
  • sequence_no — INTEGER — NOT NULL — 같은 종류 내 순번, 하나뿐이면 0
  • object_key — VARCHAR(1024) — NOT NULL — 가공본 객체 키, unique
  • content_type — VARCHAR(100) — NOT NULL — 형식
  • size_bytes — BIGINT — 크기 바이트
  • width_px — INTEGER — 가로 px
  • height_px — INTEGER — 세로 px
  • duration_ms — INTEGER — 길이 ms
  • access_policy — VARCHAR(20) — NOT NULL — PUBLIC, PRIVATE - 검사 프레임은 항상 PRIVATE
  • created_at — TIMESTAMPTZ — NOT NULL — 생성 시각 UTC

media_job

  • id — BIGINT — Primary key — NOT NULL — 작업 ID - 메시지의 작업 ID
  • artwork_id — BIGINT — Foreign key → artwork.id — NOT NULL — 작품 ID
  • source_asset_id — BIGINT — Foreign key → media_asset.id — 입력 원본 ID - 원본·종류당 1행
  • job_type — VARCHAR(30) — NOT NULL — IMAGE_DERIVATIVES, VIDEO_TRANSCODE, SHARE_VIDEO
  • status — VARCHAR(20) — NOT NULL — REQUESTED, SUCCEEDED, FAILED, SUPERSEDED
  • attempts — INTEGER — NOT NULL — 요청 횟수
  • last_error_code — VARCHAR(100) — 마지막 실패 코드
  • requested_at — TIMESTAMPTZ — NOT NULL — 마지막 요청 시각
  • completed_at — TIMESTAMPTZ — 종료 시각, SUCCEEDED·FAILED면 필수
  • version — BIGINT — NOT NULL — 낙관적 잠금 버전
  • created_at — TIMESTAMPTZ — NOT NULL — 생성 시각 UTC
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정 시각 UTC
  • output_prefix — VARCHAR(300) — NOT NULL
  • resale_photo_id — BIGINT — Foreign key → artwork_resale_photo.id
  • sent_at — TIMESTAMPTZ
  • resend_count — INTEGER — NOT NULL
  • last_resent_at — TIMESTAMPTZ

media_worker_launch

  • worker — VARCHAR(40) — Primary key — NOT NULL
  • client_token — UUID — NOT NULL
  • request_fingerprint — VARCHAR(64) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • task_arn — VARCHAR(512)

notification

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • kind — VARCHAR(20) — NOT NULL
  • source_key — VARCHAR(100) — NOT NULL
  • auction_id — BIGINT
  • order_id — BIGINT
  • artwork_id — BIGINT
  • artwork_title — VARCHAR(200)
  • hammer_price — BIGINT
  • payment_due_at — TIMESTAMPTZ
  • occurred_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • read_at — TIMESTAMPTZ

outbox_event

  • event_id — UUID — Primary key — NOT NULL — 이벤트 ID UUID
  • event_type — VARCHAR(100) — NOT NULL — 이벤트 종류 - 종류·멱등키 unique
  • aggregate_id — VARCHAR(100) — NOT NULL — 업무 단위 ID
  • aggregate_version — BIGINT — NOT NULL — 업무 단위 버전
  • idempotency_key — VARCHAR(200) — NOT NULL — 업무 중복 기준 키
  • schema_version — VARCHAR(20) — NOT NULL — 메시지 스키마 버전
  • payload — JSONB — NOT NULL — 업무 데이터
  • occurred_at — TIMESTAMPTZ — NOT NULL — 발생 시각 UTC
  • traceparent — VARCHAR(100) — 추적 문맥
  • attempts — INTEGER — NOT NULL — 전송 시도 횟수
  • last_attempted_at — TIMESTAMPTZ — 마지막 전송 시도 시각
  • published_at — TIMESTAMPTZ — 발행 완료 시각
  • unpublishable_reason — VARCHAR(50)
  • unpublishable_at — TIMESTAMPTZ
  • next_attempt_at — TIMESTAMPTZ — NOT NULL
  • lane — SMALLINT — NOT NULL

processed_event

  • consumer — VARCHAR(100) — Primary key — NOT NULL — 소비자 이름
  • event_id — UUID — Primary key — NOT NULL — 처리한 이벤트 ID UUID
  • processed_at — TIMESTAMPTZ — NOT NULL — 처리 시각 UTC

view_count_flush

  • batch_id — UUID — Primary key — NOT NULL — Redis 조회 증분 묶음 ID UUID
  • flushed_at — TIMESTAMPTZ — NOT NULL — DB 반영 시각 UTC