new moren

Tables (5)

order (계약정보)

  • order_no (Key) — int — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL

order_history (계약이력관리)

  • order_no (Key) — Primary key — NOT NULL
  • category (계약정보 수정 카테고리) — NOT NULL — 변경내용 카테고리 - 주행거리 - 보험변경 - 운전자 변경
  • content (변경내용)
  • update_date (변경일)
  • user_id (변경유저)
  • user_name (변경 유저)

order_ins_bill (보험대차 청구정보)

  • order_ins_id (Key) — Primary key — NOT NULL
  • bill_date (Field)
  • money_in_date (Field2)
  • order_money (Field3)
  • in_price_money (Field4)
  • ins_company (Field5)
  • ins_manager_name (Field6)
  • ins_manager_phone (Field7)
  • ins_manager_fax (Field8)
  • ins_manager_id (Field9)

order_user (계약자 운전자)

  • order_user_id (Key) — Primary key — NOT NULL
  • name (Field)
  • phone (Field2)
  • addr1 (Field3)
  • addr2 (Field4)
  • zipcode (Field5)
  • license_number (Field6)
  • licence_type (Field7)
  • licence_expire_date (Field8)
  • license_check_date (Field9)
  • license_check_yn (Field13)
  • birth (Field10)
  • secure_number (Field11)
  • gender (Field12)
  • order_user_type (Field14)
  • memo (Field15)

order_vehicle (계약차량정보)

  • order_v_id (Key) — Primary key — NOT NULL
  • order_no (Field)
  • order_v_no (Key2) — NOT NULL
  • order_v_name (Field2)
  • order_v_number (Field3)
  • order_start_time (Field4)
  • order_end_time (Field5)
  • order_start_distatnce (Field6)
  • order_end_distance (Field7)
  • order_start_gas (Field8)
  • order_end_gas (Field9)
  • order_start_gas_max (Field10)
  • order_end_gas_max (Field11)