FORCEMAJEUREREGION (Historical table)

FORCEMAJEUREREGION used to set out regions impacted by a force majeure event. This table is not used.

Package

HISTORICAL_TABLES

Table schema

Column	Official MMS Datatype	GR-MMS Datatype	Comment
FMID	varchar(10)	varchar(10)	Force Majeure ID
REGIONID	varchar(10)	varchar(10)	Differentiates this region from all other regions
LASTCHANGED	datetime(3)	datetime2(0)	Last date and time record changed

Official MMS data model indexes

Index name	Index type	Index columns (in order)
FORCEMAJEUREREGION_LCX	nonclustered	LASTCHANGED
FORCEMAJEUREREGION_PK	clustered, unique, primary key	FMID, REGIONID

GR-MMS data model indexes

Index name	Index type	Index columns (in order)
IX_FORCEMAJEUREREGION_LASTCHANGED	nonclustered	LASTCHANGED
PK_FORCEMAJEUREREGION	clustered, unique, primary key	FMID, REGIONID

Historical-MMS data model indexes

Index name	Index type	Index columns (in order)
FORCEMAJEUREREGION_LCX	nonclustered	LASTCHANGED
FORCEMAJEUREREGION_PK	clustered, unique, primary key	FMID, REGIONID