NHDS ERD

Tables (3)

diagnosis (diag_tb)

  • survey year (year) — int(4) — Foreign key → injury inpatient.survey year — NOT NULL
  • patient identifier (num) — int(8) — Foreign key → injury inpatient.patient identifier — NOT NULL
  • diagnosis flag (flag) — int(1) — NOT NULL
  • code serial number (seri) — int(2) — NOT NULL
  • diagnosis code (code) — varchar(10) — NOT NULL

injury inpatient (nhds_tb)

  • survey year (year) — int(4) — Primary key — NOT NULL
  • patient identifier (num) — int(8) — Primary key — NOT NULL
  • hospital identifier (hident) — varchar(10) — NOT NULL
  • hospital area (area) — int — NOT NULL
  • bed size (bed) — int — NOT NULL
  • patient sex (sex) — int — NOT NULL
  • patient age in years (age) — int — NOT NULL
  • date of birth (bdate) — varchar(8) — NOT NULL
  • zip code (zip) — varchar(6) — NOT NULL
  • medical bill payment source (paysou) — int — NOT NULL
  • date of admission (admdate) — varchar(8) — NOT NULL
  • date of discharge (disdate) — varchar(8) — NOT NULL
  • admission route (admrou) — int — NOT NULL
  • external cause code of injury 1 (injdia1) — varchar(9)
  • external cause code of injury 2 (injdia2) — varchar(9)
  • discharge status (txres) — int — NOT NULL
  • disposition (dispo) — int — NOT NULL
  • underlying cause of death (deathca) — varchar(10)
  • intent of injury (injint) — int
  • place of injury occurrence (injpla) — int
  • activity at injury (injact) — int
  • mechanism of injury (injmec) — int
  • date of injury (injdate) — varchar(8)
  • mode of transport (tamode) — int
  • risk factors of suicide or suicide attempt (suifac) — int
  • poisoning substance (poisub) — int
  • weight — decimal(20,15) — NOT NULL

procedure (proc_tb)

  • survey year (year) — int(4) — Foreign key → injury inpatient.survey year — NOT NULL
  • patient identifier (num) — int(8) — Foreign key → injury inpatient.patient identifier — NOT NULL
  • Field (prodate) — varchar(8)
  • procedure flag (flag) — int(1) — NOT NULL
  • code serial number (seri) — int(2) — NOT NULL
  • procedure code (code) — varchar(10) — NOT NULL