|
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
|
|
<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">
|
|
<database-model-description></database-model-description>
|
|
<schema-list>
|
|
<schema alias="" name="DEFAULT_SCHEMA" remarks="" uid="13ed0e:11d774ed92c:-7ffe">
|
|
<schema-description></schema-description>
|
|
<domain-list/>
|
|
<table-list>
|
|
<table alias="" name="accounts" remarks="" uid="13ed0e:11d774ed92c:-7ffd">
|
|
<table-description></table-description>
|
|
<table-figure-bounds height="-1" width="-1" x="541" y="91"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7ffb">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></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="0" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="13ed0e:11d774ed92c:-7ff8">
|
|
<column-description></column-description>
|
|
<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="22" decimal-digits="0" default-value="" mandatory="false" name="start_amount" remarks="" uid="13ed0e:11d774ed92c:-7ff7">
|
|
<column-description></column-description>
|
|
<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="254" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="13ed0e:11d774ed92c:-7ff6">
|
|
<column-description></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-list>
|
|
<primary-key alias="" name="PK_ACCOUNTS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7ffc">
|
|
<primary-key-description></primary-key-description>
|
|
<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">
|
|
<foreign-key-description></foreign-key-description>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="11" y="45"/>
|
|
<fk-fig-target-terminal x="200" y="128"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="member_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list>
|
|
<index alias="" name="is_owned_by" remarks="" uid="13ed0e:11d774ed92c:-7ff5" unique="false">
|
|
<index-description></index-description>
|
|
<index-column name="member_id" sort="ASC"/>
|
|
</index>
|
|
</index-list>
|
|
</table>
|
|
<table alias="" name="members" remarks="" uid="13ed0e:11d774ed92c:-7fe9">
|
|
<table-description></table-description>
|
|
<table-figure-bounds height="-1" width="-1" x="209" y="9"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fe7">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></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="50" decimal-digits="0" default-value="" mandatory="false" name="street_number" remarks="" uid="13ed0e:11d774ed92c:-7fe5">
|
|
<column-description></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="250" decimal-digits="0" default-value="" mandatory="false" name="street" remarks="" uid="13ed0e:11d774ed92c:-7fe4">
|
|
<column-description></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="250" decimal-digits="0" default-value="" mandatory="false" name="town" remarks="" uid="13ed0e:11d774ed92c:-7fe3">
|
|
<column-description></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="ZIP_code" remarks="" uid="13ed0e:11d774ed92c:-7fe2">
|
|
<column-description></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="3" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="13ed0e:11d774ed92c:-7fe1">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></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="20" decimal-digits="0" default-value="" mandatory="false" name="qos_rate" remarks="" uid="13ed0e:11d774ed92c:-7fdf">
|
|
<column-description></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="22" decimal-digits="0" default-value="" mandatory="false" name="entrance_fee" remarks="" uid="13ed0e:11d774ed92c:-7fde">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></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="old_db_id" remarks="" uid="13ed0e:11d774ed92c:-7fd4">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<primary-key-description></primary-key-description>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list/>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="money_transfer_bank_infos" remarks="" uid="13ed0e:11d774ed92c:-7fd3">
|
|
<table-description></table-description>
|
|
<table-figure-bounds height="-1" width="-1" x="817" y="326"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7e41">
|
|
<column-description></column-description>
|
|
<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>
|
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="false" name="transfer_id" remarks="" uid="13ed0e:11d774ed92c:-7fd1">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></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-list>
|
|
<primary-key alias="" name="PK_MONEY_TRANSFER_BANK_INFOS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fd2">
|
|
<primary-key-description></primary-key-description>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_money_transfer_bank_infos_1" on-delete="" on-update="" referenced-key="PK_MONEY_TRANSFERS_PRIMARY" referenced-table="money_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">
|
|
<foreign-key-description></foreign-key-description>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="0" y="51"/>
|
|
<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>
|
|
<table alias="" name="money_transfers" remarks="" uid="13ed0e:11d774ed92c:-7fcc">
|
|
<table-description></table-description>
|
|
<table-figure-bounds height="-1" width="-1" x="532" y="321"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="13ed0e:11d774ed92c:-7fca">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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="previous_transfer_id" remarks="" uid="13ed0e:11d774ed92c:-7fc7">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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="CURRENT_TIMESTAMP" mandatory="true" name="timestamp" remarks="" uid="13ed0e:11d774ed92c:-7fc6">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="93" literal-prefix="'" literal-suffix="'" name="TIMESTAMP" selected-variant-pattern="TIMESTAMP(%n)">
|
|
<variant precision-max="14" precision-min="0" precision-variable="%n" type-name-pattern="TIMESTAMP(%n)"/>
|
|
<variant type-name-pattern="TIMESTAMP"/>
|
|
</data-type>
|
|
</column>
|
|
<column alias="" auto-increment="false" column-size="254" decimal-digits="0" default-value="" mandatory="false" name="text" remarks="" uid="13ed0e:11d774ed92c:-7fc5">
|
|
<column-description></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="22" decimal-digits="0" default-value="" mandatory="false" name="amount" remarks="" uid="13ed0e:11d774ed92c:-7fc4">
|
|
<column-description></column-description>
|
|
<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">
|
|
<primary-key-description></primary-key-description>
|
|
<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">
|
|
<foreign-key-description></foreign-key-description>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="41" y="0"/>
|
|
<fk-fig-target-terminal x="32" y="97"/>
|
|
<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_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-description>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="130" y="4"/>
|
|
<fk-fig-target-terminal x="122" y="94"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="destination_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list>
|
|
<index alias="" name="from" remarks="" uid="13ed0e:11d774ed92c:-7fc3" unique="false">
|
|
<index-description></index-description>
|
|
<index-column name="origin_id" sort="ASC"/>
|
|
</index>
|
|
<index alias="" name="to" remarks="" uid="13ed0e:11d774ed92c:-7fc2" unique="false">
|
|
<index-description></index-description>
|
|
<index-column name="destination_id" sort="ASC"/>
|
|
</index>
|
|
</index-list>
|
|
</table>
|
|
<table alias="" name="users" remarks="" uid="13ed0e:11d774ed92c:-7fc1">
|
|
<table-description></table-description>
|
|
<table-figure-bounds height="-1" width="-1" x="-63" y="236"/>
|
|
<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">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></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="30" decimal-digits="0" default-value="" mandatory="false" name="middle_name" remarks="" uid="13ed0e:11d774ed92c:-7fbc">
|
|
<column-description></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="60" decimal-digits="0" default-value="" mandatory="false" name="surname" remarks="" uid="13ed0e:11d774ed92c:-7fbb">
|
|
<column-description></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="40" decimal-digits="0" default-value="" mandatory="false" name="pre_title" remarks="" uid="13ed0e:11d774ed92c:-7fba">
|
|
<column-description></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="30" decimal-digits="0" default-value="" mandatory="false" name="post_title" remarks="" uid="13ed0e:11d774ed92c:-7fb9">
|
|
<column-description></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="birthday" remarks="" uid="13ed0e:11d774ed92c:-7fb8">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></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="60" decimal-digits="0" default-value="" mandatory="false" name="email" remarks="" uid="13ed0e:11d774ed92c:-7fb6">
|
|
<column-description></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="50" decimal-digits="0" default-value="" mandatory="false" name="login" remarks="" uid="13ed0e:11d774ed92c:-7fb5">
|
|
<column-description></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="50" decimal-digits="0" default-value="" mandatory="false" name="password" remarks="" uid="13ed0e:11d774ed92c:-7fb4">
|
|
<column-description></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="7" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="13ed0e:11d774ed92c:-7fb3">
|
|
<column-description></column-description>
|
|
<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">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></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="240" decimal-digits="0" default-value="all" mandatory="true" name="aro_section_value" remarks="" uid="13ed0e:11d774ed92c:-7faf">
|
|
<column-description></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="0" mandatory="true" name="aro_order_value" remarks="" uid="13ed0e:11d774ed92c:-7fae">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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">
|
|
<primary-key-description></primary-key-description>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list/>
|
|
<index-list>
|
|
<index alias="" name="login" remarks="" uid="13ed0e:11d774ed92c:-7fac" unique="true">
|
|
<index-description></index-description>
|
|
<index-column name="login" sort="ASC"/>
|
|
</index>
|
|
<index alias="" name="belogs_to_member" remarks="" uid="13ed0e:11d774ed92c:-7fab" unique="false">
|
|
<index-description></index-description>
|
|
<index-column name="member_id" sort="ASC"/>
|
|
</index>
|
|
<index alias="" name="email" remarks="" uid="13ed0e:11d774ed92c:-7faa" unique="false">
|
|
<index-description></index-description>
|
|
<index-column name="email" sort="ASC"/>
|
|
</index>
|
|
<index alias="" name="phone" remarks="" uid="13ed0e:11d774ed92c:-7fa9" unique="false">
|
|
<index-description></index-description>
|
|
<index-column name="phone" sort="ASC"/>
|
|
</index>
|
|
</index-list>
|
|
</table>
|
|
<table alias="" name="works" remarks="" uid="13ed0e:11d774ed92c:-7fa8">
|
|
<table-description></table-description>
|
|
<table-figure-bounds height="-1" width="-1" x="258" y="367"/>
|
|
<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-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) 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="true" name="user_id" remarks="" uid="13ed0e:11d774ed92c:-7fa5">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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="255" decimal-digits="0" default-value="" mandatory="false" name="description" remarks="" uid="13ed0e:11d774ed92c:-7fa4">
|
|
<column-description></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="12" decimal-digits="0" default-value="" mandatory="false" name="hours" remarks="" uid="13ed0e:11d774ed92c:-7fa3">
|
|
<column-description></column-description>
|
|
<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="confirmed_by_id" remarks="" uid="13ed0e:11d774ed92c:-7fa2">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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="13ed0e:11d774ed92c:-7fa1">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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_WORKS_PRIMARY" remarks="" uid="13ed0e:11d774ed92c:-7fa7">
|
|
<primary-key-description></primary-key-description>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="works_ibfk_10" on-delete="CASCADE" on-update="NO ACTION" 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="13ed0e:11d774ed92c:-7f9d">
|
|
<foreign-key-description></foreign-key-description>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="1" y="63"/>
|
|
<fk-fig-target-terminal x="190" y="193"/>
|
|
<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="works_ibfk_11" on-delete="CASCADE" on-update="NO ACTION" 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="13ed0e:11d774ed92c:-7f9c">
|
|
<foreign-key-description></foreign-key-description>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="2" y="95"/>
|
|
<fk-fig-target-terminal x="190" y="226"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="confirmed_by_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="works_ibfk_12" on-delete="CASCADE" on-update="NO ACTION" referenced-key="PK_MONEY_TRANSFERS_PRIMARY" referenced-table="money_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="13ed0e:11d774ed92c:-7f9b">
|
|
<foreign-key-description></foreign-key-description>
|
|
<foreign-key-figure>
|
|
<fk-fig-target-terminal x="1" y="65"/>
|
|
<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>
|
|
<index alias="" name="commited_by" remarks="" uid="13ed0e:11d774ed92c:-7fa0" unique="false">
|
|
<index-description></index-description>
|
|
<index-column name="user_id" sort="ASC"/>
|
|
</index>
|
|
<index alias="" name="transfer_salary" remarks="" uid="13ed0e:11d774ed92c:-7f9f" unique="false">
|
|
<index-description></index-description>
|
|
<index-column name="transfer_id" sort="ASC"/>
|
|
</index>
|
|
<index alias="" name="confirmed_by" remarks="" uid="13ed0e:11d774ed92c:-7f9e" unique="false">
|
|
<index-description></index-description>
|
|
<index-column name="confirmed_by_id" sort="ASC"/>
|
|
</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>
|
|
<table-figure-bounds height="124" width="143" x="802" y="144"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="19bc716:120374b574f:-7ff4">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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="true" name="account_id" remarks="" uid="19bc716:120374b574f:-7fed">
|
|
<column-description></column-description>
|
|
<data-type jdbc-type="4" name="INT" selected-variant-pattern="INT(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n)"/>
|
|
<variant type-name-pattern="INT"/>
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INT(%n) 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="254" decimal-digits="0" default-value="" mandatory="false" name="account_nr" remarks="" uid="19bc716:120374b574f:-7f77">
|
|
<column-description></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="bank_nr" remarks="" uid="19bc716:120374b574f:-7f74">
|
|
<column-description></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="254" decimal-digits="0" default-value="" mandatory="false" name="IBAN" remarks="" uid="19bc716:120374b574f:-7f6e">
|
|
<column-description></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="254" decimal-digits="0" default-value="" mandatory="false" name="SWIFT" remarks="" uid="19bc716:120374b574f:-7f65">
|
|
<column-description></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-list>
|
|
<primary-key alias="" name="PK_BANK_ACCOUNTS" remarks="" uid="19bc716:120374b574f:-7ff9">
|
|
<primary-key-description></primary-key-description>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_bank_accounts_1" on-delete="" on-update="" referenced-key="PK_ACCOUNTS_PRIMARY" referenced-table="accounts" referenced-table-schema="DEFAULT_SCHEMA" remarks="" source-entity-role="" source-multiplicity="0..1" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="19bc716:120374b574f:-7f86">
|
|
<foreign-key-description></foreign-key-description>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="5" y="30"/>
|
|
<fk-fig-target-terminal x="141" y="67"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="account_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
</table-list>
|
|
</schema>
|
|
</schema-list>
|
|
</database-model>
|
|
</clay-model>
|