Revize 192
Přidáno uživatelem Tomáš Dulík před více než 15 roky(ů)
| freenetis/trunk/money_transfers.clay | ||
|---|---|---|
|
which means that any account from the "accounts" table can have 0 or 1 record in
|
||
|
"bank_accounts" table for holding additional data like SWIFT, IBAN etc.
|
||
|
(note: "accounts" table holds data about double-entry accounting system accounts).</table-description>
|
||
|
<table-figure-bounds height="124" width="143" x="803" y="91"/>
|
||
|
<table-figure-bounds height="124" width="143" x="804" y="102"/>
|
||
|
<column-list>
|
||
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="19bc716:120374b574f:-7ff4">
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) UNSIGNED"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) UNSIGNED ZEROFILL"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) ZEROFILL"/>
|
||
| ... | ... | |
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="account_id" remarks="" uid="19bc716:120374b574f:-7fed">
|
||
|
<column-description></column-description>
|
||
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant type-name-pattern="INT"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) UNSIGNED"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) UNSIGNED ZEROFILL"/>
|
||
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) ZEROFILL"/>
|
||
| ... | ... | |
|
<foreign-key alias="" name="FK_bank_accounts_1" on-delete="" on-update="" referenced-key="PK_ACCOUNTS_PRIMARY" referenced-table="accounts" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..1" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="19bc716:120374b574f:-7f86">
|
||
|
<foreign-key-description></foreign-key-description>
|
||
|
<foreign-key-figure>
|
||
|
<fk-fig-target-terminal x="141" y="67"/>
|
||
|
<fk-fig-bendpoint-list/>
|
||
|
</foreign-key-figure>
|
||
|
<foreign-key-column column-name="account_id" referenced-key-column-name="id"/>
|
||
Také k dispozici: Unified diff
maly update schema