다비켜요
테이블 (9)
Untitled
- 생성자 (created_by) — VARCHAR(100)
- 생성일 (created_at) — TIMESTAMP
- 수정자 (updated_by) — VARCHAR(100)
- 수정일 (updated_at) — TIMESTAMP
- 삭제 여부 (is_deleted) — BOOLEAN
- 삭제일 (deleted_at) — TIMESTAMP
ambulance
- id — INTEGER — 기본 키 — NOT NULL
- created_by — VARCHAR(100)
- created_at — TIMESTAMP
- updated_by — VARCHAR(100)
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN
- deleted_at — TIMESTAMP
- code — VARCHAR(100) — NOT NULL
ambulance_location
- id — INTEGER — 기본 키 — NOT NULL
- created_by — VARCHAR(100)
- created_at — TIMESTAMP
- updated_by — VARCHAR(100)
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN
- deleted_at — TIMESTAMP
- trip_id — INTEGER — NOT NULL
- latitude — DOUBLE
- longitude — DOUBLE
- recorded_at — TIMESTAMP
ambulance_trip
- id — INTEGER — 기본 키 — NOT NULL
- created_by — VARCHAR(100)
- created_at — TIMESTAMP
- updated_by — VARCHAR(100)
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN
- deleted_at — TIMESTAMP
- call_id — INTEGER — NOT NULL
- ambulance_id — INTEGER — NOT NULL
- origin_lat — DOUBLE
- origin_lng — DOUBLE
- destination_hospital_id — INTEGER — NOT NULL
- start_time — TIMESTAMP
- end_time — TIMESTAMP
hospital
- id — INTEGER — 기본 키 — NOT NULL
- created_by — VARCHAR(100)
- created_at — TIMESTAMP
- updated_by — VARCHAR(100)
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN
- deleted_at — TIMESTAMP
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- latitude — DOUBLE
- longitude — DOUBLE
- is_available — BOOLEAN
hospital_response
- id — INTEGER — 기본 키 — NOT NULL
- created_by — VARCHAR(100)
- created_at — TIMESTAMP
- updated_by — VARCHAR(100)
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN
- deleted_at — TIMESTAMP
- call_id — INTEGER — NOT NULL
- hospital_id — INTEGER — NOT NULL
- response_status — VARCHAR(50)
- response_time — TIMESTAMP
patient_call
- id — INTEGER — 기본 키 — NOT NULL
- created_by — VARCHAR(100)
- created_at — TIMESTAMP
- updated_by — VARCHAR(100)
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN
- deleted_at — TIMESTAMP
- caller_name — VARCHAR(100)
- caller_phone — VARCHAR(100)
- request_time — TIMESTAMP
- origin_lat — DOUBLE
- origin_lng — DOUBLE
- status — VARCHAR(50)
알림 토큰 (fcm_tocken)
- 아이디 (id) — UUID — 기본 키 — NOT NULL
- 생성자 (created_by) — VARCHAR(100)
- 생성일 (created_at) — TIMESTAMP
- 수정자 (updated_by) — VARCHAR(100)
- 수정일 (updated_at) — TIMESTAMP
- 삭제 여부 (is_deleted) — BOOLEAN
- 삭제일 (deleted_at) — TIMESTAMP
- 토큰 (tocken) — VARCHAR
- 유저 아이디 (user_id) — INTEGER — 외래 키 → 유저.아이디 — NOT NULL
유저 (User)
- 아이디 (id) — INTEGER — 기본 키 — NOT NULL
- 생성자 (created_by) — VARCHAR(100)
- 생성일 (created_at) — TIMESTAMP
- 수정자 (updated_by) — VARCHAR(100)
- 수정일 (updated_at) — TIMESTAMP
- 삭제 여부 (is_deleted) — BOOLEAN
- 삭제일 (deleted_at) — TIMESTAMP
- 아이디 (username) — VARCAHR(100)
- 비밀번호 (password) — VARCHAR(100)
- 권한 (role) — VARCHAR(100)
- 전화번호 (phone_number) — VARCHAR(100)