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