doc_folder Table (281)
•
Environment: onsite, online
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.