-
-
Save gossi/baaa491b8fb2a7404455 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment