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