human
Tables (6)
Department (진료과)
- Key — Primary key — NOT NULL
- name (이름)
ResearchInstitution (연구책임기관)
- Key — Primary key — NOT NULL
- name (이름)
ResearchScope (연구 범위)
- Key — Primary key — NOT NULL
- name (이름)
ResearchStep (연구 모형)
- Key — Primary key — NOT NULL
- name (이름)
ResearchType (연구 종류)
- Key — Primary key — NOT NULL
- name (이름)
Trial (임상시험)
- Key — Primary key — NOT NULL
- trial_id (과제 번호) — str
- trial_name (과제 명) — str
- total_target_number (임상시험 대상 수) — int
- study_period (Field) — str
- created_at (생성 시간) — date
- updated_at (업데이트 시간) — date
- department_id (진료과 ID) — int — Foreign key → ResearchStep.Key — NOT NULL
- research_institution_id (연구책임기관 ID) — int — Foreign key → Department.Key — NOT NULL
- research_type_id (연구 종류 ID) — int — Foreign key → ResearchInstitution.Key — NOT NULL
- research_step_id (연구 모형 ID) — int — Foreign key → ResearchType.Key — NOT NULL
- research_scope_id (연구 범위 ID) — int — Foreign key → ResearchScope.Key — NOT NULL