R&D V3_NK,T

Tables (14)

Copy Of Copy Of TB_DONOR (TB_PBMC)

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

Copy Of TB_DONOR (TB_PBNK)

  • Key (PBNK_id) — Primary key — NOT NULL
  • donor_id — TEXT — Foreign key → TB_DONOR.donor_id — NOT NULL — 채취일+번호
  • Field (Sorting date) — 분리일
  • Field (Purity_NK) — REAL — Purity
  • Field2 (Purity_T) — REAL — Purity
  • Field3 (Purity_NKT) — REAL — Purity
  • Field4 (Purity_Others) — REAL — Purity

Copy Of TB_MEDIA_LOT (TB_MEDIA_LOG)

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

TB_CELL_LINE

  • cell_line_id — TEXT — Primary key — NOT NULL
  • cell_type — TEXT — K562, Nalm-6
  • passage — INTEGER
  • stock_date — TEXT
  • source — TEXT

TB_CULTURE_RUN

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

TB_DONOR

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

TB_EXPERIMENT_SET

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

TB_MEDIA_COMPOSITION (TB_MEDIA_RECIPE)

  • media_lot_id — TEXT — Foreign key → TB_MEDIA_LOT.media_lot_id — NOT NULL
  • reagent_id — TEXT — Foreign key → TB_REAGENT.reagent_id — NOT NULL
  • amount — REAL
  • unit — TEXT

TB_MEDIA_LOT

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

TB_REAGENT

  • reagent_id — TEXT — Primary key — NOT NULL
  • reagent_name — TEXT
  • cat_no — TEXT
  • supplier — TEXT
  • storage_condition — TEXT

TB_REAGENT_LOT

  • reagent_lot_id — TEXT — Primary key — NOT NULL
  • reagent_id — TEXT — Foreign key → TB_REAGENT.reagent_id — NOT NULL
  • lot_no — TEXT
  • expire_date — TEXT

TB_RESULT (TB_RESULT_Proliferation)

  • Key (result_id) — TEXT — Primary key — NOT NULL
  • run_id — TEXT — Foreign key → TB_CULTURE_RUN.run_id — NOT NULL
  • Field (seeding_density)
  • culture_date — TEXT — 실험일자
  • culture_day — INTEGER — 배양일차
  • total_cell_number (cell_fold_increase) — INTEGER
  • cell_size — REAL
  • cell_viability — REAL
  • culture_scale — TEXT

TB_USER

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

Untitled (TB_TEST_ITEM)

  • Key (test_item_id) — Primary key — NOT NULL
  • Field (test_item_name) — Proliferation, CD3+, PD-1
  • Field (unit) — %
  • Field (test_equipment) — FACS