Soeul-Pubil-Data-2025

테이블 (5)

Emergency Report (긴급신고 내역) (emergency_report)

  • Emergency Report ID (id) — UUID — 기본 키 — NOT NULL
  • Emergency Date (emergency_at) — DATETIMESTAMP NOT NULL DEFAULT(NOW)
  • Emergency Latitude (emergency_latitude) — FLOAT
  • Emergency Longitude (emergency_longitude) — FLOAT
  • User ID (user_id) — UUID — 외래 키 → User (Custom User).User ID — NOT NULL
  • Notification ID (notification_id) — UUID — 외래 키 → Notification (긴급알림).Notification ID — NOT NULL
  • Create Date (created_at) — DATETIMESTAMP NOT NULL DEFAULT(NOW)

Notification (긴급알림) (notification)

  • Notification ID (id) — UUID — 기본 키 — NOT NULL
  • Message (message) — TEXT NOT NULL DEFAULT("")
  • Notification Type (notification_type) — VARCHAR(10) ENUM(112(문자) 보호자(문자, 푸시알림)
  • Create Date (created_at) — DATETIMESTAMP NOT NULL DEFAULT(NOW)
  • Update Date (updated_at) — DATETIMESTAMP NOT NULL DEFAULT(NOW)
  • Protector Name (protector_name) — VARCHAR(30) NOT NULL
  • Protector Phone Number (protector_phone_number) — VARCHAR(30) NOT NULL UNIQUE
  • User ID (user_id) — UUID — 외래 키 → User (Custom User).User ID — NOT NULL

Relation (관계) (relation)

  • Relation ID (id) — UUID — 기본 키 — NOT NULL
  • Child ID (child_id) — UUID — 외래 키 → User (Custom User).User ID — NOT NULL
  • Protector ID (protector_id) — UUID — 외래 키 → User (Custom User).User ID — NOT NULL
  • Create Date (created_at) — DATETIMESTAMP NOT NULL DEFAULT(NOW)
  • Approval (is_approval) — BOOLEAN
  • Child Name (child_name) — VARCHAR(30) NOT NULL
  • ParentName (parent_name)

Safety Facility (안심시설물) (safety_facility)

  • Safety Facility ID (id) — UUID — 기본 키 — NOT NULL
  • Facility Type (facility_type) — VARCHAR(10) ENUM(상세참조) — 301 안심벨 302 CCTV 303 안내표지판 (전주 표기 포함) 304 노면표기 305 보안등 306 안심귀갓길 서비스 안내판 307 112 위치 신고 안내 308 기타(안심반사경 등) 401 택배함 402 지…
  • Facility Latitude (위도) (facility_latitude) — FLOAT
  • Facility Longitude (경도) (facility_longitude) — FLOAT
  • Facility Location (facility_location) — TEXT NOT NULL — 세부 위치
  • Create Date (created_date) — DATETIMESTAMP NOT NULL DEFAULT(NOW)
  • Sigungu Code (sigungu_code) — VARCHAR(20) NOT NULL
  • Eupmyeondong Code (eupmyeondong_code) — VARCHAR(20 NOT NULL
  • Sigungu Name (sigungu_name) — VARCHAR(20 NOT NULL
  • Eupmyeondong Name (eupmyeondong_name) — VARCHAR(20 NOT NULL

User (Custom User) (user)

  • User ID (id) — UUID — 기본 키 — NOT NULL
  • Email (email) — VARCHAR(30) NOT NULL UNIQUE — 이메일
  • Profile Name (profile_name) — VARCHAR(30) NOT NULL
  • Phone Number (phone_number) — VARCHAR(30) NOT NULL UNIQUE
  • FCMToken (fcm_token) — VARCHAR(30) NOT NULL UNIQUE
  • Create Date (created_at) — DATETIMESTAMP NOT NULL DEFAULT(NOW)
  • Delete Date (deleted_at) — DATETIMESTAMP NOT NULL DEFAULT(NOW)