테스트

테이블 (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)