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)