document_template_profiles

Columns

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

|

| | | template_id | BIGINT UNSIGNED | 20 | | | null |

|

| | | profile | VARCHAR | 64 | | | null |

|

| | | template_name | VARCHAR | 255 | | | null |

|

| | | category | VARCHAR | 64 | | | null |

|

| | | provider | INT UNSIGNED | 10 | √ | | NULL |

|

| | | modified_date | DATETIME | 19 | | | current_timestamp() |

|

| | | member_of | VARCHAR | 64 | | | null |

|

| | | active | BOOLEAN | 3 | | | 0 |

|

| | | recurring | BOOLEAN | 3 | | | 1 |

|

| | | event_trigger | VARCHAR | 31 | | | null |

|

| | | period | INT | 10 | | | null |

|

| | | notify_trigger | VARCHAR | 31 | | | null |

|

| | | notify_period | INT | 10 | | | null |

|

| |

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
location	Must be unique	Asc/Asc/Asc	profile + template_id + member_of

Relationships

Close relationships within degrees of separation