aaaaa
Tables (4)
PRICE_STATS
- STAT_ID — BIGINT — Primary key — NOT NULL
- AREA_CODE — VARCHAR(10) — NOT NULL
- CAR_MODEL_CODE — VARCHAR(20) — NOT NULL
- REPAIR_PART_CODE — VARCHAR(20) — NOT NULL
- LOG_NORM_PRICE — DOUBLE — NOT NULL
- IQR_VAL — DOUBLE — NOT NULL
- WEIGHT_W — DECIMAL(3,2) — NOT NULL
- K_FACTOR — DOUBLE — NOT NULL
- FINAL_BOUNDARY_LOW — DECIMAL(12,2) — NOT NULL
- FINAL_BOUNDARY_HIGH — DECIMAL(12,2) — NOT NULL
- SHOP_TYPE — VARCHAR(20) — NOT NULL
REPAIR_LOGS
- LOG_ID — BIGINT — Primary key — NOT NULL
- SHOP_ID — INT — Foreign key → SHOP_INFO.SHOP_ID — NOT NULL
- CAR_MODEL_CODE — VARCHAR(20) — NOT NULL
- REPAIR_PART_CODE — VARCHAR(20) — NOT NULL
- YEAR_FACTOR — DECIMAL(5,2) — NOT NULL
- REGION_FACTOR — DECIMAL(5,2) — NOT NULL
- RAW_PRICE — DECIMAL(12,2) — NOT NULL
- REG_DATE — DATETIME — NOT NULL
SHOP_INFO
- SHOP_ID — INT — Primary key — NOT NULL
- SHOP_NAME — VARCHAR(100) — NOT NULL
- AREA_CODE — VARCHAR(10) — NOT NULL
- SHOP_TYPE — VARCHAR(20) — NOT NULL
- RATING — DECIMAL(3,2)
VISUAL_ASSETS
- ASSET_ID — BIGINT — Primary key — NOT NULL
- LOG_ID — BIGINT — Foreign key → REPAIR_LOGS.LOG_ID — NOT NULL
- IMG_URL — VARCHAR(255) — NOT NULL
- AI_TAG_INFO — JSON — NOT NULL
- AD_SUITABILITY_SCORE — INT — NOT NULL
- CONVERSION_RATE — DECIMAL(5,2)