Class DocDocumentTableInfo
Table 'doc_document': This table contains documents.
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("doc_document")]
public class DocDocumentTableInfo : TableInfo, ICloneableRemarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Fields
DictionaryTableName
Conceptual name of table DocDocument in the database dictionary: doc_document
Declaration
public const string DictionaryTableName = "doc_document"Field Value
| Type | Description |
|---|---|
| String |
Properties
AccessLevel
Field 'access_level' in table 'doc_document': Dictionary type Enum, .NET type: Int16
The access level of the document
Declaration
public UInt16FieldInfo AccessLevel { get; }Property Value
| Type | Description |
|---|---|
| UInt16FieldInfo |
AttachmentId
Field 'attachment_id' in table 'doc_document': Dictionary type FK, .NET type: Int32
The attachment.id for the attachment associated with this document.
Declaration
public Int32FieldInfo AttachmentId { get; }Property Value
| Type | Description |
|---|---|
| Int32FieldInfo |
AttachmentId_InnerJoin_Attachment
Generated join from the foreign key AttachmentId in this table, to its target table AttachmentTableInfo.
Declaration
public TargetedInnerJoin<AttachmentTableInfo> AttachmentId_InnerJoin_Attachment { get; }Property Value
| Type | Description |
|---|---|
| TargetedInnerJoin<AttachmentTableInfo> |
ChangedBy
Field 'changed_by' in table 'doc_document': Dictionary type FK, .NET type: Int32
Who last changed the document
Declaration
public Int32FieldInfo ChangedBy { get; }Property Value
| Type | Description |
|---|---|
| Int32FieldInfo |
ChangedBy_InnerJoin_Ejuser
Generated join from the foreign key ChangedBy in this table, to its target table EjuserTableInfo.
Declaration
public TargetedInnerJoin<EjuserTableInfo> ChangedBy_InnerJoin_Ejuser { get; }Property Value
| Type | Description |
|---|---|
| TargetedInnerJoin<EjuserTableInfo> |
CreatedAt
Field 'created_at' in table 'doc_document': Dictionary type DateTime, .NET type: DateTime
When the document was created
Declaration
public DateTimeFieldInfo CreatedAt { get; }Property Value
| Type | Description |
|---|---|
| DateTimeFieldInfo |
CreatedBy
Field 'created_by' in table 'doc_document': Dictionary type FK, .NET type: Int32
Who created the document
Declaration
public Int32FieldInfo CreatedBy { get; }Property Value
| Type | Description |
|---|---|
| Int32FieldInfo |
CreatedBy_InnerJoin_Ejuser
Generated join from the foreign key CreatedBy in this table, to its target table EjuserTableInfo.
Declaration
public TargetedInnerJoin<EjuserTableInfo> CreatedBy_InnerJoin_Ejuser { get; }Property Value
| Type | Description |
|---|---|
| TargetedInnerJoin<EjuserTableInfo> |
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }Property Value
| Type | Description |
|---|---|
| SoTable |
Overrides
Description
Field 'description' in table 'doc_document': Dictionary type Clob, .NET type: String
A descriptive text for the document
Declaration
public StringFieldInfo Description { get; }Property Value
| Type | Description |
|---|---|
| StringFieldInfo |
DictionaryTableNumber
Table number for table DocDocument in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database
Declaration
public int DictionaryTableNumber { get; }Property Value
| Type | Description |
|---|---|
| Int32 |
DocDocumentId
Field 'id' in table 'doc_document': Dictionary type PK, .NET type: Int32
The primary key (auto-incremented)
Declaration
public Int32FieldInfo DocDocumentId { get; }Property Value
| Type | Description |
|---|---|
| Int32FieldInfo |
FolderId
Field 'folder_id' in table 'doc_document': Dictionary type FK, .NET type: Int32
The id of the document folder this entry is located in.
Declaration
public Int32FieldInfo FolderId { get; }Property Value
| Type | Description |
|---|---|
| Int32FieldInfo |
FolderId_InnerJoin_DocFolder
Generated join from the foreign key FolderId in this table, to its target table DocFolderTableInfo.
Declaration
public TargetedInnerJoin<DocFolderTableInfo> FolderId_InnerJoin_DocFolder { get; }Property Value
| Type | Description |
|---|---|
| TargetedInnerJoin<DocFolderTableInfo> |
IdString
Field 'id_string' in table 'doc_document': Dictionary type String[256], .NET type: String
A field for an id_string which may be used to access the document
Declaration
public StringFieldInfo IdString { get; }Property Value
| Type | Description |
|---|---|
| StringFieldInfo |
LastChanged
Field 'last_changed' in table 'doc_document': Dictionary type DateTime, .NET type: DateTime
When the document last was changed
Declaration
public DateTimeFieldInfo LastChanged { get; }Property Value
| Type | Description |
|---|---|
| DateTimeFieldInfo |
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }Property Value
| Type | Description |
|---|---|
| SoTable |
Status
Field 'status' in table 'doc_document': Dictionary type Enum, .NET type: Int16
The status of the document
Declaration
public UInt16FieldInfo Status { get; }Property Value
| Type | Description |
|---|---|
| UInt16FieldInfo |
Title
Field 'title' in table 'doc_document': Dictionary type String[256], .NET type: String
The title for the document
Declaration
public StringFieldInfo Title { get; }Property Value
| Type | Description |
|---|---|
| StringFieldInfo |