Country

Section: Universal

Metadata

Base Table Class: Static
Default Size: 300

Fields

Name	Type	Size (bytes)	Description
Id	Integer (signed)	8	The unique identifier of this Country. Not editable Read-only
Status	Set of Status	4
ShortName	String	24	The short text identifier of this Country. Required
ShortCode	String	24	The short text identifier of this Country.
Name	String	48	The long text identifier of this Country. Required
Region	Foreign key to Region	8	This is a reference to the Region table. It is keyed by the Region column in this table to the Id column in the Region table. 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 Country.
OwnerGroup	Foreign key to Group	8	The Id of the Group that owns this Country.
OwnerFirm	Foreign key to Firm	8	The Id of the Firm that owns this Country.
CreateUser	Foreign key to User	8	The Id of the User that created this Country. Not editable Read-only
CreateTimestamp	Integer (unsigned)	8	The time at which this Country was created. Not editable Read-only
UpdateUser	Foreign key to User	8	The Id of the User that last updated this Country. Not editable Read-only
UpdateTimestamp	Integer (unsigned)	8	The time at which this Country was last updated. Not editable Read-only

Foreign Keys

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

graph LR;
	Enterprise-->|Country|Country
	click Enterprise "/marketgrid/developer/model/tables/Enterprise"
	Firm-->|Country|Country
	click Firm "/marketgrid/developer/model/tables/Firm"
	BankAccount-->|Country|Country
	click BankAccount "/marketgrid/developer/model/tables/BankAccount"
	Holding-->|Country|Country
	click Holding "/marketgrid/developer/model/tables/Holding"
	HoldingTransaction-->|Country|Country
	click HoldingTransaction "/marketgrid/developer/model/tables/HoldingTransaction"
	InstrumentMarket-->|Country|Country
	click InstrumentMarket "/marketgrid/developer/model/tables/InstrumentMarket"
	Order-->|Country|Country
	click Order "/marketgrid/developer/model/tables/Order"