Table empire.EMPIRE3.NATIONS 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
NATIONNUM integer 10
BATTLEMAIL.ATTACKER FKF1378AAF2C940087 R
BATTLEMAIL.DEFENDER FKF1378AAF33137975 R
ISLANDKNOWLEDGEKEY.NATION_NATIONNUM FK2D5B97D6EC9AD779 R
ISLANDS.NAMINGNATION FKE003E0DE45706161 R
MAIL.FROMNATION FK2479D7BA1FF703 R
MAIL.TONATION FK2479D7CF95CD14 R
NATIONWARNATION.FROMNATION_NATIONNUM FK909900A8608A5B23 R
NATIONWARNATION.TONATION_NATIONNUM FK909900A8F85C8FF4 R
NEWS.SENDER FK24FEF3D67791C7 R
SECTORS.OWNER FKD8A82DAD12CB6A45 R
SHIPS.OWNER_ID FK4C27D976F9915B9 R
ISLANDSON integer 10
LASTLOGON double 52  √  null
LASTREADNEWSDATE double 52  √  null
MATERIEL integer 10
NAME varchar 52  √  null
NUMSHIPS integer 10
PASSWORD varchar 52  √  null
POPULATION integer 10
POWER integer 10
POWERDATE double 52  √  null
SEAPOWER integer 10
NATIONSTATE varchar 25  √  null
TOTALSECTORS integer 10
VERSION integer 10
CENTERX integer 10  √  null
CENTERY integer 10  √  null
HOMEISLAND integer 10
ISLANDS.ISLANDNUM FKCA4031EC5FD4AE14 R

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

Indexes:
Column(s) Type Sort Constraint Name
NATIONNUM Primary key Asc SQL100929185447800
HOMEISLAND Performance Asc SQL100929185448830

Close relationships: