UPDATE BD_BBS_ESTIMATE
SET bbs_title = :bbs_title
  , type_cd = :type_cd
  , type_cd2 = :type_cd2
  , type_cd3 = :type_cd3
  , comp_nm = :comp_nm
  , user_id = :user_id
  , cust_knm = :cust_knm
  , cust_enm = :cust_enm
  , nick_name = :nick_name
  , cust_phone_1 = :cust_phone_1
  , cust_phone_2 = :cust_phone_2
  , cust_phone_3 = :cust_phone_3
  , cust_phone = :cust_phone
  , cust_email = :cust_email
  , start_place = :start_place
  , travel_place = :travel_place
  , total_cnt = :total_cnt
  , room_type = :room_type
  , room_cnt = :room_cnt
  , trafic_type = :trafic_type
  , start_dt = :start_dt
  , end_dt = :end_dt
  , meal_a = :meal_a
  , meal_b = :meal_b
  , meal_c = :meal_c
  , remark = :remark
  , view_yn = :view_yn
  , upd_dt = now()
  , upd_id = :login_id
  , upd_ip = :login_ip
WHERE  bd_bbs_estimate_seq = :bd_bbs_estimate_seq