유전체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)

Untitled5

    Untitled6

    • Field
    • Field2
    • Field3

    Untitled8

    • POS (Field22) — 외래 키 → 유전체DB.POS
    • REF (Field)
    • ALT (Field2)

    Untitled9

      사람 (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)