R&D_T XF, AOF

Tables (11)

Copy Of Copy Of TB_DONOR (TB_PBMC)

  • Key (PBMC_id) — VARCHAR — Primary key — NOT NULL
  • donor_id — VARCHAR — Foreign key → TB_DONOR.donor_id — NOT NULL — 채취일+번호
  • Field (Purity_NK) — FLOAT — Purity
  • Field2 (Purity_T) — FLOAT — Purity
  • Field3 (Purity_NKT) — FLOAT — Purity
  • Field4 (Purity_Others) — FLOAT — Purity

Copy Of Copy Of TB_RESULT (TB_RESULT_ELISA)

  • Key (result_elisa_id) — VARCHAR — Primary key — NOT NULL
  • run_id — VARCHAR — Foreign key → TB_CULTURE_RUN.run_id — NOT NULL
  • culture_date — DATE — 실험일자
  • culture_day — INT — 배양일차
  • Field (IFN_gamma) — FLOAT
  • Field4 (Perforin) — FLOAT
  • Field2 (Granzym_B) — FLOAT
  • Field3 (TNF_alpha) — FLOAT

Copy Of TB_MEDIA_LOT (TB_MEDIA_LOG)

  • Key (media_log_id) — VARCHAR — Primary key — NOT NULL
  • media_lot_id — VARCHAR — Foreign key → TB_MEDIA_LOT.media_lot_id — NOT NULL
  • Field (pH) — FLOAT
  • Field (osmolality) — FLOAT
  • Field (measure_time) — VARCHAR — 측정 시점
  • Field (measure_date) — DATE — 분석 일자
  • Field (measure_place) — VARCHAR — 분석 장소

Copy Of TB_RESULT (TB_RESULT_FACS)

  • Key (result_facs_id) — VARCHAR — Primary key — NOT NULL
  • run_id — VARCHAR — Foreign key → TB_CULTURE_RUN.run_id — NOT NULL
  • culture_date — DATE — 실험일자
  • culture_day — INT — 배양일차
  • Field (Purity_CD3) — FLOAT
  • Field4 (Activation_CD25) — FLOAT
  • Field2 (Phenotype_CD4) — FLOAT
  • Field3 (Phenotype_CD8) — FLOAT
  • Field5 (Phenotype_TN) — FLOAT
  • Field6 (Phenotype_TCM) — FLOAT
  • Field (Phenotype_TEM) — FLOAT
  • Field2 (Phenotype_TEFF) — FLOAT
  • Field (Exhaustion_PD1) — FLOAT

TB_CELL_LINE

  • cell_line_id — VARCHAR — Primary key — NOT NULL
  • cell_type — VARCHAR — K562, Nalm-6
  • passage — INT
  • stock_date — DATE
  • source — VARCHAR

TB_CULTURE_RUN (TB_CULTURE_TREATMENT)

  • run_id — VARCHAR — Primary key — NOT NULL
  • set_id — VARCHAR — Foreign key → TB_EXPERIMENT_SET.set_id — NOT NULL
  • media_lot_id (supple_media_lot_id) — VARCHAR — Foreign key → TB_MEDIA_LOT.media_lot_id — NOT NULL — TA2602, XDGJ01
  • media_lot_id (basal_media_lot_id) — VARCHAR — Foreign key → TB_MEDIA_LOT.media_lot_id — NOT NULL — XDGJ01S
  • donor_id — VARCHAR — Foreign key → TB_DONOR.donor_id — PBMC#33
  • cell_line_id — VARCHAR — Foreign key → TB_CELL_LINE.cell_line_id

TB_DONOR

  • donor_id — VARCHAR — Primary key — NOT NULL — 채취일+번호
  • collection_date — DATE — 채취일
  • cell_type — VARCHAR — PBMC, MSC, PanT
  • gender — VARCHAR — Female, male
  • age — INT — 출생연도
  • source — VARCHAR — 구매, 채취

TB_EXPERIMENT_SET

  • set_id — VARCHAR — Primary key — NOT NULL
  • user_id — VARCHAR — Foreign key → TB_USER.user_id — NOT NULL — CH, SJ
  • Field (project) — VARCHAR — T AOF, T XF
  • experiment_name — VARCHAR — ACC_0M, ACC_6M, PE-1
  • purpose — TEXT

TB_MEDIA_LOT

  • media_lot_id — VARCHAR — Primary key — NOT NULL
  • Field (project) — VARCHAR
  • manufacture_date — DATE
  • manufacturer — VARCHAR — 조성개발팀, 공정기술개발팀
  • Field2 (storage_condition) — VARCHAR
  • Field (media_type) — VARCHAR — basal, supplement
  • Field (scale) — FLOAT — 3L
  • Field (water_type) — VARCHAR — WFI, DW

TB_RESULT (TB_RESULT_CULTURE)

  • Key (result_culture_id) — VARCHAR — Primary key — NOT NULL
  • run_id — VARCHAR — Foreign key → TB_CULTURE_RUN.run_id — NOT NULL
  • Field (seeding_density) — INT
  • culture_date — DATE — 실험일자
  • culture_day — INT — 배양일차
  • total_cell_number (cell_fold_increase) — FLOAT
  • cell_size — FLOAT
  • cell_viability — FLOAT
  • culture_scale — VARCHAR

TB_USER

  • user_id — VARCHAR — Primary key — NOT NULL — 1. 사원번호 = ID 2. Master table
  • name — VARCHAR — 김조현
  • team — VARCHAR — 조성개발팀