ㅣㅣ
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