ERD 테스트
테이블 (20)
alert
- id — INT — 기본 키 — NOT NULL
- doctor_id — INT — 외래 키 → doctor.id — NOT NULL
- patient_id — INT — 외래 키 → patient.id — NOT NULL
- alert_type — VARCHAR(50) — NOT NULL — 기기오작동
- alert_level — VARCHAR(50) — enum_code:
- title — VARCHAR(50)
- message — VARCHAR(200) — NOT NULL
- triggered_at — TIMESTAMP — 생성일시랑
- read_at — TIMESTAMP
- status — VARCHAR(50) — NOT NULL — enum_code:
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
audit
- id — INT — 기본 키 — NOT NULL
- keycloak_id — TEXT — NOT NULL — 유저
- task_id — TEXT — NOT NULL
- session_id — INT — 외래 키 → session.id
- task_name — TEXT — NOT NULL
- content — JSONB — input
- access_log_path — TEXT — 파일명
- created_at — TIMESTAMP — NOT NULL
- completed_at — TIMESTAMP
- action — TEXT — NOT NULL — segment_process_start
- service_name — TEXT — NOT NULL — fastapi-server
batch
- id — INT — 기본 키 — NOT NULL
- session_id — INT — 외래 키 → session.id — NOT NULL
- batch_duration — INT — NOT NULL — 2분
- created_at — TIMESTAMP
batch_signal
- signal_id — INT — 외래 키 → signal.id — NOT NULL
- batch_id — INT — 외래 키 → batch.id — NOT NULL
- seq_no — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
config
- id — INT — 기본 키 — NOT NULL
- model_id — INT — 외래 키 → model.id — NOT NULL
- redis_signals_max_count — INT
- redis_features_max_count — INT
- window_duration — INT — 2분
- soft_time_limit_sec — INT — NOT NULL
- created_at — TIMESTAMP
doctor
- id — INT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- gender — ENUM('F','M')
- keycloak_id — VARCHAR(36) — NOT NULL — Keycloak
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
emergency_contact
- id — INT — 기본 키 — NOT NULL
- patient_id — INT — 외래 키 → patient.id — NOT NULL
- phone_number — VARCHAR(20)
- relationship — VARCHAR(50) — 보류
- contact_name — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
enum_code_detail
- group_code_detail — VARCHAR(50) — 기본 키 — NOT NULL — 예:
- group_code — VARCHAR(50) — 외래 키 → enum_code_group.group_code — NOT NULL
- code_name — VARCHAR(100) — NOT NULL — 한글
enum_code_group
- group_code — VARCHAR(50) — 기본 키 — NOT NULL — 예:
- group_name — VARCHAR(100) — NOT NULL
- is_use — BOOLEAN — NOT NULL
feature
- id — INT — 외래 키 → batch.id — NOT NULL
- features — JSONB — NOT NULL — stream
- status — VARCHAR(50) — NOT NULL — enum_code:
- created_at — TIMESTAMP — NOT NULL
hrv_bookmark
- id — INT — 기본 키 — NOT NULL
- doctor_id — INT — 외래 키 → doctor.id — NOT NULL
- session_id — INT — 외래 키 → session.id — NOT NULL
- start_at — TIMESTAMP — 기획에
- end_at — TIMESTAMP — 기획에
- note — VARCHAR(1000)
- created_at — TIMESTAMP — NOT NULL
medication_diary
- id — INT — 기본 키 — NOT NULL
- patient_id — INT — 외래 키 → patient.id — NOT NULL
- medicine_name — VARCHAR(100) — NOT NULL
- dosage — INT — 1회
- taken_at — TIMESTAMP — NOT NULL
- unit — VARCHAR(50) — enum_code:
- note — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
model
- id — INT — 기본 키 — NOT NULL
- model_name — VARCHAR(100)
- model_version — VARCHAR(10)
- system_name — VARCHAR(100)
- system_version — VARCHAR(10)
- indication — VARCHAR(100)
- description — VARCHAR(500)
- limitation — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
patient
- id — INT — 기본 키 — NOT NULL
- doctor_id — INT — 외래 키 → doctor.id
- name — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(50)
- keycloak_id — VARCHAR(36) — NOT NULL — Keycloak
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
predict_feature
- predict_result_id — INT — 외래 키 → predict_result.id — NOT NULL
- feature_id — INT — 외래 키 → feature.id — NOT NULL
- feature_seq_no — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
predict_result
- id — INT — 기본 키 — NOT NULL
- session_id — INT — 외래 키 → session.id — NOT NULL
- model_id — INT — 외래 키 → model.id — NOT NULL
- score — FLOAT
- processing_duration — FLOAT
- status — VARCHAR(50)
- measured_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
preprocessing
- id — INT — 외래 키 → batch.id — NOT NULL
- processing_duration — FLOAT
- measured_at — TIMESTAMP
- hash — VARCHAR — NOT NULL
- file_path — VARCHAR — NOT NULL
- status — VARCHAR(50) — enum_code:
- created_at — TIMESTAMP — NOT NULL
seizure_diary
- id — INT — 기본 키 — NOT NULL
- patient_id — INT — 외래 키 → patient.id — NOT NULL
- content — VARCHAR(1000)
- start_at — TIMESTAMP — NOT NULL
- duration_sec — INT — NOT NULL
- category — VARCHAR(50) — NOT NULL — enum_code:
- type — VARCHAR(50) — NOT NULL — 추후변경예정
- intensity — VARCHAR(50) — NOT NULL — enum_code:
- trigger — VARCHAR(150)
- note — VARCHAR(1000)
- location — VARCHAR(200)
- is_warning — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
session
- id — INT — 기본 키 — NOT NULL
- patient_id — INT — 외래 키 → patient.id — NOT NULL
- start_at — TIMESTAMP
- end_at — TIMESTAMP
- upload_type — VARCHAR(50) — enum_code:
- fs — INT
- final_seq_no — INT
- file_path — VARCHAR(200) — NOT NULL
- status — VARCHAR(50) — NOT NULL — enum_code:
- created_at — TIMESTAMP — NOT NULL
signal
- id — INT — 기본 키 — NOT NULL
- session_id — INT — 외래 키 → session.id — NOT NULL
- seq_no — INT — NOT NULL — 원본
- start_at — TIMESTAMP
- end_at — TIMESTAMP
- duration — INT — NOT NULL
- file_path — VARCHAR
- hash — VARCHAR — SHA-256(무결성
- status — VARCHAR(50) — enum_code:
- send_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL