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)