Can anyone explain this? I used the DatabaseIO to read in a schema I just
generated. For some reason, it's trying to read the foreign key as a
column.
nAddressAlternateID - INTEGER
szFirstName - VARCHAR
szLastName - VARCHAR
szAddress1 - VARCHAR
szAddress2 - VARCHAR
szAddress3 - VARCHAR
szStateProv - VARCHAR
szPostalCode - VARCHAR
szCity - VARCHAR
nCountryFK - INTEGER
FK_tb_AddressAlternate_tb_Country - null
<table name="tb_AddressAlternate">
<column name="nAddressAlternateID" primaryKey="true" required="true"
type="INTEGER" size="10" autoIncrement="true"/>
<column name="szFirstName" primaryKey="false" required="true"
type="VARCHAR" size="32" autoIncrement="false"/>
<column name="szLastName" primaryKey="false" required="true"
type="VARCHAR" size="32" autoIncrement="false"/>
<column name="szAddress1" primaryKey="false" required="false"
type="VARCHAR" size="32" autoIncrement="false"/>
<column name="szAddress2" primaryKey="false" required="false"
type="VARCHAR" size="32" autoIncrement="false"/>
<column name="szAddress3" primaryKey="false" required="false"
type="VARCHAR" size="32" autoIncrement="false"/>
<column name="szStateProv" primaryKey="false" required="false"
type="VARCHAR" size="32" autoIncrement="false"/>
<column name="szPostalCode" primaryKey="false" required="false"
type="VARCHAR" size="16" autoIncrement="false"/>
<column name="szCity" primaryKey="false" required="false"
type="VARCHAR" size="32" autoIncrement="false"/>
<column name="nCountryFK" primaryKey="false" required="false"
type="INTEGER" size="10" autoIncrement="false"/>
<foreign-key foreignTable="tb_Country"
name="FK_tb_AddressAlternate_tb_Country">
<reference local="nCountryFK" foreign="nCountryID"/>
</foreign-key>
</table>
--
Obs
