ㅣㅣ

Tables (8)

ai_job

  • job_id — UUID — Primary key — NOT NULL
  • scene_image_id — BIGINT — Foreign key → scene_image.scene_image_id
  • job_type — VARCHAR(30)
  • status — VARCHAR(20)
  • input_payload — JSONB
  • result_payload — JSONB
  • error_code — VARCHAR(50)
  • error_message — TEXT
  • attempt_count — SMALLINT
  • max_attempts — SMALLINT
  • worker_id — VARCHAR(100)
  • locked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ
  • started_at — TIMESTAMPTZ
  • finished_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

app_user

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • user_name — VARCHAR(100)
  • password_hash — VARCHAR(255)
  • session — VARCHAR(255)
  • role — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMPTZ

approval

  • request_id — BIGSERIAL — Primary key — NOT NULL
  • tagging_result_id — BIGINT — Foreign key → tagging_result.result_id
  • scene_image_id — BIGINT — Foreign key → scene_image.scene_image_id
  • object_index — SMALLINT
  • status — VARCHAR(20)
  • requested_by — BIGINT — Foreign key → app_user.user_id
  • requested_at — TIMESTAMPTZ
  • reviewed_by — BIGINT — Foreign key → app_user.user_id
  • reviewed_at — TIMESTAMPTZ
  • reject_reason — VARCHAR(255)

product_image_submission

  • submission_id — BIGSERIAL — Primary key — NOT NULL
  • target_type — VARCHAR(20)
  • target_sku_id — BIGINT — Foreign key → sku_catalog.sku_id
  • proposed_sku_code — VARCHAR(50)
  • proposed_product_name — VARCHAR(200)
  • proposed_brand — VARCHAR(100)
  • proposed_price — INT
  • proposed_category — VARCHAR(50)
  • proposed_sub_category — VARCHAR(50)
  • proposed_attributes — JSONB
  • image_url — TEXT
  • image_type — VARCHAR(20)
  • status — VARCHAR(20)
  • requested_by — BIGINT — Foreign key → app_user.user_id
  • requested_at — TIMESTAMPTZ
  • submitted_at — TIMESTAMPTZ
  • reviewed_by — BIGINT — Foreign key → app_user.user_id
  • reviewed_at — TIMESTAMPTZ
  • reject_reason — VARCHAR(255)
  • final_sku_id — BIGINT — Foreign key → sku_catalog.sku_id
  • final_sku_image_id — BIGINT — Foreign key → sku_image.sku_image_id

scene_image

  • scene_image_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → app_user.user_id
  • image_url — TEXT
  • origin_name — VARCHAR(255)
  • mime_type — VARCHAR(20)
  • file_size — INT
  • analysis_error — TEXT
  • analysis_status — VARCHAR(20)
  • created_at — TIMESTAMPTZ
  • object_metadata — JSONB
  • width_px — INT
  • height_px — INT

sku_catalog

  • sku_id — BIGSERIAL — Primary key — NOT NULL
  • sku_code — VARCHAR(50) — NOT NULL
  • product_name — VARCHAR(200)
  • category — VARCHAR(50)
  • sub_category — VARCHAR(50)
  • brand — VARCHAR(50)
  • price — INTEGER
  • key_features — JSONB
  • attributes — JSONB
  • text_embedding — VECTOR(3072)
  • created_at — TIMESTAMPTZ

sku_image

  • sku_image_id — BIGSERIAL — Primary key — NOT NULL
  • sku_id — BIGINT — Foreign key → sku_catalog.sku_id
  • image_url — TEXT
  • image_type — VARCHAR(20)
  • embedding — VECTOR(3072)
  • indexed_at — TIMESTAMPTZ
  • embedding_pipeline_version — VARCHAR(50)
  • embedding_image_sha256 — TEXT
  • created_at — TIMESTAMPTZ

tagging_result

  • result_id — BIGSERIAL — Primary key — NOT NULL
  • scene_image_id — BIGINT — Foreign key → scene_image.scene_image_id
  • object_idx — SMALLINT
  • sku_id — BIGINT — Foreign key → sku_catalog.sku_id
  • sku_image_id — BIGINT — Foreign key → sku_image.sku_image_id
  • match_source — VARCHAR(20)
  • match_rank — SMALLINT
  • similarity_score — NUMERIC(6,4)
  • similarity_grade — CHAR(1)
  • xai_result — JSONB
  • vlm_mood — JSONB
  • created_by — BIGINT — Foreign key → app_user.user_id
  • created_at — TIMESTAMPTZ