cms
Tables (20)
admin_member_info
- admin_id — varchar(250) — Primary key — NOT NULL
- admin_password — varchar(100) — NOT NULL
- admin_name — varchar(30)
- job_level — varchar(20)
- contact — varchar(20)
- admin_level — varchar(10)
- transport_company_name — varchar(50)
- regdate — varchar(30) — NOT NULL
admin_session
- session_id — varchar(100) — Primary key — NOT NULL
- member_id — varchar(100)
- created_at — datetime
air_measure_area_info
- areaIndex — int — Primary key — NOT NULL
- area_sido — varchar(10)
- area_dong — varchar(15)
- area_create_date — varchar(10)
- meas_area_type — varchar(20)
- meas_contents — varchar(100)
- area_lat — varchar(100)
- area_lng — varchar(100)
- area_address — varchar(100)
air_quality_mgt
- idx — int — Primary key — NOT NULL
- site — varchar(255) — NOT NULL
- areaIndex — varchar(10) — NOT NULL
- controlnumber — varchar(10)
- pm10 — varchar(50)
- pm25 — varchar(50)
- co — varchar(50)
- o3 — varchar(50)
- no2 — varchar(50)
- so2 — varchar(50)
- update_time — varchar(20)
bus_company_mgt
- idx — int — Primary key — NOT NULL
- company_name — varchar(50)
- company_contact — varchar(20)
- company_address — varchar(100)
- regdate — timestamp
bus_des_guide_mgt
- idx — int — Primary key — NOT NULL
- bus_number — varchar(20) — NOT NULL
- guide_ver — varchar(20)
- ver_tbu — varchar(20) — 업데이트 예정 버전
- ver_tbu_date — varchar(20) — 업데이트 예정 버전 날짜
- update_time — varchar(20)
bus_mgt
- bus_number — varchar(20) — Primary key — NOT NULL
- transport_company — varchar(45) — NOT NULL
- licensed_route — varchar(20) — NOT NULL
- transport_type — varchar(10)
- VIN — varchar(30)
- VIN_2 — varchar(10)
- car_manufacturer — varchar(20)
- use_type — varchar(10)
- car_type — varchar(10)
- fuel_type — varchar(10)
- car_year — varchar(10)
- car_reg_date — varchar(20)
- car_expiry_date — varchar(20)
- led_front — varchar(15)
- led_side — varchar(15)
- regdate — timestamp
bus_msg_mgt
- idx — int — Primary key — NOT NULL
- bus_number — varchar(20) — NOT NULL
- em_msg — text
- em_msg_state — varchar(20)
- update_time — varchar(30)
des_guide_mgt
- idx — int — Primary key — NOT NULL
- ver — varchar(20) — NOT NULL
- data — mediumtext
device_mgt
- idx — int — Primary key — NOT NULL
- MAC — varchar(100) — NOT NULL
- bus_number — varchar(45) — NOT NULL
- device_location — varchar(10)
- ScreenType — varchar(5)
- licensed_route — varchar(20) — NOT NULL
- current_route_ver — varchar(30)
- current_firmware_ver — varchar(30)
- applied_firmware_ver — varchar(45)
- update_time — varchar(20)
- regdate — timestamp
- RouteID — varchar(10)
- DriveState — varchar(5)
- Direction — varchar(5)
- StopIndex — varchar(5)
- RemainSeatEnable — varchar(5)
- DeviceError — varchar(20)
- KernelVer — varchar(10)
- FutFWApplyDateTime — varchar(20)
- FutRouteVer — varchar(30)
- FutRouteApplyDateTime — varchar(20)
file_mgt
- idx — int — Primary key — NOT NULL
- f_title — varchar(50)
- f_type — varchar(10)
- f_name — varchar(50)
- f_path — varchar(50)
- regdate — varchar(30)
line_des_guide_mgt
- idx — int — Primary key — NOT NULL
- route_no — varchar(15) — NOT NULL
- guide_ver — varchar(20)
- ver_tbu — varchar(20) — 업데이트 예정 버전\n
- ver_tbu_date — varchar(20) — 업데이트 예정 버전 날짜
- update_time — varchar(20)
line_file_mgt
- idx — int — Primary key — NOT NULL
- line_no — varchar(15) — NOT NULL
- file_id — int — NOT NULL
- order_num — varchar(10)
- regdate — varchar(30)
line_msg_mgt
- idx — int — Primary key — NOT NULL
- route_no — varchar(15) — NOT NULL
- em_msg — text
- em_msg_state — varchar(20)
- update_time — varchar(30)
maintenance_history_mgt
- idx — int — Primary key — NOT NULL
- writer_id — varchar(50) — NOT NULL
- doc_type — varchar(50)
- title — varchar(50)
- data — mediumtext
- updateAt — datetime
- createAt — datetime
minwon_mgt
- idx — int — Primary key — NOT NULL
- writer_id — varchar(50) — NOT NULL
- title — varchar(100)
- contents — text
- file_name — varchar(50)
- file_path — varchar(50)
- regdate — datetime
msg_opt_mgt
- idx — int — Primary key — NOT NULL
- type — varchar(50) — NOT NULL
- value — varchar(20)
notice_mgt
- idx — int — Primary key — NOT NULL
- writer_id — varchar(50) — NOT NULL
- view_type — varchar(10) — NOT NULL
- title — varchar(100)
- contents — text
- file_name — varchar(50)
- file_path — varchar(50)
- regdate — datetime
request_maintenance_mgt
- idx — int — Primary key — NOT NULL
- writer_id — varchar(50) — NOT NULL
- title — varchar(100)
- contents — text
- file_name — varchar(50)
- file_path — varchar(50)
- regdate — datetime
- process_state — varchar(10)
- comment_writer_id — varchar(50)
- comment — text
- comment_regdate — varchar(20)
request_new_bus_mgt
- idx — int — Primary key — NOT NULL
- writer_id — varchar(50) — NOT NULL
- title — varchar(100)
- contents — text
- file_name — varchar(50)
- file_path — varchar(50)
- regdate — datetime
- process_state — varchar(10)
- comment_writer_id — varchar(50)
- comment — text
- comment_regdate — varchar(20)