empire.EMPIRE3 contains 151 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
BATTLEMAIL	ID	integer	10		√	AUTOINCREMENT: start 1 increment 1
ISLANDKNOWLEDGEKEY	ID	integer	10		√	AUTOINCREMENT: start 1 increment 1
MAIL	ID	integer	10		√	AUTOINCREMENT: start 1 increment 1
NEWS	ID	integer	10		√	AUTOINCREMENT: start 1 increment 1
CONFIGDATA	ADMINPASSWORD	varchar	255	√		null
BATTLEMAIL	AIRCRAFT	integer	10
SHIPS	ARTILLERY	integer	10
BATTLEMAIL	ATTACKER	integer	10
BATTLEMAIL	ATTACKTYPE	varchar	255	√		null
SECTORS	AUTHORIZED	integer	10
SHIPS	AUTOASSAULT	smallint	5
SECTORS	BOMBERS	integer	10
SHIPS	BOMBERS	integer	10
BATTLEMAIL	BOMBERSLOST	integer	10
BATTLEMAIL	BOMBS	integer	10
BATTLEMAIL	CAPITOLSACKED	smallint	5
BATTLEMAIL	CASUALTIES	integer	10
NATIONS	CENTERX	integer	10	√		null
NATIONS	CENTERY	integer	10	√		null
SECTORS	CIVILIANS	double	52
SHIPS	CIVILIANS	integer	10
BATTLEMAIL	CIVILIANSCAPTURED	integer	10
SHIPS	COURSESET	smallint	5
SHIPS	COURSESYNC	double	52
CONFIGDATA	DATEINCREMENT	double	52
CONFIGDATA	DATEOFFSET	double	52
BATTLEMAIL	DEFENDER	integer	10
BATTLEMAIL	DEPTHCHARGES	integer	10
SECTORS	DES	integer	10
SHIPS	DESTX	integer	10
SHIPS	DESTY	integer	10
ISLANDS	DISCOVERED	double	52	√		null
SHIPS	DOCKED	smallint	5
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	GAMEENDDATE	double	52
CONFIGDATA	GAMESTATE	integer	10
SECTORS	GUNS	integer	10
CONFIGDATA	GUNSCOST	integer	10
CONFIGDATA	HIGHESTNATIONNUMUSED	integer	10
CONFIGDATA	HIGHESTSHIPNUMUSED	integer	10
NATIONS	HOMEISLAND	integer	10
CONFIGDATA	ID	integer	10
NATIONWARNATION	ID	integer	10
SECTORS	ISLAND	integer	10
ISLANDKNOWLEDGEKEY	ISLAND_ISLANDNUM	integer	10	√		null
ISLANDS	ISLANDNUM	integer	10
NATIONS	ISLANDSON	integer	10
ISLANDKNOWLEDGEKEY	KNOWLEDGE	integer	10	√		null
CONFIGDATA	LASTCENSUSDATE	double	52
NATIONS	LASTLOGON	double	52	√		null
NATIONS	LASTREADNEWSDATE	double	52	√		null
SHIPS	LASTUPDATED	double	52
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
MAIL	MESSAGE	clob	32767	√		null
SECTORS	MILITARY	integer	10
SHIPS	MILITARY	integer	10
BATTLEMAIL	MINES	integer	10
ISLANDS	NAME	varchar	52	√		null
NATIONS	NAME	varchar	52	√		null
ISLANDS	NAMINGNATION	integer	10	√		null
ISLANDKNOWLEDGEKEY	NATION_NATIONNUM	integer	10	√		null
NATIONS	NATIONNUM	integer	10
NATIONS	NATIONSTATE	varchar	25	√		null
SHIPS	NEWLYCREATED	smallint	5
CONFIGDATA	NEWSMANINCREMENT	double	52
CONFIGDATA	NUMISLANDS	integer	10
BATTLEMAIL	NUMSECTORS	integer	10
NATIONS	NUMSHIPS	integer	10
SECTORS	ORE	double	52
SHIPS	ORE	double	52
SECTORS	ORESAMPLE	integer	10
SECTORS	OWNER	integer	10	√		null
SHIPS	OWNER_ID	integer	10
NATIONS	PASSWORD	varchar	52	√		null
NATIONS	POPULATION	integer	10
NATIONS	POWER	integer	10
NATIONS	POWERDATE	double	52	√		null
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
CONFIGDATA	SHIPDAYLENGTH	double	52
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
SHIPS	SPEED	double	52
CONFIGDATA	STARTINGTIMEUNITS	integer	10
ISLANDS	STATE	varchar	25	√		null
SHIPS	STATE	integer	10
MAIL	STATUS	varchar	255	√		null
MAIL	SUBJECT	varchar	255	√		null
SHIPS	SUBMERGED	smallint	5
NEWS	TEXT	clob	32767	√		null
BATTLEMAIL	TIME	double	52
NEWS	TIME	double	52
SECTORS	TIMELEFT	double	52	√		null
SECTORS	TIMERIGHT	integer	10
MAIL	TIMESENT	double	52
SHIPS	TIMESYNC	double	52
BATTLEMAIL	TOISLAND	integer	10	√		null
MAIL	TONATION	integer	10
NATIONWARNATION	TONATION_NATIONNUM	integer	10	√		null
NEWS	TOPIC	varchar	15	√		null
BATTLEMAIL	TORPEDOES	integer	10
NATIONS	TOTALSECTORS	integer	10
BATTLEMAIL	TOX	integer	10	√		null
BATTLEMAIL	TOY	integer	10	√		null
SHIPS	TYPE	varchar	25	√		null
CONFIGDATA	VERSION	varchar	255	√		null
ISLANDS	VERSION	integer	10
NATIONS	VERSION	integer	10
SHIPS	VERSION	integer	10
NATIONWARNATION	WARSTATUS	varchar	15	√		null
BATTLEMAIL	WON	smallint	5
CONFIGDATA	WORLDX	integer	10
CONFIGDATA	WORLDY	integer	10
ISLANDS	X	integer	10
SECTORS	X	integer	10
ISLANDS	Y	integer	10
SECTORS	Y	integer	10