유전체DB

테이블 (15)

3

  • REF (Field) — NOT NULL
  • ALT (Field2) — NOT NULL
  • GT (Key2) — NOT NULL

FORMAT (5)

  • QUAL (Field)
  • Filter (Field2)
  • AD (Field3)
  • DP (Field4)
  • GQ (Field5)
  • PL (Field6)
  • PGT (Field7)
  • PID (Field8)
  • PS (Field9)

GT (6)

  • POS (Field2) — NOT NULL
  • GT(1) (Field)
  • GT2() (Field3)

ID (Untitled9)

  • ID (Key) — 기본 키 — NOT NULL
  • SMK (Field2)
  • ID (Field22) — 외래 키 → Untitled7.ID

INFO (Untitled6)

  • QUAL (Field)
  • FILTER (Field2)
  • Field3
  • Field4
  • Field5
  • ID (Field6) — 외래 키 → Untitled2.ID

INFO(1) (Untitled12)

  • AC (Field) — NOT NULL
  • AF (Field2) — NOT NULL
  • AN (Field3) — NOT NULL

INFO(2) (Untitled11)

  • BaseQRankSum (Field)
  • DP (Field2)
  • ExcessHET (Field3)
  • FS (Field4)
  • InbreedingCoeff (Field5)
  • MLEAC (Field6)
  • MLEAF (Field7)
  • MQ (Field8)
  • MQRankSum (Field9)
  • QD (Field10)
  • ReadPosRankSum (Field11)
  • SOR (Field12)

MEMBER (1)

  • CHROM (Field) — NOT NULL
  • SMK (Field3) — NOT NULL
  • ID (Key) — NOT NULL

Untitled10

  • POS (Field)
  • CHROM (Field2)
  • ID (Key) — 외래 키 → ID.ID — NOT NULL

Untitled2

  • ID (Field) — 기본 키
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8
  • Field9
  • Field10
  • Field11

Untitled3

  • ID (Field) — 외래 키 → Untitled2.ID

Untitled4

  • ID (Field) — 외래 키 → Untitled2.ID
  • SMK (Field2)
  • CHROM (Field3)
  • POS (Field4)

Untitled5

  • REF (Field)
  • ALT (Field2)

Untitled7

  • ID (Field2) — 기본 키
  • REF (Field4)
  • GT (Field6)
  • INFO (중복)
  • INFO (중복x)
  • NULL (null)

Untitled8

  • SMK (Field)
  • ALT (Field3)
  • ID (Field22) — 외래 키 → Untitled7.ID