facility_user_ids

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
id	BIGINT	19		√	null

|

| | | uid | BIGINT | 19 | √ | | NULL |

|

| | | facility_id | BIGINT | 19 | √ | | NULL |

|

| | | uuid | BINARY | 16 | √ | | NULL |

|

| | | field_id | VARCHAR | 31 | | | null |

|

|

references layout_options.field_id

| | field_value | TEXT | 65535 | √ | | NULL |

|

| | | date_created | DATETIME | 19 | | | current_timestamp() |

|

| | | last_updated | DATETIME | 19 | | | current_timestamp() |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
uid	Performance	Asc/Asc/Asc	uid + facility_id + field_id
uuid	Performance	Asc	uuid

Relationships

Close relationships within degrees of separation