PATIENTS

1504 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID VARCHAR 255
ALLERGIES.PATIENT SYS_CONSTRAINT_f0ab3069-3f1d-4c1e-8bbb-6e571754b2c2R
CAREPLANS.PATIENT SYS_CONSTRAINT_77b204cd-a7bf-413e-96e7-be9b0085cf18R
CLAIMS.PATIENT SYS_CONSTRAINT_07b0c7b7-417e-43df-9627-edd075257adbR
CLAIMS_TRANSACTIONS.PATIENTID SYS_CONSTRAINT_6f8538f1-dd06-4a3e-b554-a5d33494e001R
CONDITIONS.PATIENT SYS_CONSTRAINT_3a3a128f-1fd2-48d3-b8d4-87eaa81cde23R
DEVICES.PATIENT SYS_CONSTRAINT_e2a1a98d-f168-4890-809f-d73aa8374427R
ENCOUNTERS.PATIENT SYS_CONSTRAINT_e0684af9-ae3f-499c-a922-c005b4709394R
IMMUNIZATIONS.PATIENT SYS_CONSTRAINT_19205834-e6b3-410c-866f-dad0617d00a3R
MEDICATIONS.PATIENT SYS_CONSTRAINT_fd050e68-2816-4e4a-933b-03ed2b3e74d2R
OBSERVATIONS.PATIENT SYS_CONSTRAINT_54277ced-c2e0-47d8-9ee5-5340cbb764f3R
PAYER_TRANSITIONS.PATIENT SYS_CONSTRAINT_985b080e-597a-440b-af29-4078be588ce1R
PROCEDURES.PATIENT SYS_CONSTRAINT_1040a22b-d9eb-448e-876f-f924ae272090R
SUPPLIES.PATIENT SYS_CONSTRAINT_15db7e07-794c-4149-8b3f-2eb2c2dbc8fdR
BIRTHDATE DATE 0 √
DEATHDATE DATE 0 √
SSN VARCHAR 255 √
DRIVERS VARCHAR 255 √
PASSPORT VARCHAR 255 √
PREFIX VARCHAR 255 √
FIRST VARCHAR 255 √
LAST VARCHAR 255 √
SUFFIX VARCHAR 255 √
MAIDEN VARCHAR 255 √
MARITAL VARCHAR 255 √
RACE VARCHAR 255 √
ETHNICITY VARCHAR 255 √
GENDER VARCHAR 255 √
BIRTHPLACE VARCHAR 255 √
ADDRESS VARCHAR 255 √
CITY VARCHAR 255 √
STATE VARCHAR 255 √
COUNTY VARCHAR 255 √
FIPS DOUBLE 0 √
ZIP NUMBER 38 √
LAT DOUBLE 0 √
LON DOUBLE 0 √
HEALTHCARE_EXPENSES DOUBLE 0 √
HEALTHCARE_COVERAGE DOUBLE 0 √
INCOME NUMBER 38 √

Relationships

Close relationships within degrees of separation