Table empire.EMPIRE3.ISLANDS Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ISLANDNUM integer 10
BATTLEMAIL.FROMISLAND FKF1378AAFAB034C9F R
BATTLEMAIL.TOISLAND FKF1378AAFC07922B0 R
ISLANDKNOWLEDGEKEY.ISLAND_ISLANDNUM FK2D5B97D6268D3E07 R
NATIONS.HOMEISLAND FKCA4031EC5FD4AE14 R
SECTORS.ISLAND FKD8A82DADBE9D1C75 R
DISCOVERED double 52  √  null
X integer 10
Y integer 10
NAME varchar 52  √  null
SANCTUARIES integer 10
SIZEY integer 10
SIZEX integer 10
STATE varchar 25  √  null
VERSION integer 10
NAMINGNATION integer 10  √  null
NATIONS.NATIONNUM FKE003E0DE45706161 R

Table contained 40 rows at Mon Oct 04 15:46 PDT 2010

Indexes:
Column(s) Type Sort Constraint Name
ISLANDNUM Primary key Asc SQL100929185447710
NAMINGNATION Performance Asc SQL100929185448480

Close relationships  within of separation: