sendig-3-1

Tables (30)

Body Weight Gains (BG)

  • Key (BGTESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (BGDTC) — CHAR — Primary key — NOT NULL
  • Key3 (BGENDTC) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Body Weights (BW)

  • Key (BWTESTCD) — CHAR — Primary key — NOT NULL
  • Key (BWDTC) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Cardiovascular (CV)

  • Key (CVTESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (CVTPTREF) — CHAR — Primary key — NOT NULL
  • Key3 (CVTPTNUM) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Clinical Observations (CL)

  • Key (POOLID) — CHAR — Primary key — NOT NULL
  • Key2 (CLTESTCD) — CHAR — Primary key — NOT NULL
  • Key3 (CLCAT) — CHAR — Primary key — NOT NULL
  • Key4 (CLORRES) — CHAR — Primary key — NOT NULL
  • Key5 (CLLOC) — CHAR — Primary key — NOT NULL
  • Key6 (CLDTC) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Comments (CO)

  • Key2 (COSEQ) — NUM — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL

Death Diagnosis and Details (DD)

  • Key (DDORRES) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Description (DM)

  • Key (STUDYID) — CHAR — Primary key — NOT NULL
  • Key2 (USUBJID) — CHAR — Primary key — NOT NULL

Disposition (DS)

  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

ECG (EG)

  • Key (EGTESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (EGTPTREF) — CHAR — Primary key — NOT NULL
  • Key3 (EGTPTNUM) — NUM — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Exposure (EX)

  • Key (EXTRT) — CHAR — Primary key — NOT NULL
  • Key2 (EXSTDTC) — CHAR — Primary key — NOT NULL
  • Key (POOLID) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Food and Water Consumption (FW)

  • Key (POOLID) — CHAR — Primary key — NOT NULL
  • Key2 (FWTESTCD) — CHAR — Primary key — NOT NULL
  • Key3 (FWDTC) — CHAR — Primary key — NOT NULL
  • Key4 (FWENDTC) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Laboratory (LB)

  • Key (POOLID) — CHAR — Primary key — NOT NULL
  • Key2 (LBTESTCD) — CHAR — Primary key — NOT NULL
  • Key3 (LBSPEC) — CHAR — Primary key — NOT NULL
  • Key4 (LBDTC) — CHAR — Primary key — NOT NULL
  • Key5 (LBTPTNUM) — NUM — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Macroscopic Findings (MA)

  • Key (MATESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (MAORRES) — CHAR — Primary key — NOT NULL
  • Key3 (MASPEC) — CHAR — Primary key — NOT NULL
  • Key4 (MAANTREG) — CHAR — Primary key — NOT NULL
  • Key5 (MALAT) — CHAR — Primary key — NOT NULL
  • Key6 (MADIR) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Microscopic Findings (MI)

  • Key (MITESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (MISTRESC) — CHAR — Primary key — NOT NULL
  • Key3 (MISPEC) — CHAR — Primary key — NOT NULL
  • Key4 (MIANTREG) — CHAR — Primary key — NOT NULL
  • Key5 (MILAT) — CHAR — Primary key — NOT NULL
  • Key6 (MIDIR) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Organ Measurements (OM)

  • Key (OMTESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (OMSPEC) — CHAR — Primary key — NOT NULL
  • Key3 (OMANTREG) — CHAR — Primary key — NOT NULL
  • Key4 (OMLAT) — CHAR — Primary key — NOT NULL
  • Key5 (OMDIR) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Pharmacokinetics Concentraations (PC)

  • Key (POOLID) — CHAR — Primary key — NOT NULL
  • Key2 (PCTESTCD) — CHAR — Primary key — NOT NULL
  • Key3 (PCSPEC) — CHAR — Primary key — NOT NULL
  • Key4 (PCDTC) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Pharmacokinetics Parameters (PP)

  • Key (POOLID) — CHAR — Primary key — NOT NULL
  • Key2 (PPTESTCD) — CHAR — Primary key — NOT NULL
  • Key3 (PPCAT) — CHAR — Primary key — NOT NULL
  • Key4 (PPSPEC) — CHAR — Primary key — NOT NULL
  • Key5 (PPRETDTC) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Pool Definition (POOLDEF)

  • Key (POOLID) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Related Records (RELREC)

  • Key (RDOMAIN) — CHAR — Primary key — NOT NULL
  • Key2 (IDVAR) — CHAR — Primary key — NOT NULL
  • Key3 (IDVARVAL) — CHAR — Primary key — NOT NULL
  • Key4 (RELID) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Respiratory Test Results (RE)

  • Key (RETESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (REDTC) — CHAR — Primary key — NOT NULL
  • Key3 (RETPT) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Subject Characteristics (SC)

  • Key (SCTESTCD) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Subject Elements (SE)

  • Key (ETCD) — CHAR — Primary key — NOT NULL
  • Key (SESTDTC) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Supplemental Qualifiers for (domain name) (SUPP--)

  • Key (RDOMAIN) — CHAR — Primary key — NOT NULL
  • Key2 (IDVAR) — CHAR — Primary key — NOT NULL
  • Key3 (IDVARVAL) — CHAR — Primary key — NOT NULL
  • Key4 (QNAM) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Trail Arms (TA)

  • Key (ARNCD) — CHAR — Primary key — NOT NULL
  • Key (TAETORD) — NUM — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL

Trail Elements (TE)

  • Key (ETCD) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL

Trail Sets (TX)

  • Key (SETCD) — CHAR — Primary key — NOT NULL
  • Key2 (TXPARMCD) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL

Trail Summary (TS)

  • Key (TSPARMCD) — CHAR — Primary key — NOT NULL
  • Key2 (TSSEQ) — NUM — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL

Tumor Findings (TF)

  • Key (TFTESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (TFORRES) — CHAR — Primary key — NOT NULL
  • Key3 (TFSPEC) — CHAR — Primary key — NOT NULL
  • Key4 (TFANTREG) — CHAR — Primary key — NOT NULL
  • Key5 (TFLAT) — CHAR — Primary key — NOT NULL
  • Key6 (TFDIR) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

Vital Signs (VS)

  • Key (VSTESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (VSDTC) — CHAR — Primary key — NOT NULL
  • Key3 (VSTPT) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL

palpable Masses (PM)

  • Key (PMTESTCD) — CHAR — Primary key — NOT NULL
  • Key2 (PMSPID) — CHAR — Primary key — NOT NULL
  • Key3 (PMDTC) — CHAR — Primary key — NOT NULL
  • Key (STUDYID) — CHAR — Foreign key → Description.Key — NOT NULL
  • Key2 (USUBJID) — CHAR — Foreign key → Description.Key2 — NOT NULL