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)