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)