Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
patientid | int | 4 | √ | null |
|
|
||||
facilityid | int | 4 | √ | null |
|
|
||||
facilitycode | varchar | 5 | √ | null |
|
|
||||
masterpatientid | int | 4 | √ | null |
|
|
||||
firstname | varchar | 50 | √ | null |
|
|
||||
middlename | varchar | 35 | √ | null |
|
|
||||
lastname | varchar | 50 | √ | null |
|
|
||||
title | varchar | 254 | √ | null |
|
|
||||
suffix | int | 4 | √ | null |
|
|
||||
gender | char | 1 | √ | null |
|
|
||||
address1 | varchar | 35 | √ | null |
|
|
||||
address2 | varchar | 35 | √ | null |
|
|
||||
address3 | varchar | 35 | √ | null |
|
|
||||
city | varchar | 50 | √ | null |
|
|
||||
state | varchar | 3 | √ | null |
|
|
||||
country | varchar | 254 | √ | null |
|
|
||||
zipcode | varchar | 15 | √ | null |
|
|
||||
varchar | 75 | √ | null |
|
|
|||||
homephone | varchar | 35 | √ | null |
|
|
||||
dateofbirth | datetime | 16,3 | √ | null |
|
|
||||
deceaseddate | datetime | 16,3 | √ | null |
|
|
||||
ssnumber | varchar | 30 | √ | null |
|
|
||||
education | varchar | 254 | √ | null |
|
|
||||
citizenship | varchar | 254 | √ | null |
|
|
||||
race | varchar | 254 | √ | null |
|
|
||||
religion | varchar | 254 | √ | null |
|
|
||||
maritalstatus | varchar | 254 | √ | null |
|
|
||||
originaladmissiondate | datetime | 16,3 | √ | null |
|
|
||||
recentadmissiondate | datetime | 16,3 | √ | null |
|
|
||||
dischargedate | datetime | 16,3 | √ | null |
|
|
||||
patientidnumber | varchar | 35 | √ | null |
|
|
||||
patientmrn | varchar | 35 | √ | null |
|
|
||||
patientmedicaidnumber | varchar | 30 | √ | null |
|
|
||||
patientmedicarenumber | varchar | 30 | √ | null |
|
|
||||
createdby | varchar | 60 | √ | null |
|
|
||||
createddate | datetime | 16,3 | √ | null |
|
|
||||
revisionby | varchar | 60 | √ | null |
|
|
||||
revisiondate | datetime | 16,3 | √ | null |
|
|
||||
masterpatientdeleted | varchar | 1 | √ | null |
|
|
||||
patientdeleted | varchar | 1 | √ | null |
|
|
||||
deletedby | varchar | 60 | √ | null |
|
|
||||
deleteddate | datetime | 16,3 | √ | null |
|
|
||||
currentcensusid | int | 4 | √ | null |
|
|
||||
allergies | varchar | 1000 | √ | null |
|
|
||||
occupations | varchar | 50 | √ | null |
|
|
||||
primarypharmacyid | int | 4 | √ | null |
|
|
||||
primaryphysicianid | int | 4 | √ | null |
|
|
||||
nickname | varchar | 50 | √ | null |
|
|
||||
placeofbirth | varchar | 35 | √ | null |
|
|
||||
initialadmissiondate | datetime | 16,3 | √ | null |
|
|
||||
dss_update_time | datetime | 16,3 | √ | null |
|
|