• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

doc_document Table (280)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

This table contains documents.

Fields

Name Description Type Null
id The primary key (auto-incremented) PK
folder_id The id of the document folder this entry is located in. FK doc_folder
attachment_id The attachment.id for the attachment associated with this document. FK attachment
title The title for the document String(255)
created_at When the document was created DateTime ●
created_by Who created the document FK ejuser
last_changed When the document last was changed DateTime ●
changed_by Who last changed the document FK ejuser ●
status The status of the document status ●
access_level The access level of the document access_level ●
description A descriptive text for the document Clob ●
id_string A field for an id_string which may be used to access the document String(255)

doc_document table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
folder_id FK Index
attachment_id FK Index
title String(255) Index
created_by FK Index
changed_by FK Index

Relationships

Table Description
attachment This table contains metadata for attachments. The actual attachments are stored directly on disk, with filenames based on the the primary key for this table.
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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top