Class DocFolderTableInfo
Table 'doc_folder': A document folder.
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("doc_folder")]
public class DocFolderTableInfo : 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 TablesInfo.GetDocFolderInfo().
Fields
DictionaryTableName
Conceptual name of table DocFolder in the database dictionary: doc_folder
Declaration
public const string DictionaryTableName = "doc_folder"
Field Value
Type | Description |
---|---|
string |
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 TablesInfo.GetDocFolderInfo().
Properties
AccessLevel
Field 'access_level' in table 'doc_folder': Dictionary type Enum, .NET type: short
The access level for the folderDeclaration
public UInt16FieldInfo AccessLevel { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetDocFolderInfo().
CreatedAt
Field 'created_at' in table 'doc_folder': Dictionary type DateTime, .NET type: DateTime
When the folder was created.Declaration
public DateTimeFieldInfo CreatedAt { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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 TablesInfo.GetDocFolderInfo().
CreatedBy
Field 'created_by' in table 'doc_folder': Dictionary type FK, target: Ejuser, .NET type: int
The used who created the folder.Declaration
public Int32FieldInfo CreatedBy { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetDocFolderInfo().
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> |
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 TablesInfo.GetDocFolderInfo().
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
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 TablesInfo.GetDocFolderInfo().
DictionaryTableNumber
Table number for table DocFolder 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 |
---|---|
int |
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 TablesInfo.GetDocFolderInfo().
DocFolderId
Field 'id' in table 'doc_folder': Dictionary type PK, .NET type: int
The primary id (auto-incremented)Declaration
public Int32FieldInfo DocFolderId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetDocFolderInfo().
FolderId
Field 'folder_id' in table 'doc_folder': Dictionary type FK, target: DocFolder, .NET type: int
The parent folder. -1 if this is a root folder.Declaration
public Int32FieldInfo FolderId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 TablesInfo.GetDocFolderInfo().
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> |
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 TablesInfo.GetDocFolderInfo().
Fullname
Field 'fullname' in table 'doc_folder': Dictionary type Clob, .NET type: string
The full name of this category, i.e. Foo/bar/test.Declaration
public StringFieldInfo Fullname { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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 TablesInfo.GetDocFolderInfo().
InheritedAccessLevel
Field 'inherited_access_level' in table 'doc_folder': Dictionary type Enum, .NET type: short
The lowest access level for this folder or any parentDeclaration
public UInt16FieldInfo InheritedAccessLevel { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetDocFolderInfo().
LeftOuterJoin_DocDocument_FolderId
Generated left outer join from the primary key DocFolderId on this table, to DocDocument.FolderId.
Declaration
public TargetedLeftOuterJoin<DocDocumentTableInfo> LeftOuterJoin_DocDocument_FolderId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<DocDocumentTableInfo> |
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 TablesInfo.GetDocFolderInfo().
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 |
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 TablesInfo.GetDocFolderInfo().
Status
Field 'status' in table 'doc_folder': Dictionary type Enum, .NET type: short
The status of the folder.Declaration
public UInt16FieldInfo Status { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
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 TablesInfo.GetDocFolderInfo().
Title
Field 'title' in table 'doc_folder': Dictionary type String[256], .NET type: string
The title of the folderDeclaration
public StringFieldInfo Title { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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 TablesInfo.GetDocFolderInfo().