Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 525

Přidáno uživatelem Tomáš Dulík před téměř 15 roky(ů)

drobne upravy ERD diagramu money_transfers

Zobrazit rozdíly:

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