Sector

Sectors are the primary mechanism for the economic classification of the Instruments that are modelled in the system. A Sector is a collection of Instruments that usually share a common underlying economic characteristic that makes grouping them convenient for a number of purposes.

Section: Products

Metadata

Base Table Class: Static
Default Size: 1000

Fields

Name	Type	Size (bytes)	Description
Id	Integer (signed)	8	The unique identifier of this Sector. Not editable Read-only
Status	Set of Status	4
ShortName	String	24	The short text identifier of this Sector. Required
Name	String	48	The long text identifier of this Sector. Required
Industry	Foreign key to Industry	8	Industries are a part of the mechanism for the economic classification of the Instruments that are modelled in the system. An Industry is a collection of Sectors and an arbitrary number of sectors may be placed within an Industry. Required
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 Sector.
OwnerGroup	Foreign key to Group	8	The Id of the Group that owns this Sector.
OwnerFirm	Foreign key to Firm	8	The Id of the Firm that owns this Sector.
CreateUser	Foreign key to User	8	The Id of the User that created this Sector. Not editable Read-only
CreateTimestamp	Integer (unsigned)	8	The time at which this Sector was created. Not editable Read-only
UpdateUser	Foreign key to User	8	The Id of the User that last updated this Sector. Not editable Read-only
UpdateTimestamp	Integer (unsigned)	8	The time at which this Sector was last updated. Not editable Read-only

Foreign Keys

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

graph LR;
	Instrument-->|Sector|Sector
	click Instrument "/marketgrid/developer/model/tables/Instrument"
	InstrumentMarket-->|Sector|Sector
	click InstrumentMarket "/marketgrid/developer/model/tables/InstrumentMarket"