campaign
Tables (5)
mys_mk_campaign_master
- mk_campaign_no — varchar(20) — Primary key — NOT NULL
- level_type — varchar(10)
- title — varchar(100)
- subtitle — varchar(100)
- description — varchar(4000)
- ownership — varchar(50)
- cust_type — varchar(50)
- period_from — timestamp
- period_to — timestamp
- discount_general — numeric(5, 2)
- operation_type — varchar(10)
- discount_labor — numeric(5, 2)
- discount_part — numeric(5, 2)
- discount_sundry — numeric(5, 2)
- fixed_price — numeric(9, 2)
- provided_item — varchar(100)
- target_type — varchar(10)
- fuel_type — varchar(30)
- date_from — varchar(8)
- date_to — varchar(8)
- annual_mle — numeric(7)
- annual_mle_range — varchar(10)
- annual_mle_unit — varchar(10)
- transmission — varchar(10)
- voucher_use_yn — varchar(50)
- activate_yn — varchar(50)
- validity_target — varchar(10)
- reg_usr_id — varchar(20)
- reg_dt — timestamp
- udt_usr_id — varchar(20)
- udt_dt — timestamp
mys_mk_campaign_operation
- mk_campaign_no — varchar(20) — Primary key — NOT NULL
- operation_type — varchar(10)
- opcode — varchar(50)
- opcodeid — varchar(10)
- opname — varchar(5000)
- reg_usr_id — varchar(20)
- reg_dt — timestamp
- udt_usr_id — varchar(20)
- udt_dt — timestamp
mys_mk_campaign_target_user
- mk_campaign_no — varchar(20) — Primary key — NOT NULL
- dealer_cd — varchar(20)
- comp_cd — varchar(10)
- reg_usr_id — varchar(20)
- reg_dt — timestamp
- udt_usr_id — varchar(20)
- udt_dt — timestamp
mys_mk_campaign_target_vehicle
- mk_campaign_no — varchar(20) — Primary key — NOT NULL
- vin_no — bytea
- reg_no — varchar(20)
- model_id — varchar(10)
- model_code — varchar(30)
- family_code — varchar(10)
- reg_usr_id — varchar(20)
- reg_dt — timestamp
- udt_usr_id — varchar(20)
- udt_dt — timestamp
mys_mk_campaign_voucher
- mk_campaign_no — varchar(20) — Primary key — NOT NULL
- voucher_no — varchar(20) — Primary key — NOT NULL
- use_yn — varchar(1)
- reg_usr_id — varchar(20)
- reg_dt — timestamp
- udt_usr_id — varchar(20)
- udt_dt — timestamp