Cog_ERD
Tables (3)
hospital
- id — uuid
- name — varchar(255) — NOT NULL
- type — hospital_type_enum — NOT NULL
- size — hospital_size_enum — 1:
- department — varchar(255) — report에
hospital_user
- id — uuid
- email — varchar(255) — NOT NULL
- first_name — varchar(255) — NOT NULL
- last_name — varchar(255)
- password — varchar(255) — NOT NULL
- terms_yn — boolean — NOT NULL
- privacy_yn — boolean — NOT NULL
- role — user_role_enum — NOT NULL — user
- is_active — boolean — NOT NULL
launcher_neuro
- id — uuid
- hospital_id — uuid — NOT NULL
- patient_id — varchar(255) — NOT NULL
- prescription_id — varchar(255) — QC
- prescripted_at — timestamp — NOT NULL — 처방일시
- prescription_type — prescription_type_enum — NOT NULL — Cog
- pacs_id — varchar(255) — QC
- pacs_created_at — timestamp — NOT NULL — MRI
- pacs_location_path — varchar(255) — PACS상
- first_name — varchar(255) — NOT NULL — QC용
- last_name — varchar(255) — NOT NULL — QC용
- age — int2 — NOT NULL
- sex — sex_enum — NOT NULL — male
- mmse — numeric — 0~30
- cdr_sb — float4 — 0.0~18.0
- status — numeric — NOT NULL
- pacs_saved_path — varchar(255) — 로컬에
- result — jsonb
- report_saved_path — varchar(255) — 로컬에
- saved_duration — timestamp — NOT NULL — 데이터