test
Tables (26)
cctv
- cctv_id — INT — Primary key — NOT NULL
- residences_id — INT — NOT NULL
- cctv_name — VARCHAR(255)
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- type — VARCHAR(100) — NOT NULL
child_detail
- child_id — INT — Foreign key → user.user_id — NOT NULL — 유저 ID
- name — VARCHAR(20) — NOT NULL
- height — VARCHAR(10) — NOT NULL
- features — VARCHAR(100) — NOT NULL
- birth — DATE — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- child_profile_image — VARCHAR(255) — NOT NULL
- updated_at — DATETIME — NOT NULL
child_photo
- photo_id — INT — Primary key — NOT NULL
- child_id — INT — NOT NULL — 유저 ID
- photo_url — VARCHAR(255) — NOT NULL
child_schedule
- schedule_id — INT — Primary key — NOT NULL
- child_id — INT — NOT NULL — 유저 ID
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- days — VARCHAR(20) — NOT NULL
- start_place — VARCHAR(100) — NOT NULL
- end_place — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN — NOT NULL
construction_zone
- construction_zone_id — INT — Primary key — NOT NULL
- location_name — VARCHAR(100) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
- updated_at — DATETIME — NOT NULL
exprected_route
- route_id — INT — Primary key — NOT NULL
- schedule_id — INT — NOT NULL
- waypoint — JSON — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- expected_time — DATETIME — NOT NULL
favorite_location
- location_id — INT — Primary key — NOT NULL
- child_id — INT — NOT NULL — 유저 ID
- name — VARCHAR(20) — NOT NULL
- address — VARCHAR(100) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
help_center
- help_center_id — INT — Primary key — NOT NULL
- category — VARCHAR(100) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
location
- location_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL — 유저 ID
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- timestamp — DATETIME — NOT NULL
- is_moving — BOOLEAN — NOT NULL
media_info
- media_id — INT — Primary key — NOT NULL
- sos_request_id — INT — NOT NULL
- video_url — VARCHAR(255) — NOT NULL
- audio_url — VARCHAR(255) — NOT NULL
- streamed_at — DATETIME — NOT NULL
notification_setting
- setting_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL — 유저 ID
- push_alert — BOOLEAN — NOT NULL
- child_activity_alert — BOOLEAN — NOT NULL
- off_route_alert — BOOLEAN — NOT NULL
- traffic_alert — BOOLEAN — NOT NULL
- constructor_alert — BOOLEAN — NOT NULL
- updated_at — DATETIME
random_code
- code_id — INT — Primary key — NOT NULL
- code — VARCHAR(20) — NOT NULL
- child_id — INT — NOT NULL — 유저 ID
- is_used — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- expired_at — DATETIME — NOT NULL
relations
- relations_id — INT — Primary key — NOT NULL
- parent_id — INT — NOT NULL — 유저 ID
- child_id — INT — NOT NULL — 유저 ID
- connected_at — DATETIME — NOT NULL
residences
- residences_id — INT — Primary key — NOT NULL
- address — VARCHAR(255) — NOT NULL
- residence_name — VARCHAR(255)
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
route
- route_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL — 유저 ID
- start_time — DATETIME — NOT NULL
- end_time — DATETIME
- route_name — VARCHAR(255)
route_deviation
- deviation_id — INT — Primary key — NOT NULL
- child_id — INT — NOT NULL — 유저 ID
- schedule_id — INT — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- detected_at — DATETIME — NOT NULL
social_account
- social_account_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL — 유저 ID
- provider — VARCHAR(100) — NOT NULL
- provider_user_id — VARCHAR(100) — NOT NULL
- connected_id — DATETIME — NOT NULL
sos_helper
- sos_helper_id — INT — Primary key — NOT NULL
- sos_request_id — INT — NOT NULL
- helper_id — INT — NOT NULL — 유저 ID
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME
- status — VARCHAR(100) — NOT NULL
sos_history
- history_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL — 유저 ID
- sos_request_id — INT — NOT NULL
- receiver_type — VARCHAR(10) — NOT NULL
- alert_time — DATETIME — NOT NULL
- is_active — BOOLEAN — NOT NULL
sos_request
- sos_request_id — INT — Primary key — NOT NULL
- child_id — INT — NOT NULL — 유저 ID
- request_time — DATETIME — NOT NULL
- status — VARCHAR(100) — NOT NULL
sos_response
- sos_response_id — INT — Primary key — NOT NULL
- sos_request_id — INT — NOT NULL
- parent_id — INT — NOT NULL — 유저 ID
- type — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
traffic_info
- traffic_id — INT — Primary key — NOT NULL
- location_name — VARCHAR(100) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- updated_at — DATETIME — NOT NULL
user
- user_id — INT — Primary key — NOT NULL — 유저 ID
- name — VARCHAR(100) — NOT NULL — 이름
- password — VARCHAR(100) — 패스워드
- email — VARCHAR(100) — 이메일
- phone — VARCHAR(50) — NOT NULL — 전화번호
- profile_image — VARCHAR(255) — 프로필 이미지
- is_adult — BOOLEAN — NOT NULL
- is_helper — BOOLEAN — NOT NULL
- nickname — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
user_permission
- permission_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL — 유저 ID
- permission_location — BOOLEAN — NOT NULL
- permission_camera — BOOLEAN — NOT NULL
- permission_mic — BOOLEAN — NOT NULL
- permission_gallery — BOOLEAN — NOT NULL
user_residences
- user_id — INT — Foreign key → user.user_id — NOT NULL — 유저 ID
- residences_id — INT — NOT NULL
user_role
- user_role_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL — 유저 ID
- role_type — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME