다비켜요

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