safe driving
Tables (4)
drive_records
- id — int — Primary key — NOT NULL
- drive_date — date
- start_time — time
- end_time — time
- duration — int
- avg_drowsiness — int
- warning_count — int
- attention_count — int
- user_id — int — Foreign key → users.id — NOT NULL
- start_lat — float
- start_lng — float
- end_lat — float
- end_lng — float
rest_area
- rest_area_id — int — Primary key — NOT NULL
- name — varchar(255)
- sido — varchar(100)
- sigungu — varchar(100)
- road_type — varchar(100)
- road_name — varchar(100)
- road_number — int
- direction — varchar(50)
- direction_type — varchar(50)
- address — varchar(255)
- latitude — float
- longitude — float
- parking_count — int
- toilet_yn — char(1)
- created_at — timestamp
service_station
- service_station_id — int — Primary key — NOT NULL
- name — varchar(255)
- road_type — varchar(100)
- road_number — int
- road_name — varchar(100)
- direction — varchar(50)
- latitude — float
- longitude — float
- parking_count — int
- repair — varchar(50)
- gas_station — varchar(50)
- lpg_station — varchar(50)
- ev_station — varchar(50)
- bus_transfer — varchar(50)
- rest_area — varchar(50)
- toilet — varchar(50)
- pharmacy — varchar(50)
- nursing_room — varchar(50)
- store — varchar(50)
- restaurant — varchar(50)
- facilities — varchar(255)
- 휴게소대표음식명 — varchar(255)
- phone — varchar(50)
- created_at — timestamp
- direction_type — varchar(50)
users
- id — int — Primary key — NOT NULL
- email — varchar(255)
- password — varchar(255)
- username — varchar(255)
- created_at — timestamp
- emergency_call — varchar(255)