knr test

Tables (9)

consent_channel_pref

  • row_id — VARCHAR(64)
  • cust_uid — VARCHAR(64) — Foreign key → customer.cust_uid — NOT NULL
  • channel_cd — VARCHAR(30)
  • opt_in_yn — CHAR(1)
  • last_updated — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

consent_privacy

  • row_id — VARCHAR(64)
  • cust_uid — VARCHAR(64) — Foreign key → customer.cust_uid — NOT NULL
  • consent_typ — VARCHAR(80)
  • status_cd — VARCHAR(20)
  • effective_dt — DATE
  • expiry_dt — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

customer

  • row_id — VARCHAR(64)
  • cust_uid — VARCHAR(64) — NOT NULL
  • cust_id — VARCHAR(64)
  • first_name — VARCHAR(150)
  • last_name — VARCHAR(150)
  • email — VARCHAR(255)
  • phone — VARCHAR(50)
  • prefd_sals_dlr_id — VARCHAR(64) — Foreign key → dealer.row_id
  • prefd_svc_dlr_id — VARCHAR(64) — Foreign key → dealer.row_id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

cvr

  • row_id — VARCHAR(64)
  • cust_uid — VARCHAR(64) — Foreign key → customer.cust_uid — NOT NULL
  • vin — VARCHAR(32) — Foreign key → vehicle.vin — NOT NULL
  • relation_typ — VARCHAR(50)
  • start_dt — DATE
  • end_dt — DATE
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

dealer

  • row_id — VARCHAR(64)
  • dlr_cd — VARCHAR(32)
  • dlr_name — VARCHAR(255)
  • region_cd — VARCHAR(32)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

product

  • row_id — VARCHAR(64)
  • sals_fsc_cd — VARCHAR(64)
  • mdl_cd — VARCHAR(64)
  • mdl_name — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

repair_order

  • row_id — VARCHAR(64)
  • ro_id — VARCHAR(64) — NOT NULL
  • vin — VARCHAR(32) — Foreign key → vehicle.vin — NOT NULL
  • cust_uid — VARCHAR(64) — Foreign key → customer.cust_uid
  • dlr_id — VARCHAR(64) — Foreign key → dealer.row_id
  • ro_dt — TIMESTAMP
  • ro_stat_cd — VARCHAR(30)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

vehicle

  • row_id — VARCHAR(64)
  • vin — VARCHAR(32) — NOT NULL
  • sals_fsc_cd — VARCHAR(64) — Foreign key → product.sals_fsc_cd
  • sals_dlr_id — VARCHAR(64) — Foreign key → dealer.row_id
  • ws_dlr_id — VARCHAR(64) — Foreign key → dealer.row_id
  • last_ro_id — VARCHAR(64) — Foreign key → repair_order.ro_id
  • last_ro_dlr_id — VARCHAR(64) — Foreign key → dealer.row_id
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

warranty

  • row_id — VARCHAR(64)
  • warr_clm_id — VARCHAR(64) — NOT NULL
  • vin — VARCHAR(32) — Foreign key → vehicle.vin — NOT NULL
  • dlr_id — VARCHAR(64) — Foreign key → dealer.row_id
  • clm_dt — TIMESTAMP
  • clm_stat_cd — VARCHAR(30)
  • amount — DECIMAL(18,2)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP