Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
Id | id | 18 | null |
|
|
Label: Document ID |
||||
FolderId | reference | 18 | null |
|
|
Label: Folder ID |
||||
IsDeleted | boolean | 0 | null |
|
|
Label: Deleted |
||||
Name | string | 255 | null |
|
|
Label: Document Name |
||||
DeveloperName | string | 80 | null |
|
|
Label: Document Unique Name |
||||
NamespacePrefix | string | 15 | null |
|
|
Label: Namespace Prefix |
||||
ContentType | string | 120 | null |
|
|
Label: MIME Type |
||||
Type | string | 40 | null |
|
|
Label: File Extension |
||||
IsPublic | boolean | 0 | null |
|
|
Label: Externally Available |
||||
BodyLength | int | 8 | null |
|
|
Label: Body Length |
||||
Body | base64 | 0 | null |
|
|
Label: Body |
||||
Url | string | 255 | null |
|
|
Label: Url |
||||
Description | textarea | 255 | null |
|
|
Label: Description |
||||
Keywords | string | 255 | null |
|
|
Label: Keywords |
||||
IsInternalUseOnly | boolean | 0 | null |
|
|
Label: Internal Use Only |
||||
AuthorId | reference | 18 | null |
|
|
Label: Author ID |
||||
CreatedDate | datetime | 0 | null |
|
|
Label: Created Date |
||||
CreatedById | reference | 18 | null |
|
|
Label: Created By ID |
||||
LastModifiedDate | datetime | 0 | null |
|
|
Label: Last Modified Date |
||||
LastModifiedById | reference | 18 | null |
|
|
Label: Last Modified By ID |
||||
SystemModstamp | datetime | 0 | null |
|
|
Label: System Modstamp |
||||
IsBodySearchable | boolean | 0 | null |
|
|
Label: Document Content Searchable |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
FakeIndex72 | Must be unique | Asc | Id |