Table empire.EMPIRE3.SHIPS 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
SHIPNUM integer 10
ARTILLERY integer 10
AUTOASSAULT smallint 5
BOMBERS integer 10
CIVILIANS integer 10
COURSESET smallint 5
COURSESYNC double 52
DESTX integer 10
DESTY integer 10
DOCKED smallint 5
EFF integer 10
EXPLOSIVES integer 10
FIGHTERS integer 10
FLEET integer 10
LASTUPDATED double 52
LOCX integer 10
LOCY integer 10
LOCATIONSTATUS integer 10
MILITARY integer 10
NEWLYCREATED smallint 5
ORE double 52
RUST integer 10
SPEED double 52
STATE integer 10
SUBMERGED smallint 5
TIMESYNC double 52
TYPE varchar 25  √  null
VERSION integer 10
OWNER_ID integer 10
NATIONS.NATIONNUM FK4C27D976F9915B9 R
MAPKEY integer 10  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
SHIPNUM Primary key Asc SQL100929185448010
OWNER_ID Performance Asc SQL100929185449070

Close relationships  within of separation: