agi

Tables (15)

tb_audio_metadata

  • audio_metadata_id — serial4 — Primary key — NOT NULL
  • item_id — serial4 — Foreign key → tb_items.item_id — NOT NULL
  • patient_id — uuid — Foreign key → tb_items.patient_id — NOT NULL
  • file_path — varchar(4000) — 서버/스토리지
  • file_size_mb — numeric(10, 2) — 파일
  • duration_seconds — int4 — 길이(초)
  • sample_rate_hz — int4 — 샘플레이트(Hz)
  • channels — int4 — 오디오
  • bit_rate_kbps — int4 — 비트레이트(kbps
  • codec — varchar(255) — 오디오
  • is_anonymized — bool — 비식별
  • created_ts — timestamp
  • file_ext — varchar(255)
  • file_name — varchar(255)
  • needs_anonymization — bool — 비식별
  • anonymized_ts — timestamp — 비식별
  • data_category — varchar(255) — 업무

tb_data_preprocessing

  • preprocessing_id — serial4 — Primary key — NOT NULL
  • item_id — serial4 — Foreign key → tb_items.item_id — NOT NULL
  • data_category — varchar(50)
  • original_file_path — text — 원본
  • json_file_path — text — JSON
  • encrypted_file_path — text — 암호화
  • registered_at — timestamp — 등록
  • processing_started_at — timestamp — 작업
  • processing_ended_at — timestamp — 작업
  • processing_duration_sec — numeric(10, 2) — 작업
  • total_frames — int4 — 영상
  • encrypted_frames — int4 — 비식별화
  • detected_face_frames — int4 — 얼굴
  • success_rate — numeric(5, 2) — 성공률
  • preprocessing_type — varchar(100) — 비식별화타입
  • description — text — 비고

tb_data_validation

  • validation_id — serial4 — Primary key — NOT NULL
  • item_id — serial4 — Foreign key → tb_items.item_id — NOT NULL
  • validation_method — varchar(50) — 검증
  • validation_description — text — 검증에
  • validation_datetime — timestamp — 검증
  • patient_id — uuid

tb_depression_stage

  • stage_id — serial4 — Primary key — NOT NULL
  • item_id — serial4 — Foreign key → tb_items.item_id — NOT NULL
  • patient_id — uuid — Foreign key → tb_patient_info.patient_id — NOT NULL
  • stage_value — int4
  • stage_description — text
  • assessment_date — date

tb_download_history

  • history_id — serial4 — Primary key — NOT NULL
  • file_name — varchar(100)
  • file_type — varchar — 말뭉치/QNA/비디오/문진/환자정보
  • category — varchar(10) — 파킨슨/우울증
  • down_count — numeric(10, 2) — 다운로드
  • down_date — timestamp(0) — 다운로드
  • mbr_id — varchar(20) — 다운로드
  • file_size — numeric(10, 2) — 파일

tb_external_code

  • external_code_id — serial4 — Primary key — NOT NULL
  • code_name — varchar(100) — NOT NULL — 데이터
  • description — varchar(255) — NOT NULL — 코드
  • category — varchar(50) — NOT NULL — 상위
  • created_at — timestamp — 등록

tb_external_collection

  • external_id — serial4 — Primary key — NOT NULL
  • external_code_id — serial4 — Foreign key → tb_external_code.external_code_id — NOT NULL
  • code_name — varchar(100)
  • data_category — varchar(50) — 데이터
  • data_type — varchar(50) — 데이터
  • num_samples — int4 — 수집된
  • total_sentences — int4 — 총
  • total_tokens — int4 — 총
  • reference_missing_rate — float8 — 참조(reference)
  • doi_missing_rate — float8 — DOI
  • verification_missing_rate — float8 — 검증(verification)
  • file_size_mb — numeric(10, 2) — 수집
  • source_name — varchar(255) — 수집
  • collector — varchar(100) — 수집
  • notes — text — 기타
  • created_at — timestamp
  • collected_date — timestamp — 데이터
  • collection_latency — interval — 데이터

tb_external_validation

  • validation_id — serial4 — Primary key — NOT NULL
  • external_id — serial4 — Foreign key → tb_external_collection.external_id — NOT NULL
  • external_code_id — serial4 — Foreign key → tb_external_collection.external_code_id — NOT NULL
  • code_name — varchar(100) — 검증
  • data_category — varchar(50) — 데이터
  • data_type — varchar(50) — 검증
  • validation_type — varchar(100) — 검증
  • validation_result — varchar(50) — 검증
  • validation_score — float8 — 검증
  • verification_missing_rate — float8 — 검증(verification)
  • reference_missing_rate — float8 — 참조(reference)
  • doi_missing_rate — float8 — DOI
  • file_size_mb — numeric(10, 2) — 검증
  • collection_latency — interval — 검증
  • checked_at — timestamp — 검증
  • source_filename — varchar(255) — 검증
  • reviewer — varchar(100) — 검증
  • notes — text — 검증

tb_file_metadata

  • file_metadata_id — serial4 — Primary key — NOT NULL
  • item_id — serial4 — Foreign key → tb_items.item_id — NOT NULL
  • patient_id — uuid — Foreign key → tb_items.patient_id — NOT NULL
  • file_path — varchar(4000) — 서버/스토리지
  • file_size_mb — numeric(10, 2) — 파일
  • created_ts — timestamp — 등록
  • file_ext — varchar(255) — 확장자(소문자)
  • file_name — varchar(255) — 파일명
  • data_category — varchar(255) — 업무

tb_items

  • item_id — serial4 — Primary key — NOT NULL
  • patient_id — uuid — Foreign key → tb_patient_info.patient_id — NOT NULL
  • data_category — varchar(50) — 데이터
  • data_type — varchar(50) — 데이터
  • seq — int4 — 동일
  • description — text — 항목
  • collected_at — timestamp — 데이터
  • is_deleted — bool — 소프트
  • deleted_at — timestamp — 소프트
  • is_updated — bool — NAS
  • updated_at — timestamp — 업로드

tb_parkinson_stage

  • stage_id — serial4 — Primary key — NOT NULL
  • patient_id — uuid — Foreign key → tb_patient_info.patient_id — NOT NULL
  • item_id — serial4 — Foreign key → tb_items.item_id — NOT NULL
  • stage_value — numeric(2, 1) — 단계
  • stage_description — text — 단계
  • assessment_date — date — 평가

tb_patient_info

  • patient_id — uuid — Primary key — NOT NULL
  • display_id — varchar(20) — 외부
  • patient_initials — varchar(10) — 환자
  • gender — varchar(10) — 환자
  • birth_date — date — 환자
  • institution — varchar(100) — 수집
  • is_data_complete — bool — 데이터
  • completion_date — timestamp — 데이터
  • created_ts — timestamp — 데이터
  • update_ts — timestamp — 데이터
  • is_deleted — bool — 환자
  • deleted_ts — timestamp

tb_questionnaire_answers

  • answer_id — serial4 — Primary key — NOT NULL
  • question_id — serial4 — Foreign key → tb_questionnaire_questions.question_id — NOT NULL
  • item_id — serial4 — Foreign key → tb_items.item_id — NOT NULL
  • answer_component — varchar(50) — 답변
  • answer_value — varchar(255) — 답변
  • submission_datetime — timestamp — 답변

tb_questionnaire_questions

  • question_id — serial4 — Primary key — NOT NULL
  • questionnaire_type — varchar(50) — 설문지
  • question_number — int4 — 질문
  • question_text — varchar(500) — 질문

tb_video_metadata

  • video_metadata_id — serial4 — Primary key — NOT NULL
  • item_id — serial4 — Foreign key → tb_items.item_id — NOT NULL
  • patient_id — uuid — Foreign key → tb_items.patient_id — NOT NULL
  • file_path — varchar(4000) — 파일
  • file_size_mb — numeric(10, 2) — 파일
  • duration_seconds — int4 — 영상
  • resolution — varchar(20) — 해상도
  • frame_rate — int4 — 프레임
  • is_anonymized — bool — 비식별화
  • created_ts — timestamp — 서버
  • file_ext — varchar(255) — 파일
  • file_name — varchar(255) — 파일
  • shooting_ts — timestamp — 촬영일자
  • needs_anonymization — bool — 비식별화
  • anonymized_ts — timestamp — 비식별화
  • data_category — varchar(255) — 질환타입