doc_folder Table (281)
Some tooltip text!
• 1 minute to read
• 1 minute to read
A document folder.
Fields
Name | Description | Type | Null |
---|---|---|---|
id | The primary id (auto-incremented) | PK | |
folder_id | The parent folder. -1 if this is a root folder. | FK doc_folder | |
title | The title of the folder | String(255) | |
created_at | When the folder was created. | DateTime | ● |
created_by | The used who created the folder. | FK ejuser | ● |
status | The status of the folder. | status | ● |
access_level | The access level for the folder | access_level | ● |
inherited_access_level | The lowest access level for this folder or any parent | inherited_access_level | ● |
fullname | The full name of this category, i.e. Foo/bar/test. | Clob | ● |
Indexes
Fields | Types | Description |
---|---|---|
id | PK | Clustered, Unique |
folder_id | FK | Index |
title | String(255) | Index |
created_by | FK | Index |
Relationships
Table | Description |
---|---|
doc_document | This table contains documents. |
doc_folder | A document folder. |
ejuser | This table contains entries for the users of the system. |
Replication Flags
- None
Security Flags
- No access control via user's Role.