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