dsi_source_attributes

Columns

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

|

| | | client_id | VARCHAR | 80 | | | null |

|

| | | list_id | VARCHAR | 100 | | | null |

|

| | | option_id | VARCHAR | 100 | | | null |

|

| | | clinical_rule_id | VARCHAR | 31 | √ | | NULL |

|

| | | source_value | TEXT | 65535 | √ | | NULL |

|

| | | created_by | BIGINT | 19 | √ | | NULL |

|

| | | last_updated_by | BIGINT | 19 | √ | | NULL |

|

| | | created_at | TIMESTAMP | 19 | | | current_timestamp() |

|

| | | last_updated_at | TIMESTAMP | 19 | | | current_timestamp() |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
list_id	Must be unique	Asc/Asc/Asc	list_id + option_id + client_id

Relationships

Close relationships within degrees of separation