INTERCONNECTOR

INTERCONNECTOR sets out valid identifiers for each interconnector.

Package

MARKET_CONFIG

Visibility

Public

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
INTERCONNECTORID	varchar(10)	varchar(10)	Unique Id of this interconnector
REGIONFROM	varchar(10)	varchar(10)	Starting region of the interconnect
RSOID	varchar(10)	varchar(10)	Not used
REGIONTO	varchar(10)	varchar(10)	Ending region of the interconnect
DESCRIPTION	varchar(64)	varchar(64)	Description of interconnector
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
INTERCONNECTOR_LCX	nonclustered	LASTCHANGED
INTERCONNECTOR_PK	clustered, unique, primary key	INTERCONNECTORID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_INTERCONNECTOR_LASTCHANGED	nonclustered	LASTCHANGED
PK_INTERCONNECTOR	clustered, unique, primary key	INTERCONNECTORID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
INTERCONNECTOR_LCX	nonclustered	LASTCHANGED
INTERCONNECTOR_PK	clustered, unique, primary key	INTERCONNECTORID