Projekt

Obecné

Profil

Stáhnout (82.2 KB) Statistiky
| Revize:

sourceforge/freenetis/trunk/money_transfers.clay @ 519

519 tomas_duli
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
191 tomas_duli
<clay-model clay-version="1.4.2">
<database-model alias="" author="" begin-script="" end-script="" name="money_transfers" remarks="" sql-dialect-id="jp.azzurri.clay.dialect.MySQL_5_0_Dialect" uid="13ed0e:11d774ed92c:-8000" version="1.0">
519 tomas_duli
<database-model-description/>
191 tomas_duli
<schema-list>
<schema alias="" name="DEFAULT_SCHEMA" remarks="" uid="13ed0e:11d774ed92c:-7ffe">
519 tomas_duli
<schema-description/>
191 tomas_duli
<domain-list/>
<table-list>
<table alias="" name="accounts" remarks="" uid="13ed0e:11d774ed92c:-7ffd">
519 tomas_duli
<table-description/>
<table-figure-bounds height="-1" width="-1" x="535" y="38"/>
191 tomas_duli
<column-list>
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7ffb">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="member_id" remarks="" uid="13ed0e:11d774ed92c:-7ffa">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="100" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="13ed0e:11d774ed92c:-7ff9">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
279 tomas_duli
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="account_attribute_id" remarks="" uid="13ed0e:11d774ed92c:-7ff8">
519 tomas_duli
<column-description/>
279 tomas_duli
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/>
<variant type-name-pattern="INTEGER UNSIGNED"/>
<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INTEGER ZEROFILL"/>
191 tomas_duli
</data-type>
</column>
<column alias="" auto-increment="false" column-size="254" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="13ed0e:11d774ed92c:-7ff6">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_ACCOUNTS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7ffc">
519 tomas_duli
<primary-key-description/>
191 tomas_duli
<primary-key-column name="id"/>
</primary-key>
<unique-key-list/>
<foreign-key-list>
<foreign-key alias="" name="FK_accounts_1" on-delete="" on-update="" referenced-key="PK_MEMBERS_PRIMARY" referenced-table="members" 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="13ed0e:11d774ed92c:-7e58">
519 tomas_duli
<foreign-key-description/>
191 tomas_duli
<foreign-key-figure>
<fk-fig-source-terminal x="11" y="45"/>
294 tomas_duli
<fk-fig-target-terminal x="202" y="192"/>
191 tomas_duli
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="member_id" referenced-key-column-name="id"/>
</foreign-key>
279 tomas_duli
<foreign-key alias="" name="FK_accounts_2" on-delete="" on-update="" referenced-key="PK_ACCOUNT_ATTRIBUTES" referenced-table="account_attributes" 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="5084c6:122298f0109:-7f87">
519 tomas_duli
<foreign-key-description/>
279 tomas_duli
<foreign-key-figure>
519 tomas_duli
<fk-fig-source-terminal x="181" y="72"/>
294 tomas_duli
<fk-fig-target-terminal x="66" y="88"/>
279 tomas_duli
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="account_attribute_id" referenced-key-column-name="id"/>
</foreign-key>
191 tomas_duli
</foreign-key-list>
<index-list>
<index alias="" name="is_owned_by" remarks="" uid="13ed0e:11d774ed92c:-7ff5" unique="false">
519 tomas_duli
<index-description/>
191 tomas_duli
<index-column name="member_id" sort="ASC"/>
</index>
</index-list>
</table>
<table alias="" name="members" remarks="" uid="13ed0e:11d774ed92c:-7fe9">
519 tomas_duli
<table-description/>
<table-figure-bounds height="-1" width="-1" x="195" y="-107"/>
191 tomas_duli
<column-list>
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fe7">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="100" decimal-digits="0" default-value="" mandatory="true" name="name" remarks="" uid="13ed0e:11d774ed92c:-7fe6">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="50" decimal-digits="0" default-value="" mandatory="false" name="street_number" remarks="" uid="13ed0e:11d774ed92c:-7fe5">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="street" remarks="" uid="13ed0e:11d774ed92c:-7fe4">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="town" remarks="" uid="13ed0e:11d774ed92c:-7fe3">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="ZIP_code" remarks="" uid="13ed0e:11d774ed92c:-7fe2">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="3" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="13ed0e:11d774ed92c:-7fe1">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="-6" name="TINYINT" selected-variant-pattern="TINYINT(%n)">
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
<variant type-name-pattern="TINYINT"/>
<variant type-name-pattern="TINYINT UNSIGNED"/>
<variant type-name-pattern="TINYINT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="TINYINT ZEROFILL"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="20" decimal-digits="0" default-value="" mandatory="false" name="qos_ceil" remarks="" uid="13ed0e:11d774ed92c:-7fe0">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="20" decimal-digits="0" default-value="" mandatory="false" name="qos_rate" remarks="" uid="13ed0e:11d774ed92c:-7fdf">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="22" decimal-digits="0" default-value="" mandatory="false" name="entrance_fee" remarks="" uid="13ed0e:11d774ed92c:-7fde">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="8" name="DOUBLE" selected-variant-pattern="DOUBLE">
<variant type-name-pattern="DOUBLE"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s)"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) UNSIGNED"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) UNSIGNED ZEROFILL"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) ZEROFILL"/>
<variant type-name-pattern="DOUBLE UNSIGNED"/>
<variant type-name-pattern="DOUBLE UNSIGNED ZEROFILL"/>
<variant type-name-pattern="DOUBLE ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="22" decimal-digits="0" default-value="" mandatory="false" name="debt_payment_rate" remarks="" uid="13ed0e:11d774ed92c:-7fdd">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="8" name="DOUBLE" selected-variant-pattern="DOUBLE">
<variant type-name-pattern="DOUBLE"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s)"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) UNSIGNED"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) UNSIGNED ZEROFILL"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) ZEROFILL"/>
<variant type-name-pattern="DOUBLE UNSIGNED"/>
<variant type-name-pattern="DOUBLE UNSIGNED ZEROFILL"/>
<variant type-name-pattern="DOUBLE ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="22" decimal-digits="0" default-value="" mandatory="false" name="entrance_fee_left" remarks="" uid="13ed0e:11d774ed92c:-7fdc">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="8" name="DOUBLE" selected-variant-pattern="DOUBLE">
<variant type-name-pattern="DOUBLE"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s)"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) UNSIGNED"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) UNSIGNED ZEROFILL"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) ZEROFILL"/>
<variant type-name-pattern="DOUBLE UNSIGNED"/>
<variant type-name-pattern="DOUBLE UNSIGNED ZEROFILL"/>
<variant type-name-pattern="DOUBLE ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="entrance_fee_date" remarks="" uid="13ed0e:11d774ed92c:-7fdb">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
<variant type-name-pattern="DATE"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="3" decimal-digits="0" default-value="1" mandatory="false" name="must_pay_regular_fee" remarks="" uid="13ed0e:11d774ed92c:-7fda">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="-6" name="TINYINT" selected-variant-pattern="TINYINT(%n)">
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
<variant type-name-pattern="TINYINT"/>
<variant type-name-pattern="TINYINT UNSIGNED"/>
<variant type-name-pattern="TINYINT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="TINYINT ZEROFILL"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="12" decimal-digits="0" default-value="" mandatory="false" name="current_credit" remarks="" uid="13ed0e:11d774ed92c:-7fd9">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="7" name="FLOAT" selected-variant-pattern="FLOAT(%n)">
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n)"/>
<variant type-name-pattern="FLOAT"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n) UNSIGNED"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n) ZEROFILL"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s)"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s) UNSIGNED"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s) UNSIGNED ZEROFILL"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s) ZEROFILL"/>
<variant type-name-pattern="FLOAT UNSIGNED"/>
<variant type-name-pattern="FLOAT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="FLOAT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="entrance_date" remarks="" uid="13ed0e:11d774ed92c:-7fd8">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
<variant type-name-pattern="DATE"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="entrance_form_received" remarks="" uid="13ed0e:11d774ed92c:-7fd7">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
<variant type-name-pattern="DATE"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="entrance_form_accepted" remarks="" uid="13ed0e:11d774ed92c:-7fd6">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
<variant type-name-pattern="DATE"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="13ed0e:11d774ed92c:-7fd5">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="old_db_id" remarks="" uid="13ed0e:11d774ed92c:-7fd4">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_MEMBERS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fe8">
519 tomas_duli
<primary-key-description/>
191 tomas_duli
<primary-key-column name="id"/>
</primary-key>
<unique-key-list/>
<foreign-key-list/>
<index-list/>
</table>
294 tomas_duli
<table alias="" name="bank_transfers" remarks="" uid="13ed0e:11d774ed92c:-7fd3">
519 tomas_duli
<table-description/>
<table-figure-bounds height="141" width="163" x="966" y="165"/>
191 tomas_duli
<column-list>
<column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7e41">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT">
<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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
294 tomas_duli
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="origin_id" remarks="" uid="13cf887:1224b8822ba:-7fef">
519 tomas_duli
<column-description/>
294 tomas_duli
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/>
<variant type-name-pattern="INTEGER UNSIGNED"/>
<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="destination_id" remarks="" uid="13cf887:1224b8822ba:-7fec">
519 tomas_duli
<column-description/>
294 tomas_duli
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/>
<variant type-name-pattern="INTEGER UNSIGNED"/>
<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
191 tomas_duli
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="transfer_id" remarks="" uid="13ed0e:11d774ed92c:-7fd1">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="19" decimal-digits="0" default-value="" mandatory="false" name="variable_symbol" remarks="" uid="13ed0e:11d774ed92c:-7fd0">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT(%n)">
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/>
<variant type-name-pattern="BIGINT"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) ZEROFILL"/>
<variant type-name-pattern="BIGINT UNSIGNED"/>
<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="BIGINT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="19" decimal-digits="0" default-value="" mandatory="false" name="constant_symbol" remarks="" uid="13ed0e:11d774ed92c:-7fcf">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT(%n)">
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/>
<variant type-name-pattern="BIGINT"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) ZEROFILL"/>
<variant type-name-pattern="BIGINT UNSIGNED"/>
<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="BIGINT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="19" decimal-digits="0" default-value="" mandatory="false" name="specific_symbol" remarks="" uid="13ed0e:11d774ed92c:-7fce">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="-5" name="BIGINT" selected-variant-pattern="BIGINT(%n)">
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n)"/>
<variant type-name-pattern="BIGINT"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="BIGINT(%n) ZEROFILL"/>
<variant type-name-pattern="BIGINT UNSIGNED"/>
<variant type-name-pattern="BIGINT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="BIGINT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="13ed0e:11d774ed92c:-7fcd">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_MONEY_TRANSFER_BANK_INFOS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fd2">
519 tomas_duli
<primary-key-description/>
191 tomas_duli
<primary-key-column name="id"/>
</primary-key>
<unique-key-list/>
<foreign-key-list>
294 tomas_duli
<foreign-key alias="" name="FK_money_transfer_bank_infos_1" on-delete="" on-update="" referenced-key="PK_MONEY_TRANSFERS_PRIMARY" referenced-table="transfers" 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="13ed0e:11d774ed92c:-7e05">
519 tomas_duli
<foreign-key-description/>
191 tomas_duli
<foreign-key-figure>
519 tomas_duli
<fk-fig-source-terminal x="36" y="139"/>
294 tomas_duli
<fk-fig-target-terminal x="177" y="55"/>
191 tomas_duli
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="transfer_id" referenced-key-column-name="id"/>
</foreign-key>
294 tomas_duli
<foreign-key alias="" name="FK_bank_transfers_2" on-delete="" on-update="" referenced-key="PK_BANK_ACCOUNTS" referenced-table="bank_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="13cf887:1224b8822ba:-7f86">
519 tomas_duli
<foreign-key-description/>
294 tomas_duli
<foreign-key-figure>
<fk-fig-source-terminal x="16" y="3"/>
519 tomas_duli
<fk-fig-target-terminal x="34" y="123"/>
294 tomas_duli
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="origin_id" referenced-key-column-name="id"/>
</foreign-key>
<foreign-key alias="" name="FK_bank_transfers_3" on-delete="" on-update="" referenced-key="PK_BANK_ACCOUNTS" referenced-table="bank_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="13cf887:1224b8822ba:-7d3c">
519 tomas_duli
<foreign-key-description/>
294 tomas_duli
<foreign-key-figure>
<fk-fig-source-terminal x="112" y="1"/>
519 tomas_duli
<fk-fig-target-terminal x="127" y="122"/>
294 tomas_duli
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="destination_id" referenced-key-column-name="id"/>
</foreign-key>
191 tomas_duli
</foreign-key-list>
<index-list/>
</table>
294 tomas_duli
<table alias="" name="transfers" remarks="" uid="13ed0e:11d774ed92c:-7fcc">
519 tomas_duli
<table-description/>
<table-figure-bounds height="-1" width="-1" x="523" y="292"/>
191 tomas_duli
<column-list>
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fca">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="origin_id" remarks="" uid="13ed0e:11d774ed92c:-7fc9">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="destination_id" remarks="" uid="13ed0e:11d774ed92c:-7fc8">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
487 jsvitak
<column alias="" auto-increment="false" column-size="11" decimal-digits="0" default-value="" mandatory="false" name="previous_transfer_id" remarks="" uid="1834b39:1238964e7e9:-7be9">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
519 tomas_duli
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
487 jsvitak
<variant type-name-pattern="INT"/>
191 tomas_duli
<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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
487 jsvitak
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="member_id" remarks="" uid="1834b39:1238964e7e9:-7bab">
519 tomas_duli
<column-description/>
487 jsvitak
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
519 tomas_duli
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
487 jsvitak
<variant type-name-pattern="CHAR"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
191 tomas_duli
</data-type>
</column>
487 jsvitak
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="user_id" remarks="" uid="1834b39:1238964e7e9:-7baa">
519 tomas_duli
<column-description/>
487 jsvitak
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
519 tomas_duli
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
487 jsvitak
<variant type-name-pattern="CHAR"/>
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="1834b39:1238964e7e9:-7bac">
519 tomas_duli
<column-description/>
487 jsvitak
<data-type jdbc-type="-6" name="TINYINT" selected-variant-pattern="TINYINT">
<variant type-name-pattern="TINYINT"/>
<variant type-name-pattern="TINYINT UNSIGNED"/>
<variant type-name-pattern="TINYINT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="TINYINT ZEROFILL"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n)"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="1" precision-min="0" precision-variable="%n" type-name-pattern="TINYINT(%n) ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="datetime" remarks="" uid="13ed0e:11d774ed92c:-7fc7">
519 tomas_duli
<column-description/>
487 jsvitak
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="DATETIME" selected-variant-pattern="DATETIME">
<variant type-name-pattern="DATETIME"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="creation_datetime" remarks="" uid="1834b39:1238964e7e9:-7bea">
519 tomas_duli
<column-description/>
487 jsvitak
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="DATETIME" selected-variant-pattern="DATETIME">
<variant type-name-pattern="DATETIME"/>
</data-type>
</column>
191 tomas_duli
<column alias="" auto-increment="false" column-size="254" decimal-digits="0" default-value="" mandatory="false" name="text" remarks="" uid="13ed0e:11d774ed92c:-7fc5">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="22" decimal-digits="0" default-value="" mandatory="false" name="amount" remarks="" uid="13ed0e:11d774ed92c:-7fc4">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="8" name="DOUBLE" selected-variant-pattern="DOUBLE">
<variant type-name-pattern="DOUBLE"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s)"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) UNSIGNED"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) UNSIGNED ZEROFILL"/>
<variant precision-max="255" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="DOUBLE(%p, %s) ZEROFILL"/>
<variant type-name-pattern="DOUBLE UNSIGNED"/>
<variant type-name-pattern="DOUBLE UNSIGNED ZEROFILL"/>
<variant type-name-pattern="DOUBLE ZEROFILL"/>
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_MONEY_TRANSFERS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fcb">
519 tomas_duli
<primary-key-description/>
191 tomas_duli
<primary-key-column name="id"/>
</primary-key>
<unique-key-list/>
<foreign-key-list>
<foreign-key alias="" name="FK_money_transfers_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..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="13ed0e:11d774ed92c:-7f43">
519 tomas_duli
<foreign-key-description/>
191 tomas_duli
<foreign-key-figure>
519 tomas_duli
<fk-fig-source-terminal x="14" y="2"/>
<fk-fig-target-terminal x="8" y="84"/>
191 tomas_duli
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="origin_id" referenced-key-column-name="id"/>
</foreign-key>
487 jsvitak
<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">
519 tomas_duli
<foreign-key-description/>
487 jsvitak
<foreign-key-figure>
519 tomas_duli
<fk-fig-target-terminal x="187" y="35"/>
487 jsvitak
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="user_id" referenced-key-column-name="id"/>
</foreign-key>
<foreign-key alias="" name="FK_transfers_4" on-delete="" on-update="" referenced-key="PK_MEMBERS_PRIMARY" referenced-table="members" 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:-7b67">
519 tomas_duli
<foreign-key-description/>
487 jsvitak
<foreign-key-figure>
519 tomas_duli
<fk-fig-source-terminal x="9" y="33"/>
487 jsvitak
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="member_id" referenced-key-column-name="id"/>
</foreign-key>
<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">
519 tomas_duli
<foreign-key-description/>
487 jsvitak
<foreign-key-figure>
519 tomas_duli
<fk-fig-target-terminal x="80" y="82"/>
487 jsvitak
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="destination_id" referenced-key-column-name="id"/>
</foreign-key>
519 tomas_duli
<foreign-key alias="" name="FK_money_transfers_2" 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="13ed0e:11d774ed92c:-7e7f">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-source-terminal x="165" y="0"/>
<fk-fig-target-terminal x="155" y="89"/>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="previous_transfer_id" referenced-key-column-name="id"/>
</foreign-key>
191 tomas_duli
</foreign-key-list>
<index-list>
<index alias="" name="from" remarks="" uid="13ed0e:11d774ed92c:-7fc3" unique="false">
519 tomas_duli
<index-description/>
191 tomas_duli
<index-column name="origin_id" sort="ASC"/>
</index>
<index alias="" name="to" remarks="" uid="13ed0e:11d774ed92c:-7fc2" unique="false">
519 tomas_duli
<index-description/>
191 tomas_duli
<index-column name="destination_id" sort="ASC"/>
</index>
</index-list>
</table>
<table alias="" name="users" remarks="" uid="13ed0e:11d774ed92c:-7fc1">
519 tomas_duli
<table-description/>
<table-figure-bounds height="-1" width="-1" x="6" y="335"/>
191 tomas_duli
<column-list>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="member_id" remarks="" uid="13ed0e:11d774ed92c:-7fbf">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT UNSIGNED">
<variant type-name-pattern="INT UNSIGNED"/>
<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"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fbe">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="30" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="13ed0e:11d774ed92c:-7fbd">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="30" decimal-digits="0" default-value="" mandatory="false" name="middle_name" remarks="" uid="13ed0e:11d774ed92c:-7fbc">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="60" decimal-digits="0" default-value="" mandatory="false" name="surname" remarks="" uid="13ed0e:11d774ed92c:-7fbb">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="40" decimal-digits="0" default-value="" mandatory="false" name="pre_title" remarks="" uid="13ed0e:11d774ed92c:-7fba">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="30" decimal-digits="0" default-value="" mandatory="false" name="post_title" remarks="" uid="13ed0e:11d774ed92c:-7fb9">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="birthday" remarks="" uid="13ed0e:11d774ed92c:-7fb8">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="91" literal-prefix="'" literal-suffix="'" name="DATE" selected-variant-pattern="DATE">
<variant type-name-pattern="DATE"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="40" decimal-digits="0" default-value="" mandatory="false" name="phone" remarks="" uid="13ed0e:11d774ed92c:-7fb7">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="60" decimal-digits="0" default-value="" mandatory="false" name="email" remarks="" uid="13ed0e:11d774ed92c:-7fb6">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="50" decimal-digits="0" default-value="" mandatory="false" name="login" remarks="" uid="13ed0e:11d774ed92c:-7fb5">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="50" decimal-digits="0" default-value="" mandatory="false" name="password" remarks="" uid="13ed0e:11d774ed92c:-7fb4">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="7" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="13ed0e:11d774ed92c:-7fb3">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="1111" literal-prefix="'" literal-suffix="'" name="ENUM" selected-variant-pattern="ENUM(7)">
<variant type-name-pattern="ENUM(7)"/>
<variant type-name-pattern="ENUM('%1')"/>
<variant type-name-pattern="ENUM('%1', '%2')"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="web_messages_types" remarks="" uid="13ed0e:11d774ed92c:-7fb2">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="email_messages_types" remarks="" uid="13ed0e:11d774ed92c:-7fb1">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="250" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="13ed0e:11d774ed92c:-7fb0">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="240" decimal-digits="0" default-value="all" mandatory="true" name="aro_section_value" remarks="" uid="13ed0e:11d774ed92c:-7faf">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="0" mandatory="true" name="aro_order_value" remarks="" uid="13ed0e:11d774ed92c:-7fae">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="0" mandatory="true" name="aro_hidden" remarks="" uid="13ed0e:11d774ed92c:-7fad">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_USERS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fc0">
519 tomas_duli
<primary-key-description/>
191 tomas_duli
<primary-key-column name="id"/>
</primary-key>
<unique-key-list/>
487 jsvitak
<foreign-key-list>
<foreign-key alias="" name="FK_users_1" on-delete="" on-update="" referenced-key="PK_MEMBERS_PRIMARY" referenced-table="members" 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:-7c0d">
519 tomas_duli
<foreign-key-description/>
487 jsvitak
<foreign-key-figure>
519 tomas_duli
<fk-fig-target-terminal x="110" y="292"/>
487 jsvitak
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="member_id" referenced-key-column-name="id"/>
</foreign-key>
</foreign-key-list>
191 tomas_duli
<index-list>
<index alias="" name="login" remarks="" uid="13ed0e:11d774ed92c:-7fac" unique="true">
519 tomas_duli
<index-description/>
191 tomas_duli
<index-column name="login" sort="ASC"/>
</index>
<index alias="" name="belogs_to_member" remarks="" uid="13ed0e:11d774ed92c:-7fab" unique="false">
519 tomas_duli
<index-description/>
191 tomas_duli
<index-column name="member_id" sort="ASC"/>
</index>
<index alias="" name="email" remarks="" uid="13ed0e:11d774ed92c:-7faa" unique="false">
519 tomas_duli
<index-description/>
191 tomas_duli
<index-column name="email" sort="ASC"/>
</index>
<index alias="" name="phone" remarks="" uid="13ed0e:11d774ed92c:-7fa9" unique="false">
519 tomas_duli
<index-description/>
191 tomas_duli
<index-column name="phone" sort="ASC"/>
</index>
</index-list>
</table>
<table alias="" name="works" remarks="" uid="13ed0e:11d774ed92c:-7fa8">
519 tomas_duli
<table-description/>
<table-figure-bounds height="-1" width="-1" x="532" y="476"/>
191 tomas_duli
<column-list>
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fa6">
519 tomas_duli
<column-description/>
191 tomas_duli
<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) 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
519 tomas_duli
<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/>
191 tomas_duli
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
519 tomas_duli
<variant type-name-pattern="INT"/>
191 tomas_duli
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
519 tomas_duli
<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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="submitted" remarks="" uid="1f4899c:123ebc4f1c6:-7d8d">
<column-description/>
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="DATETIME" selected-variant-pattern="DATETIME">
<variant type-name-pattern="DATETIME"/>
</data-type>
</column>
<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)">
191 tomas_duli
<variant type-name-pattern="INT"/>
519 tomas_duli
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
191 tomas_duli
<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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
519 tomas_duli
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="date_time" remarks="" uid="1f4899c:123ebc4f1c6:-7da8">
<column-description/>
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="DATETIME" selected-variant-pattern="DATETIME">
<variant type-name-pattern="DATETIME"/>
191 tomas_duli
</data-type>
</column>
<column alias="" auto-increment="false" column-size="12" decimal-digits="0" default-value="" mandatory="false" name="hours" remarks="" uid="13ed0e:11d774ed92c:-7fa3">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="7" name="FLOAT" selected-variant-pattern="FLOAT(%n)">
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n)"/>
<variant type-name-pattern="FLOAT"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n) UNSIGNED"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n) ZEROFILL"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s)"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s) UNSIGNED"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s) UNSIGNED ZEROFILL"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s) ZEROFILL"/>
<variant type-name-pattern="FLOAT UNSIGNED"/>
<variant type-name-pattern="FLOAT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="FLOAT ZEROFILL"/>
</data-type>
</column>
519 tomas_duli
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="distance" remarks="" uid="13ed0e:11d774ed92c:-7fa1">
<column-description/>
<data-type jdbc-type="7" name="FLOAT" selected-variant-pattern="FLOAT">
<variant type-name-pattern="FLOAT"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n)"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n) UNSIGNED"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="53" precision-min="0" precision-variable="%n" type-name-pattern="FLOAT(%n) ZEROFILL"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s)"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s) UNSIGNED"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s) UNSIGNED ZEROFILL"/>
<variant precision-max="53" precision-min="0" precision-variable="%p" scale-max="30" scale-min="0" scale-variable="%s" type-name-pattern="FLOAT(%p, %s) ZEROFILL"/>
<variant type-name-pattern="FLOAT UNSIGNED"/>
<variant type-name-pattern="FLOAT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="FLOAT ZEROFILL"/>
191 tomas_duli
</data-type>
</column>
519 tomas_duli
<column alias="" auto-increment="false" column-size="65535" decimal-digits="0" default-value="" mandatory="false" name="description" remarks="" uid="13ed0e:11d774ed92c:-7fa4">
<column-description/>
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
191 tomas_duli
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_WORKS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fa7">
519 tomas_duli
<primary-key-description/>
191 tomas_duli
<primary-key-column name="id"/>
</primary-key>
<unique-key-list/>
<foreign-key-list>
519 tomas_duli
<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/>
191 tomas_duli
<foreign-key-figure>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
519 tomas_duli
<foreign-key-column column-name="work_report_id" referenced-key-column-name="id"/>
191 tomas_duli
</foreign-key>
</foreign-key-list>
<index-list>
<index alias="" name="commited_by" remarks="" uid="13ed0e:11d774ed92c:-7fa0" unique="false">
519 tomas_duli
<index-description/>
191 tomas_duli
</index>
<index alias="" name="transfer_salary" remarks="" uid="13ed0e:11d774ed92c:-7f9f" unique="false">
519 tomas_duli
<index-description/>
<index-column name="distance" sort="ASC"/>
191 tomas_duli
</index>
<index alias="" name="confirmed_by" remarks="" uid="13ed0e:11d774ed92c:-7f9e" unique="false">
519 tomas_duli
<index-description/>
191 tomas_duli
</index>
</index-list>
</table>
<table alias="" name="bank_accounts" remarks="" uid="19bc716:120374b574f:-7ffa">
<table-description>This table contains data specific for bank accounts.
The table depends on the "accounts" table by (one-to-one or zero) relationship,
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>
519 tomas_duli
<table-figure-bounds height="124" width="143" x="942" y="-138"/>
191 tomas_duli
<column-list>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="19bc716:120374b574f:-7ff4">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
192 tomas_duli
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
191 tomas_duli
<variant type-name-pattern="INT"/>
<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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
294 tomas_duli
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="member_id" remarks="" uid="13cf887:1224b8822ba:-7ff2">
519 tomas_duli
<column-description/>
294 tomas_duli
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT">
<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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
191 tomas_duli
<column alias="" auto-increment="false" column-size="254" decimal-digits="0" default-value="" mandatory="false" name="account_nr" remarks="" uid="19bc716:120374b574f:-7f77">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="bank_nr" remarks="" uid="19bc716:120374b574f:-7f74">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="254" decimal-digits="0" default-value="" mandatory="false" name="IBAN" remarks="" uid="19bc716:120374b574f:-7f6e">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="254" decimal-digits="0" default-value="" mandatory="false" name="SWIFT" remarks="" uid="19bc716:120374b574f:-7f65">
519 tomas_duli
<column-description/>
191 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_BANK_ACCOUNTS" remarks="" uid="19bc716:120374b574f:-7ff9">
519 tomas_duli
<primary-key-description/>
191 tomas_duli
<primary-key-column name="id"/>
</primary-key>
<unique-key-list/>
<foreign-key-list>
294 tomas_duli
<foreign-key alias="" name="FK_bank_accounts_1" on-delete="" on-update="" referenced-key="PK_MEMBERS_PRIMARY" referenced-table="members" 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="13cf887:1224b8822ba:-7cdc">
519 tomas_duli
<foreign-key-description/>
191 tomas_duli
<foreign-key-figure>
294 tomas_duli
<fk-fig-source-terminal x="8" y="45"/>
<fk-fig-target-terminal x="199" y="116"/>
191 tomas_duli
<fk-fig-bendpoint-list/>
</foreign-key-figure>
294 tomas_duli
<foreign-key-column column-name="member_id" referenced-key-column-name="id"/>
191 tomas_duli
</foreign-key>
</foreign-key-list>
<index-list/>
</table>
279 tomas_duli
<table alias="" name="account_attributes" remarks="" uid="5084c6:122298f0109:-7ff5">
519 tomas_duli
<table-description/>
<table-figure-bounds height="-1" width="-1" x="817" y="126"/>
279 tomas_duli
<column-list>
<column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="5084c6:122298f0109:-7ff1">
519 tomas_duli
<column-description/>
279 tomas_duli
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/>
<variant type-name-pattern="INTEGER UNSIGNED"/>
<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="100" decimal-digits="0" default-value="" mandatory="false" name="number" remarks="" uid="5084c6:122298f0109:-7fef">
519 tomas_duli
<column-description/>
279 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="255" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="5084c6:122298f0109:-7ff0">
519 tomas_duli
<column-description/>
279 tomas_duli
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="5084c6:122298f0109:-7fee">
519 tomas_duli
<column-description/>
279 tomas_duli
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/>
<variant type-name-pattern="INTEGER UNSIGNED"/>
<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="kind" remarks="" uid="5084c6:122298f0109:-7fed">
519 tomas_duli
<column-description/>
279 tomas_duli
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER">
<variant type-name-pattern="INTEGER"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) UNSIGNED ZEROFILL"/>
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n) ZEROFILL"/>
<variant type-name-pattern="INTEGER UNSIGNED"/>
<variant type-name-pattern="INTEGER UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INTEGER ZEROFILL"/>
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_ACCOUNT_ATTRIBUTES" remarks="" uid="5084c6:122298f0109:-7ff4">
519 tomas_duli
<primary-key-description/>
279 tomas_duli
<primary-key-column name="id"/>
</primary-key>
<unique-key-list/>
<foreign-key-list/>
<index-list/>
</table>
487 jsvitak
<table alias="" name="accounts_bank_accounts" remarks="" uid="1834b39:1238964e7e9:-7b3a">
519 tomas_duli
<table-description/>
<table-figure-bounds height="-1" width="-1" x="815" y="56"/>
487 jsvitak
<column-list>
<column alias="" auto-increment="false" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="account_id" remarks="" uid="1834b39:1238964e7e9:-7b36">
519 tomas_duli
<column-description/>
487 jsvitak
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
519 tomas_duli
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
487 jsvitak
<variant type-name-pattern="INT"/>
<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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="bank_account_id" remarks="" uid="1834b39:1238964e7e9:-7b35">
519 tomas_duli
<column-description/>
487 jsvitak
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
519 tomas_duli
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
487 jsvitak
<variant type-name-pattern="INT"/>
<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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_ACCOUNTS_BANK_ACCOUNTS" remarks="" uid="1834b39:1238964e7e9:-7b39">
519 tomas_duli
<primary-key-description/>
487 jsvitak
<primary-key-column name="account_id"/>
<primary-key-column name="bank_account_id"/>
</primary-key>
<unique-key-list/>
<foreign-key-list>
<foreign-key alias="" name="FK_accounts_bank_accounts_2" 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:-7904">
519 tomas_duli
<foreign-key-description/>
487 jsvitak
<foreign-key-figure>
519 tomas_duli
<fk-fig-target-terminal x="181" y="40"/>
487 jsvitak
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="account_id" referenced-key-column-name="id"/>
</foreign-key>
<foreign-key alias="" name="FK_accounts_bank_accounts_1" on-delete="" on-update="" referenced-key="PK_BANK_ACCOUNTS" referenced-table="bank_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:-79f2">
519 tomas_duli
<foreign-key-description/>
487 jsvitak
<foreign-key-figure>
519 tomas_duli
<fk-fig-source-terminal x="67" y="8"/>
<fk-fig-target-terminal x="6" y="68"/>
487 jsvitak
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="bank_account_id" referenced-key-column-name="id"/>
</foreign-key>
</foreign-key-list>
<index-list/>
</table>
519 tomas_duli
<table alias="" name="work_reports" remarks="" uid="1f4899c:123ebc4f1c6:-7e47">
<table-description/>
<table-figure-bounds height="136" width="187" x="226" y="469"/>
<column-list>
<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 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<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 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="65535" decimal-digits="0" default-value="" mandatory="false" name="description" remarks="" uid="1f4899c:123ebc4f1c6:-7e35">
<column-description/>
<data-type jdbc-type="12" literal-prefix="'" literal-suffix="'" name="VARCHAR" selected-variant-pattern="VARCHAR(%n)">
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n)"/>
<variant precision-max="255" precision-min="1" precision-variable="%n" type-name-pattern="VARCHAR(%n) BINARY"/>
</data-type>
</column>
<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 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<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 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"/>
<variant type-name-pattern="INT UNSIGNED"/>
<variant type-name-pattern="INT UNSIGNED ZEROFILL"/>
<variant type-name-pattern="INT ZEROFILL"/>
</data-type>
</column>
<column alias="" auto-increment="false" column-size="0" decimal-digits="0" default-value="" mandatory="false" name="submitted" remarks="" uid="1f4899c:123ebc4f1c6:-7da5">
<column-description/>
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="DATETIME" selected-variant-pattern="DATETIME">
<variant type-name-pattern="DATETIME"/>
</data-type>
</column>
</column-list>
<primary-key alias="" name="PK_WORK_REPORTS" remarks="" uid="1f4899c:123ebc4f1c6:-7e46">
<primary-key-description/>
<primary-key-column name="id"/>
</primary-key>
<unique-key-list/>
<foreign-key-list>
<foreign-key alias="" name="FK_work_reports_1" on-delete="" on-update="" referenced-key="PK_MONEY_TRANSFERS_PRIMARY" referenced-table="transfers" 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:-7df9">
<foreign-key-description/>
<foreign-key-figure>
<fk-fig-source-terminal x="81" y="7"/>
<fk-fig-bendpoint-list/>
</foreign-key-figure>
<foreign-key-column column-name="transfer_id" referenced-key-column-name="id"/>
</foreign-key>
</foreign-key-list>
<index-list/>
</table>
191 tomas_duli
</table-list>
</schema>
</schema-list>
</database-model>
</clay-model>