The LibraryDocs table stores information about properties for each document or Web address URL that is in a Library folder. Documents and URLs are added to the Library folder using the Administrator. The information includes file name, directory ID of the folder, description, available status, revision date, expiration date, file size, and a flag is set if the file can be sent to Remotes. The Abstract field can contain up to a 1024-character comment about the file.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
FILEID (PK) |
STANDARDID(12) |
NOT NULL |
LIBRARYDOCS_FILEID_PK (CA) |
|
|
|
DIRID (FK) |
STANDARDID(12) |
NULLS |
LIBRARYDOCS_DIRID (IE) |
(Many) to (One) |
|
|
FILENAME |
varchar(255) |
NULLS |
|
|
|
|
DESCRIPTION |
varchar(255) |
NULLS |
|
|
|
|
FOUND |
BOOLEAN(1) |
NULLS |
|
|
|
|
ABSTRACT |
TEXTBLOB |
NULLS |
|
|
|
|
STATUS |
BOOLEAN(1) |
NULLS |
|
|
|
|
REVISIONDATE |
datetime(8) |
NULLS |
|
|
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
EXPIREDATE |
datetime(8) |
NULLS |
|
|
|
|
FLAGS |
int(4) |
NULLS |
|
|
|
|
FILESIZE |
int(4) |
NULLS |
|
|
|
|
EXPIRES |
char(1) |
NULLS |
|
|
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
| CREATESOURCE |
varchar(255) |
NULLS |