CREATE TABLE `t_rs1_data_jisseki` (
`manage_no` INTEGER NOT NULL
, `shirei_mng_cd` TEXT
, `rs_sho_no` TEXT
, `rs_sho_br_no` INTEGER
, `uketsuke_no` TEXT
, `shirei_no` TEXT
, `shirei_br_no` TEXT
, `rs_jisshi_shibu_cd` TEXT
, `rs_jisshi_kichi_cd` TEXT
, `rs_irai_shudan_cd` TEXT
, `yoyaku_flg` TEXT
, `chokuuke_flg` TEXT
, `saigai_flg` TEXT
, `season_saigai_flg` TEXT
, `iraimoto_cd` TEXT
, `iraimoto_name` TEXT
, `iraimoto_tanto` TEXT
, `iraimoto_tel_no` TEXT
, `iraimoto_gaichuu_no` TEXT
, `sagyo_date` TEXT
, `sagyou_youbi` TEXT
, `uketsuke_start_datetime` TEXT
, `uketsuke_comp_datetime` TEXT
, `shirei_ryokai_datetime` TEXT
, `move_start_datetime` TEXT
, `arrival_datetime` TEXT
, `sagyo_start_datetime` TEXT
, `kenin_start_datetime` TEXT
, `sagyo_comp_datetime` TEXT
, `katazuke_kanryou_datetime` TEXT
, `sagyo_shu_zissi_date` TEXT
, `rs_sho_get_datetime` TEXT
, `shuusei_datetime` TEXT
, `reg_date_time` TEXT
, `update_date_time` TEXT
, `rs_sagyou_date` TEXT
, `rs_sho_print_datetime` TEXT
, `rs_print_preview_datetime` TEXT
, `road_cls` TEXT
, `place_cls` TEXT
, `shutsudo_basho_name` TEXT
, `road_cd` TEXT
, `road_shisen_cd` TEXT
, `jh_kanri_flg` TEXT
, `hoko` TEXT
, `kiro_post` TEXT
, `manage_office_cd` TEXT
, `shutsudo_place_cd` TEXT
, `idou_kyori` TEXT
, `user_cd` TEXT
, `user_shozoku_shibu_cd` TEXT
, `user_shozoku_kichi_cd` TEXT
, `kaiin_no` TEXT
, `zaiseki_shibu_cd` TEXT
, `valid_kigen` TEXT
, `user_name_kana` TEXT
, `user_name` TEXT
, `yubin_no` TEXT
, `address_1` TEXT
, `address_2` TEXT
, `tel_no` TEXT
, `honnin_kakunin_shorui_1` TEXT
, `honnin_kakunin_shorui_1_no` TEXT
, `honnin_kakunin_shorui_2` TEXT
, `honnin_kakunin_shorui_2_no` TEXT
, `kaiin_jyotai_flg` TEXT
, `sex_cls` TEXT
, `renrakusaki_cls` TEXT
, `kaiin_type` TEXT
, `rentcar_hjn_torihikisaki_cd` TEXT
, `rentcar_hjn_torihikisaki_mei` TEXT
, `login_user_cd` TEXT
, `shitei_kojyo_kojin_mishu_jaf_kaishu_flg` TEXT
, `rs_sho_print_user_cd` TEXT
, `cutstomer_id` TEXT
, `sms_tel_no` TEXT
, `kaiin_correct_rea_1` TEXT
, `kaiin_correct_rea_2` TEXT
, `kaiin_correct_rea_3` TEXT
, `kaiin_correct_memo` TEXT
, `nyuukai_cls` TEXT
, `nyuukai_cls_1` TEXT
, `kaiin_meisai_info_1` INTEGER
, `nyuukai_cls_2` TEXT
, `kaiin_meisai_info_2` INTEGER
, `nyuukai_cls_3` TEXT
, `kaiin_meisai_info_3` INTEGER
, `jusho_henko_flg` TEXT
, `car_no` TEXT
, `rscc_cd` TEXT
, `maker_cd` TEXT
, `car_tsusho_name_cd` TEXT
, `car_reg_area_cd` TEXT
, `bike_tourokuchi_cd` TEXT
, `car_no_bunrui` TEXT
, `car_no_kana` TEXT
, `car_no_car_no` TEXT
, `shodo_reg` TEXT
, `car_style` TEXT
, `soukou_kiro_value` INTEGER
, `kosho_status_cd` TEXT
, `master_trouble_cd` TEXT
, `kudo_cls` TEXT
, `frame_no` TEXT
, `shaken_siyousha` TEXT
, `rscc2_cd` TEXT
, `car_no_yoto` INTEGER
, `douryoku_type` TEXT
, `dtc_infomation` TEXT
, `arrival_battery_value` TEXT
, `kanryou_battery_value` TEXT
, `handling_cls` TEXT
, `uriage_cls` TEXT
, `shochi_master_cls` TEXT
, `shochi_slave_cls` TEXT
, `bansou_flg` TEXT
, `sagyou_kousu_value` REAL
, `kenin_kiro_value` INTEGER
, `ki_kenin_kiro_value` INTEGER
, `punc_repair_value` INTEGER
, `nyuko_place_cls` TEXT
, `nyuuko_urikakesaki_cd` TEXT
, `nyuko_name` TEXT
, `nyukosaki_jyusho_cd` TEXT
, `tenko_cd` TEXT
, `romen_cd` TEXT
, `nyuukosaki_tel_no` TEXT
, `nyuukosaki_jusho` TEXT
, `shochi_rmrks` TEXT
, `shonin_shireiin` TEXT
, `one_point_advice_flg` TEXT
, `accidt_support_flg` TEXT
, `kihon_amt` INTEGER
, `sagyo_amt` INTEGER
, `kenin_amt` INTEGER
, `tsuko_amt` INTEGER
, `charge_kouhou_keikai_tukou` INTEGER
, `kouhou_keikai_gousha_no` TEXT
, `koho_keikai_shibu_cd` TEXT
, `koho_keikai_kichi_cd` TEXT
, `koho_keikai_shirei_no` TEXT
, `koho_keikai_shirei_br_no` TEXT
, `part_cd_1` TEXT
, `parts_value_1` INTEGER
, `charge_parts_1` INTEGER
, `part_cd_2` TEXT
, `parts_value_2` INTEGER
, `charge_parts_2` INTEGER
, `part_cd_3` TEXT
, `parts_value_3` INTEGER
, `charge_parts_3` INTEGER
, `kaihi` INTEGER
, `charge_seikyu` INTEGER
, `ryoshu_amt` INTEGER
, `kihon_hokyuukin_charge` INTEGER
, `charge_sagyou_hokyuukin` INTEGER
, `kenin_hokyuukin` INTEGER
, `genchaku_before_hokyuukin` INTEGER
, `genchaku_after_hokyuukin` INTEGER
, `charge_tatekae_tsuko` INTEGER
, `charge_keikai_hokyuukin` INTEGER
, `charge_keikai_tsuko_hokyuukin` INTEGER
, `charge_punc_hokyuukin` INTEGER
, `sp_hokyuukin_cd_1` TEXT
, `sp_hokyuukin_charge_1` INTEGER
, `sp_hokyuukin_cd_2` TEXT
, `sp_hokyuukin_charge_2` INTEGER
, `sp_hokyuukin_cd_3` TEXT
, `sp_hokyuukin_charge_3` INTEGER
, `sp_hokyuukin_cd_4` TEXT
, `sp_hokyuukin_charge_4` INTEGER
, `sp_hokyuukin_cd_5` TEXT
, `sp_hokyuukin_charge_5` INTEGER
, `sp_hokyuukin_cd_6` TEXT
, `sp_hokyuukin_charge_6` INTEGER
, `sp_hokyuukin_cd_7` TEXT
, `sp_hokyuukin_charge_7` INTEGER
, `sp_hokyuukin_cd_8` TEXT
, `sp_hokyuukin_charge_8` INTEGER
, `sp_hokyuukin_cd_9` TEXT
, `sp_hokyuukin_charge_9` INTEGER
, `sp_hokyuukin_cd_10` TEXT
, `sp_hokyuukin_charge_10` INTEGER
, `sp_hokyuukin_cd_11` TEXT
, `sp_hokyuukin_charge_11` INTEGER
, `sp_hokyuukin_cd_12` TEXT
, `sp_hokyuukin_charge_12` INTEGER
, `sp_hokyuukin_cd_13` TEXT
, `sp_hokyuukin_charge_13` INTEGER
, `sp_hokyuukin_charge_sum` INTEGER
, `special_hokyukin_valid_flg_1` TEXT
, `special_hokyukin_valid_flg_2` TEXT
, `special_hokyukin_valid_flg_3` TEXT
, `special_hokyukin_valid_flg_4` TEXT
, `special_hokyukin_valid_flg_5` TEXT
, `special_hokyukin_valid_flg_6` TEXT
, `special_hokyukin_valid_flg_7` TEXT
, `special_hokyukin_valid_flg_8` TEXT
, `special_hokyukin_valid_flg_9` TEXT
, `special_hokyukin_valid_flg_10` TEXT
, `special_hokyukin_valid_flg_11` TEXT
, `special_hokyukin_valid_flg_12` TEXT
, `special_hokyukin_valid_flg_13` TEXT
, `charge_hokyuukin_soto_shiharai` INTEGER
, `charge_kihon_2` INTEGER
, `charge_sagyou_2` INTEGER
, `kenin_kiro_value_2` INTEGER
, `charge_kenin_2` INTEGER
, `charge_tuukou_2` INTEGER
, `charge_kouhou_keikai_tukou_2` INTEGER
, `charge_kaihi_2` INTEGER
, `charge_parts_2_1` INTEGER
, `charge_parts_2_2` INTEGER
, `charge_parts_2_3` INTEGER
, `misyu_cls` TEXT
, `urikakesaki_cd` TEXT
, `urikakesaki_tanto` TEXT
, `urikakesaki_tel_no` TEXT
, `gaichuu_no` TEXT
, `zeus_order_no` TEXT
, `kojin_seikyu_saki` TEXT
, `genba_nouhinsho_print_flg` TEXT
, `mishuu_cls_2` TEXT
, `urikakesaki_cd_2` TEXT
, `urikakesaki_tanto_name_2` TEXT
, `urikakesaki_tel_no_2` TEXT
, `gaichuu_no_2` TEXT
, `zeus_order_no_2` TEXT
, `kojin_seikyusaki_name_2` TEXT
, `nouhinsho_print_flg_2` TEXT
, `one_point_kanri_no` INTEGER
, `one_point_user_name_kana` TEXT
, `one_point_check_date` TEXT
, `one_point_jisshi_basho` TEXT
, `one_point_engine_oil` TEXT
, `one_point_brake_oil` TEXT
, `one_point_clutch_oil` TEXT
, `one_point_oil_advice` TEXT
, `one_point_cooling_water` TEXT
, `one_point_cooling_water_advice` TEXT
, `one_point_battery_voltage` TEXT
, `one_point_battery_liquid_msu` TEXT
, `one_point_battery_terminal` TEXT
, `one_point_battery_body` TEXT
, `one_point_battery_advice` TEXT
, `one_point_alternator_belt` TEXT
, `one_point_power_steering_belt` TEXT
, `one_point_air_conditioner_belt` TEXT
, `one_point_putting_belt_advice` TEXT
, `one_point_lft_front_tire_air_value` INTEGER
, `one_point_lft_front_tire_air` TEXT
, `one_point_lft_front_tire_wear` TEXT
, `one_point_lft_front_tire_crack` TEXT
, `one_point_right_front_tire_air_value` INTEGER
, `one_point_right_front_tire_air` TEXT
, `one_point_right_front_tire_wear` TEXT
, `one_point_right_front_tire_crack` TEXT
, `one_point_lft_rear_tire_air_value` INTEGER
, `one_point_lft_rear_tire_air` TEXT
, `one_point_lft_rear_tire_wear` TEXT
, `one_point_lft_rear_tire_crack` TEXT
, `one_point_right_rear_tire_air_value` INTEGER
, `one_point_right_rear_tire_air` TEXT
, `one_point_right_rear_tire_wear` TEXT
, `one_point_right_rear_tire_crack` TEXT
, `one_point_tire_advice` TEXT
, `one_point_head_lamp_valve` TEXT
, `one_point_head_lamp_damage` TEXT
, `one_point_small_lamp_valve` TEXT
, `one_point_small_lamp_damage` TEXT
, `one_point_winker_lamp_valve` TEXT
, `one_point_winker_lamp_damage` TEXT
, `one_point_brake_lamp_valve` TEXT
, `one_point_brake_lamp_damage` TEXT
, `one_point_lamp_advice` TEXT
, `one_point_wiper_rubber_damage` TEXT
, `one_point_wiper_rubber_advice` TEXT
, `one_point_tokkijikou` TEXT
, `accidt_mng_no` INTEGER
, `accidt_user_name_kana` TEXT
, `accidt_jisshibi` TEXT
, `accidt_jiko_hassei_basho_flg` TEXT
, `accidt_jiko_hassei_basho_cd` TEXT
, `accidt_jiko_hassei_datetime` TEXT
, `accidt_keganin_cls` TEXT
, `accidt_kega_bui` TEXT
, `accidt_kyukyusha_tehai_flg` TEXT
, `accidt_hansousaki_byouin_name` TEXT
, `accidt_hansousaki_byouin_rn_no` TEXT
, `accidt_sharyou_hansou_flg` TEXT
, `accidt_hansou_saki` TEXT
, `accidt_hansou_saki_cd` TEXT
, `accidt_sonshou_bui` TEXT
, `accidt_police_todoke_flg` TEXT
, `accidt_todoke_police_sta` TEXT
, `accidt_todoke_police_sta_rn_no` TEXT
, `advice_1` TEXT
, `advice_2` TEXT
, `advice_3` TEXT
, `adv_tire_left_front_value` INTEGER
, `adv_tire_right_front_value` INTEGER
, `adv_tire_left_rear_value` INTEGER
, `adv_tire_right_rear_value` INTEGER
, `advice_key` TEXT
, `nexco_road_status_kiken_lv` TEXT
, `nexco_road_status_mitoshi` TEXT
, `nexco_road_status_shomei` TEXT
, `nexco_road_status_hosoku` TEXT
, `nexco_road_status_rmrks` TEXT
, `nexco_road_status_flat` TEXT
, `nexco_road_status_line` TEXT
, `nexco_road_status_bridge` TEXT
, `nexco_road_status_tunnel` TEXT
, `nexco_traffic` TEXT
, `nexco_teisha` TEXT
, `nexco_hamidashi` TEXT
, `nexco_emergency_run` TEXT
, `nexco_keikai_yosei` TEXT
, `nexco_nexco_yosei` TEXT
, `nexco_nexco_result` TEXT
, `nexco_kanritai_shutsudou` TEXT
, `nexco_police_yosei` TEXT
, `nexco_police_result` TEXT
, `nexco_kanritai_senchaku` TEXT
, `nexco_yoseimoto` TEXT
, `nexco_staff_value` INTEGER
, `nexco_car_value` INTEGER
, `nexco_warning_flare_value` INTEGER
, `nexco_cancel_call` TEXT
, `tsc_tantou_id` TEXT
, `tsc_zisseki_flg` TEXT
, `shonin_status` TEXT
, `shonin_irai_date` TEXT
, `henkou_jyoutai` TEXT
, `hikitsugi_flg` TEXT
, `sign_image_path` TEXT
, `term_no` TEXT
, `charge_shikibetsu_cd` TEXT
, `hikitsugi_jikou` TEXT
, `shuuseisha_cd` TEXT
, `shuusei_reason` TEXT
, `csv_output_flg` TEXT
, `rs_sho_hakko_flg` TEXT
, `jifuri_umu_flg` TEXT
, `charge_time_cls` TEXT
, `kari_kaiinsho_flg` TEXT
, `kari_no_flg` TEXT
, `rs_ikken_reg_send_flg` TEXT
, `force_regist_flg` TEXT
, `nyuusyukko_renkei_cls` TEXT
, `shonin_renkei_flg` TEXT
, `transfer_denied_notify_flg` TEXT
, `kaihi_type` TEXT
, `moushikomi_nensu` INTEGER
, `tax_taisho` INTEGER
, `uchi_tax_charge` INTEGER
, `meito_paper` INTEGER
, `cashless_payment_chage_id` TEXT
, `cashless_payment_e_signature_image_path` TEXT
, `mail_flg` TEXT
, `tax_percent` INTEGER
, `seikyu_cls_cd` TEXT
, `cashless_payment_result` TEXT
, `cashless_card_type` TEXT
, `rssho_select_picture_mng_no` TEXT
, `seikyu_amount_hi_member` INTEGER
, `rs_pdf_kakunou_path` TEXT
, `one_point_advice_pdf_kakunou_path` TEXT
, `update_appli_id` TEXT
, `update_user_cd` TEXT
, `memo` TEXT
, `memo_1` TEXT
, `memo_2` TEXT
, `memo_3` TEXT
, `memo_4` TEXT
, `memo_5` TEXT
, `memo_6` INTEGER
, `memo_7` TEXT
, `comment` TEXT
, `seikyu_hoho_cd` TEXT
, `deposit` INTEGER
, `yuryo_kenin_kyori` REAL
, `jifuri_flg` TEXT
, `kessai_flg` TEXT
, `reported_flg` TEXT
, `send_flg` TEXT
, `rsenta_cooperaion_status` TEXT
, `manual_kessai_flg` TEXT
, `kessai_kakunin_hitsuyou_flg` TEXT
, PRIMARY KEY (`manage_no`)
)
这个不是表结构吗？为什么说我没有提供？？？？
扫一扫
4044
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
