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