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