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) — 질환타입