Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
---|---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
The primary key which is the same as the forms.form_id column |
||||
date | DATETIME | 19 | √ | null |
|
|
|||||
pid | BIGINT | 19 | √ | null |
|
|
The internal patient identifier |
||||
user | VARCHAR | 255 | √ | null |
|
|
The user that created this record. |
||||
groupname | VARCHAR | 255 | √ | null |
|
|
The groupname that created this record. |
||||
TINYINT | 3 | √ | null |
|
|
||||||
activity | TINYINT | 3 | √ | null |
|
|
|||||
education | VARCHAR | 30 | √ | null |
|
|
|||||
disability | VARCHAR | 30 | √ | null |
|
|
|||||
housing | VARCHAR | 30 | √ | null |
|
|
|||||
housingotherinput | TEXT | 65535 | √ | null |
|
|
|||||
workfulltime | VARCHAR | 5 | √ | null |
|
|
|||||
workparttime | VARCHAR | 5 | √ | null |
|
|
|||||
worktemporary | VARCHAR | 5 | √ | null |
|
|
|||||
workseasonal | VARCHAR | 5 | √ | null |
|
|
|||||
worklooking | VARCHAR | 5 | √ | null |
|
|
|||||
workretired | VARCHAR | 5 | √ | null |
|
|
|||||
workdisabled | VARCHAR | 5 | √ | null |
|
|
|||||
workstudent | VARCHAR | 5 | √ | null |
|
|
|||||
worknotemployed | VARCHAR | 5 | √ | null |
|
|
|||||
worknotans | VARCHAR | 5 | √ | null |
|
|
|||||
workhours | INT | 10 | √ | null |
|
|
|||||
hhincome | INT | 10 | √ | null |
|
|
|||||
hhsize | INT | 10 | √ | null |
|
|
|||||
careno | VARCHAR | 5 | √ | null |
|
|
|||||
careunder5 | VARCHAR | 5 | √ | null |
|
|
|||||
care5to12 | VARCHAR | 5 | √ | null |
|
|
|||||
careover12 | VARCHAR | 5 | √ | null |
|
|
|||||
carespecneeds | VARCHAR | 5 | √ | null |
|
|
|||||
caredisabled | VARCHAR | 5 | √ | null |
|
|
|||||
careelderly | VARCHAR | 5 | √ | null |
|
|
|||||
careother | VARCHAR | 5 | √ | null |
|
|
|||||
careotherinput | TEXT | 65535 | √ | null |
|
|
|||||
debtno | VARCHAR | 5 | √ | null |
|
|
|||||
debtmedical | VARCHAR | 5 | √ | null |
|
|
|||||
debtcreditcards | VARCHAR | 5 | √ | null |
|
|
|||||
debtrent | VARCHAR | 5 | √ | null |
|
|
|||||
debtstudentloans | VARCHAR | 5 | √ | null |
|
|
|||||
debttaxes | VARCHAR | 5 | √ | null |
|
|
|||||
debtlegal | VARCHAR | 5 | √ | null |
|
|
|||||
debtcar | VARCHAR | 5 | √ | null |
|
|
|||||
debtutilities | VARCHAR | 5 | √ | null |
|
|
|||||
debtother | VARCHAR | 5 | √ | null |
|
|
|||||
debtotherinput | TEXT | 65535 | √ | null |
|
|
|||||
moneyno | VARCHAR | 5 | √ | null |
|
|
|||||
moneyfood | VARCHAR | 5 | √ | null |
|
|
|||||
moneymedical | VARCHAR | 5 | √ | null |
|
|
|||||
moneychildcare | VARCHAR | 5 | √ | null |
|
|
|||||
moneyutilities | VARCHAR | 5 | √ | null |
|
|
|||||
moneyphone | VARCHAR | 5 | √ | null |
|
|
|||||
moneyrent | VARCHAR | 5 | √ | null |
|
|
|||||
moneytransportation | VARCHAR | 5 | √ | null |
|
|
|||||
moneyclothing | VARCHAR | 5 | √ | null |
|
|
|||||
moneyeducation | VARCHAR | 5 | √ | null |
|
|
|||||
moneyother | VARCHAR | 5 | √ | null |
|
|
|||||
moneyotherinput | TEXT | 65535 | √ | null |
|
|
|||||
transportationno | VARCHAR | 5 | √ | null |
|
|
|||||
transportmedical | VARCHAR | 5 | √ | null |
|
|
|||||
transportfood | VARCHAR | 5 | √ | null |
|
|
|||||
transportwork | VARCHAR | 5 | √ | null |
|
|
|||||
transportschool | VARCHAR | 5 | √ | null |
|
|
|||||
transportfamily | VARCHAR | 5 | √ | null |
|
|
|||||
transportother | VARCHAR | 5 | √ | null |
|
|
|||||
transportotherinput | TEXT | 65535 | √ | null |
|
|
|||||
medicalno | VARCHAR | 5 | √ | null |
|
|
|||||
medicalnoinsurance | VARCHAR | 5 | √ | null |
|
|
|||||
medicalcopay | VARCHAR | 5 | √ | null |
|
|
|||||
medicalnotcovered | VARCHAR | 5 | √ | null |
|
|
|||||
medicalwork | VARCHAR | 5 | √ | null |
|
|
|||||
medicalnoprovider | VARCHAR | 5 | √ | null |
|
|
|||||
medicalunderstand | VARCHAR | 5 | √ | null |
|
|
|||||
medicaltrust | VARCHAR | 5 | √ | null |
|
|
|||||
medicalchildcare | VARCHAR | 5 | √ | null |
|
|
|||||
medicalother | VARCHAR | 5 | √ | null |
|
|
|||||
medicalotherinput | TEXT | 65535 | √ | null |
|
|
|||||
dentist | VARCHAR | 30 | √ | null |
|
|
|||||
dentistotherinput | TEXT | 65535 | √ | null |
|
|
|||||
VARCHAR | 30 | √ | null |
|
|
||||||
stress | VARCHAR | 30 | √ | null |
|
|
|||||
stressno | VARCHAR | 5 | √ | null |
|
|
|||||
stressdeath | VARCHAR | 5 | √ | null |
|
|
|||||
stressdivorce | VARCHAR | 5 | √ | null |
|
|
|||||
stressjob | VARCHAR | 5 | √ | null |
|
|
|||||
stressmoved | VARCHAR | 5 | √ | null |
|
|
|||||
stressillness | VARCHAR | 5 | √ | null |
|
|
|||||
stressvictim | VARCHAR | 5 | √ | null |
|
|
|||||
stresswitness | VARCHAR | 5 | √ | null |
|
|
|||||
stresslegal | VARCHAR | 5 | √ | null |
|
|
|||||
stresshomeless | VARCHAR | 5 | √ | null |
|
|
|||||
stressincarcerated | VARCHAR | 5 | √ | null |
|
|
|||||
stressbankruptcy | VARCHAR | 5 | √ | null |
|
|
|||||
stressmarriage | VARCHAR | 5 | √ | null |
|
|
|||||
stressbirth | VARCHAR | 5 | √ | null |
|
|
|||||
stressadultchild | VARCHAR | 5 | √ | null |
|
|
|||||
stressother | VARCHAR | 5 | √ | null |
|
|
|||||
stressotherinput | TEXT | 65535 | √ | null |
|
|
|||||
safety | VARCHAR | 30 | √ | null |
|
|
|||||
partnersafety | VARCHAR | 30 | √ | null |
|
|
|||||
female | VARCHAR | 30 | √ | null |
|
|
|||||
addiction | VARCHAR | 30 | √ | null |
|
|
|||||
armedservices | VARCHAR | 30 | √ | null |
|
|
|||||
refugee | VARCHAR | 30 | √ | null |
|
|
|||||
discrimno | VARCHAR | 5 | √ | null |
|
|
|||||
discrimrace | VARCHAR | 5 | √ | null |
|
|
|||||
discrimgender | VARCHAR | 5 | √ | null |
|
|
|||||
discrimsexpref | VARCHAR | 5 | √ | null |
|
|
|||||
discrimgenexp | VARCHAR | 5 | √ | null |
|
|
|||||
discrimreligion | VARCHAR | 5 | √ | null |
|
|
|||||
discrimdisability | VARCHAR | 5 | √ | null |
|
|
|||||
discrimage | VARCHAR | 5 | √ | null |
|
|
|||||
discrimweight | VARCHAR | 5 | √ | null |
|
|
|||||
discrimses | VARCHAR | 5 | √ | null |
|
|
|||||
discrimedu | VARCHAR | 5 | √ | null |
|
|
|||||
discrimmarital | VARCHAR | 5 | √ | null |
|
|
|||||
discrimcitizen | VARCHAR | 5 | √ | null |
|
|
|||||
discrimaccent | VARCHAR | 5 | √ | null |
|
|
|||||
discrimcriminalhist | VARCHAR | 5 | √ | null |
|
|
|||||
discrimother | VARCHAR | 5 | √ | null |
|
|
|||||
discrimotherinput | TEXT | 65535 | √ | null |
|
|
|||||
displaceno | VARCHAR | 5 | √ | null |
|
|
|||||
displacework | VARCHAR | 5 | √ | null |
|
|
|||||
displacehousing | VARCHAR | 5 | √ | null |
|
|
|||||
displacehealth | VARCHAR | 5 | √ | null |
|
|
|||||
displacelaw | VARCHAR | 5 | √ | null |
|
|
|||||
displaceedu | VARCHAR | 5 | √ | null |
|
|
|||||
displacepublic | VARCHAR | 5 | √ | null |
|
|
|||||
displaceclubs | VARCHAR | 5 | √ | null |
|
|
|||||
displacegovt | VARCHAR | 5 | √ | null |
|
|
|||||
displacefinance | VARCHAR | 5 | √ | null |
|
|
|||||
displaceother | VARCHAR | 5 | √ | null |
|
|
|||||
displaceotherinput | TEXT | 65535 | √ | null |
|
|
|||||
contact | VARCHAR | 30 | √ | null |
|
|
|||||
contactotherinput | TEXT | 65535 | √ | null |
|
|
|||||
additional_notes | LONGTEXT | 2147483647 | √ | null |
|
|
|||||
totalscore | INT | 10 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |