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