users_facility


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of users_facility.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

joins users or patient_data to facility table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
tablename VARCHAR 64 null
table_id INT 10 null
facility_id INT 10 null
warehouse_id VARCHAR 31 ''

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc/Asc tablename + table_id + facility_id + warehouse_id

Relationships

Close relationships within degrees of separation