| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| ID |
integer |
10 |
|
√ |
AUTOINCREMENT: start 1 increment 1 |
|
|
| AIRCRAFT |
integer |
10 |
|
|
|
|
|
| ATTACKTYPE |
varchar |
255 |
√ |
|
null |
|
|
| BOMBERSLOST |
integer |
10 |
|
|
|
|
|
| BOMBS |
integer |
10 |
|
|
|
|
|
| CAPITOLSACKED |
smallint |
5 |
|
|
|
|
|
| CASUALTIES |
integer |
10 |
|
|
|
|
|
| CIVILIANSCAPTURED |
integer |
10 |
|
|
|
|
|
| DEPTHCHARGES |
integer |
10 |
|
|
|
|
|
| ENEMYCASUALTIES |
integer |
10 |
|
|
|
|
|
| FIGHTERSKILLED |
integer |
10 |
|
|
|
|
|
| FIGHTERSLOST |
integer |
10 |
|
|
|
|
|
| FROMX |
integer |
10 |
√ |
|
null |
|
|
| FROMY |
integer |
10 |
√ |
|
null |
|
|
| MATERIELCAPTURED |
integer |
10 |
|
|
|
|
|
| MINES |
integer |
10 |
|
|
|
|
|
| NUMSECTORS |
integer |
10 |
|
|
|
|
|
| PRODUCTIONLOST |
integer |
10 |
√ |
|
null |
|
|
| SHELLS |
integer |
10 |
|
|
|
|
|
| SHIPNUM |
integer |
10 |
|
|
|
|
|
| SHIPTYPE |
integer |
10 |
√ |
|
null |
|
|
| SHIPSCAPTURED |
integer |
10 |
√ |
|
null |
|
|
| SHIPSLOST |
integer |
10 |
√ |
|
null |
|
|
| SHIPSSUNK |
integer |
10 |
√ |
|
null |
|
|
| TIME |
double |
52 |
|
|
|
|
|
| TOX |
integer |
10 |
√ |
|
null |
|
|
| TOY |
integer |
10 |
√ |
|
null |
|
|
| TORPEDOES |
integer |
10 |
|
|
|
|
|
| WON |
smallint |
5 |
|
|
|
|
|
| SHIPX |
integer |
10 |
√ |
|
null |
|
|
| SHIPY |
integer |
10 |
√ |
|
null |
|
|
| ATTACKER |
integer |
10 |
|
|
|
|
| NATIONS.NATIONNUM
|
FKF1378AAF2C940087 R |
|
| DEFENDER |
integer |
10 |
|
|
|
|
| NATIONS.NATIONNUM
|
FKF1378AAF33137975 R |
|
| FROMISLAND |
integer |
10 |
√ |
|
null |
|
| ISLANDS.ISLANDNUM
|
FKF1378AAFAB034C9F R |
|
| TOISLAND |
integer |
10 |
√ |
|
null |
|
| ISLANDS.ISLANDNUM
|
FKF1378AAFC07922B0 R |
|
Table contained 0 rows at Mon Oct 04 15:46 PDT 2010
|
