AltzCare

Tables (8)

calllog

  • id — BIGSERIAL — Primary key — NOT NULL
  • guardian_id — BIGINT — Foreign key → user.id — NOT NULL
  • patient_id — BIGINT — Foreign key → user.id — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • finished_at — TIMESTAMPTZ — NOT NULL
  • place — VARCHAR(30) — NOT NULL — 통화 장소
  • call_record — TEXT — 통화 기록 url
  • length — INTEGER — 통화 길이
  • is_emergency — BOOLEAN — NOT NULL — 비상전화 유무

favorite

  • id — BIGSERIAL — Primary key — NOT NULL
  • patient_id — BIGINT — Foreign key → user.id — NOT NULL — DELETE ON CASCADE
  • place_name — VARCHAR(30) — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • count — INTEGER — NOT NULL — 이용 빈도

health_info

  • id — BITSERIAL — Primary key — NOT NULL
  • patient_id — BIGINT — Foreign key → user.id — NOT NULL

patient_log

  • id — BIGSERIAL — Primary key — NOT NULL
  • patient_id — BIGINT — Foreign key → user.id — NOT NULL
  • fail_count — INTEGER — NOT NULL — 길찾기 실패 횟수
  • esc_count — INTEGER — NOT NULL — 안전범위 이탈 횟수
  • most_visited — VARCHAR(30)

relationship (relatonship)

  • id — BIGSERIAL — Primary key — NOT NULL
  • guardian_id — BIGINT — Foreign key → user.id — NOT NULL — DELETE ON CASCADE
  • patient_id — BIGINT — Foreign key → user.id — NOT NULL — DELETE ON CASCADE
  • guardian_relation — ENUM — 보호자가 입력한 관계
  • guardian_name — VARCHAR(30) — 보호자가 입력한 이름
  • patient_relation — ENUM — 환자가 입력한 관계
  • patient_name — VARCHAR(30) — 환자가 입력한 이름

relationship_request

  • id — SERIAL — Primary key — NOT NULL
  • sender_id — BIGINT — Foreign key → user.id — NOT NULL
  • receiver_id — BIGINT — Foreign key → user.id — NOT NULL — sender receiver 복합 유니크키 처리 필요
  • relation_name — VARCHAR(30) — 상대가 등록한 이름
  • status — ENUM — NOT NULL
  • requested_at — TIMESTAMPTZ — NOT NULL

safezone

  • id — BIGSERIAL — Primary key — NOT NULL
  • patiend_id (patient_id) — BIGINT — Foreign key → user.id — NOT NULL
  • from
  • end
  • 1st_boundary — DOUBLE — NOT NULL — 1번째 경계 반경
  • 2nd_boundary — DOUBLE
  • 3rd_boundary — DOUBLE

user

  • id — BIGSERIAL — Primary key — NOT NULL
  • phone_number — VARCHAR(30) — NOT NULL — UNIQUE, 형식 통일 후 Indexing 필요
  • password — VARCHAR(30) — NOT NULL
  • user_type — ENUM — NOT NULL — 보호자 or 환자
  • name — VARCHAR(30) — NOT NULL
  • birth — VARCHAR(15)
  • profile_image? — TEXT — 넣는게 좋지 않을까 생각
  • social_type — VARCHAR(10)
  • social_id — VARCHAR(255)