Table empire.EMPIRE3.SECTORS 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
X integer 10
Y integer 10
AUTHORIZED integer 10
BOMBERS integer 10
CIVILIANS double 52
DES integer 10
EFF integer 10
FIGHTERS integer 10
GUNS integer 10
MILITARY integer 10
ORE double 52
ORESAMPLE integer 10
PRODUCTION integer 10
SHELLS integer 10
TIMELEFT double 52  √  null
TIMERIGHT integer 10
ISLAND integer 10
ISLANDS.ISLANDNUM FKD8A82DADBE9D1C75 R
OWNER integer 10  √  null
NATIONS.NATIONNUM FKD8A82DAD12CB6A45 R

Table contained 24,810 rows at Mon Oct 04 15:46 PDT 2010

Indexes:
Column(s) Type Sort Constraint Name
X + Y Primary key Asc/Asc SQL100929185447940
ISLAND Performance Asc SQL100929185448900
OWNER Performance Asc SQL100929185448990

Close relationships  within of separation: