SchemaSpy Analysis of empire.EMPIRE3 - Constraints Generated by
SchemaSpy
16 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
FK2479D7BA1FF703 MAIL.FROMNATION NATIONS.NATIONNUM Restrict delete 
FK2479D7CF95CD14 MAIL.TONATION NATIONS.NATIONNUM Restrict delete 
FK24FEF3D67791C7 NEWS.SENDER NATIONS.NATIONNUM Restrict delete 
FK2D5B97D6268D3E07 ISLANDKNOWLEDGEKEY.ISLAND_ISLANDNUM ISLANDS.ISLANDNUM Restrict delete 
FK2D5B97D6EC9AD779 ISLANDKNOWLEDGEKEY.NATION_NATIONNUM NATIONS.NATIONNUM Restrict delete 
FK4C27D976F9915B9 SHIPS.OWNER_ID NATIONS.NATIONNUM Restrict delete 
FK909900A8608A5B23 NATIONWARNATION.FROMNATION_NATIONNUM NATIONS.NATIONNUM Restrict delete 
FK909900A8F85C8FF4 NATIONWARNATION.TONATION_NATIONNUM NATIONS.NATIONNUM Restrict delete 
FKCA4031EC5FD4AE14 NATIONS.HOMEISLAND ISLANDS.ISLANDNUM Restrict delete 
FKD8A82DAD12CB6A45 SECTORS.OWNER NATIONS.NATIONNUM Restrict delete 
FKD8A82DADBE9D1C75 SECTORS.ISLAND ISLANDS.ISLANDNUM Restrict delete 
FKE003E0DE45706161 ISLANDS.NAMINGNATION NATIONS.NATIONNUM Restrict delete 
FKF1378AAF2C940087 BATTLEMAIL.ATTACKER NATIONS.NATIONNUM Restrict delete 
FKF1378AAF33137975 BATTLEMAIL.DEFENDER NATIONS.NATIONNUM Restrict delete 
FKF1378AAFAB034C9F BATTLEMAIL.FROMISLAND ISLANDS.ISLANDNUM Restrict delete 
FKF1378AAFC07922B0 BATTLEMAIL.TOISLAND ISLANDS.ISLANDNUM Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected