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