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 — 조성개발팀