Revize 525
Přidáno uživatelem Tomáš Dulík před téměř 15 roky(ů)
freenetis/trunk/money_transfers.clay | ||
---|---|---|
<foreign-key alias="" name="FK_transfers_3" on-delete="" on-update="" referenced-key="PK_USERS_PRIMARY" referenced-table="users" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7b9e">
|
||
<foreign-key-description/>
|
||
<foreign-key-figure>
|
||
<fk-fig-source-terminal x="7" y="74"/>
|
||
<fk-fig-target-terminal x="187" y="35"/>
|
||
<fk-fig-bendpoint-list/>
|
||
</foreign-key-figure>
|
||
... | ... | |
<foreign-key alias="" name="FK_transfers_5" on-delete="" on-update="" referenced-key="PK_ACCOUNTS_PRIMARY" referenced-table="accounts" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-78c5">
|
||
<foreign-key-description/>
|
||
<foreign-key-figure>
|
||
<fk-fig-source-terminal x="91" y="2"/>
|
||
<fk-fig-target-terminal x="80" y="82"/>
|
||
<fk-fig-bendpoint-list/>
|
||
</foreign-key-figure>
|
||
... | ... | |
</table>
|
||
<table alias="" name="works" remarks="" uid="13ed0e:11d774ed92c:-7fa8">
|
||
<table-description/>
|
||
<table-figure-bounds height="-1" width="-1" x="532" y="476"/>
|
||
<table-figure-bounds height="-1" width="-1" x="538" y="491"/>
|
||
<column-list>
|
||
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fa6">
|
||
<column-description/>
|
||
... | ... | |
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="work_nr" remarks="" uid="1f4899c:123ebc4f1c6:-7d93">
|
||
<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="false" name="work_report_id" remarks="" uid="1f4899c:123ebc4f1c6:-7d8a">
|
||
<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_works_1" on-delete="" on-update="" referenced-key="PK_WORK_REPORTS" referenced-table="work_reports" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1f4899c:123ebc4f1c6:-7b6b">
|
||
<foreign-key-description/>
|
||
<foreign-key-figure>
|
||
<fk-fig-source-terminal x="6" y="49"/>
|
||
<fk-fig-bendpoint-list/>
|
||
</foreign-key-figure>
|
||
<foreign-key-column column-name="work_report_id" referenced-key-column-name="id"/>
|
||
... | ... | |
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1f4899c:123ebc4f1c6:-7e43">
|
||
<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="false" name="user_id" remarks="" uid="1f4899c:123ebc4f1c6:-7e3a">
|
||
<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="false" name="voting_id" remarks="" uid="1f4899c:123ebc4f1c6:-7e30">
|
||
<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="false" name="transfer_id" remarks="" uid="1f4899c:123ebc4f1c6:-7e29">
|
||
<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-description/>
|
||
<foreign-key-figure>
|
||
<fk-fig-source-terminal x="81" y="7"/>
|
||
<fk-fig-target-terminal x="11" y="110"/>
|
||
<fk-fig-bendpoint-list/>
|
||
</foreign-key-figure>
|
||
<foreign-key-column column-name="transfer_id" referenced-key-column-name="id"/>
|
Také k dispozici: Unified diff
drobne upravy ERD diagramu money_transfers