|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
|
|
<clay-model clay-version="1.4.2">
|
|
<database-model alias="" author="" begin-script="" end-script="" name="freenetis-devices" remarks="" sql-dialect-id="jp.azzurri.clay.dialect.MySQL_5_0_Dialect" uid="1834b39:1238964e7e9:-8000" version="1.0">
|
|
<database-model-description/>
|
|
<schema-list>
|
|
<schema alias="" name="freenetis" remarks="" uid="1834b39:1238964e7e9:-7ffd">
|
|
<schema-description/>
|
|
<domain-list/>
|
|
<table-list>
|
|
<table alias="" name="devices" remarks="" uid="1834b39:1238964e7e9:-7fff">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="5" y="353"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="0" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-7ffa">
|
|
<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="0" decimal-digits="0" default-value="" mandatory="false" name="user_id" remarks="" uid="1834b39:1238964e7e9:-7ff9">
|
|
<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="0" decimal-digits="0" default-value="" mandatory="false" name="address_point_id" remarks="" uid="1834b39:1238964e7e9:-7ff8">
|
|
<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="name" remarks="" uid="1834b39:1238964e7e9:-7ff7">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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:-7ff6">
|
|
<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="login" remarks="" uid="1834b39:1238964e7e9:-7ff5">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="password" remarks="" uid="1834b39:1238964e7e9:-7ff4">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="1834b39:1238964e7e9:-7ff3">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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-list>
|
|
<primary-key alias="" name="PK_DEVICES" remarks="" uid="1834b39:1238964e7e9:-7ffe">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_devices_1" on-delete="" on-update="" referenced-key="PK_USERS" referenced-table="users" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7c71">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="58" y="3"/>
|
|
<fk-fig-target-terminal x="3" y="39"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="user_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="ifaces" remarks="" uid="1834b39:1238964e7e9:-7ff2">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="457" y="302"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-7fee">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="device_id" remarks="" uid="1834b39:1238964e7e9:-7fed">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="segment_id" remarks="" uid="1834b39:1238964e7e9:-7fec">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="mac" remarks="" uid="1834b39:1238964e7e9:-7feb">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="1834b39:1238964e7e9:-7fea">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="1834b39:1238964e7e9:-7fe9">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="wireless_setting_id" remarks="" uid="b07663:129571f5d15:-7dfc">
|
|
<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="0" decimal-digits="0" default-value="" mandatory="false" name="wmode" remarks="" uid="b07663:129571f5d15:-7df3">
|
|
<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-list>
|
|
<primary-key alias="" name="PK_IFACES" remarks="" uid="1834b39:1238964e7e9:-7ff1">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_ifaces_1" on-delete="" on-update="" referenced-key="PK_DEVICES" referenced-table="devices" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7e94">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="44" y="104"/>
|
|
<fk-fig-target-terminal x="136" y="116"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="device_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_ifaces_2" on-delete="" on-update="" referenced-key="PK_LINKS" referenced-table="links" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7dfe">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="17" y="2"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="segment_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_ifaces_3" on-delete="" on-update="" referenced-key="PK_WIRELESS_SETTINGS_IFACES" referenced-table="wireless_settings_ifaces" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="1" source-relationship-type="" target-entity-role="" target-multiplicity="1..*" target-relationship-type="" uid="b07663:129571f5d15:-7cc9">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="links" remarks="" uid="1834b39:1238964e7e9:-7fe8">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="253" y="159"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-7fe4">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="1834b39:1238964e7e9:-7fe3">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="technology" remarks="" uid="1834b39:1238964e7e9:-7fe2">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="bitrate" remarks="" uid="1834b39:1238964e7e9:-7fe1">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="duplex" remarks="" uid="1834b39:1238964e7e9:-7fe0">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="1834b39:1238964e7e9:-7fdf">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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-list>
|
|
<primary-key alias="" name="PK_LINKS" remarks="" uid="1834b39:1238964e7e9:-7fe7">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list/>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="subnets" remarks="" uid="1834b39:1238964e7e9:-7fde">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="656" y="-18"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-7fda">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="1834b39:1238964e7e9:-7fd9">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="network_address" remarks="" uid="1834b39:1238964e7e9:-7fd8">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="netmask" remarks="" uid="1834b39:1238964e7e9:-7fd7">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="redirect" remarks="" uid="1834b39:1238964e7e9:-7fd6">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="OSPF_area_id" remarks="" uid="1834b39:1238964e7e9:-7fd5">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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-list>
|
|
<primary-key alias="" name="PK_SUBNETS" remarks="" uid="1834b39:1238964e7e9:-7fdd">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list/>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="ip_addresses" remarks="" uid="1834b39:1238964e7e9:-7fd4">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="669" y="133"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-7fd0">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="iface_id" remarks="" uid="1834b39:1238964e7e9:-7fcf">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="vlan_iface_id" remarks="" uid="1834b39:1238964e7e9:-7fce">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="subnet_id" remarks="" uid="1834b39:1238964e7e9:-7fcd">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="ip_address" remarks="" uid="1834b39:1238964e7e9:-7fcc">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="dhcp" remarks="" uid="1834b39:1238964e7e9:-7fcb">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="gateway" remarks="" uid="1834b39:1238964e7e9:-7fca">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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-list>
|
|
<primary-key alias="" name="PK_IP_ADDRESSES" remarks="" uid="1834b39:1238964e7e9:-7fd3">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_ip_addresses_2" on-delete="" on-update="" referenced-key="PK_SUBNETS" referenced-table="subnets" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7d80">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="43" y="5"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="subnet_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_ip_addresses_1" on-delete="" on-update="" referenced-key="PK_IFACES" referenced-table="ifaces" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7e63">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="5" y="66"/>
|
|
<fk-fig-target-terminal x="93" y="2"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="iface_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_ip_addresses_3" on-delete="" on-update="" referenced-key="PK_VLAN_IFACES" referenced-table="vlan_ifaces" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1f4899c:123ebc4f1c6:-7eee">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-target-terminal x="47" y="2"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="iface_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="wireless_settings" remarks="" uid="1834b39:1238964e7e9:-7d25">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="480" y="24"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-7d21">
|
|
<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="norm" remarks="" uid="1834b39:1238964e7e9:-7d1c">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="frequence" remarks="" uid="1834b39:1238964e7e9:-7d1b">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="channel" remarks="" uid="1834b39:1238964e7e9:-7d1a">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="antenna" remarks="" uid="1834b39:1238964e7e9:-7d19">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="polarization" remarks="" uid="1834b39:1238964e7e9:-7d18">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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-list>
|
|
<primary-key alias="" name="PK_WIRELESS_SETTINGS" remarks="" uid="1834b39:1238964e7e9:-7d24">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_wireless_settings_1" on-delete="" on-update="" referenced-key="PK_WIRELESS_SETTINGS_IFACES" referenced-table="wireless_settings_ifaces" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="1" source-relationship-type="" target-entity-role="" target-multiplicity="1..*" target-relationship-type="" uid="b07663:129571f5d15:-7d1b">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="users" remarks="" uid="1834b39:1238964e7e9:-7ca8">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="41" y="3"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-7ca4">
|
|
<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="11" decimal-digits="0" default-value="" mandatory="false" name="member_id" remarks="" uid="1834b39:1238964e7e9:-7ca3">
|
|
<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="login" remarks="" uid="1834b39:1238964e7e9:-7ca2">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="password" remarks="" uid="1834b39:1238964e7e9:-7ca1">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="1834b39:1238964e7e9:-7ca0">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="surname" remarks="" uid="1834b39:1238964e7e9:-7c9f">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="phone" remarks="" uid="1834b39:1238964e7e9:-7c9e">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="email" remarks="" uid="1834b39:1238964e7e9:-7c9d">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="type" remarks="" uid="1834b39:1238964e7e9:-7c9c">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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-list>
|
|
<primary-key alias="" name="PK_USERS" remarks="" uid="1834b39:1238964e7e9:-7ca7">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list/>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="device_engineers" remarks="" uid="1834b39:1238964e7e9:-78bf">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="105" y="229"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="false" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="device_id" remarks="" uid="1834b39:1238964e7e9:-78bb">
|
|
<column-description/>
|
|
<data-type jdbc-type="4" name="INTEGER" selected-variant-pattern="INTEGER(%n)">
|
|
<variant precision-max="10" precision-min="0" precision-variable="%n" type-name-pattern="INTEGER(%n)"/>
|
|
<variant type-name-pattern="INTEGER"/>
|
|
<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="11" decimal-digits="0" default-value="" mandatory="true" name="user_id" remarks="" uid="1834b39:1238964e7e9:-78ba">
|
|
<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="11" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-788e">
|
|
<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_DEVICE_ENGINEERS" remarks="" uid="1834b39:1238964e7e9:-78be">
|
|
<primary-key-description/>
|
|
<primary-key-column name="device_id"/>
|
|
<primary-key-column name="user_id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_device_engineers_1" on-delete="" on-update="" referenced-key="PK_USERS" referenced-table="users" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-788f">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="51" y="4"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="device_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_device_engineers_2" on-delete="" on-update="" referenced-key="PK_DEVICES" referenced-table="devices" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-783e">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="66" y="58"/>
|
|
<fk-fig-target-terminal x="67" y="5"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="user_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="ports" remarks="" uid="1834b39:1238964e7e9:-7829">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="253" y="316"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-7825">
|
|
<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="11" decimal-digits="0" default-value="" mandatory="false" name="device_id" remarks="" uid="1834b39:1238964e7e9:-7824">
|
|
<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="11" decimal-digits="0" default-value="" mandatory="false" name="segment_id" remarks="" uid="1834b39:1238964e7e9:-7823">
|
|
<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="name" remarks="" uid="1834b39:1238964e7e9:-7822">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="untagged_vlan_id" remarks="" uid="b07663:129571f5d15:-7fe1">
|
|
<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-list>
|
|
<primary-key alias="" name="PK_PORTS" remarks="" uid="1834b39:1238964e7e9:-7828">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_ports_1" on-delete="" on-update="" referenced-key="PK_LINKS" referenced-table="links" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-77f5">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="57" y="10"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="segment_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_ports_2" on-delete="" on-update="" referenced-key="PK_DEVICES" referenced-table="devices" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-77d1">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="3" y="52"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="device_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_ports_3" on-delete="" on-update="" referenced-key="PK_VLANS" referenced-table="vlans" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="b07663:129571f5d15:-7f93">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="63" y="90"/>
|
|
<fk-fig-target-terminal x="5" y="31"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_ports_4" on-delete="" on-update="" referenced-key="PK_WIRELESS_SETTINGS_PORTS" referenced-table="wireless_settings_ports" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="b07663:129571f5d15:-7bfa">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="vlans" remarks="" uid="1834b39:1238964e7e9:-77b1">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="687" y="415"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-77ad">
|
|
<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="name" remarks="" uid="1834b39:1238964e7e9:-77ac">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="tag_802_1q" remarks="" uid="1834b39:1238964e7e9:-77ab">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="comment" remarks="" uid="1834b39:1238964e7e9:-77aa">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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-list>
|
|
<primary-key alias="" name="PK_VLANS" remarks="" uid="1834b39:1238964e7e9:-77b0">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list/>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="vlan_ifaces" remarks="" uid="1834b39:1238964e7e9:-77a9">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="685" y="287"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="true" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-77a5">
|
|
<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="vlan_id" remarks="" uid="1834b39:1238964e7e9:-77a2">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="iface_id" remarks="" uid="1834b39:1238964e7e9:-77a1">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="name" remarks="" uid="1834b39:1238964e7e9:-77a0">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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-list>
|
|
<primary-key alias="" name="PK_VLAN_IFACES" remarks="" uid="1834b39:1238964e7e9:-77a8">
|
|
<primary-key-description/>
|
|
<primary-key-column name="id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_vlan_ifaces_3" on-delete="" on-update="" referenced-key="PK_VLANS" referenced-table="vlans" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-769a">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-target-terminal x="52" y="2"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="vlan_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_vlan_ifaces_2" on-delete="" on-update="" referenced-key="PK_IFACES" referenced-table="ifaces" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-771f">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="5" y="44"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="iface_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="ports_vlans" remarks="" uid="1834b39:1238964e7e9:-7654">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="405" y="484"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="false" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="port_id" remarks="" uid="1834b39:1238964e7e9:-7650">
|
|
<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="11" decimal-digits="0" default-value="" mandatory="true" name="vlan_id" remarks="" uid="1834b39:1238964e7e9:-764f">
|
|
<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="11" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="1834b39:1238964e7e9:-75c4">
|
|
<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_PORTS_VLANS" remarks="" uid="1834b39:1238964e7e9:-7653">
|
|
<primary-key-description/>
|
|
<primary-key-column name="port_id"/>
|
|
<primary-key-column name="vlan_id"/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_ports_vlans_1" on-delete="" on-update="" referenced-key="PK_PORTS" referenced-table="ports" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-75c5">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="3" y="28"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="port_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
<foreign-key alias="" name="FK_ports_vlans_2" on-delete="" on-update="" referenced-key="PK_VLANS" referenced-table="vlans" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="1834b39:1238964e7e9:-7546">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-source-terminal x="78" y="36"/>
|
|
<fk-fig-target-terminal x="6" y="60"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="vlan_id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="enum_anteny" remarks="" uid="b07663:129571f5d15:-7f67">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="381" y="25"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="false" column-size="10" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="b07663:129571f5d15:-7f1f">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<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="10" decimal-digits="0" default-value="" mandatory="false" name="blabla" remarks="" uid="b07663:129571f5d15:-7e85">
|
|
<column-description/>
|
|
<data-type jdbc-type="1" literal-prefix="'" literal-suffix="'" name="CHAR" selected-variant-pattern="CHAR(%n)">
|
|
<variant type-name-pattern="CHAR"/>
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n)"/>
|
|
<variant precision-max="255" precision-min="0" precision-variable="%n" type-name-pattern="CHAR(%n) BINARY"/>
|
|
</data-type>
|
|
</column>
|
|
</column-list>
|
|
<primary-key alias="" name="PK_ENUM_ANTENY" remarks="" uid="b07663:129571f5d15:-7f66">
|
|
<primary-key-description/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_enum_anteny_1" on-delete="" on-update="" referenced-key="PK_WIRELESS_SETTINGS_IFACES" referenced-table="wireless_settings_ifaces" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="1" source-relationship-type="" target-entity-role="" target-multiplicity="1..*" target-relationship-type="" uid="b07663:129571f5d15:-7c63">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-target-terminal x="7" y="18"/>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="wireless_settings_ifaces" remarks="" uid="b07663:129571f5d15:-7d5b">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="476" y="162"/>
|
|
<column-list/>
|
|
<primary-key alias="" name="PK_WIRELESS_SETTINGS_IFACES" remarks="" uid="b07663:129571f5d15:-7d5a">
|
|
<primary-key-description/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list/>
|
|
<index-list/>
|
|
</table>
|
|
<table alias="" name="wireless_settings_ports" remarks="" uid="b07663:129571f5d15:-7c3b">
|
|
<table-description/>
|
|
<table-figure-bounds height="-1" width="-1" x="215" y="93"/>
|
|
<column-list>
|
|
<column alias="" auto-increment="false" column-size="11" decimal-digits="0" default-value="" mandatory="true" name="id" remarks="" uid="b07663:129571f5d15:-7b9d">
|
|
<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_WIRELESS_SETTINGS_PORTS" remarks="" uid="b07663:129571f5d15:-7c3a">
|
|
<primary-key-description/>
|
|
</primary-key>
|
|
<unique-key-list/>
|
|
<foreign-key-list>
|
|
<foreign-key alias="" name="FK_wireless_settings_ports_1" on-delete="" on-update="" referenced-key="PK_WIRELESS_SETTINGS" referenced-table="wireless_settings" referenced-table-schema="freenetis" remarks="" source-entity-role="" source-multiplicity="0..*" source-relationship-type="" target-entity-role="" target-multiplicity="1" target-relationship-type="" uid="b07663:129571f5d15:-7b9e">
|
|
<foreign-key-description/>
|
|
<foreign-key-figure>
|
|
<fk-fig-bendpoint-list/>
|
|
</foreign-key-figure>
|
|
<foreign-key-column column-name="id" referenced-key-column-name="id"/>
|
|
</foreign-key>
|
|
</foreign-key-list>
|
|
<index-list/>
|
|
</table>
|
|
</table-list>
|
|
</schema>
|
|
</schema-list>
|
|
</database-model>
|
|
</clay-model>
|