유전체DB구축
테이블 (9)
ALL (Untitled)
- SMK (Field3)
- CHR (Field4)
- POS (Field5)
- Field6
- Field7
- Field8
FORMAT (Untitled3)
- AD (Field8)
- DP (Field9)
- GQ (Field10)
- PGT (Field11)
- PID (Field12)
- PL (Field13)
- PS (Field14)
- Field18
- FORMAT일련번호 (Field) — NOT NULL
INFO (Untitled4)
- AC (Field2) — NOT NULL — NOT NULL
- AF (Field3) — NOT NULL
- AN (Field4) — NOT NULL
- BaseQRankSum (Field5)
- DP (Field6)
- ExcessHet (Field7)
- FS (Field8)
- InbreedingCoeff (Field9)
- MLEAC (Field10)
- MLEAF (Field11)
- MQ (Field12)
- MQRankSum (Field13)
- QD (Field14)
- ReadPosRankSum (Field15)
- SOR (Field16)
Untitled8
- POS (Field22) — 외래 키 → 유전체DB.POS
- REF (Field)
- ALT (Field2)
사람 (Untitled2)
- POS (Field2) — NOT NULL
- REF (Field4) — NOT NULL
- CHROM (Field5) — NOT NULL
유전체DB (Untitled7)
- POS (Field2) — 기본 키
- QUAL (Field3)
- INFO (Field5)
- Field6
- Field7
- Field8
- Field9
- Field10
- Field11
- Field12
- Field13
- Field14
- Field15
- Field16
- Field17
- Field18
- SMK (Key) — NOT NULL
- CHR (Field)