Class ProjectTableInfo

Table 'project': Projects

Inheritance
Object
TableInfo
ProjectTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("project")]
public class ProjectTableInfo : 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 Project in the database dictionary: project

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

Properties

Field 'activeErpLinks' in table 'project': Dictionary type Int, .NET type: Int32

The number of Erp Sync connections this record is synced with; count of the ErpExternalKey+ErpInternalKey relations

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

Field 'activeLinks' in table 'project': Dictionary type UInt, .NET type: UInt32

Number of active links to documents, other appointments, and such

Declaration
public FieldInfo ActiveLinks { get; }
Property Value
Type Description
FieldInfo

AssociateId

Field 'associate_id' in table 'project': Dictionary type FK, .NET type: Int32

Project manager/owner

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

AssociateId_InnerJoin_Associate

Generated join from the foreign key AssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> AssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

DictionaryTableNumber

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

Done

Field 'done' in table 'project': Dictionary type Bool, .NET type: Int16

Done (0=false, 1=true). Status implies changes in which fields are shown in GUI, as well as which fields can be updated

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

EndDate

Field 'endDate' in table 'project': Dictionary type DateTime, .NET type: DateTime

Planned end date for project, inhertied from type and later editable

Declaration
public DateTimeFieldInfo EndDate { get; }
Property Value
Type Description
DateTimeFieldInfo

GroupId

Field 'group_id' in table 'project': Dictionary type FK, .NET type: Int32

Group id of original owning associate, semantics like appnt.grp_id

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

GroupId_InnerJoin_UserGroup

Generated join from the foreign key GroupId in this table, to its target table UserGroupTableInfo.

Declaration
public TargetedInnerJoin<UserGroupTableInfo> GroupId_InnerJoin_UserGroup { get; }
Property Value
Type Description
TargetedInnerJoin<UserGroupTableInfo>

LeftOuterJoin_Appointment_ProjectId

Generated left outer join from the primary key ProjectId on this table, to Appointment.ProjectId.

Declaration
public TargetedLeftOuterJoin<AppointmentTableInfo> LeftOuterJoin_Appointment_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<AppointmentTableInfo>

LeftOuterJoin_ChatSession_ProjectId

Generated left outer join from the primary key ProjectId on this table, to ChatSession.ProjectId.

Declaration
public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatSessionTableInfo>

LeftOuterJoin_CounterValue_ProjectId

Generated left outer join from the primary key ProjectId on this table, to CounterValue.ProjectId.

Declaration
public TargetedLeftOuterJoin<CounterValueTableInfo> LeftOuterJoin_CounterValue_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<CounterValueTableInfo>

LeftOuterJoin_Email_ProjectId

Generated left outer join from the primary key ProjectId on this table, to Email.ProjectId.

Declaration
public TargetedLeftOuterJoin<EmailTableInfo> LeftOuterJoin_Email_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EmailTableInfo>

LeftOuterJoin_ProjectMember_ProjectId

Generated left outer join from the primary key ProjectId on this table, to ProjectMember.ProjectId.

Declaration
public TargetedLeftOuterJoin<ProjectMemberTableInfo> LeftOuterJoin_ProjectMember_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ProjectMemberTableInfo>

LeftOuterJoin_Sale_ProjectId

Generated left outer join from the primary key ProjectId on this table, to Sale.ProjectId.

Declaration
public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleTableInfo>

LeftOuterJoin_SaleHist_ProjectId

Generated left outer join from the primary key ProjectId on this table, to SaleHist.ProjectId.

Declaration
public TargetedLeftOuterJoin<SaleHistTableInfo> LeftOuterJoin_SaleHist_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SaleHistTableInfo>

Generated left outer join from the primary key ProjectId on this table, to SLink.AddProject.

Declaration
public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_AddProject { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SLinkTableInfo>

Generated left outer join from the primary key ProjectId on this table, to SLink.RemoveProject.

Declaration
public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_RemoveProject { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SLinkTableInfo>

Generated left outer join from the primary key ProjectId on this table, to SLink.TaskProject.

Declaration
public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_TaskProject { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SLinkTableInfo>

LeftOuterJoin_SShipment_ProjectId

Generated left outer join from the primary key ProjectId on this table, to SShipment.ProjectId.

Declaration
public TargetedLeftOuterJoin<SShipmentTableInfo> LeftOuterJoin_SShipment_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SShipmentTableInfo>

LeftOuterJoin_StatusValue_ProjectId

Generated left outer join from the primary key ProjectId on this table, to StatusValue.ProjectId.

Declaration
public TargetedLeftOuterJoin<StatusValueTableInfo> LeftOuterJoin_StatusValue_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<StatusValueTableInfo>

LeftOuterJoin_URL_ProjectId

Generated left outer join from the primary key ProjectId on this table, to URL.ProjectId.

Declaration
public TargetedLeftOuterJoin<URLTableInfo> LeftOuterJoin_URL_ProjectId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<URLTableInfo>

Name

Field 'name' in table 'project': Dictionary type String[220], .NET type: String

Project name

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

NextMilestoneDate

Field 'nextMilestoneDate' in table 'project': Dictionary type DateTime, .NET type: DateTime

Calculated date, reflects date of closest non-complete future milestone activity

Declaration
public DateTimeFieldInfo NextMilestoneDate { get; }
Property Value
Type Description
DateTimeFieldInfo

NmdAppointmentId

Field 'nmdAppointment_id' in table 'project': Dictionary type FK, .NET type: Int32

ID of appointment that "caused" the nextMilestoneDate, can be 0

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

NmdAppointmentId_InnerJoin_Appointment

Generated join from the foreign key NmdAppointmentId in this table, to its target table AppointmentTableInfo.

Declaration
public TargetedInnerJoin<AppointmentTableInfo> NmdAppointmentId_InnerJoin_Appointment { get; }
Property Value
Type Description
TargetedInnerJoin<AppointmentTableInfo>

PostitTextId

Field 'postitText_id' in table 'project': Dictionary type FK, .NET type: Int32

Paperclip text

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

PostitTextId_InnerJoin_Text

Generated join from the foreign key PostitTextId in this table, to its target table TextTableInfo.

Declaration
public TargetedInnerJoin<TextTableInfo> PostitTextId_InnerJoin_Text { get; }
Property Value
Type Description
TargetedInnerJoin<TextTableInfo>

ProjectId

Field 'project_id' in table 'project': Dictionary type PK, .NET type: Int32

Primary key

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

ProjectNumber

Field 'project_number' in table 'project': Dictionary type String[50], .NET type: String

Automatically generated number

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

Registered

Field 'registered' in table 'project': Dictionary type UtcDateTime, .NET type: DateTime

Registered date

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'project': Dictionary type FK, .NET type: Int32

Registered by whom

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

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

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

SoundEx

Field 'soundEx' in table 'project': Dictionary type String[10], .NET type: String

What the name sounds like, for duplicate detection

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

Source

Field 'source' in table 'project': Dictionary type UShort, .NET type: Int16

How did we get this project? For future integration needs

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

StatusIdx

Field 'status_idx' in table 'project': Dictionary type FK, .NET type: Int32

Link to ProjStatus list

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

StatusIdx_InnerJoin_ProjStatus

Generated join from the foreign key StatusIdx in this table, to its target table ProjStatusTableInfo.

Declaration
public TargetedInnerJoin<ProjStatusTableInfo> StatusIdx_InnerJoin_ProjStatus { get; }
Property Value
Type Description
TargetedInnerJoin<ProjStatusTableInfo>

TextId

Field 'text_id' in table 'project': Dictionary type FK, .NET type: Int32

Description field

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

TextId_InnerJoin_Text

Generated join from the foreign key TextId in this table, to its target table TextTableInfo.

Declaration
public TargetedInnerJoin<TextTableInfo> TextId_InnerJoin_Text { get; }
Property Value
Type Description
TargetedInnerJoin<TextTableInfo>

TypeIdx

Field 'type_idx' in table 'project': Dictionary type FK, .NET type: Int32

Link to ProjType list

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

TypeIdx_InnerJoin_ProjType

Generated join from the foreign key TypeIdx in this table, to its target table ProjTypeTableInfo.

Declaration
public TargetedInnerJoin<ProjTypeTableInfo> TypeIdx_InnerJoin_ProjType { get; }
Property Value
Type Description
TargetedInnerJoin<ProjTypeTableInfo>

TzLocationId

Field 'tzLocationId' in table 'project': Dictionary type FK, .NET type: Int32

Default timezone location for this project

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

TzLocationId_InnerJoin_TZLocation

Generated join from the foreign key TzLocationId in this table, to its target table TZLocationTableInfo.

Declaration
public TargetedInnerJoin<TZLocationTableInfo> TzLocationId_InnerJoin_TZLocation { get; }
Property Value
Type Description
TargetedInnerJoin<TZLocationTableInfo>

Updated

Field 'updated' in table 'project': Dictionary type UtcDateTime, .NET type: DateTime

Last updated date

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'project': Dictionary type FK, .NET type: Int32

Last updated by whom

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

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 'project': Dictionary type UShort, .NET type: Int16

Number of updates made to this record

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

Userdef2Id

Field 'userdef2_id' in table 'project': Dictionary type FK, .NET type: Int32

User defined table record 2

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

Userdef2Id_InnerJoin_UDProjectLarge

Generated join from the foreign key Userdef2Id in this table, to its target table UDProjectLargeTableInfo.

Declaration
public TargetedInnerJoin<UDProjectLargeTableInfo> Userdef2Id_InnerJoin_UDProjectLarge { get; }
Property Value
Type Description
TargetedInnerJoin<UDProjectLargeTableInfo>

UserdefId

Field 'userdef_id' in table 'project': Dictionary type FK, .NET type: Int32

Pointer to userdef small table

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

UserdefId_InnerJoin_UDProjectSmall

Generated join from the foreign key UserdefId in this table, to its target table UDProjectSmallTableInfo.

Declaration
public TargetedInnerJoin<UDProjectSmallTableInfo> UserdefId_InnerJoin_UDProjectSmall { get; }
Property Value
Type Description
TargetedInnerJoin<UDProjectSmallTableInfo>

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)