ProjectType

Section: Carbon

Metadata

Base Table Class: Static
Default Size: 100

Fields

Name	Type	Size (bytes)	Description
Id	Integer (signed)	8	The unique identifier of this ProjectType. Not editable Read-only
Status	Set of Status	4
ShortName	String	24	The short text identifier of this ProjectType. Required
FullName	String	80	Required
RegistryCode	String	80
ParentId	Foreign key to ProjectType	8	This is a reference to the ProjectType table. It is keyed by the ParentId column in this table to the Id column in the ProjectType table.
UpdateNumber	Integer (unsigned)	8	A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record. Not editable
OwnerUser	Foreign key to User	8	The Id of the User that owns this ProjectType.
OwnerGroup	Foreign key to Group	8	The Id of the Group that owns this ProjectType.
OwnerFirm	Foreign key to Firm	8	The Id of the Firm that owns this ProjectType.
CreateUser	Foreign key to User	8	The Id of the User that created this ProjectType. Not editable Read-only
CreateTimestamp	Integer (unsigned)	8	The time at which this ProjectType was created. Not editable Read-only
UpdateUser	Foreign key to User	8	The Id of the User that last updated this ProjectType. Not editable Read-only
UpdateTimestamp	Integer (unsigned)	8	The time at which this ProjectType was last updated. Not editable Read-only

Foreign Keys

The following diagram shows the tables that have a foreign key link to the ProjectType table. All Table nodes can be clicked to take you to that table's definition page.

graph LR;
	Holding-->|ProjectType|ProjectType
	click Holding "/marketgrid/developer/model/tables/Holding"
	HoldingTransaction-->|ProjectType|ProjectType
	click HoldingTransaction "/marketgrid/developer/model/tables/HoldingTransaction"
	InstrumentMarket-->|ProjectType|ProjectType
	click InstrumentMarket "/marketgrid/developer/model/tables/InstrumentMarket"
	Order-->|ProjectType|ProjectType
	click Order "/marketgrid/developer/model/tables/Order"