gistfile1.xml

  <table name="membership" phpName="Membership">
    <column name="number" type="INTEGER" primaryKey="true" required="true"/>
    <column name="user_id" type="INTEGER" required="true"/>
    <column name="start" type="DATE"/>
    <column name="end" type="DATE"/>
    <column name="expires" type="DATE"/>
    <column name="invoice_id" type="INTEGER"/>
    <column name="notes" type="LONGVARCHAR"/>
    <foreign-key name="fk_membership_user1" foreignTable="user">
      <reference local="user_id" foreign="user_id"/>
    </foreign-key>
    <index name="fk_membership_user1">
      <index-column name="user_id"/>
    </index>
    <foreign-key name="fk_membership_invoice1" foreignTable="invoice">
      <reference local="invoice_id" foreign="invoice_id"/>
    </foreign-key>
    <index name="fk_membership_invoice1">
      <index-column name="invoice_id"/>
    </index>
  </table>
  <table name="invoice" phpName="Invoice">
    <column name="invoice_id" type="INTEGER" primaryKey="true" required="true" autoIncrement="true"/>
    <column name="transaction_number" type="VARCHAR" size="45"/>
    <column name="payment_option_id" type="INTEGER" required="true"/>
    <column name="user_id" type="INTEGER" required="true"/>
    <column name="payed" type="DATE"/>
    <column name="currency_iso_nr" type="INTEGER" required="true"/>
    <behavior name="timestampable">
		<parameter name="create_column" value="created" />
		<parameter name="update_column" value="updated" />
	</behavior>
    <foreign-key name="fk_payment_payment_option1" foreignTable="payment_option">
      <reference local="payment_option_id" foreign="payment_option_id"/>
    </foreign-key>
    <foreign-key name="fk_payment_user1" foreignTable="user">
      <reference local="user_id" foreign="user_id"/>
    </foreign-key>
    <foreign-key name="fk_invoice_currency1" foreignTable="currency">
      <reference local="currency_iso_nr" foreign="cu_iso_nr"/>
    </foreign-key>
    <index name="fk_payment_payment_option1">
      <index-column name="payment_option_id"/>
    </index>
    <index name="fk_payment_user1">
      <index-column name="user_id"/>
    </index>
  </table>