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