Class ExternalDocumentTableInfo

Table 'external_document': This table stores documents which can be viewed externaly, through the customer module

Inheritance
Object
TableInfo
ExternalDocumentTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("external_document")]
public class ExternalDocumentTableInfo : TableInfo, ICloneable
Remarks

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 ExternalDocument in the database dictionary: external_document

Declaration
public const string DictionaryTableName = "external_document"
Field Value
Type Description
String

Properties

AttachmentId

Field 'attachment_id' in table 'external_document': Dictionary type FK, .NET type: Int32

The attachment.id for the attachment associated with this external 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 'external_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 'external_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 'external_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

Deleted

Field 'deleted' in table 'external_document': Dictionary type Bool, .NET type: Int16

A boolean telling if the external document is to be treated as deleted

Declaration
public UInt16FieldInfo Deleted { get; }
Property Value
Type Description
UInt16FieldInfo

Description

Field 'description' in table 'external_document': Dictionary type Clob, .NET type: String

The description of the external document

Declaration
public StringFieldInfo Description { get; }
Property Value
Type Description
StringFieldInfo

DictionaryTableNumber

Table number for table ExternalDocument 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

ExternalDocumentId

Field 'id' in table 'external_document': Dictionary type PK, .NET type: Int32

Primary key

Declaration
public Int32FieldInfo ExternalDocumentId { get; }
Property Value
Type Description
Int32FieldInfo

HierarchyId

Field 'hierarchy_id' in table 'external_document': Dictionary type FK, .NET type: Int32

This document belongs to the following folder

Declaration
public Int32FieldInfo HierarchyId { get; }
Property Value
Type Description
Int32FieldInfo

HierarchyId_InnerJoin_Hierarchy

Generated join from the foreign key HierarchyId in this table, to its target table HierarchyTableInfo.

Declaration
public TargetedInnerJoin<HierarchyTableInfo> HierarchyId_InnerJoin_Hierarchy { get; }
Property Value
Type Description
TargetedInnerJoin<HierarchyTableInfo>

LastChanged

Field 'last_changed' in table 'external_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

SMessage

Field 's_message' in table 'external_document': Dictionary type FK, .NET type: Int32

Relation to s_message if this document is an image in a newsletter

Declaration
public Int32FieldInfo SMessage { get; }
Property Value
Type Description
Int32FieldInfo

SMessage_InnerJoin_SMessage

Generated join from the foreign key SMessage in this table, to its target table SMessageTableInfo.

Declaration
public TargetedInnerJoin<SMessageTableInfo> SMessage_InnerJoin_SMessage { get; }
Property Value
Type Description
TargetedInnerJoin<SMessageTableInfo>

Title

Field 'title' in table 'external_document': Dictionary type String[256], .NET type: String

The title for the document

Declaration
public StringFieldInfo Title { get; }
Property Value
Type Description
StringFieldInfo

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)