documents_legal_master

Columns

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
dlm_category	INT UNSIGNED	10	√		NULL

|

| | | dlm_subcategory | INT UNSIGNED | 10 | √ | | NULL |

|

| | | dlm_document_id | INT UNSIGNED | 10 | | √ | null |

|

| | | dlm_document_name | VARCHAR | 75 | | | null |

|

| | | dlm_filepath | VARCHAR | 75 | | | null |

|

| | | dlm_facility | INT UNSIGNED | 10 | √ | | NULL |

|

| | | dlm_provider | INT UNSIGNED | 10 | √ | | NULL |

|

| | | dlm_sign_height | DOUBLE | 22 | | | null |

|

| | | dlm_sign_width | DOUBLE | 22 | | | null |

|

| | | dlm_filename | VARCHAR | 45 | | | null |

|

| | | dlm_effective_date | DATETIME | 19 | | | null |

|

| | | dlm_version | INT UNSIGNED | 10 | | | null |

|

| | | content | VARCHAR | 255 | | | null |

|

| | | dlm_savedsign | VARCHAR | 255 | √ | | NULL |

|

|

0-Yes 1-No

| | dlm_review | VARCHAR | 255 | √ | | NULL |

|

|

0-Yes 1-No

| | dlm_upload_type | TINYINT | 3 | √ | | 0 |

|

|

0-Provider Uploaded,1-Patient Uploaded

|

Indexes

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	dlm_document_id

Relationships

Close relationships within degrees of separation