SchemaSpy Analysis of empire.EMPIRE3 - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Oct 04 15:46 PDT 2010
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

empire.EMPIRE3 contains 151 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
MAIL MESSAGE clob 32767  √  null
NEWS TEXT clob 32767  √  null
SECTORS CIVILIANS double 52
SHIPS COURSESYNC double 52
CONFIGDATA DATEINCREMENT double 52
CONFIGDATA DATEOFFSET double 52
ISLANDS DISCOVERED double 52  √  null
CONFIGDATA GAMEENDDATE double 52
CONFIGDATA LASTCENSUSDATE double 52
NATIONS LASTLOGON double 52  √  null
NATIONS LASTREADNEWSDATE double 52  √  null
SHIPS LASTUPDATED double 52
CONFIGDATA NEWSMANINCREMENT double 52
SECTORS ORE double 52
SHIPS ORE double 52
NATIONS POWERDATE double 52  √  null
CONFIGDATA SHIPDAYLENGTH double 52
SHIPS SPEED double 52
BATTLEMAIL TIME double 52
NEWS TIME double 52
SECTORS TIMELEFT double 52  √  null
MAIL TIMESENT double 52
SHIPS TIMESYNC double 52
BATTLEMAIL AIRCRAFT integer 10
SHIPS ARTILLERY integer 10
BATTLEMAIL ATTACKER integer 10
SECTORS AUTHORIZED integer 10
SECTORS BOMBERS integer 10
SHIPS BOMBERS integer 10
BATTLEMAIL BOMBERSLOST integer 10
BATTLEMAIL BOMBS integer 10
BATTLEMAIL CASUALTIES integer 10
NATIONS CENTERX integer 10  √  null
NATIONS CENTERY integer 10  √  null
SHIPS CIVILIANS integer 10
BATTLEMAIL CIVILIANSCAPTURED integer 10
BATTLEMAIL DEFENDER integer 10
BATTLEMAIL DEPTHCHARGES integer 10
SECTORS DES integer 10
SHIPS DESTX integer 10
SHIPS DESTY integer 10
SECTORS EFF integer 10
SHIPS EFF integer 10
BATTLEMAIL ENEMYCASUALTIES integer 10
SHIPS EXPLOSIVES integer 10
SECTORS FIGHTERS integer 10
SHIPS FIGHTERS integer 10
BATTLEMAIL FIGHTERSKILLED integer 10
BATTLEMAIL FIGHTERSLOST integer 10
SHIPS FLEET integer 10
BATTLEMAIL FROMISLAND integer 10  √  null
MAIL FROMNATION integer 10
NATIONWARNATION FROMNATION_NATIONNUM integer 10  √  null
BATTLEMAIL FROMX integer 10  √  null
BATTLEMAIL FROMY integer 10  √  null
CONFIGDATA GAMESTATE integer 10
SECTORS GUNS integer 10
CONFIGDATA GUNSCOST integer 10
CONFIGDATA HIGHESTNATIONNUMUSED integer 10
CONFIGDATA HIGHESTSHIPNUMUSED integer 10
NATIONS HOMEISLAND integer 10
BATTLEMAIL ID integer 10  √  AUTOINCREMENT: start 1 increment 1
CONFIGDATA ID integer 10
ISLANDKNOWLEDGEKEY ID integer 10  √  AUTOINCREMENT: start 1 increment 1
MAIL ID integer 10  √  AUTOINCREMENT: start 1 increment 1
NATIONWARNATION ID integer 10
NEWS ID integer 10  √  AUTOINCREMENT: start 1 increment 1
SECTORS ISLAND integer 10
ISLANDKNOWLEDGEKEY ISLAND_ISLANDNUM integer 10  √  null
ISLANDS ISLANDNUM integer 10
NATIONS ISLANDSON integer 10
ISLANDKNOWLEDGEKEY KNOWLEDGE integer 10  √  null
SHIPS LOCATIONSTATUS integer 10
SHIPS LOCX integer 10
SHIPS LOCY integer 10
SHIPS MAPKEY integer 10  √  null
NATIONS MATERIEL integer 10
BATTLEMAIL MATERIELCAPTURED integer 10
SECTORS MILITARY integer 10
SHIPS MILITARY integer 10
BATTLEMAIL MINES integer 10
ISLANDS NAMINGNATION integer 10  √  null
ISLANDKNOWLEDGEKEY NATION_NATIONNUM integer 10  √  null
NATIONS NATIONNUM integer 10
CONFIGDATA NUMISLANDS integer 10
BATTLEMAIL NUMSECTORS integer 10
NATIONS NUMSHIPS integer 10
SECTORS ORESAMPLE integer 10
SECTORS OWNER integer 10  √  null
SHIPS OWNER_ID integer 10
NATIONS POPULATION integer 10
NATIONS POWER integer 10
SECTORS PRODUCTION integer 10
BATTLEMAIL PRODUCTIONLOST integer 10  √  null
SHIPS RUST integer 10
ISLANDS SANCTUARIES integer 10
NATIONS SEAPOWER integer 10
CONFIGDATA SECTORSPERSANCTUARY integer 10
NEWS SENDER integer 10
BATTLEMAIL SHELLS integer 10
SECTORS SHELLS integer 10
CONFIGDATA SHELLSCOST integer 10
BATTLEMAIL SHIPNUM integer 10
SHIPS SHIPNUM integer 10
BATTLEMAIL SHIPSCAPTURED integer 10  √  null
BATTLEMAIL SHIPSLOST integer 10  √  null
BATTLEMAIL SHIPSSUNK integer 10  √  null
BATTLEMAIL SHIPTYPE integer 10  √  null
BATTLEMAIL SHIPX integer 10  √  null
BATTLEMAIL SHIPY integer 10  √  null
ISLANDS SIZEX integer 10
ISLANDS SIZEY integer 10
CONFIGDATA STARTINGTIMEUNITS integer 10
SHIPS STATE integer 10
SECTORS TIMERIGHT integer 10
BATTLEMAIL TOISLAND integer 10  √  null
MAIL TONATION integer 10
NATIONWARNATION TONATION_NATIONNUM integer 10  √  null
BATTLEMAIL TORPEDOES integer 10
NATIONS TOTALSECTORS integer 10
BATTLEMAIL TOX integer 10  √  null
BATTLEMAIL TOY integer 10  √  null
ISLANDS VERSION integer 10
NATIONS VERSION integer 10
SHIPS VERSION integer 10
CONFIGDATA WORLDX integer 10
CONFIGDATA WORLDY integer 10
ISLANDS X integer 10
SECTORS X integer 10
ISLANDS Y integer 10
SECTORS Y integer 10
SHIPS AUTOASSAULT smallint 5
BATTLEMAIL CAPITOLSACKED smallint 5
SHIPS COURSESET smallint 5
SHIPS DOCKED smallint 5
SHIPS NEWLYCREATED smallint 5
SHIPS SUBMERGED smallint 5
BATTLEMAIL WON smallint 5
NEWS TOPIC varchar 15  √  null
NATIONWARNATION WARSTATUS varchar 15  √  null
NATIONS NATIONSTATE varchar 25  √  null
ISLANDS STATE varchar 25  √  null
SHIPS TYPE varchar 25  √  null
ISLANDS NAME varchar 52  √  null
NATIONS NAME varchar 52  √  null
NATIONS PASSWORD varchar 52  √  null
CONFIGDATA ADMINPASSWORD varchar 255  √  null
BATTLEMAIL ATTACKTYPE varchar 255  √  null
MAIL STATUS varchar 255  √  null
MAIL SUBJECT varchar 255  √  null
CONFIGDATA VERSION varchar 255  √  null