테스트
테이블 (8)
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 — VARCHAR(100)
- password — VARCHAR(100)
- role — VARCHAR(100)
- phone_number — VARCHAR(100)
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
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
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)