bus
Tables (27)
ad
- id — BIGINT
- title — VARCHAR(255)
- image_url — TEXT
- link_url — VARCHAR(255)
- start_date_time — DATETIME
- end_date_time — DATETIME
- deleted — BOOLEAN
- company_id — BIGINT
- show_popup — BOOLEAN — NOT NULL
- extension_count — INT — NOT NULL
ad_company
- id — BIGINT
- company_name — VARCHAR(255)
- contact — VARCHAR(255)
admin_audit_log
- id — BIGINT
- admin_id — BIGINT
- action_type — VARCHAR(50)
- action_details — TEXT
- ip_address — VARCHAR(50)
- timestamp — DATETIME
api_access_log
- id — BIGINT
- api_key_id — BIGINT
- endpoint — VARCHAR(255)
- method — VARCHAR(10)
- status_code — INT
- timestamp — DATETIME
api_key
- id — BIGINT
- key_value — VARCHAR(255)
- description — VARCHAR(255)
- user_id — BIGINT
- status — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
- last_used_at — DATETIME
api_key_callback_url
- id — BIGINT
- api_key_id — BIGINT
- url — VARCHAR(255)
bus_company
- id — BIGINT
- company_name — VARCHAR(255)
- company_info — VARCHAR(255)
bus_fare
- id — BIGINT
- city — VARCHAR(255)
- adult_card_fare — INTEGER
- adult_cash_fare — INTEGER
- youth_card_fare — INTEGER
- youth_cash_fare — INTEGER
- child_card_fare — INTEGER
- child_cash_fare — INTEGER
- note — TEXT
bus_schedule
- id — BIGINT
- header_id — BIGINT
- departure_time — VARCHAR(50)
- arrival_time — VARCHAR(50)
- stop_name — VARCHAR(255)
- stop_order — INTEGER
bus_schedule_header
- id — BIGINT
- route_name — VARCHAR(255)
- date_type — VARCHAR(50)
bus_stop
- id — BIGINT
- bs_id — VARCHAR(255)
- bs_nm — VARCHAR(255)
- x_pos — DOUBLE
- y_pos — DOUBLE
bus_stop_info
- id — BIGINT
- bs_id — VARCHAR(255)
- bs_nm — VARCHAR(255)
- local_bs_id — VARCHAR(255)
- arsId — VARCHAR(255)
- dataconnareacd — VARCHAR(255)
favorite_bus_stop
- id — BIGINT
- user_id — BIGINT
- bs_id — VARCHAR(255)
- bs_nm — VARCHAR(255)
favorite_route
- id — BIGINT
- user_id — BIGINT
- route_id — VARCHAR(255)
- route_no — VARCHAR(255)
- st_nm — VARCHAR(255)
- ed_nm — VARCHAR(255)
found_item
- id — BIGINT
- item_name — VARCHAR(255)
- bus_company — VARCHAR(255)
- bus_number — VARCHAR(255)
- found_place — VARCHAR(255)
- found_time — DATETIME
- content — TEXT
- storage_location — VARCHAR(255)
- handler_contact — VARCHAR(255)
- handler_email — VARCHAR(255)
- status — VARCHAR(50)
- handler_id — BIGINT
- is_deleted — BOOLEAN — NOT NULL
- is_hidden — BOOLEAN — NOT NULL
- visible — BOOLEAN — NOT NULL
- matched — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
lost_found_match
- id — BIGINT
- lost_id — BIGINT
- found_id — BIGINT
- matched_by_id — BIGINT
- match_date — DATETIME
lost_item
- id — BIGINT
- title — VARCHAR(255)
- content — TEXT
- bus_number — VARCHAR(255)
- bus_company — VARCHAR(255)
- lost_time — DATETIME
- reporter_id — BIGINT
- matched — BOOLEAN
- visible — BOOLEAN
- deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
low_floor_bus
- id — BIGINT
- bus_number — VARCHAR(255)
- route_name — VARCHAR(255)
- company_name — VARCHAR(255)
- start_station — VARCHAR(255)
- end_station — VARCHAR(255)
- operation_time — VARCHAR(255)
- special_note — TEXT
notice
- id — BIGINT
- title — VARCHAR(255)
- content — TEXT
- author — VARCHAR(255)
- created_date — TIMESTAMP
- updated_date — TIMESTAMP
- view_count — BIGINT — NOT NULL
- show_popup — BOOLEAN — NOT NULL
- popup_start — DATETIME
- popup_end — DATETIME
notice_file
- id — BIGINT
- notice_id — BIGINT
- file_path — VARCHAR(255)
- original_filename — VARCHAR(255)
notification
- id — BIGINT
- user_id — BIGINT
- message — VARCHAR(255)
- is_read — BOOLEAN
- created_at — DATETIME
photo
- id — BIGINT
- found_item_id — BIGINT
- photo_url — VARCHAR(255)
qna
- id — BIGINT
- member_id — BIGINT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — VARCHAR(50)
- answer — TEXT
- is_secret — BOOLEAN
- is_deleted — BOOLEAN
- visible — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
route
- id — BIGINT
- route_id — VARCHAR(255)
- route_no — VARCHAR(255)
- st_bs_id — VARCHAR(255)
- ed_bs_id — VARCHAR(255)
- st_nm — VARCHAR(255)
- ed_nm — VARCHAR(255)
- route_note — TEXT
- dataconnareacd — VARCHAR(255)
- dir_route_note — VARCHAR(255)
- ndir_route_note — VARCHAR(255)
- route_tCd — VARCHAR(50)
route_stop_link
- id — BIGINT
- route_id — VARCHAR(255)
- bs_id — VARCHAR(255)
- bs_order — INT
- dir_cd — VARCHAR(10)
route_type
- id — BIGINT
- type_name — VARCHAR(255)
- type_code — VARCHAR(50)
users
- id — BIGINT
- user_id — VARCHAR(255) — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(255)
- role — VARCHAR(50) — NOT NULL
- signup_type — VARCHAR(50) — NOT NULL
- signup_date — DATETIME
- last_login_at — DATETIME
- withdraw — BOOLEAN — NOT NULL