Venue

A Venue is a collection of Markets. It is a way of grouping markets into a single entity to represent an exchange or other market operator that is responsible for more than a single Market. Markets are grouped by Venue, each Market belonging to one Venue.

Metadata

  • Base Table Class: Static
  • Default Size: 100

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this Venue.
StatusSet of Status4
ShortNameString24The short text identifier of this Venue.
NameString48The long text identifier of this Venue.
TimeZoneForeign key to TimeZone8This is a reference to the TimeZone table. It is keyed by the TimeZone column in this table to the Id column in the TimeZone table.
HighlightColourString6
WorkingStatusSet of Status4
ModeOne of SystemMode1
WorkingModeOne of SystemMode1
UpdateNumberInteger (unsigned)8A 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.
OwnerUserForeign key to User8The Id of the User that owns this Venue.
OwnerGroupForeign key to Group8The Id of the Group that owns this Venue.
OwnerFirmForeign key to Firm8The Id of the Firm that owns this Venue.
CreateUserForeign key to User8The Id of the User that created this Venue.
CreateTimestampInteger (unsigned)8The time at which this Venue was created.
UpdateUserForeign key to User8The Id of the User that last updated this Venue.
UpdateTimestampInteger (unsigned)8The time at which this Venue was last updated.

Foreign Keys

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

graph LR;
	Enterprise-->|Venue|Venue
	click Enterprise "/marketgrid/developer/model/tables/Enterprise"
	Market-->|Venue|Venue
	click Market "/marketgrid/developer/model/tables/Market"
← UserName
VirtualReferenceNumber →