db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Obs <obb...@gmail.com>
Subject Reading
Date Wed, 19 Jul 2006 15:31:40 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message