FreenetIS

<LMModel DescriptionSize="4096" Description="789cedceb10ac2301006e0824e4e3ec2915d8b9bd43493080eba54704edbab29246d4daf607d7a537d0811ef234be0e7bf5f1a72564983ba54d2216968b4c354dc7d5d18c2070928da86b0a1546c04c44ac69f6cde9623f434da10ae4262d5d74f4cb61deddebf4abbda8ec92983cca0b5b0b737a116b2531753f7105e31781f5aed086430dc709d45422835e95cf718aafd50d0e011da0a0e1ef18c74ccd632ee424d3c5d9fa64ce323f647e6d7285a46b36fcf608c31c618638cb15ff30202824429" Align="68" DisplayFlags="0" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" BackgroundColor="#ffffff" FontBold="0" BackgroundImagePlacement="0" FontItalic="0" ModificationDate="2008-01-21T23:28:36" Author="Tomas Dulik" TextFlag="2048" CreationDate="2008-01-21T23:06:51" BackgroundType="0" FontStrikeOut="0" Name="FreeNetIS Database" BackgroundStyle="none" Version="2.2" NextOID="183" FontFamily="MS Shell Dlg" ><![CDATA[FreeNetIS database structure ER diagram]]><LMEntityNormal DescriptionSize="4096" width="131" Description="789cd5567b3494fbbb7fcd2422d46e9b8cc8507227c316862191c8ade49e9a696630e6829971d718612b8472a910daf64ecc18a688284665c4104523d7dced49eea9c4e650679db5f6faad75d6f9f7bc7fbdcff37cbe9fe7f33c9f77bdeb6b164023119166013834166946c2d1d030329a84335709a1e03101345c044d05860922d370649ab98abe0a4c0f69a6f7137b29081b09a3d222895b60bf2d840e151f8533350ea6217e447e68129e1869eae80a730dc01189306ba2bf0a52c22c1869460d4693ff75301c87f70fa0991a1d3daa82b4c65131147c300d1f443635d3db866e350cfe71f05c000e76094dc56360a1541c05b6a5084f8bd4856da729383435880cf30ba2c08e848406d1108eb84b38cacf57189e0aa305a0693034ccc9d61946092593f164ffad140e769282c339e16878aa0e094d46fbe3b030328e161e4421c0305b1203d06138183988ac131c1049c5e0d1449d601c65bb0d0947da62a7c2d4cd83b65828b0208a3f9a8c8f426f8ba66ac0d064ec363b15f7efc20f4e3c19430cc5e2605bfd227f8cb1c5b24d8fc7a089b09ff4540d5d98f30f5e5c049a144cdca2f1fb1f19dbb87fcbd81eefe7a068d8cf9dff8c747fae4d6fdba66dcfb65d060493b192858d4353040b11f7579e035354f2d7d5e2b563b78dc6a2a7b23aa70d6c99931886ea2ce75b21122c607f1fc2658535f69d8a19e02a6661f41dcbc558df763f61cda70c548a29f2a5dda0ed1df466efc65ceb499fa3c650c2805eac4243fb3bf2f8aed6b94bbd0715f25e9f7a7d3eb4bd3aa96c2f3af8a344b87146155dacafd0b9bc7a2f69ffa526595d966e1693a10425d08a77b094870f03b237384683fb8f6f7116764e372f959f01413e8d868b9cb78a665d66cfb21786c20e381dae3c77c1b796f5bdf71ab8f2242faa3bc5162b2209aa97c88a579a57a8cce9b6d195cb4fcdee26ec11ae5c6ed23fdeb2d138aa15fecfc9971ab0fbe682e01dda5745efde17c957c3cc3e9e39387fb1fe7a21aefe7abd11398511fa9737621c756b22ddaa739e1bf951c2c357d6f623be461925c2c5605925cfde918b9719b2e949fb1cbc90be8f1bbcf20ace9fa0141458b80369999cb4dac762496255d5d5f53a1f86f313c6e4aa52edf3ba33099e3e3939aab1afef6e6219b6af3cf1e68ae8e828bd01dd186648747e1cb26574c73df9113328532924b4cfd09b5b972343960b79a6cf8d9cd3327b50369036351743dfa43b97e883058a1feccd3f18867fff270660ffa1a075af39e097cf73d4a27dcdbfeb80e7071d3e62ef59b7cae7126e8971e3b1ac29e1907fee597df5db700ba9832cc74e96b2810cb07ec6437c418903ad4d4e95d5ac5887b259e280bac0ce77b4dacb9f446a15d6f05837ab4ac2956a333e4807673bc105868eaeb149cde642c77924e0929d0617644cddf09dda903f22650f1481e0022bc23f512d87ea81240d60275b156393e3464e1c559553fb466f2ae28120f93714a4063b258c5b2f27cedea9a7159e8f7c617373a85024ff9e02b31dce675d273d66d5496ed084eed83ade8e2f6d9fc7665a44f395313682b19ef588c8bfafebd1e3ddffdeaff867a6d05e59c0f6d11319b183bb4f6035ebd095dc8936432874f519d8c56296430ef6752dadae3a826a72bb09367aa0bee3752687fd38d5a60423187c6c1e216a1b5b2b586a29831cac4da87b0ecaf38dd19d11bb65f0614f225d4fc5af2991dce0252ad7333dd03c3ab12ca46adf9d504f0041065be6256b93eb9efb197f065b9ec0b28ce48cc4807e15cc6f965c10638ad633f5acdb276e42f341db740529e6a1fecc74b7dd218f91a76970f7d8a4ea58444bdd21e26427c41205bd77c578e5cd2478a162ab943e27ed49f09744557cd03bf516e4d78f1101ce3bf302b9cb8e0fe9bd63859d2d36268042b7af2f9aa2900721340dcfb987b2cdcf5d1707c468b73839645207ad66fe6b78c984cf80ae8708178ae991ddd85984774919dd03dc36d56b093c75fed16a98aff29e357a6348badac7eeb8c350a67c696e874ffac06b48b0e50278171d4e47721d78f2fdfd7dcf4dc012ab71008117906e03f597046adbe4a0a7bb4380112fdf5ed9d752ad79e29e24920e90f1ce97970bb6a7daa9be1f69dce0000cc84a36c708d15466107119b9f9cf66ba660d0450eff2e095195891bc0788939e0bd3ad17120a23cb4fca78583e698043ba380556d7b4d4e5b8725f654180d9691ec8746535e11d7d39eb9bb3eae9f20e20636973a0be5ea78fa6bebb283f647833fb6e8a69797591954e72b6494519a96af844cf2da56ba9a22ec7d9a030fb5b1cdef40893fda486e7d5f8484c7770707ee9e3d07cd2ecbda9477745901951ed6b6f35f98b6a62f29c6f87f5a38f56aaf822047fa05db44487e50ed4f949a17e4b3a372753753814e1fe6c69d49899e7345351d1399ef310c2bc20796c51b34cd9861256d677325151fd95a70d5db38668667eec61ef0026ee407f409a3771effe470c59b820b9b9ffa3b65547d6ace75e8fd127524ab2a5fa72ef52c30ae75c33f379c52fb58b6098f26f95ceca739a34b3b72c61476c1baa04ac76d7b7ad0a7c66afe846e021cce5b38d0ae943e497deeb3a7b57bc8b9f0638ae975f287830d5338e7c74b72676c7b71ba618376419df947279f9cc9369bca373d28b9c605e73da10857c0e76877e6ad16c66edfc4c73438f94a850d098e9672e676a683c10e7c3867be3b4c679e4e3e0b335986cc8875d51acdc9c7221a43b2124aecdc789299b710103d5128ec7e81375a47746231eec96663e994426bb078a738b0d73380f11e8efe2e27bba03b34bc9450956602ccb07a1a169875a61ddfc85bf79b84b1a3a234873fbde52c1a1fa6506dcd8acb227d40c12ed4b31fe3b232050adf4e6c47dfb939e732387d31ae0fd8a01d675a96ebaef0671f49ca0cd6c428afb0bbb40f293e6aec6f129222b15dc99ad8b711ca292a6aea6f4c9e6cd2d97745f6df3d12d0a9929c02914cdd44d400959381e48e72c76453821edd5669c6177003a53dedc57babf86d61c6832d0e264bb7eb08c3a23734fa3f0cb61d0e0efa92be111b626e8b12fbf2607a5fbae57aaa156c3ee39a6985f036454308e5150ab0b5c495fb62df7ca6bb80bd7a0d573eb638f37415e33bab417e80add8c5903e97286268da47334096d1c296fae1d8d09fe9a59a7c85c92faabeff6e7be8c2f64675b9bc84ffdc8069911ea856a51324be9ac59def78db2954b15a9b637e5d66bd9a9174f087fdff927b94553f140c69c2a054095f0e0024ec2618fa69b1b25df6f149b28c0dc315049f1b75f1b0f49dd2f1489c08f3fb302188456cff4379bdfbe24720f54d4f7cc4a183a5d1c35f8fbd6a817ef47741a01d9e3cc0665700e3a37ee06063352b39b98083fb99dfa920059652882d56bf6a9bb3aa4ee52d37561fa403432810e651febf87c4b1a427c980a76ced2c584664e927932dd2d33343eb153686a92f36b42b85f48e06ecfeed9126b5d9c42c495542833862cf85a2424c417b309ce6ebc38b557b7397e7ebff592c2cb7be9e51777cee9d940c596f0308c22b5919e50b1c2b7b4ffaa356e0997c2b242ba66d8e6419b0bb22523b1767ce3059a9d69def78619f8ba626ca9df8b7422eefcd6566e2b4902b0825451608f330f045c55dbfa05becce400c058ab27002cca6f954fddcf1f2ff3e3f7973afc01e49fe0810efe75bef7891f7f2c12b93e0be47d9605097b5e16a1337218aef816d0377dd2a0f76914c65570526c92376a6980d51e3913566e52cb2404095ed486883c924951ccb25cde4e07f2bcdfad135e6503ac4c0e235557dcd3bb9ce1c87b0a1646acc9d4c659cf7a06deecba4231138c8997835f74964cf70d4faf388d11a7735fc4e57c8eef3f181c7df943a807928924ee8a8eaefddd28c0f28f306d860d6ef9ac23b72f3aebda014623561b560fbe369d7b82d1931a29f61fe361b50146041c6229ba9c0242fcc8b4a78b9a75f0da4c2a74ba952e16d6d4e815a04394325122efb605df3feeef6085db9d7bf2af9a81fd9d9561da968a50c90816b78b4a7ca6c808854318d6a22f0da614235806c32bcb1bb03dd608c882fab8cb67f69ae211b7b42b9b0bf984b5803950d94abcedce1feaef14b8bd9537b4bca80c589a41ff3723fe5be97fc0beced7e801454e9bb392c0fb6d6f50720d97450184506bc7ff99e2ff1b6c53242c785fe5edee97cbc0d66367e364cdb6425dc188ed76e0814eca86e7bbd79eb3b4cdb2b4c7414f8b2016fe3c2d4f340914d1d8fcfa652730e8f768bc4ae31db56594a221ea9d4857ea995eee54fb126deaec85ece8dc555dc6522024e71a6bfbdcdec0f6df815fe9a05b671ab47fd23964dc17d2bf74dbf5bd623fe5e031839c57a94b50070d3c20e656a687917d6cb66250dce5072a96e90dcb7f2ca03dab4418aebdbf6fd0d19f857a73f53bdcddc4e2115a741762c3b595746977f3082d9bbffe00d380907f43e12d19c45b54a47af6fea2e474ebd7d3ae35de034f37935524622d24aa4e1ad430bc9862da4ab1c12825a5bd2bb7d35755133d97f3419050264b41ebc1e42ea742feb510842b90ebf296551ed3eef2c00d072568062c3798a81df224d07e0beb6baf0808641be69f2ebba2c12f696c69a201af997a18c7cd34d8ce44a335da2b874fcfe1472f377ec04996a3dad661116567f67313cbda3d9359ea676a3d582b1582bb1d11862d2cd4eb6ae1f56bb6211b265fee4b1c4270eb340d205896cd82836178e0fabeac20925350f6c1370c899ea88bcaa91377dcb1d462e648daf36a21b075b9941c0e6f19d1e2b71bd634783f265d74df2bdd3f65de70ccc4e94eebbdddf1f6ada8c5ea122e0aabfdc0ea286d78a3b971711c7b17b5840f1296558a5ea027b0f1f60e77202204d2e2846b016dc3a01796ae752e8773f3ba1b5f0dc23e6a3230aad4e9c37fabe83fc1ff957e456de6e4f80bfe3cdfe7cbe8310b9c5ee38e7e0f2f5eaebb3c33c7b9bd6241da5f302f6e35911675e29730a98c5b594f3b54feb6e90bdf05ee9e522cc3a817f1da6553ba1bc1e68e0d7cd965dbaaf5e0310e2da770a23f7e5265d1c56c55c66235795563713cc2ef9beb4513819d9ad8fbd69ab8eb4c8de9999ed5cdf5878bfc721dfefb2cc6a0ae9385aaebcd586f7769b6b96aa52086e45dca7ac542936e741476394a2d8d385f866add392da17624963259aab599d7ba3e31e6e1a0ebb3f4960efc1780126778" x="365" TextField="2" Align="68" y="289" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="1" height="314" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Member" NextOID="27" FontFamily="MS Shell Dlg" ><![CDATA[The basic entity. The reason for distinguishing between Users and Members is that a NGO running the FreeNetis-managed network can have non-physcial-person members (=other organizations) and these organizations can include many users (physical persons). Other example of non-physical-person member is "a family".]]><sink x="0.916667" y="0.1" OID="20" />

<sink x="0.969466" y="0.0828025" OID="26" />

<LMAttribute OID="1" Identifier="1" >

<Uses Class="LMDataItem" Path="2" Name="ID" />

</LMAttribute>

<LMAttribute OID="25" >

<Uses Class="LMDataItem" Path="157" Name="name" />

</LMAttribute>

<LMAttribute OID="2" >

<Uses Class="LMDataItem" Path="3" Name="street_number" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="4" Name="street" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="5" Name="town" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="6" Name="ZIP_code" />

</LMAttribute>

<LMAttribute OID="6" >

<Uses Class="LMDataItem" Path="7" Name="type" />

</LMAttribute>

<LMAttribute OID="7" >

<Uses Class="LMDataItem" Path="8" Name="login" />

</LMAttribute>

<LMAttribute OID="8" >

<Uses Class="LMDataItem" Path="9" Name="password" />

</LMAttribute>

<LMAttribute OID="10" >

<Uses Class="LMDataItem" Path="10" Name="qos_ceil" />

</LMAttribute>

<LMAttribute OID="16" >

<Uses Class="LMDataItem" Path="16" Name="qos_rate" />

</LMAttribute>

<LMAttribute OID="11" >

<Uses Class="LMDataItem" Path="11" Name="entrance_fee" />

</LMAttribute>

<LMAttribute OID="15" >

<Uses Class="LMDataItem" Path="15" Name="debt_payment_rate" />

</LMAttribute>

<LMAttribute OID="17" >

<Uses Class="LMDataItem" Path="17" Name="entrance_fee_left" />

</LMAttribute>

<LMAttribute OID="13" >

<Uses Class="LMDataItem" Path="13" Name="must_pay_regular_fee" />

</LMAttribute>

<LMAttribute OID="14" >

<Uses Class="LMDataItem" Path="14" Name="current_credit" />

</LMAttribute>

<LMAttribute OID="18" >

<Uses Class="LMDataItem" Path="18" Name="entrance_date" />

</LMAttribute>

<LMAttribute OID="21" >

<Uses Class="LMDataItem" Path="37" Name="comment" />

</LMAttribute>

</LMEntityNormal>

<LMEntityNormal width="130" x="173" TextField="2" Align="68" y="295" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="20" height="329" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="User" NextOID="25" FontFamily="MS Shell Dlg" ><![CDATA[The table "Users" holds **compulsory** contact information about individual users (each member can have several users).

An additional contact info can be stored in the table "Contacts"]]><sink x="0.815385" y="0.00911854" OID="24" />

<sink x="0.0650888" y="0.0931174" OID="1" />

<sink x="0.922481" y="0.110672" OID="14" />

<sink x="0.829457" y="0.141304" OID="18" />

<sink x="0.0852713" y="0.15942" OID="21" />

<sink x="0.292308" y="0.0121581" OID="23" />

<LMAttribute OID="17" >

<Uses Class="LMDataItem" Path="43" Name="ID_member" />

</LMAttribute>

<LMAttribute OID="2" Identifier="1" >

<Uses Class="LMDataItem" Path="24" Name="ID" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="21" Name="name" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="22" Name="middle_name" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="23" Name="surname" />

</LMAttribute>

<LMAttribute OID="6" >

<Uses Class="LMDataItem" Path="25" Name="pre_title" />

</LMAttribute>

<LMAttribute OID="7" >

<Uses Class="LMDataItem" Path="26" Name="post_title" />

</LMAttribute>

<LMAttribute OID="8" >

<Uses Class="LMDataItem" Path="27" Name="birthday" />

</LMAttribute>

<LMAttribute OID="9" >

<Uses Class="LMDataItem" Path="28" Name="phone" />

</LMAttribute>

<LMAttribute OID="10" >

<Uses Class="LMDataItem" Path="29" Name="email" />

</LMAttribute>

<LMAttribute OID="11" >

<Uses Class="LMDataItem" Path="33" Name="login" />

</LMAttribute>

<LMAttribute OID="12" >

<Uses Class="LMDataItem" Path="34" Name="password" />

</LMAttribute>

<LMAttribute OID="15" >

<Uses Class="LMDataItem" Path="38" Name="web_messages_types" />

</LMAttribute>

<LMAttribute OID="16" >

<Uses Class="LMDataItem" Path="39" Name="email_messages_types" />

</LMAttribute>

<LMAttribute OID="13" >

<Uses Class="LMDataItem" Path="35" Name="comment" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="1,n" BeginOrdinality="1" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="31" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" EndOrdinality="1" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Member_has_Users" EndCardinality="1,1" BeginTruncate="1" BeginArrowFlags="1" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship describes the following facts:

Member can be a physical person, but usually Member is a legal entity, like another NGO or a family.

Therefore, member can have several users - physical persons, who are eligible to use the NGO resources.

Side note: We could have made the things more complicated by considering users, who belong to more than one member. In such a case, this would lead to M:N relation, that would have to be implemented by table "Users_Members". In such a case, the "Contacts", "Device" and other tables, that are related to User belonging to certain Member, would be related to "Users_Members" table (not just Users like currently).]]><point x="181" y="326" OID="1" SinkObjectOID="20" SinkOID="1" />

<point x="485" y="320" OID="2" SinkObjectOID="1" SinkOID="20" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="136" y="6" OID="4" />

<EndRoleHandle x="-138" y="12" OID="5" />

</LMRelationship>

<LMEntityNormal width="61" x="51" TextField="2" Align="68" y="292" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="36" height="88" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Contacts" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[Additional contact fields for a given user.

Rules of thumb:

-Compulsory contact fields should be directly in the "User" table.

-Additional contact fields go into this "Contacts" table]]><sink x="0.137931" y="0.366197" OID="1" />

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="44" Name="ID_user" />

</LMAttribute>

<LMAttribute OID="5" Identifier="1" >

<Uses Class="LMDataItem" Path="45" Name="ID" />

</LMAttribute>

<LMAttribute OID="2" >

<Uses Class="LMDataItem" Path="40" Name="type" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="41" Name="value" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="1,1" BeginOrdinality="1" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="42" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="User_has_Contacts" EndCardinality="0,n" BeginTruncate="1" BeginArrowFlags="0" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[Relationship for assigning several contacts to one user.]]><point x="292" y="331" OID="1" SinkObjectOID="20" SinkOID="14" />

<point x="61" y="325" OID="2" SinkObjectOID="36" SinkOID="1" />

<TextHandle x="0.438356" y="2.14943" OID="3" />

<BeginRoleHandle x="-137" y="-23" OID="4" />

<EndRoleHandle x="60" y="-27" OID="5" />

</LMRelationship>

<LMEntityNormal width="99" x="44" TextField="2" Align="68" y="668" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="46" height="206" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Devices" NextOID="17" FontFamily="MS Shell Dlg" ><![CDATA[Table "Devices" represents devices conected to the network. Device can be a PC, router, switch, AP, client wifi box, VOIP phone, IPTV set-top-box - simply anything with active ethernet plug.]]><sink x="0.172897" y="0.545455" OID="2" />

<sink x="0.555556" y="0.896552" OID="7" />

<sink x="0.9" y="0.16092" OID="12" />

<sink x="0.35" y="0.0574713" OID="13" />

<LMAttribute OID="8" >

<Uses Class="LMDataItem" Path="81" Name="ID" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="49" Name="ID_user" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="47" Name="name" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="48" Name="type" />

</LMAttribute>

<LMAttribute OID="6" >

<Uses Class="LMDataItem" Path="50" Name="PPPoE_logging_in" />

</LMAttribute>

<LMAttribute OID="9" >

<Uses Class="LMDataItem" Path="104" Name="login" />

</LMAttribute>

<LMAttribute OID="10" >

<Uses Class="LMDataItem" Path="105" Name="password" />

</LMAttribute>

<LMAttribute OID="14" >

<Uses Class="LMDataItem" Path="144" Name="GPS" />

</LMAttribute>

<LMAttribute OID="15" >

<Uses Class="LMDataItem" Path="145" Name="location_address" />

</LMAttribute>

<LMAttribute OID="16" >

<Uses Class="LMDataItem" Path="146" Name="location_details" />

</LMAttribute>

<LMAttribute OID="11" >

<Uses Class="LMDataItem" Path="106" Name="comment" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,n" DescriptionSize="4096" Description="789cd5966b38946bdbc76f338908b55a262372d3c69e0c4b188644229b4af6a99966066376cc8c5d3446582a42d954285ad64a99314c11518cca8821158d6cb3b726d9442a65f10ebdef87f778dee33d9eafcffded3ccffffdbf7effebba8efbb8ad43186412ca3a048fc1a1acc9780606a460c8781bad701a011bc2c04733b4402c95c2c05318365a265aa031cadaf8a7f60c151703d2193124893848a230a413cee2ad2cc218c8f52a0843269062acdc3c41cf103c89043a9082b55072d66128772a030f06516920238440211228c1562095820771f84802160f623114c9004fa5e119042c86448a0143309178902c6948fa92e19a36828ea7198051211242308a1a41c2816bd27553372b779086276118042a851e42083300cf4430406c048d264920718bc283743c1ea450252a0c9d4a597f898c59e358070aa6ff5c0b4b258791f0d146d6c661126ae3b5b06bc9d7f60a20e3c967f0343aa8634395a0d2402a2d1843219cfdb9a62e88a1e0d622d0f1ff7bb01e8d40c1922270923c184acc7a0c894b58480c7d2d2b182629d71c8c408f755f7c34660d02a40649782986ffa333fca9037f6280043ab8373c82ca4062c09f7bfeb3fa3fc945e3f1f2850d0313445b29ef17be7d1374cad7a5e21ffbaf9b8fc44e64774c9a3ab1c7b1ac3dd3bc6f8528a888fb7d009f1dd9d07338ae8faf9e8d35712b93e17cdbfc88339bda5721a32e54f482b7b5339bfc1bf21cc603f659c0897dc6f16af56d6f29a39b5a66ce74ef54cb7f79f8e5c988b6aa94d2ad98b00f72511699954c999e428fb2aaade4ed671a958d3846d96c96069cc828dec0d11cdc0d285fe199f76f3f20f12cec986c9a2f3b06817d1c8e923a691fcb39c79de6ce0d44ee70df5d71e254600de77bf74568c521c1d9ce54279c943ca44e2e3b516356ad22b7d3d148a5202da793b845bc78aed1e440f34ac3b07ed43f879eeb82776c44611b0c2e48dfbc2355a08d9d7e38b573f674dde5427cdde53a734a2a2be22f7fe428fada58867dc72c3fe6839c4fa0b2d30742b5265a8a8fc5714a9ebca5142fb0943352b6b9faa1021fd6fbe5df3a799076eb96ad37909ec54baf792893225359555567f87eb0206944a532cd25bf338be81b909bbb27fee5cd551ccbe9852fc1461d137bd6b8cf288e1d1e5b90806a1ede705b75c81aced6088fe831f3e7d7e62a5154c29f98f06366f4adef96f6a54fccc43157991e25265091fa7b179bf76651dfff8903b87fa8e9df6e0af9e5f30cbd685bd3ef86d0d97ed70fb8db0e2daa79c46b32fc441c67423c109c77dc44e73ac2566127c7ad83a369aa042c1ff3919dd3e0c16b2ea529eb952fc3b91c594047e41c385ce5174c26b788ab059cab9525511a3599ef15c372dc11223337cff894261bb1db2c0a389a938e10654e5c099c5851ddabe002144110227be23f679b77d50129bac046ee1eac63ae172579788f8af63766639100022bb8a2a6d0df2167d1722e79fa461da3f064cc33c7ab03855205b7d5d86d0821e732f921a7567e8521f6c6d50a367c69fd3c32d52c5da08975148d742d47c7fc7dd99899e8fdf776f53fb3c42e9a226e80b1d49033c27b0ca7578ba9e08fb59ac1e14b4fa0476da77994b040cf7b55957bd18d5e57a1e6777536bccce2711fa639966045fd0f6da2a59de26b44f3cda5b09d3549b54f21f98171465332d74cdf6f49661a6b05352653eafda455ba26fb9a86c716c474839b633a4910587ff3ac7ccda5daa741169fa17607711c73157319a0570bfb9b1d1fc29a60744d3ce90c4818d3bbdb3a594e8ebb6f3235d9e9bccb67e8713ac23b3ea52a1ed95cbb8b34de01b343c36f9fb7587c3d0e9d2b978c3266147d89c1f2e8f2f7c687df40827ab152c0490f41287fc1ed3eb37ba4b0a3d9d11250eb0c0cc4d0d4f261c4c6c119ef08aecd89cbb2800ce31a2f97426e6754cf7e8d2a190be833f291e2c3b15dca2b1b8b08475387b700d7ad8c9b430f9f7cb01419a8b9e507b3213c43fb4367c26e385bf55e5e7b4046df4b5898dd1c741313c144f15d05aabdbd3d4f2da1724b0900511092e1080f96076a5a55e0473ac38121bfc06ee5970a2df9b2be64b22190f93650900775a13bef7937d4b0c20358b0c51c9e39b2b1d434fa1c6af59fd50cbd6a18a0f3ca47506a6a4ff6ef238dfbce4db69c4a2a8c293ba4e463f7a81e017bc5bb657f515f4785aff2551902581f1140ac169792de3217b2bf79ec3952d60e64ceaff6d5d519f63074361715840faee6dc4cb52aab2ab237bc9463595e4aae1c3cd8754de3629af4d1035c48a4cb359e607288cd7d542df06b782063d4df3f3bff61603665faf6c4839b52a8ccb36d3fdee8093f69cba8f2beed3689dd57a1158814fd8139aa2f3da8b2a3364801fd5bca8919a5cadd1148ef27f3c316ec7cf7a9f2f28ed1dcfb30f629f9fd9ff44a351d6991a53d8792d5755ef83a32f5aa49d636fbef77f7611376f486a4fb93b66e7fc05246882e35f57e30b06fcf9ef6ddea33fc484143f99e89cadbb4c8c219cfac0241f1738322105bf6adc24373468f61fd86236e8f6f459740b56f06b656428f6d955e09dd853d77bc412d6380f2dc7fd970eba27ff1e310b7e5b253b7ee4e748da21edcac8edff0ed8a15d60b552ab4a29d5b38f66892e0e691f22c374cd0943e40a39c006f300f7fb29efa7172aaa9be4b415a2c6ac80ab251b132b3e84b08e022fcf1faa302ca01e8f16a6c0eecfda6b39cbcdc3231ac33293ca135c09dad9c790a0bd7178fc699900c1537c622ef6e56643f1a475df20e95e5179be5f2ee2331df6565b77486e6dca31425d943719c00a4ae9e337a9173f517e1eaee578af02951bad7f7e6721e3d282be4ca6aa50bb1ba9fe4720f1bbc311a06d7cf684adeb63de5293f6630bd1ed1ab1ee2509be665f4b61fcfcca5aee61053bd9f3987521e35bd6a189d2071d2a01d394658b7013a79e2426a8f72fecc4249e785d600a3a2f0a95b78b5a2a9da3138311b2f80181ec72d8ac714fd5a2d329d77c0a7ca9a7aee6daf6634855af635bb3b2def2ca54f29ddd62dfcb21bd2ff7bda6254b4932566e4cbaf97a81981cb15dae8a5c8db6ea9361701252dacdb59b8fd29be7c20d7897ffe25e228dfb4c55772d9132d5117cdcf6c055e45acc6fd8018f106c6cd1573f588ad3c057fbe33830dfd9a55abce9e57f8abe7fae79ecc2f140f27c7988fbda87aa521faa92a690a47e3b875fef795d2c533e5694e5755966bb869a70f8a7fdff827a5594f7d47e6cc1e1a802e112044bca4dd3e8d57574abe5f29b65403bdb17079d9375f1b7629dc29948a268c3eb10758c416df8cd7abdfbe24f37794d7754dcb99b99f1e36fdfbdab09f60bd3a82846df1e04232793b3d1a3603fd9969398d6c6490ca46137980a23510cde9b6fed859155e7ba6f1b238a32f1695c48473f7b77fbea60823dd4f837a641b6123b2c62902a5cee6298690d421b6b2ccfd35292a283c74b36fe7748983115e2dfa7c1a9c1d47117d2d1213138bb9440f2f4182f68bebbca0a0dfbac95165ddccb2d31b678c1de132f30410ab4e6f6026952f0aed5cbeea8fda2114709cf057535c1beaea9c72c950bcb3d0628ee16c95ffbd7e0ab1ac1e7f2fe85906097f52b22bd735e401f0569a34b0c54300012e684b3e81cfb3780030d2e20b009f5425e3c3770a464b8384bdf75cff000a0e0a203bff3ad9fd28483812835a9e06f23f2b43c45dcf8b3099b92c4f4233e49b09b9dfff081aeb293a24332e18b633c5190c1d8b2cb3ac6113a9a26735e1520f9452d5b3ed16d6daa102ffb7cbc4173900278bc74a3392f5f52f63b9091e43c5d13f946a121ca67d43afbe3a4fb3168dc896419f75944cf60c4e2eba8f9026f39e25e47e4eecdd19167bee7d840f8a8d226d8a8dadf9dd3cc4ee8f480396237ee1b81bbf2736fbe20e5603ce00ac835e9ccc3bc8ea4a8b91f99778380380158d80d9492fa44290eb9db60c69eb7641ab65b961a7c6e9c2ea6ae35b98708d2cb4d4db35e03b07825dedf19bf30efd55ddb7bda322d2c04e1d2e1fcde1bfa2939ea8b32210309683f473d309f5688ee9e0e2c20ab8c501099bd3193dfa99fb437daf57faf9d5b902e28f901948e962a2d3c675fa1bb7bcdea89ad99dd604ecace1ffdf41fc37e9bfc8bece561b0345eeabd3f2c0bbb5b341abd49f93069062fd0dffb6c57f9a6c552a326c5bc5f5cee70b80e471767477e0daa3cf636536bb0a208794a30abc6b4ed83965dbb9e0e147a490737f1e512559864ae9ae7efdb211e80f7a305aa9fb96de3c4cd395f64f666a744d2e74687f89b5f2f043b5776caa2ae5a8112fe55918045c5fc1f5de409c6f673a6499b67d34dc65d113de3b7fddf39d7a2f6de77ed3dc1769f370575d0220e3556a8c557e68bd685afc2a0852acd41d59f050c478528134fbf1ee8e697b6f36faf585ef086f4bdb0718e94dc815cf16f299cd4d438c1ce1f25d6c3d52f5354d306f9a685b9ee6dbfd8b86fbb55f8f7856fbf73d5ebda425176f2b5779c8b49ae5c79631d0880f436b686c5dbc9eb1b427d977a100028b6073d4f4ef8e6f722f145e0c477a027947df70cae2da8edef5c2c3897a210bf596dabb7c898cdf227bdaca4342b96605474acfeb0a4b1a9a1b19c04bb631d66d351ddc986cfe83f1c2f5e353c4be730deff1f265e8d66530baf4d8767e72699bef258eceb11a1fce62b9e8667bb4593307fdb24a7cf9a253f88ae5973b72bb90fc5a3d53188ee338e76a1615babc2d9b4a76a7e6ec7ccd92eb3a7b5a336dec86378e5ecc1e4a7f5a2506243f97f28351cd43fac236b3ea7aff87e4d3de5b157b276ceaf75bbadf68b9bd39d1a505fda9aa848fc619dcb5dfc7185c696af8348abb899e2750c5a515d2a798495c828beb0d981491fc69ccf31663c5b41bccd03f91cbbb7ad94ba80de3eeb3ec1bd6e80810be510f1e13feca3caf3d7568f499705618f06578bf2ddeb86143af8f9f20cf5b959debd1563ea7182c9a95b51f4b3f7bf0974885cc6bd98fdbb5fe76ec89da04ed9c502fc5ea1409da94533b1ba0366ef542e505a7cae5b0111e23b770ac37715cebd351eb2525dba54b4bba9f46a383be799eb614396bcbbc6ba94eb8ccd69d9cea5a5a5dbeff495866287c97cdea3772b7dde37935dedf5b916bb3a7421447f6bfc779c1c190afb417be7253981ff23807d7bf71444e7b6f3c6dfc9efe6a7ecbf2d8888fab51c0fc1b26f05f39fe6830" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="51" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" EndOrdinality="1" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Device_is_owned_by_User" EndCardinality="1,1" BeginTruncate="1" EndRole="owns" BeginRole="is owned by" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[Relationship for assigning one or more devices to one user]]><point x="61" y="780" OID="1" SinkObjectOID="46" SinkOID="2" />

<point x="281" y="342" OID="2" SinkObjectOID="20" SinkOID="18" />

<TextHandle x="0.359307" y="0.548098" OID="3" />

<BeginRoleHandle x="81" y="-132" OID="4" />

<EndRoleHandle x="-138" y="204" OID="5" />

</LMRelationship>

<LMEntityNormal width="74" x="227" TextField="2" Align="68" y="671" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="52" height="121" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Interfaces" NextOID="15" FontFamily="MS Shell Dlg" ><![CDATA[Interface is any network interface which has its own MAC adres.

Interface is typically a network interface card in a PC or in a router.

Note: ports in switches should not be in this table! They should be in table "Ports".

An exception is managable switch - which has MAC and IP address.

Therefore, managable switches should have the port, which is connected to the segment with the switch's IP subnet, stored in the "Interfaces" table.]]><sink x="0.842105" y="0.585366" OID="11" />

<sink x="0.477064" y="0.859756" OID="10" />

<sink x="0.864865" y="0.206612" OID="14" />

<sink x="0.0540541" y="0.330579" OID="13" />

<LMAttribute OID="4" Identifier="1" >

<Uses Class="LMDataItem" Path="55" Name="ID" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="56" Name="ID_device" />

</LMAttribute>

<LMAttribute OID="8" >

<Uses Class="LMDataItem" Path="79" Name="ID_segment" />

</LMAttribute>

<LMAttribute OID="2" >

<Uses Class="LMDataItem" Path="53" Name="MAC" />

</LMAttribute>

<LMAttribute OID="9" >

<Uses Class="LMDataItem" Path="80" Name="name" />

</LMAttribute>

<LMAttribute OID="12" >

<Uses Class="LMDataItem" Path="107" Name="comment" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="1,1" BeginOrdinality="1" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="54" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Device_has_interface" EndCardinality="0,n" BeginTruncate="1" BeginArrowFlags="0" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns interfaces to a device]]><point x="133" y="701" OID="1" SinkObjectOID="46" SinkOID="12" />

<point x="231" y="711" OID="2" SinkObjectOID="52" SinkOID="13" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="19" y="9" OID="4" />

<EndRoleHandle x="-24" y="1" OID="5" />

</LMRelationship>

<LMEntityNormal width="73" x="406" TextField="2" Align="68" y="679" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="57" height="103" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="IP_address" NextOID="11" FontFamily="MS Shell Dlg" ><![CDATA[One network interface can have multiple IP addresses. These IP addresses are recorded in this table]]><sink x="0.479452" y="0.893204" OID="8" />

<sink x="0.830508" y="0.266234" OID="7" />

<sink x="0.219178" y="0.242718" OID="10" />

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="60" Name="ID_interface" />

</LMAttribute>

<LMAttribute OID="9" >

<Uses Class="LMDataItem" Path="100" Name="ID_VLAN_Interface" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="74" Name="ID_subnet" />

</LMAttribute>

<LMAttribute OID="2" >

<Uses Class="LMDataItem" Path="59" Name="IP_address" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="58" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Interface_has_IP_address" EndCardinality="0,1" BeginTruncate="1" EndRole="has" BeginRole="assigned to" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings IP addresses to an interface.

Note:

To get a list of all IP addresses assigned to a interface, you must look also to the relationship "VLAN_interface_has_IP_addresses" !]]><point x="422" y="704" OID="1" SinkObjectOID="57" SinkOID="10" />

<point x="291" y="696" OID="2" SinkObjectOID="52" SinkOID="14" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="-70" y="-20" OID="4" />

<EndRoleHandle x="22" y="9" OID="5" />

</LMRelationship>

<LMEntityNormal width="69" x="233" TextField="2" Align="68" y="848" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="61" height="121" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Segments" NextOID="11" FontFamily="MS Shell Dlg" ><![CDATA[Any (sub)network can be composed of many segments, which are interconnected by network bridges or switches. The segments are stored in this table]]><sink x="0.0833333" y="0.213836" OID="9" />

<sink x="0.407407" y="0.157233" OID="8" />

<LMAttribute OID="1" Identifier="1" >

<Uses Class="LMDataItem" Path="66" Name="ID" />

</LMAttribute>

<LMAttribute OID="2" >

<Uses Class="LMDataItem" Path="62" Name="name" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="63" Name="technology" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="64" Name="bitrate" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="65" Name="duplex" />

</LMAttribute>

<LMAttribute OID="10" >

<Uses Class="LMDataItem" Path="86" Name="comment" />

</LMAttribute>

</LMEntityNormal>

<LMEntityNormal width="90" x="549" TextField="2" Align="68" y="683" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="68" height="108" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Subnets" NextOID="8" FontFamily="MS Shell Dlg" ><![CDATA[Every IP address belongs to a subnet. Subnets are described by this table.]]><sink x="0.0582524" y="0.182482" OID="6" />

<LMAttribute OID="1" Identifier="1" >

<Uses Class="LMDataItem" Path="69" Name="ID" />

</LMAttribute>

<LMAttribute OID="7" >

<Uses Class="LMDataItem" Path="101" Name="ID_OSPF_area" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="70" Name="name" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="71" Name="network_address" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="72" Name="netmask" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="73" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="IP_address_belongs_to_Subnet" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings IP addresses to a subnet]]><point x="466" y="706" OID="1" SinkObjectOID="57" SinkOID="7" />

<point x="554" y="703" OID="2" SinkObjectOID="68" SinkOID="6" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="19" y="10" OID="4" />

<EndRoleHandle x="-24" y="12" OID="5" />

</LMRelationship>

<LMEntityNormal width="72" x="66" TextField="2" Align="68" y="961" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="75" height="94" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Ports" NextOID="8" FontFamily="MS Shell Dlg" ><![CDATA[Port is any active network socket on a Device.

Port is typically a port on a switch.

Port has no MAC address - only a network interface (see table "Interface") has a MAC.

An exception is managable switch - which has a MAC and an IP address.

Therefore, managable switches should have the port, which is connected to the segment with the switch's IP subnet, stored in the "Interfaces" table.]]><sink x="0.462963" y="0.111111" OID="1" />

<sink x="0.722222" y="0.409722" OID="5" />

<sink x="0.890411" y="0.527273" OID="7" />

<LMAttribute OID="2" Identifier="1" >

<Uses Class="LMDataItem" Path="77" Name="ID" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="83" Name="ID_device" />

</LMAttribute>

<LMAttribute OID="6" >

<Uses Class="LMDataItem" Path="85" Name="ID_segment" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="76" Name="name" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="78" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" EndOrdinality="1" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Interface_is_connected_to_Segment" EndCardinality="1,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns Interfaces to a segment]]><point x="262" y="776" OID="1" SinkObjectOID="52" SinkOID="10" />

<point x="261" y="868" OID="2" SinkObjectOID="61" SinkOID="8" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="9" y="24" OID="4" />

<EndRoleHandle x="-19" y="-46" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="82" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Device_has_Ports" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns ports to a device (switch)]]><point x="99" y="971" OID="1" SinkObjectOID="75" SinkOID="1" />

<point x="99" y="852" OID="2" SinkObjectOID="46" SinkOID="7" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="17" y="-36" OID="4" />

<EndRoleHandle x="7" y="27" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="84" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" EndOrdinality="1" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Ports_connected_to_a_Segment" EndCardinality="1,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns ports on a switch to a network segment]]><point x="117" y="1000" OID="1" SinkObjectOID="75" SinkOID="5" />

<point x="238" y="874" OID="2" SinkObjectOID="61" SinkOID="9" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="51" y="-29" OID="4" />

<EndRoleHandle x="-34" y="-18" OID="5" />

</LMRelationship>

<LMEntityNormal width="70" x="398" TextField="2" Align="68" y="993" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="87" height="92" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="VLANs" NextOID="8" FontFamily="MS Shell Dlg" ><![CDATA[VLAN is a virtual network working upon physical network segments.

VLAN is implemented in switches or routers and is present on their ports/interfaces.

On a switch or router, one VLAN can be assigned to several ports, and one port can have several VLANs.

On a router, a VLAN interface, created on one of its physical network interfaces, can have several IP addressess assigned to it.]]><sink x="0.506173" y="0.023622" OID="6" />

<sink x="0.0493827" y="0.204724" OID="7" />

<LMAttribute OID="2" >

<Uses Class="LMDataItem" Path="90" Name="ID" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="91" Name="name" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="92" Name="802_1q_tag" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="93" Name="comment" />

</LMAttribute>

</LMEntityNormal>

<LMEntityNormal width="109" x="393" TextField="2" Align="68" y="851" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="89" height="76" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="VLAN_Interfaces" NextOID="7" FontFamily="MS Shell Dlg" ><![CDATA[Several VLAN Interfaces can be created upon normal network Interface. Every VLAN Interface then belongs to just one VLAN (but there can be many VLAN interfaces with the same VLAN ID!).

From a router's internal point of view, a VLAN interface is the same thing as a normal network interface - it can have several IP addresses assigned (but it shares the MAC address of its physical network interface).]]><sink x="0.440367" y="0.0394737" OID="6" />

<sink x="0.293578" y="0.0263158" OID="1" />

<sink x="0.376147" y="0.921053" OID="2" />

<LMAttribute OID="3" Identifier="1" >

<Uses Class="LMDataItem" Path="94" Name="ID" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="95" Name="ID_VLAN" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="96" Name="ID_Interface" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,1" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="97" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="VLAN_Interface_belong_to_a_VLAN" EndCardinality="0,n" BeginTruncate="1" BeginArrowFlags="4" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns VLAN interfaces to a VLAN.]]><point x="433" y="996" OID="1" SinkObjectOID="87" SinkOID="6" />

<point x="434" y="921" OID="2" SinkObjectOID="89" SinkOID="2" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="9" y="-26" OID="4" />

<EndRoleHandle x="10" y="10" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,1" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="98" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="VLAN_Interface_is_created_on_Interface" EndCardinality="0,n" BeginTruncate="1" EndRole="is created on" BeginRole="hosts" BeginArrowFlags="4" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns VLAN interfaces to a physical network interface]]><point x="290" y="741" OID="1" SinkObjectOID="52" SinkOID="11" />

<point x="425" y="853" OID="2" SinkObjectOID="89" SinkOID="1" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="32" y="11" OID="4" />

<EndRoleHandle x="-65" y="-28" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="99" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="VLAN_interface_has_IP_addresses" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings IP addresses to a VLAN interface.

Note:

To get a list of all IP addresses assigned to a interface, you must look also to the relationship "Interface_has_IP_addresses" !]]><point x="441" y="771" OID="1" SinkObjectOID="57" SinkOID="8" />

<point x="441" y="854" OID="2" SinkObjectOID="89" SinkOID="6" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="10" y="10" OID="4" />

<EndRoleHandle x="5" y="-22" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="102" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Ports_belong_to_VLANs" EndCardinality="0,n" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship (M:N) assigns

- one VLAN to several ports on a switch

- one port to several VLANs.]]><point x="130" y="1011" OID="1" SinkObjectOID="75" SinkOID="7" />

<point x="401" y="1011" OID="2" SinkObjectOID="87" SinkOID="7" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="10" y="10" OID="4" />

<EndRoleHandle x="-41" y="7" OID="5" />

</LMRelationship>

<LMEntityNormal width="109" x="594" TextField="2" Align="68" y="81" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="108" height="151" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Money_transfer" NextOID="27" FontFamily="MS Shell Dlg" ><![CDATA[This is the table where transfers from one account to another are stored.]]><sink x="0.0183486" y="0.139073" OID="25" />

<sink x="0.174312" y="0" OID="26" />

<sink x="0.00917431" y="0.15894" OID="23" />

<sink x="0.281818" y="0.985915" OID="22" />

<sink x="0.845455" y="0.971831" OID="21" />

<LMAttribute OID="1" Identifier="1" >

<Uses Class="LMDataItem" Path="109" Name="ID" />

</LMAttribute>

<LMAttribute OID="2" >

<Uses Class="LMDataItem" Path="110" Name="ID_origin" />

</LMAttribute>

<LMAttribute OID="17" >

<Uses Class="LMDataItem" Path="160" Name="ID_destination" />

</LMAttribute>

<LMAttribute OID="24" >

<Uses Class="LMDataItem" Path="179" Name="ID_bank_info" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="112" Name="timestamp" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="113" Name="text" />

</LMAttribute>

<LMAttribute OID="7" >

<Uses Class="LMDataItem" Path="115" Name="type" />

</LMAttribute>

<LMAttribute OID="11" >

<Uses Class="LMDataItem" Path="120" Name="amount" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="111" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="account_is_origin" EndCardinality="0,1" BeginTruncate="1" EndRole="is_origin" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship captures the origins of account transfers]]><point x="624" y="230" OID="1" SinkObjectOID="108" SinkOID="22" />

<point x="626" y="411" OID="2" SinkObjectOID="156" SinkOID="12" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="-21" y="8" OID="4" />

<EndRoleHandle x="-45" y="-127" OID="5" />

</LMRelationship>

<LMEntityNormal width="89" x="26" TextField="2" Align="68" y="400" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="131" height="150" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Access_mods" NextOID="11" FontFamily="MS Shell Dlg" ><![CDATA[This is table records the modifications of the members' access to the network.]]><sink x="0.820225" y="0.133333" OID="10" />

<sink x="0.595506" y="0.886667" OID="9" />

<LMAttribute OID="1" Identifier="1" >

<Uses Class="LMDataItem" Path="132" Name="ID" />

</LMAttribute>

<LMAttribute OID="2" >

<Uses Class="LMDataItem" Path="133" Name="ID_device" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="134" Name="ID_user_admin" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="136" Name="timestamp_start" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="137" Name="timestamp_end" />

</LMAttribute>

<LMAttribute OID="6" >

<Uses Class="LMDataItem" Path="138" Name="type" />

</LMAttribute>

<LMAttribute OID="7" >

<Uses Class="LMDataItem" Path="139" Name="reason" />

</LMAttribute>

<LMAttribute OID="8" >

<Uses Class="LMDataItem" Path="140" Name="comment" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="142" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="User_Admin_made_Access_modifications" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings access modifications to a user (administrator)]]><point x="99" y="420" OID="1" SinkObjectOID="131" SinkOID="10" />

<point x="184" y="348" OID="2" SinkObjectOID="20" SinkOID="21" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="26" y="-11" OID="4" />

<EndRoleHandle x="-31" y="34" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="143" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Device_has_Access_modification" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns access modifications to a device]]><point x="79" y="533" OID="1" SinkObjectOID="131" SinkOID="9" />

<point x="78" y="680" OID="2" SinkObjectOID="46" SinkOID="13" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="10" y="24" OID="4" />

<EndRoleHandle x="-16" y="-30" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="151" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Member_has_Assigned_Payments" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings assigned payments to a member]]><point x="623" y="335" OID="1" SinkObjectOID="156" SinkOID="13" />

<point x="492" y="315" OID="2" SinkObjectOID="1" SinkOID="26" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="-40" y="4" OID="4" />

<EndRoleHandle x="10" y="10" OID="5" />

</LMRelationship>

<LMEntityNormal width="90" x="614" TextField="2" Align="68" y="294" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="156" height="128" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Account" NextOID="14" FontFamily="MS Shell Dlg" ><![CDATA[This table stores data about all accounts in the system. There are:

- NGO own bank accounts

- bank accounts of the members

- members' analytical accounts, e.g. "credit", "project account" etc.

- NGO analytical (virtual) accounts, e.g. "bonuses", "penalties", ...]]><sink x="0.822222" y="0.90625" OID="11" />

<sink x="0.133333" y="0.914062" OID="12" />

<sink x="0.1" y="0.320312" OID="13" />

<LMAttribute OID="8" >

<Uses Class="LMDataItem" Path="158" Name="ID" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="148" Name="ID_owner" />

</LMAttribute>

<LMAttribute OID="6" >

<Uses Class="LMDataItem" Path="152" Name="name" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="149" Name="type" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="150" Name="start_amount" />

</LMAttribute>

<LMAttribute OID="7" >

<Uses Class="LMDataItem" Path="153" Name="comment" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,n" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="161" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="account_is_destination" EndCardinality="0,1" BeginTruncate="1" EndRole="is_destination" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" ><![CDATA[This relationship captures the destinations of account transfers]]><point x="686" y="227" OID="1" SinkObjectOID="108" SinkOID="21" />

<point x="688" y="410" OID="2" SinkObjectOID="156" SinkOID="11" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="12" y="9" OID="4" />

<EndRoleHandle x="7" y="-135" OID="5" />

</LMRelationship>

<LMEntityNormal width="103" x="394" TextField="2" Align="68" y="158" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="162" height="122" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Work" NextOID="11" FontFamily="MS Shell Dlg" ><![CDATA[Work for the organization commited by the users]]><sink x="0.038835" y="0.729508" OID="9" />

<sink x="0.980583" y="0.877049" OID="10" />

<sink x="0.0319149" y="0.293233" OID="1" />

<LMAttribute OID="3" Identifier="1" >

<Uses Class="LMDataItem" Path="163" Name="ID" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="164" Name="ID_user" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="165" Name="description" />

</LMAttribute>

<LMAttribute OID="6" >

<Uses Class="LMDataItem" Path="166" Name="hours" />

</LMAttribute>

<LMAttribute OID="7" >

<Uses Class="LMDataItem" Path="167" Name="confirmed_by_ID" />

</LMAttribute>

<LMAttribute OID="8" >

<Uses Class="LMDataItem" Path="168" Name="transfer_ID" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,1" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="169" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="transfer_of_salary" EndCardinality="0,1" BeginTruncate="1" BeginRole="was_paid_by" BeginArrowFlags="4" NextOID="6" FontFamily="MS Shell Dlg" >

<point x="495" y="265" OID="1" SinkObjectOID="162" SinkOID="10" />

<point x="595" y="105" OID="2" SinkObjectOID="108" SinkOID="23" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="14" y="-14" OID="4" />

<EndRoleHandle x="-18" y="35" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,1" TextField="0" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="170" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="user_has_done_work" EndCardinality="0,n" BeginTruncate="1" BeginRole="did" BeginArrowFlags="4" NextOID="6" FontFamily="MS Shell Dlg" >

<point x="211" y="299" OID="1" SinkObjectOID="20" SinkOID="23" />

<point x="397" y="194" OID="2" SinkObjectOID="162" SinkOID="1" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="5" y="-26" OID="4" />

<EndRoleHandle x="-31" y="-11" OID="5" />

</LMRelationship>

<LMEntityNormal width="163" x="336" TextField="2" Align="68" y="16" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="171" height="136" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Money_transfer_bank_info" NextOID="10" FontFamily="MS Shell Dlg" >

<sink x="0.981595" y="0.786765" OID="8" />

<sink x="0.993865" y="0.183824" OID="9" />

<LMAttribute OID="1" Identifier="1" >

<Uses Class="LMDataItem" Path="177" Name="ID" />

</LMAttribute>

<LMAttribute OID="2" >

<Uses Class="LMDataItem" Path="172" Name="variable_symbol" />

</LMAttribute>

<LMAttribute OID="3" >

<Uses Class="LMDataItem" Path="173" Name="constant_symbol" />

</LMAttribute>

<LMAttribute OID="4" >

<Uses Class="LMDataItem" Path="174" Name="specific_symbol" />

</LMAttribute>

<LMAttribute OID="5" >

<Uses Class="LMDataItem" Path="175" Name="text" />

</LMAttribute>

<LMAttribute OID="6" >

<Uses Class="LMDataItem" Path="176" Name="ID_fee_transfer" />

</LMAttribute>

<LMAttribute OID="7" >

<Uses Class="LMDataItem" Path="178" Name="date_time" />

</LMAttribute>

</LMEntityNormal>

<LMRelationship BeginCardinality="0,n" TextField="2" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="180" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" EndCardinality="0,1" BeginTruncate="1" EndRole="confirmed" BeginArrowFlags="5" NextOID="6" FontFamily="MS Shell Dlg" >

<point x="398" y="247" OID="1" SinkObjectOID="162" SinkOID="9" />

<point x="279" y="298" OID="2" SinkObjectOID="20" SinkOID="24" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="-35" y="-14" OID="4" />

<EndRoleHandle x="-3" y="-22" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,1" TextField="2" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="181" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" EndCardinality="0,1" BeginTruncate="1" EndRole="has" BeginArrowFlags="4" NextOID="6" FontFamily="MS Shell Dlg" >

<point x="498" y="41" OID="1" SinkObjectOID="171" SinkOID="9" />

<point x="613" y="81" OID="2" SinkObjectOID="108" SinkOID="26" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="10" y="10" OID="4" />

<EndRoleHandle x="-4" y="-20" OID="5" />

</LMRelationship>

<LMRelationship BeginCardinality="0,1" TextField="2" Align="68" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" Generate="1" EndArrowType="3" FontUnderline="0" FillColor="#ffffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="182" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="4" NextOID="6" FontFamily="MS Shell Dlg" >

<point x="496" y="123" OID="1" SinkObjectOID="171" SinkOID="8" />

<point x="596" y="102" OID="2" SinkObjectOID="108" SinkOID="25" />

<TextHandle x="0.45" y="0.5" OID="3" />

<BeginRoleHandle x="10" y="10" OID="4" />

<EndRoleHandle x="-25" y="-18" OID="5" />

</LMRelationship>

<Validation>

<Rule Name="Model name missing" Value="Error" />

<Rule Name="Model comment missing" Value="Warning" />

<Rule Name="Model description missing" Value="Information" />

<Rule Name="Model author missing" Value="Warning" />

<Rule Name="Rule name missing" Value="Error" />

<Rule Name="Rule code missing" Value="Warning" />

<Rule Name="Rule comment missing" Value="Warning" />

<Rule Name="Rule description missing" Value="Information" />

<Rule Name="Rule name duplicate" Value="Error" />

<Rule Name="Rule code duplicate" Value="Error" />

<Rule Name="Rule not used" Value="Warning" />

<Rule Name="Domain name missing" Value="Error" />

<Rule Name="Domain code missing" Value="Warning" />

<Rule Name="Domain comment missing" Value="Warning" />

<Rule Name="Domain description missing" Value="Information" />

<Rule Name="Domain name duplicate" Value="Error" />

<Rule Name="Domain code duplicate" Value="Error" />

<Rule Name="Domain type missing" Value="Error" />

<Rule Name="Domain type unknown" Value="Error" />

<Rule Name="Domain not used" Value="Warning" />

<Rule Name="Data Item name missing" Value="Error" />

<Rule Name="Data Item code missing" Value="Warning" />

<Rule Name="Data Item comment missing" Value="Warning" />

<Rule Name="Data Item description missing" Value="Information" />

<Rule Name="Data Item name duplicate" Value="Error" />

<Rule Name="Data Item code duplicate" Value="Error" />

<Rule Name="Data Item type missing" Value="Error" />

<Rule Name="Data Item type unknown" Value="Error" />

<Rule Name="Data Item not used" Value="Warning" />

<Rule Name="Entity name missing" Value="Error" />

<Rule Name="Entity code missing" Value="Warning" />

<Rule Name="Entity comment missing" Value="Warning" />

<Rule Name="Entity description missing" Value="Information" />

<Rule Name="Entity name duplicate" Value="Error" />

<Rule Name="Entity code duplicate" Value="Error" />

<Rule Name="Entity attribute missing" Value="Error" />

<Rule Name="Entity primary identifier missing" Value="Warning" />

<Rule Name="Association name missing" Value="Error" />

<Rule Name="Association code missing" Value="Warning" />

<Rule Name="Association comment missing" Value="Warning" />

<Rule Name="Association description missing" Value="Information" />

<Rule Name="Association name duplicate" Value="Error" />

<Rule Name="Association code duplicate" Value="Error" />

<Rule Name="Association link missing" Value="Error" />

<Rule Name="Inheritance name missing" Value="Error" />

<Rule Name="Inheritance code missing" Value="Warning" />

<Rule Name="Inheritance comment missing" Value="Warning" />

<Rule Name="Inheritance description missing" Value="Information" />

<Rule Name="Inheritance name duplicate" Value="Warning" />

<Rule Name="Inheritance code duplicate" Value="Warning" />

<Rule Name="Inheritance link missing" Value="Error" />

<Rule Name="Relationship name missing" Value="Error" />

<Rule Name="Relationship code missing" Value="Warning" />

<Rule Name="Relationship comment missing" Value="Warning" />

<Rule Name="Relationship description missing" Value="Information" />

<Rule Name="Relationship name duplicate" Value="Warning" />

<Rule Name="Relationship code duplicate" Value="Warning" />

<Rule Name="Relationship child entity missing" Value="Error" />

<Rule Name="Relationship parent entity missing" Value="Error" />

<Rule Name="Association Link name missing" Value="Error" />

<Rule Name="Association Link code missing" Value="Warning" />

<Rule Name="Association Link comment missing" Value="Warning" />

<Rule Name="Association Link description missing" Value="Information" />

<Rule Name="Association Link name duplicate" Value="Warning" />

<Rule Name="Association Link code duplicate" Value="Warning" />

<Rule Name="Association Link entity missing" Value="Error" />

<Rule Name="Association Link association missing" Value="Error" />

<Rule Name="Inheritance Link name missing" Value="" />

<Rule Name="Inheritance Link code missing" Value="" />

<Rule Name="Inheritance Link comment missing" Value="" />

<Rule Name="Inheritance Link description missing" Value="" />

<Rule Name="Inheritance Link name duplicate" Value="" />

<Rule Name="Inheritance Link code duplicate" Value="" />

<Rule Name="Inheritance Link entity missing" Value="Error" />

<Rule Name="Inheritance Link inheritance missing" Value="Error" />

<Rule Name="Attribute name missing" Value="Error" />

<Rule Name="Attribute code missing" Value="Warning" />

<Rule Name="Attribute comment missing" Value="Warning" />

<Rule Name="Attribute description missing" Value="Information" />

<Rule Name="Attribute is indentifier but not mandatory" Value="Error" />

<Rule Name="Attribute name duplicate" Value="Error" />

<Rule Name="Attribute code duplicate" Value="Error" />

<Rule Name="Identifier name missing" Value="Error" />

<Rule Name="Identifier code missing" Value="Warning" />

<Rule Name="Identifier comment missing" Value="Warning" />

<Rule Name="Identifier description missing" Value="Information" />

<Rule Name="Identifier name duplicate" Value="Error" />

<Rule Name="Identifier code duplicate" Value="Error" />

<Rule Name="Identifier attribute missing" Value="Error" />

</Validation>

<LMDomain OID="103" />

<LMDataItem DataType="INTEGER" OID="2" Name="ID" />

<LMDataItem Length="50" DataType="VARCHAR" OID="3" Name="street_number" ><![CDATA[Member's official contact address, where all the official mails for this member are sent]]></LMDataItem>

<LMDataItem Length="250" DataType="VARCHAR" OID="4" Name="street" ><![CDATA[Member's official contact address, where all the official mails for this member are sent]]></LMDataItem>

<LMDataItem Length="250" DataType="VARCHAR" OID="5" Name="town" ><![CDATA[Member's official contact address, where all the official mails for this member are sent]]></LMDataItem>

<LMDataItem Length="10" DataType="VARCHAR" OID="6" Name="ZIP_code" />

<LMDataItem DataType="TINYINT" OID="7" Name="type" ><![CDATA[Membership type: regular, symphatizing, graceful (?estn...), VIP (president of the country...), waiting for membership, non-member (membership ended for some reason), ...]]></LMDataItem>

<LMDataItem Length="40" DataType="VARCHAR" OID="8" Name="login" ><![CDATA[Member's login name. Member can use it for the web administration for managing his/her account (adding new users, computers, getting the statistics)]]></LMDataItem>

<LMDataItem Length="40" DataType="VARCHAR" OID="9" Name="password" ><![CDATA[see login]]></LMDataItem>

<LMDataItem Length="20" DataType="VARCHAR" OID="10" Name="qos_ceil" ><![CDATA[See HTB ceil definition]]></LMDataItem>

<LMDataItem DataType="DOUBLE PRECISION" OID="11" Name="entrance_fee" ><![CDATA[The amount of money which the member must pay as the entrance free.

Notes:

- The entrance fee can be changed by the decision of the NGO management

- Some members (typicaly, people with social/health disadvantages, VIPs) does not have to pay the entrance fee at all.]]></LMDataItem>

<LMDataItem OID="12" />

<LMDataItem DataType="TINYINT" OID="13" Name="must_pay_regular_fee" ><![CDATA[True if the member must (is obliged to) pay the regular free. Some members (typicaly, people with social/health disadvantages, VIPs, ...) does not have to pay the regular fee.]]></LMDataItem>

<LMDataItem DataType="FLOAT" OID="14" Name="current_credit" ><![CDATA[Most members pay the regular fee well in advance. Typically, if the regular fee is monthly one, members can pay half an year in advance.

Current credit hold the money paid in advance. From this amount, the regular fee is substracted regulary (e.g. monthly).

If the credit = 0, the member gets a warning about missing payment.]]></LMDataItem>

<LMDataItem DataType="DOUBLE PRECISION" OID="15" Name="debt_payment_rate" ><![CDATA[In some cases, the entrance fee payment can be prescribed to several payments - this can be used by members, who does not have that much money to be able to pay the membership normally.

The debt_rate is the amount of money, which should be subtracted from the credit every month to pay for the entrance fee debt.]]></LMDataItem>

<LMDataItem Length="20" DataType="VARCHAR" OID="16" Name="qos_rate" ><![CDATA[see HTB rate definition]]></LMDataItem>

<LMDataItem DataType="DOUBLE PRECISION" OID="17" Name="entrance_fee_left" ><![CDATA[If the member pays the entrance fee in several payments using the "debt" feature, then entrance_fee_left holds the current amount which is still missing for the entrance fee to be paid fully.]]></LMDataItem>

<LMDataItem DataType="DATE" OID="18" Name="entrance_date" ><![CDATA[The date when the person became the member. From this date, he must pay the regular fee.]]></LMDataItem>

<LMDataItem OID="19" />

<LMDataItem Length="30" DataType="VARCHAR" OID="21" Name="name" />

<LMDataItem Length="30" DataType="VARCHAR" OID="22" Name="middle_name" />

<LMDataItem Length="60" DataType="VARCHAR" OID="23" Name="surname" />

<LMDataItem DataType="INTEGER" OID="24" Name="ID" />

<LMDataItem Length="40" DataType="VARCHAR" OID="25" Name="pre_title" ><![CDATA[prof. Ing. Mgr.]]></LMDataItem>

<LMDataItem Length="30" DataType="VARCHAR" OID="26" Name="post_title" ><![CDATA[PhD, CSc, DiS, ....]]></LMDataItem>

<LMDataItem DataType="DATE" OID="27" Name="birthday" />

<LMDataItem Length="40" DataType="VARCHAR" OID="28" Name="phone" />

<LMDataItem Length="60" DataType="VARCHAR" OID="29" Name="email" />

<LMDataItem OID="30" Name="variable_symbol" ><![CDATA[variable symbol is an integer used in bank transfer commands to identify the payment]]></LMDataItem>

<LMDataItem OID="32" />

<LMDataItem Length="50" DataType="VARCHAR" OID="33" Name="login" ><![CDATA[login for PPPoE]]></LMDataItem>

<LMDataItem Length="50" DataType="VARCHAR" OID="34" Name="password" />

<LMDataItem Length="65535" DataType="VARCHAR" OID="35" Name="comment" />

<LMDataItem Length="250" DataType="VARCHAR" OID="37" Name="comment" />

<LMDataItem DataType="INTEGER" OID="38" Name="web_messages_types" ><![CDATA[This is a 32bit binary-represented set, defining which messages the user want to receive. The values can follow this example:

... 0000 0000 - no messages at all

... 0000 0001 - technical news

... 0000 0010 - organizational news

... 0000 0011 - technical and organizational news]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="39" Name="email_messages_types" ><![CDATA[See receive_web_messages_set - but this is for emails]]></LMDataItem>

<LMDataItem Length="40" DataType="VARCHAR" OID="40" Name="type" ><![CDATA[Type of the contact. Examples:

Skype, MSN, AOL, phone2, Address2, ...]]></LMDataItem>

<LMDataItem Length="255" DataType="VARCHAR" OID="41" Name="value" ><![CDATA[Value of the contact]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="43" Name="ID_member" ><![CDATA[ID of the member that the user belongs to]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="44" Name="ID_user" ><![CDATA[ID of the user which this contact belongs to]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="45" Name="ID" ><![CDATA[ID of this contact]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="47" Name="name" ><![CDATA[Name of the device (examples: "AP-London-3", "PC324" etc.)]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="48" Name="type" ><![CDATA[Type of the device. Examples:

AP

Router

PC

VOIP phone

...]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="49" Name="ID_user" ><![CDATA[ID of the user (from table "Users") who is owning this device]]></LMDataItem>

<LMDataItem DataType="TINYINT" OID="50" Name="PPPoE_logging_in" ><![CDATA[If the device is logging in to the network using PPPoE, this attribute should be set to true.

For all the devices, that can't log in using PPPoE, exceptions must be made in their gateway firewall.]]></LMDataItem>

<LMDataItem Length="15" DataType="VARCHAR" OID="53" Name="MAC" />

<LMDataItem DataType="INTEGER" OID="55" Name="ID" />

<LMDataItem DataType="INTEGER" OID="56" Name="ID_device" ><![CDATA[ID of the device, that this interface belongs to.]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="59" Name="IP_address" ><![CDATA[e.g.: "192.168.0.1", but stored as Integer, so network mask operations can be easily calculated with it.]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="60" Name="ID_interface" ><![CDATA[ID of the network interface (from table "Network_interface") that this IP address is assigned to.

This can be also null, if the IP is assigned to a VLAN interface]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="62" Name="name" ><![CDATA[Name of the segment, like "Optical backbone segment between building A and building B"]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="63" Name="technology" ><![CDATA[E.g.:

WiFi

Optical cable

Ethernet CAT5e]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="64" Name="bitrate" ><![CDATA[Max. bitrate of this segment in Mbit/s

e.g.:

10 [Mbit/s]

100 [Mbit/s]

1000 [Mbit/s]]]></LMDataItem>

<LMDataItem DataType="TINYINT" OID="65" Name="duplex" ><![CDATA["1" if Full duplex, "0" if half duplex]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="66" Name="ID" />

<LMDataItem OID="67" />

<LMDataItem DataType="INTEGER" OID="69" Name="ID" />

<LMDataItem Length="254" DataType="VARCHAR" OID="70" Name="name" ><![CDATA[Name of the subnet, e.g.:

"Downing street 314 - users"]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="71" Name="network_address" ><![CDATA[Network address of this subnet.

It is probably not really necessay because it can be calculated from any IP address belonging to the subnet, but ... if it can save a DB querry then why not putting it here?]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="72" Name="netmask" ><![CDATA[e.g. 255.255.255.0]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="74" Name="ID_subnet" ><![CDATA[ID of the subnet that this IP belongs to]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="76" Name="name" ><![CDATA[name of the port, e.g.

"1"]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="77" Name="ID" />

<LMDataItem DataType="INTEGER" OID="79" Name="ID_segment" ><![CDATA[ID of the Segment, that this Interface is connected to.

Interface can be connected to 1 segment only (there is no way of connecting RJ45 plug into 2 differnet cables, or connecting WiFi to 2 APs at once)]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="80" Name="name" ><![CDATA[name of the interface]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="81" Name="ID" />

<LMDataItem DataType="INTEGER" OID="83" Name="ID_device" ><![CDATA[ID of the device that this port belongs to]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="85" Name="ID_segment" ><![CDATA[ID of the segment (see table "Segment") to which this port is connected to]]></LMDataItem>

<LMDataItem OID="86" Name="comment" ><![CDATA[E.g.: the color of the optical fibres used by this segment]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="90" Name="ID" />

<LMDataItem Length="254" DataType="VARCHAR" OID="91" Name="name" />

<LMDataItem DataType="INTEGER" OID="92" Name="802_1q_tag" ><![CDATA[The 802_1q tag used for marking packets on this VLAN]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="93" Name="comment" />

<LMDataItem DataType="INTEGER" OID="94" Name="ID" />

<LMDataItem DataType="INTEGER" OID="95" Name="ID_VLAN" />

<LMDataItem OID="96" Name="ID_Interface" ><![CDATA[ID of the interface that the VLAN is created upon]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="100" Name="ID_VLAN_Interface" ><![CDATA[ID of the VLAN interface (from table "VLAN_Interface") that this IP address is assigned to.

This can be also null, if the IP is assigned to a physical network interface.]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="101" Name="ID_OSPF_area" ><![CDATA[OSPF area id used for this subnet.]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="104" Name="login" ><![CDATA[administrator's login to this device]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="105" Name="password" ><![CDATA[administrator's password for this device]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="106" Name="comment" />

<LMDataItem Length="254" DataType="VARCHAR" OID="107" Name="comment" />

<LMDataItem DataType="INTEGER" OID="109" Name="ID" />

<LMDataItem DataType="INTEGER" OID="110" Name="ID_origin" ><![CDATA[ID of the member who made the bank transfer. The system can assign this ID automatically using ( e.g.) the variable symbol or manually by the administrator.

Remember that the member who paid the amount does not necessarily be the one whose account should be increased by the payment - see the "Multi_payment" table!]]></LMDataItem>

<LMDataItem Precision1="14" DataType="TIMESTAMP" OID="112" Name="timestamp" ><![CDATA[time of the transfer]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="113" Name="text" ><![CDATA[Descriptive text field of the payment.]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="114" Name="name" ><![CDATA[Name of the bank account that the payment came from]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="115" Name="type" ><![CDATA[Type of the payment, e.g.:

normal transfer,

bank fee,

...]]></LMDataItem>

<LMDataItem DataType="BIGINT" OID="116" Name="variable_symbol" ><![CDATA[Variable symbol is a number that banks in Czech republic provide to their clients for passing extra information in the payments]]></LMDataItem>

<LMDataItem OID="117" />

<LMDataItem DataType="INTEGER" OID="118" Name="constant_symbol" ><![CDATA[Constant symbol is a number that banks in Czech republic provide to their clients for passing extra information in the payments.

The constant symbol's value must be selected from predefined set, e.g.:

0308 - other payments

0559 - insurace

etc.]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="119" Name="specific_symbol" ><![CDATA[Variable symbol is a number that banks in Czech republic provide to their clients for passing extra information in the payments]]></LMDataItem>

<LMDataItem DataType="DOUBLE PRECISION" OID="120" Name="amount" ><![CDATA[The amount of money being transfered]]></LMDataItem>

<LMDataItem DataType="DOUBLE PRECISION" OID="121" Name="fee" ><![CDATA[bank fee charged to the account for this transfer]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="123" Name="ID_member" ><![CDATA[ID of the member whose credit is changed by this modification]]></LMDataItem>

<LMDataItem DataType="DOUBLE PRECISION" OID="124" Name="amount" ><![CDATA[Amount of money added/substracted from the credit]]></LMDataItem>

<LMDataItem DataType="TIMESTAMP" OID="125" Name="timestamp" ><![CDATA[Date and time of the modification]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="126" Name="ID_user_admin" ><![CDATA[ID of the administrator/manager, who made this modification]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="127" Name="ID" />

<LMDataItem Length="254" DataType="VARCHAR" OID="128" Name="reason" ><![CDATA[The reason for the credit modification (visible to the member whose credit is modified)]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="129" Name="comment" />

<LMDataItem DataType="INTEGER" OID="132" Name="ID" />

<LMDataItem DataType="INTEGER" OID="133" Name="ID_device" ><![CDATA[ID of the device whose access is modified]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="134" Name="ID_user_admin" ><![CDATA[ID of the user who made the modification]]></LMDataItem>

<LMDataItem OID="135" ><![CDATA[Date and time of the modification]]></LMDataItem>

<LMDataItem DataType="TIMESTAMP" OID="136" Name="timestamp_start" />

<LMDataItem DataType="TIMESTAMP" OID="137" Name="timestamp_end" ><![CDATA[Date and time of the modification end]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="138" Name="type" ><![CDATA[Type of the modification, e.g.:

- qos_rate_download changed to 128kbits---

- HTTP redirected to "refill your credit" page

- access completely blocked]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="139" Name="reason" ><![CDATA[Reason of the modification visible to the user]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="140" Name="comment" />

<LMDataItem Length="100" DataType="VARCHAR" OID="144" Name="GPS" ><![CDATA[GPS position of the device.

Used mainly for WiFi APs to be able to display them on the map]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="145" Name="location_address" ><![CDATA[Address of the building where the device resides]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="146" Name="location_details" ><![CDATA[More details about the location of the device - e.g., room nubmer, floor, instructions how to get to the location etc.]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="148" Name="ID_owner" ><![CDATA[ID of the Member owning this account]]></LMDataItem>

<LMDataItem DataType="TINYINT" OID="149" Name="type" ><![CDATA[type of the account:

- bank account

- analytical ('virtual') account]]></LMDataItem>

<LMDataItem DataType="DOUBLE PRECISION" OID="150" Name="start_amount" ><![CDATA[If the account type is "analytical", this is the starting amount.

With bank accounts, this column doesn't make too much sense]]></LMDataItem>

<LMDataItem Length="100" DataType="VARCHAR" OID="152" Name="name" ><![CDATA[Type of the payment, e.g.:

- regular fee payment

- entrance fee payment]]></LMDataItem>

<LMDataItem Length="254" DataType="VARCHAR" OID="153" Name="comment" />

<LMDataItem OID="155" Name="unassigned_amount" ><![CDATA[The amount of the money from this payment, which is still not assigned.

E.g.:

Member A pays 7000 for members A, B, C entrance fees, which should be 2000 each. 3x2000=6000, so 1000 must be still assigned to somebody's credit.

Until the financial administrator finds out, where the 1000 goes, it will be recorded in this field.

Note that the unassinged amount can be also retrieved by querrying the "Payments Assignments" table, but it takes time - while using the "unassigned_amount" attribute, the unassigned payments can be listed very quickly.

Of course, regular consistency checks must be done to ensure this field holds correct values!]]></LMDataItem>

<LMDataItem Length="100" DataType="VARCHAR" OID="157" Name="name" ><![CDATA[Name of the non-physical person.

In case of physical person, put the surname or name+surname here.]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="158" Name="ID" ><![CDATA[ID of the account]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="159" Name="ID_destination" ><![CDATA[ID of the destination account]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="160" Name="ID_destination" ><![CDATA[ID of the destination (target) account, where the money are sent to.]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="163" Name="ID" ><![CDATA[The work item ID]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="164" Name="ID_user" ><![CDATA[The user who commited the work]]></LMDataItem>

<LMDataItem Length="255" DataType="VARCHAR" OID="165" Name="description" ><![CDATA[Description of the work]]></LMDataItem>

<LMDataItem DataType="FLOAT" OID="166" Name="hours" ><![CDATA[Number of hours spent by the work]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="167" Name="confirmed_by_ID" ><![CDATA[user's credit can be increased only if the work is confirmed by the organization management or by a manager of the project budget.

This is the ID of the manager who confirmed the work.]]></LMDataItem>

<LMDataItem DataType="INTEGER" OID="168" Name="transfer_ID" ><![CDATA[If the work is confirmed, the credit/money is transfered to the account of the member. This is the ID of the transfer.]]></LMDataItem>

<LMDataItem OID="172" Name="variable_symbol" />

<LMDataItem OID="173" Name="constant_symbol" />

<LMDataItem OID="174" Name="specific_symbol" />

<LMDataItem OID="175" Name="text" />

<LMDataItem OID="176" Name="ID_fee_transfer" />

<LMDataItem OID="177" Name="ID" />

<LMDataItem OID="178" Name="date_time" />

<LMDataItem OID="179" Name="ID_bank_info" />

</LMModel>

<SAWorkspace Name="" Version="2.2" >

<Child Class="SAProject" Location="FreeNetIS.SAProject" />

</SAWorkspace>

<MYModel Align="68" DisplayFlags="5" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" DatabaseType="MySQL" BackgroundColor="#ffffff" FontBold="0" BackgroundImagePlacement="0" FontItalic="0" ModificationDate="2007-04-30T09:00:07" Author="Tomas Dulik" TextFlag="2048" CreationDate="2007-04-30T08:43:51" BackgroundType="0" FontStrikeOut="0" Name="FreeNetIS Database" BackgroundStyle="none" Version="2.2" ViewParse="1" NextOID="158" FontFamily="MS Shell Dlg" ><![CDATA[FreeNetIS database structure ER diagram]]><MYTable DescriptionSize="4096" width="131" Description="789ced913b4e0331108613d2202a8e30da0291220f1a8492cd561154498a700026bbb36b0b3f36b643b2b911f7e140d8bb12520a3a241a7f951fbffff9c7933227459632c2224b253904859216c9def09c393ab90472ad1c29b7481e129864e9a4d3ee74d180758df0e2d22b46969f69f654bb79bb2b5172d1cc565bd832120296a24ab29bb4ce525ba3ba7878245e31377b9c4e936c493637bc765cab593a09525fb06e1fbe32821d5a9ec3c192019f88bb660ce1d8105aada0d406eef607ede62bda91e996c02d38860e10d62f1b3007a5b8aafc11c1b3215a93e37624516145052872476dde21f711197e1028ad46356b6cce518c6a32a18c24e9dd2ddc2fb47731a04d858a9f3184b643405504774b9717ad2757b9381404be5ed3b6e15d823dcf5140676f8763d8b4be7442590b6f53fec408bacb18a1bdae5184eecfbbddb8fbb6491853985998722f1289442291482412f963e4e0addfbbed0d4efdac77fdf579f5df792291c8ef7c03f32ab170" x="365" TextField="2" Align="68" y="289" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="1" ScriptCreateSQLDrop="0" height="314" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="MEMBERS" Name="Members" NextOID="25" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[The basic entity. The reason for distinguishing between Users and Members is that a NGO running the FreeNetis-managed network can have non-physcial-person members (=other organizations) and these organizations can include many users (physical persons). Other example of non-physical-person member is "a family".]]><sink x="0.916667" y="0.1" OID="20" />

<sink x="0.21374" y="0.0127389" OID="23" />

<sink x="0.938931" y="0.0828025" OID="24" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="1" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="50" DataType="VARCHAR" OID="2" Code="STREET_NUMBER" Name="street_number" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="250" DataType="VARCHAR" OID="3" Code="STREET" Name="street" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="250" DataType="VARCHAR" OID="4" Code="TOWN" Name="town" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="10" DataType="VARCHAR" OID="5" Code="ZIP_CODE" Name="ZIP_code" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="TINYINT" OID="6" Code="TYPE" Name="type" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="7" Code="LOGIN" Name="login" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="8" Code="PASSWORD" Name="password" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="20" DataType="VARCHAR" OID="10" Code="QOS_CEIL" Name="qos_ceil" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="20" DataType="VARCHAR" OID="16" Code="QOS_RATE" Name="qos_rate" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="11" Code="ENTRANCE_FEE" Name="entrance_fee" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="15" Code="DEBT_PAYMENT_RATE" Name="debt_payment_rate" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="17" Code="ENTRANCE_FEE_LEFT" Name="entrance_fee_left" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="TINYINT" OID="13" Code="MUST_PAY_REGULAR_FEE" Name="must_pay_regular_fee" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="FLOAT" OID="14" Code="CURRENT_CREDIT" Name="current_credit" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="DATE" OID="18" Code="ENTRANCE_DATE" Name="entrance_date" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="65535" DataType="VARCHAR" OID="21" Code="COMMENT" Name="comment" />

</MYTable>

<MYTable width="130" x="173" TextField="2" Align="68" y="295" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="20" ScriptCreateSQLDrop="0" height="329" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="USERS" Name="Users" NextOID="24" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[The table "Users" holds **compulsory** contact information about individual users (each member can have several users).

An additional contact info can be stored in the table "Contacts"]]><sink x="0.915385" y="0.109422" OID="23" />

<sink x="0.823077" y="0.957447" OID="22" />

<sink x="0.0650888" y="0.0931174" OID="1" />

<sink x="0.829457" y="0.141304" OID="18" />

<sink x="0.899225" y="0.0108696" OID="20" />

<sink x="0.0852713" y="0.15942" OID="21" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="17" Code="ID_MEMBER" Name="ID_member" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="2" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="30" DataType="VARCHAR" OID="3" Code="NAME" Name="name" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="30" DataType="VARCHAR" OID="4" Code="MIDDLE_NAME" Name="middle_name" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="60" DataType="VARCHAR" OID="5" Code="SURNAME" Name="surname" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="6" Code="PRE_TITLE" Name="pre_title" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="30" DataType="VARCHAR" OID="7" Code="POST_TITLE" Name="post_title" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="DATE" OID="8" Code="BIRTHDAY" Name="birthday" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="9" Code="PHONE" Name="phone" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="60" DataType="VARCHAR" OID="10" Code="EMAIL" Name="email" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="50" DataType="VARCHAR" OID="11" Code="LOGIN" Name="login" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="50" DataType="VARCHAR" OID="12" Code="PASSWORD" Name="password" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="15" Code="WEB_MESSAGES_TYPES" Name="web_messages_types" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="16" Code="EMAIL_MESSAGES_TYPES" Name="email_messages_types" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="65535" DataType="VARCHAR" OID="13" Code="COMMENT" Name="comment" />

</MYTable>

<MYTable width="61" x="51" TextField="2" Align="68" y="292" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="36" ScriptCreateSQLDrop="0" height="88" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="CONTACTS" Name="Contacts" NextOID="7" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Additional contact fields for a given user.

Rules of thumb:

-Compulsory contact fields should be directly in the "User" table.

-Additional contact fields go into this "Contacts" table]]><sink x="0.163934" y="0.375" OID="6" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="ID_USER" Name="ID_user" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="5" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="40" DataType="VARCHAR" OID="2" Code="TYPE" Name="type" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="255" DataType="VARCHAR" OID="3" Code="VALUE" Name="value" />

</MYTable>

<MYTable width="99" x="44" TextField="2" Align="68" y="668" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="46" ScriptCreateSQLDrop="0" height="206" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="DEVICES" Name="Devices" NextOID="18" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Table "Devices" represents devices conected to the network. Device can be a PC, router, switch, AP, client wifi box, VOIP phone, IPTV set-top-box - simply anything with active ethernet plug.]]><sink x="0.89899" y="0.160194" OID="17" />

<sink x="0.172897" y="0.545455" OID="2" />

<sink x="0.555556" y="0.896552" OID="7" />

<sink x="0.35" y="0.0574713" OID="13" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="8" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="5" Code="ID_USER" Name="ID_user" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="3" Code="NAME" Name="name" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="4" Code="TYPE" Name="type" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="TINYINT" OID="6" Code="PPPOE_LOGGING_IN" Name="PPPoE_logging_in" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="9" Code="LOGIN" Name="login" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="10" Code="PASSWORD" Name="password" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="100" DataType="VARCHAR" OID="14" Code="GPS" Name="GPS" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="15" Code="LOCATION_ADDRESS" Name="location_address" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="16" Code="LOCATION_DETAILS" Name="location_details" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="11" Code="COMMENT" Name="comment" />

</MYTable>

<MYTable width="74" x="227" TextField="2" Align="68" y="671" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="52" ScriptCreateSQLDrop="0" height="121" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="INTERFACES" Name="Interfaces" NextOID="16" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Interface is any network interface which has its own MAC adres.

Interface is typically a network interface card in a PC or in a router.

Note: ports in switches should not be in this table! They should be in table "Ports".

An exception is managable switch - which has MAC and IP address.

Therefore, managable switches should have the port, which is connected to the segment with the switch's IP subnet, stored in the "Interfaces" table.]]><sink x="0.0540541" y="0.330579" OID="15" />

<sink x="0.842105" y="0.585366" OID="11" />

<sink x="0.477064" y="0.859756" OID="10" />

<sink x="0.864865" y="0.206612" OID="14" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="4" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="5" Code="ID_DEVICE" Name="ID_device" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="8" Code="ID_SEGMENT" Name="ID_segment" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="15" DataType="VARCHAR" OID="2" Code="MAC" Name="MAC" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="9" Code="NAME" Name="name" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="12" Code="COMMENT" Name="comment" />

</MYTable>

<MYTable width="73" x="406" TextField="2" Align="68" y="679" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="57" ScriptCreateSQLDrop="0" height="103" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="IP_ADDRESS" Name="IP_address" NextOID="12" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[One network interface can have multiple IP addresses. These IP addresses are recorded in this table]]><sink x="0.479452" y="0.893204" OID="8" />

<sink x="0.830508" y="0.266234" OID="7" />

<sink x="0.219178" y="0.242718" OID="10" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_INTERFACE" Name="ID_interface" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="9" Code="ID_VLAN_INTERFACE" Name="ID_VLAN_Interface" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="5" Code="ID_SUBNET" Name="ID_subnet" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="2" Code="IP_ADDRESS" Name="IP_address" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="11" Name="ID" />

</MYTable>

<MYTable width="69" x="233" TextField="2" Align="68" y="848" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="61" ScriptCreateSQLDrop="0" height="121" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="SEGMENTS" Name="Segments" NextOID="11" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Any (sub)network can be composed of many segments, which are interconnected by network bridges or switches. The segments are stored in this table]]><sink x="0.0833333" y="0.213836" OID="9" />

<sink x="0.407407" y="0.157233" OID="8" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="1" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="2" Code="NAME" Name="name" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="3" Code="TECHNOLOGY" Name="technology" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="BITRATE" Name="bitrate" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="TINYINT" OID="5" Code="DUPLEX" Name="duplex" />

<MYColumn ScriptCreateSQLCreateManual="0" OID="10" Code="COMMENT" Name="comment" />

</MYTable>

<MYTable width="90" x="549" TextField="2" Align="68" y="683" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="68" ScriptCreateSQLDrop="0" height="108" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="SUBNETS" Name="Subnets" NextOID="8" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Every IP address belongs to a subnet. Subnets are described by this table.]]><sink x="0.0582524" y="0.182482" OID="6" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="1" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="7" Code="ID_OSPF_AREA" Name="ID_OSPF_area" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="3" Code="NAME" Name="name" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="NETWORK_ADDRESS" Name="network_address" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="5" Code="NETMASK" Name="netmask" />

</MYTable>

<MYTable width="72" x="66" TextField="2" Align="68" y="961" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="75" ScriptCreateSQLDrop="0" height="94" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="PORTS" Name="Ports" NextOID="9" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Port is any active network socket on a Device.

Port is typically a port on a switch.

Port has no MAC address - only a network interface (see table "Interface") has a MAC.

An exception is managable switch - which has a MAC and an IP address.

Therefore, managable switches should have the port, which is connected to the segment with the switch's IP subnet, stored in the "Interfaces" table.]]><sink x="0.486111" y="0.489362" OID="8" />

<sink x="0.462963" y="0.111111" OID="1" />

<sink x="0.722222" y="0.409722" OID="5" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="2" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_DEVICE" Name="ID_device" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="6" Code="ID_SEGMENT" Name="ID_segment" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="4" Code="NAME" Name="name" />

</MYTable>

<MYTable width="70" x="398" TextField="2" Align="68" y="993" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="87" ScriptCreateSQLDrop="0" height="92" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="VLANS" Name="VLANs" NextOID="9" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[VLAN is a virtual network working upon physical network segments.

VLAN is implemented in switches or routers and is present on their ports/interfaces.

On a switch or router, one VLAN can be assigned to several ports, and one port can have several VLANs.

On a router, a VLAN interface, created on one of its physical network interfaces, can have several IP addressess assigned to it.]]><sink x="0.485714" y="0.48913" OID="8" />

<sink x="0.506173" y="0.023622" OID="6" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="2" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="3" Code="NAME" Name="name" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="802_1Q_TAG" Name="802_1q_tag" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="5" Code="COMMENT" Name="comment" />

</MYTable>

<MYTable width="109" x="393" TextField="2" Align="68" y="851" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="89" ScriptCreateSQLDrop="0" height="76" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="VLAN_INTERFACES" Name="VLAN_Interfaces" NextOID="7" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Several VLAN Interfaces can be created upon normal network Interface. Every VLAN Interface then belongs to just one VLAN (but there can be many VLAN interfaces with the same VLAN ID!).

From a router's internal point of view, a VLAN interface is the same thing as a normal network interface - it can have several IP addresses assigned (but it shares the MAC address of its physical network interface).]]><sink x="0.440367" y="0.0394737" OID="6" />

<sink x="0.293578" y="0.0263158" OID="1" />

<sink x="0.376147" y="0.921053" OID="2" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="3" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="ID_VLAN" Name="ID_VLAN" />

<MYColumn ScriptCreateSQLCreateManual="0" OID="5" Code="ID_INTERFACE" Name="ID_Interface" />

</MYTable>

<MYTable width="110" x="611" TextField="2" Align="68" y="454" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="108" ScriptCreateSQLDrop="0" height="213" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="PAYMENTS" Name="Payments" NextOID="17" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This is the table where all payments from the bank account listings are stored.]]><sink x="0.434343" y="0.0646766" OID="15" />

<sink x="0.171717" y="0.925373" OID="14" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="1" Code="ID" Name="ID" />

<MYColumn Precision1="14" ScriptCreateSQLCreateManual="0" DataType="TIMESTAMP" OID="4" Code="TIMESTAMP" Name="timestamp" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="5" Code="TEXT" Name="text" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="6" Code="NAME" Name="name" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="7" Code="TYPE" Name="type" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="BIGINT" OID="8" Code="VARIABLE_SYMBOL" Name="variable_symbol" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="9" Code="CONSTANT_SYMBOL" Name="constant_symbol" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="10" Code="SPECIFIC_SYMBOL" Name="specific_symbol" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="11" Code="AMOUNT" Name="amount" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="12" Code="FEE" Name="fee" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="2" Code="ID_PAYER" Name="ID_payer" />

<MYColumn ScriptCreateSQLCreateManual="0" OID="16" Code="UNASSIGNED_AMOUNT" Name="unassigned_amount" />

</MYTable>

<MYTable width="100" x="341" TextField="2" Align="68" y="76" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="122" ScriptCreateSQLDrop="0" height="139" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="CREDIT_MODS" Name="Credit_mods" NextOID="10" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[The current credit of each member can be modified by the management of the organization for different reasons, e.g.:

- the member can receive credit bonuses for his work for the organization

- the credit can be lowered by giving the member a penalty for an accident or purposeful act whose aftermath costs the organization some money, e.g. in the case when member damages some network equipment or tool owned by the organization]]><sink x="0.512397" y="0.870504" OID="1" />

<sink x="0.15" y="0.942446" OID="9" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="2" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_MEMBER" Name="ID_member" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="ID_USER_ADMIN" Name="ID_user_admin" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="5" Code="AMOUNT" Name="amount" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="TIMESTAMP" OID="6" Code="TIMESTAMP" Name="timestamp" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="7" Code="REASON" Name="reason" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="8" Code="COMMENT" Name="comment" />

</MYTable>

<MYTable width="89" x="26" TextField="2" Align="68" y="400" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="131" ScriptCreateSQLDrop="0" height="150" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="ACCESS_MODS" Name="Access_mods" NextOID="11" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This is table records the modifications of the members' access to the network.]]><sink x="0.820225" y="0.133333" OID="10" />

<sink x="0.595506" y="0.886667" OID="9" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="1" Code="ID" Name="ID" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="2" Code="ID_DEVICE" Name="ID_device" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_USER_ADMIN" Name="ID_user_admin" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="TIMESTAMP" OID="4" Code="TIMESTAMP_START" Name="timestamp_start" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="TIMESTAMP" OID="5" Code="TIMESTAMP_END" Name="timestamp_end" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="6" Code="TYPE" Name="type" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="7" Code="REASON" Name="reason" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="8" Code="COMMENT" Name="comment" />

</MYTable>

<MYTable width="137" x="583" TextField="2" Align="68" y="283" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="147" ScriptCreateSQLDrop="0" height="123" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="PAYMENTS_ASSIGNMENTS" Name="Payments_Assignments" NextOID="9" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Auxiliary table implementing the M:N relations "Payment assigned to multiple users".

This M:N relationship is necessary for being able to capture cases, when a member makes single bank transfer to pay for several other Members.]]><sink x="0.520408" y="0.858407" OID="2" />

<sink x="0.102041" y="0.283186" OID="1" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Code="ID_MEMBER" Name="ID_Member" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Code="ID_PAYMENT" Name="ID_Payment" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="DOUBLE" OID="5" Code="AMOUNT" Name="amount" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="20" DataType="VARCHAR" OID="6" Code="TYPE" Name="type" />

<MYColumn ScriptCreateSQLCreateManual="0" Length="254" DataType="VARCHAR" OID="7" Code="COMMENT" Name="comment" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="8" Name="ID" />

</MYTable>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="31" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Users" FontItalic="0" Parent="Members" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="MEMBER_HAS_USERS" Name="Member_has_Users" BeginTruncate="1" BeginArrowFlags="1" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship describes the following facts:

Member can be a physical person, but usually Member is a legal entity, like another NGO or a family.

Therefore, member can have several users - physical persons, who are eligible to use the NGO resources.

Side note: We could have made the things more complicated by considering users, who belong to more than one member. In such a case, this would lead to M:N relation, that would have to be implemented by table "Users_Members". In such a case, the "Contacts", "Device" and other tables, that are related to User belonging to certain Member, would be related to "Users_Members" table (not just Users like currently).]]><point x="181" y="326" OID="1" SinkObjectOID="20" SinkOID="1" />

<point x="485" y="320" OID="2" SinkObjectOID="1" SinkOID="20" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="42" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Contacts" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="USER_HAS_CONTACTS" Name="User_has_Contacts" BeginTruncate="1" BeginArrowFlags="0" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Relationship for assigning several contacts to one user.]]><point x="61" y="325" OID="1" SinkObjectOID="36" SinkOID="6" />

<point x="292" y="331" OID="2" SinkObjectOID="20" SinkOID="23" />

<TextHandle x="0.438356" y="2.14943" OID="3" />

</MYReference>

<MYReference DescriptionSize="4096" Description="789ced90bd4ec330148523c1c4c4235c654020b58dd8509a66626d19fa04ae73135bf827b59db6e99333729d8801891d55f2b75ddfe3e3735c89a0555d09644d5d690c0c0cd3b8c98f4e7211f01272e0d604346193bfe650d455316b0fb619c1875191b825c5d2cb2b966f7d584f53cbb45463b9ddc35ea052f0aebabc7ea8fa7a6703426b1d0421cda7345d09d6203478921c8133430bb40e83e44ca911043b21683aa0735a46ede0d12de02c28219ceda01a88d2c9745beec0a162415ae385ec17701802f0c1396a406e67048f08c6928a796ba64b9ac51c53a0cecf6f71ab7b85975555f494ba886563f3f85799467d40e7e1796329aa03eb3a66e4757ef305986962058fbf17533569b81a1aeac3cc38d520975e8c3e76859ec6e8b0828fc9172f2c8600db525eb3fcd12d671dcc31407a783a0e36ac19cc7f3e4f7f264f241289c4ed73ff95658fd9dd7fc7482412894422717b7c03fd48b015" TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="51" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Devices" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="DEVICE_IS_OWNED_BY_USER" Name="Device_is_owned_by_User" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[Relationship for assigning one or more devices to one user]]><point x="61" y="780" OID="1" SinkObjectOID="46" SinkOID="2" />

<point x="281" y="342" OID="2" SinkObjectOID="20" SinkOID="18" />

<TextHandle x="0.359307" y="0.548098" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="54" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Interfaces" FontItalic="0" Parent="Devices" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="DEVICE_HAS_INTERFACE" Name="Device_has_interface" BeginTruncate="1" BeginArrowFlags="0" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns interfaces to a device]]><point x="231" y="711" OID="1" SinkObjectOID="52" SinkOID="15" />

<point x="133" y="701" OID="2" SinkObjectOID="46" SinkOID="17" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="58" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="IP_address" FontItalic="0" Parent="Interfaces" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="INTERFACE_HAS_IP_ADDRESS" Name="Interface_has_IP_address" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings IP addresses to an interface.

Note:

To get a list of all IP addresses assigned to a interface, you must look also to the relationship "VLAN_interface_has_IP_addresses" !]]><point x="422" y="704" OID="1" SinkObjectOID="57" SinkOID="10" />

<point x="291" y="696" OID="2" SinkObjectOID="52" SinkOID="14" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="73" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="IP_address" FontItalic="0" Parent="Subnets" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="IP_ADDRESS_BELONGS_TO_SUBNET" Name="IP_address_belongs_to_Subnet" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings IP addresses to a subnet]]><point x="466" y="706" OID="1" SinkObjectOID="57" SinkOID="7" />

<point x="554" y="703" OID="2" SinkObjectOID="68" SinkOID="6" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="78" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Interfaces" FontItalic="0" Parent="Segments" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="INTERFACE_IS_CONNECTED_TO_SEGMENT" Name="Interface_is_connected_to_Segment" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns Interfaces to a segment]]><point x="262" y="776" OID="1" SinkObjectOID="52" SinkOID="10" />

<point x="261" y="868" OID="2" SinkObjectOID="61" SinkOID="8" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="82" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Ports" FontItalic="0" Parent="Devices" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="DEVICE_HAS_PORTS" Name="Device_has_Ports" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns ports to a device (switch)]]><point x="99" y="971" OID="1" SinkObjectOID="75" SinkOID="1" />

<point x="99" y="852" OID="2" SinkObjectOID="46" SinkOID="7" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="84" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Ports" FontItalic="0" Parent="Segments" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="PORTS_CONNECTED_TO_A_SEGMENT" Name="Ports_connected_to_a_Segment" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns ports on a switch to a network segment]]><point x="117" y="1000" OID="1" SinkObjectOID="75" SinkOID="5" />

<point x="238" y="874" OID="2" SinkObjectOID="61" SinkOID="9" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="97" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="VLANs" FontItalic="0" Parent="VLAN_Interfaces" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="VLAN_INTERFACE_BELONG_TO_A_VLAN" Name="VLAN_Interface_belong_to_a_VLAN" BeginTruncate="1" BeginArrowFlags="4" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns VLAN interfaces to a VLAN.]]><point x="433" y="996" OID="1" SinkObjectOID="87" SinkOID="6" />

<point x="434" y="921" OID="2" SinkObjectOID="89" SinkOID="2" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="98" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Interfaces" FontItalic="0" Parent="VLAN_Interfaces" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="VLAN_INTERFACE_IS_CREATED_ON_INTERFACE" Name="VLAN_Interface_is_created_on_Interface" BeginTruncate="1" BeginArrowFlags="4" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns VLAN interfaces to a physical network interface]]><point x="290" y="741" OID="1" SinkObjectOID="52" SinkOID="11" />

<point x="425" y="853" OID="2" SinkObjectOID="89" SinkOID="1" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="99" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="IP_address" FontItalic="0" Parent="VLAN_Interfaces" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="VLAN_INTERFACE_HAS_IP_ADDRESSES" Name="VLAN_interface_has_IP_addresses" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings IP addresses to a VLAN interface.

Note:

To get a list of all IP addresses assigned to a interface, you must look also to the relationship "Interface_has_IP_addresses" !]]><point x="441" y="771" OID="1" SinkObjectOID="57" SinkOID="8" />

<point x="441" y="854" OID="2" SinkObjectOID="89" SinkOID="6" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="102" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Ports_belong_to_VLANs" FontItalic="0" Parent="VLANs" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="PORTS_BELONG_TO_VLANS" Name="Ports_belong_to_VLANs" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship (M:N) assigns

- one VLAN to several ports on a switch

- one port to several VLANs.]]><point x="262" y="1041" OID="1" SinkObjectOID="156" SinkOID="1" />

<point x="432" y="1038" OID="2" SinkObjectOID="87" SinkOID="8" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="5" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="111" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Payments" FontItalic="0" Parent="Payments_Assignments" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="MEMBER_HAS_PAYMENTS" Name="Member_has_Payments" BeginTruncate="1" BeginArrowFlags="4" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship captures the Payments assigned to a Member.

There are cases when one Member pays for several Members by single bank transfer.]]><point x="658" y="467" OID="1" SinkObjectOID="108" SinkOID="15" />

<point x="654" y="389" OID="2" SinkObjectOID="147" SinkOID="2" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="130" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Credit_mods" FontItalic="0" Parent="Members" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="MEMBERS_CREDIT_HAS_MODIFICATIONS" Name="Members_credit_has_Modifications" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship captures the Credit Modifications made in the Member's account.

Of course, one Modification can be made to only one Member.]]><point x="392" y="197" OID="1" SinkObjectOID="122" SinkOID="1" />

<point x="393" y="293" OID="2" SinkObjectOID="1" SinkOID="23" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="141" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Credit_mods" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="USER_ADMIN_MADE_CREDIT_MODIFICATIONS" Name="User_Admin_made_Credit_modifications" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship captures the Credit Modifications made by an Administrator.

One Modification can be made by only one Administrator. If another Administrator modifies the same user's credit subsequently, a new record in the Credit Modification table is created.]]><point x="356" y="207" OID="1" SinkObjectOID="122" SinkOID="9" />

<point x="289" y="298" OID="2" SinkObjectOID="20" SinkOID="20" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="142" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Access_mods" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="USER_ADMIN_MADE_ACCESS_MODIFICATIONS" Name="User_Admin_made_Access_modifications" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings access modifications to a user (administrator)]]><point x="99" y="420" OID="1" SinkObjectOID="131" SinkOID="10" />

<point x="184" y="348" OID="2" SinkObjectOID="20" SinkOID="21" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="143" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Access_mods" FontItalic="0" Parent="Devices" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="DEVICE_HAS_ACCESS_MODIFICATION" Name="Device_has_Access_modification" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assigns access modifications to a device]]><point x="79" y="533" OID="1" SinkObjectOID="131" SinkOID="9" />

<point x="78" y="680" OID="2" SinkObjectOID="46" SinkOID="13" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="151" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Payments_Assignments" FontItalic="0" Parent="Members" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="MEMBER_HAS_ASSIGNED_PAYMENTS" Name="Member_has_Assigned_Payments" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relationship assings assigned payments to a member]]><point x="596" y="317" OID="1" SinkObjectOID="147" SinkOID="1" />

<point x="488" y="315" OID="2" SinkObjectOID="1" SinkOID="24" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYReference TextField="0" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="4" EndArrowType="3" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="154" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" ScriptCreateSQLDropManual="0" Child="Payments" FontItalic="0" Parent="Users" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Code="USER_MADE_PAYMENT" Name="User_made_Payment" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" ><![CDATA[This relation assigns a Payment to a User, who made the bank transfer.

Warning: the payment must be assigned to a Member in order to increase his credit!

This relation is reallly just a hint information, we could live without it.]]><point x="629" y="651" OID="1" SinkObjectOID="108" SinkOID="14" />

<point x="280" y="610" OID="2" SinkObjectOID="20" SinkOID="22" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<MYTable width="142" x="194" TextField="2" Align="68" y="997" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" FontUnderline="0" FillColor="#00ff00" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="156" ScriptCreateSQLDrop="0" height="90" DefaultsLoaded="1" FontBold="0" ScriptCreateSQLDropManual="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Code="PORTS_BELONG_TO_VLANS" Name="Ports_belong_to_VLANs" NextOID="6" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" >

<sink x="0.48" y="0.48" OID="1" />

<sink x="0.48" y="0.48" OID="2" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="3" Name="ID_ports" />

<MYColumn ScriptCreateSQLCreateManual="0" DataType="INTEGER" OID="4" Name="ID_VLANs" />

<MYColumn PrimaryKey="1" ScriptCreateSQLCreateManual="0" AutoInc="1" DataType="INTEGER" OID="5" Name="ID" />

</MYTable>

<MYReference TextField="3" Align="68" LineColor="#0000ff" ScriptCreateSQLCreateManual="0" FillStyle="Solid" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="2" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="157" ScriptCreateSQLDrop="0" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" ScriptCreateSQLDropManual="0" Child="Ports_belong_to_VLANs" FontItalic="0" Parent="Ports" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" BeginTruncate="1" BeginArrowFlags="0" NextOID="4" ScriptCreateSQLCreate="1" FontFamily="MS Shell Dlg" >

<point x="262" y="1041" OID="1" SinkObjectOID="156" SinkOID="2" />

<point x="101" y="1007" OID="2" SinkObjectOID="75" SinkOID="8" />

<TextHandle x="0.45" y="0.5" OID="3" />

</MYReference>

<Validation>

<Rule Name="Model name missing" Value="Error" />

<Rule Name="Model comment missing" Value="Warning" />

<Rule Name="Model description missing" Value="Information" />

<Rule Name="Model database type missing" Value="Error" />

<Rule Name="Model database name missing" Value="Warning" />

<Rule Name="Model target missing" Value="Warning" />

<Rule Name="Model author missing" Value="Warning" />

<Rule Name="Reference name missing" Value="Warning" />

<Rule Name="Reference code missing" Value="Warning" />

<Rule Name="Reference comment missing" Value="Information" />

<Rule Name="Reference description missing" Value="Information" />

<Rule Name="Reference name duplicate" Value="Warning" />

<Rule Name="Reference code duplicate" Value="Warning" />

<Rule Name="Reference child table missing" Value="Error" />

<Rule Name="Reference parent table missing" Value="Error" />

<Rule Name="Rule name missing" Value="Warning" />

<Rule Name="Rule code missing" Value="Warning" />

<Rule Name="Rule comment missing" Value="Information" />

<Rule Name="Rule description missing" Value="Information" />

<Rule Name="Rule name duplicate" Value="Warning" />

<Rule Name="Rule code duplicate" Value="Warning" />

<Rule Name="Rule not used" Value="Warning" />

<Rule Name="Domain name missing" Value="Error" />

<Rule Name="Domain code missing" Value="Warning" />

<Rule Name="Domain comment missing" Value="Warning" />

<Rule Name="Domain description missing" Value="Information" />

<Rule Name="Domain name duplicate" Value="Error" />

<Rule Name="Domain code duplicate" Value="Error" />

<Rule Name="Domain type missing" Value="Error" />

<Rule Name="Domain type unknown" Value="Error" />

<Rule Name="Domain not used" Value="Warning" />

<Rule Name="Table name missing" Value="Error" />

<Rule Name="Table code missing" Value="Warning" />

<Rule Name="Table comment missing" Value="Warning" />

<Rule Name="Table description missing" Value="Information" />

<Rule Name="Table name duplicate" Value="Error" />

<Rule Name="Table code duplicate" Value="Error" />

<Rule Name="Table index missing" Value="Warning" />

<Rule Name="Table column not really a foreign key" Value="Warning" />

<Rule Name="Table primary key missing" Value="Warning" />

<Rule Name="Column name missing" Value="Error" />

<Rule Name="Column code missing" Value="Warning" />

<Rule Name="Column comment missing" Value="Warning" />

<Rule Name="Column description missing" Value="Information" />

<Rule Name="Column name duplicate" Value="Error" />

<Rule Name="Column code duplicate" Value="Error" />

<Rule Name="Column is primary key but not mandatory" Value="Error" />

<Rule Name="Column data type missing" Value="Error" />

<Rule Name="Column too large for data type" Value="Warning" />

<Rule Name="Column scale too large for data type" Value="Warning" />

<Rule Name="Column scale too small for data type" Value="Warning" />

<Rule Name="Column mandatory flag invalid for data type" Value="Warning" />

<Rule Name="Column data type unknown" Value="Error" />

<Rule Name="Column data type invalid for auto-inc. Try INTEGER." Value="Error" />

<Rule Name="Key name missing" Value="Error" />

<Rule Name="Key code missing" Value="Warning" />

<Rule Name="Key comment missing" Value="Warning" />

<Rule Name="Key description missing" Value="Information" />

<Rule Name="Key name duplicate" Value="Error" />

<Rule Name="Key code duplicate" Value="Error" />

<Rule Name="Key column missing" Value="Error" />

<Rule Name="Index name missing" Value="Error" />

<Rule Name="Index code missing" Value="Warning" />

<Rule Name="Index comment missing" Value="Warning" />

<Rule Name="Index description missing" Value="Information" />

<Rule Name="Index name duplicate" Value="Error" />

<Rule Name="Index code duplicate" Value="Error" />

<Rule Name="Index column missing" Value="Error" />

<Rule Name="Index Column name missing" Value="Error" />

<Rule Name="Index Column not in table" Value="Error" />

<Rule Name="Reference Expression child column missing" Value="Error" />

<Rule Name="Reference Expression parent column missing" Value="Error" />

</Validation>

<Grammar>

<PMDataType DescriptionSize="4096" Description="789ced903f4fc33010c523c1c4c447b80981441b5aa90241b044b70e940e5d18dde49a58d8e7e03fb4e92767c46ed4a1881d55f26fb064ddbb77efae98b2e56cfe3e9b2f8b7cca8a057b812f341d58c5a504410e6b344358360856d48415184e3582b030188d1fc069188def7b81a7df92bb581f4f264328a68ce2049851254aeed0820b2d8a6f85f20a2a615bc9c358b1c3deec5091587379548fc6d1b3c8172cdb682f2b2863d8b536f0fa380783923ba1c936a2bd859577507a63909cec6013d64004d241c5ada67d93e21f82ea9027bc16943608a556adc46d98d1b28b225fe9aa6345de382559a650add058b87ed6610503dad49cc4ae9f79039caab89ac5e342c848e19ea5f4555c8e3af076efd2369d0d1791d0866f7418c2dbde17b73c8600bd0e796970d00d7a1df431e231ae3ebd764f1cd65c09d9f5bf3f9327128944e2f439ffceb2cbececbf63241289442291383d7e00f553aaf7" Name="TINYINT" Syntax="TINYINT(n)" />

<PMDataType DescriptionSize="4096" Description="789ced90314fc330108523c1c4c44fb809b5126d68a50a04c143b60c1424b230ba899b58d8e7603b6add5fce889da843113baae46fb064ddbb77ef2ecb495e94599a93ec8dbc3b54e8246c9586b2587f14eb72b29866e91b495a068637c86ad0141b06dcc06cb17c00ab60b1bc9f43e9053dfe96dc85fa72b59a4396130c53a0c09a57d43203d6b748bae7b2975073d309eafc8c031bcd8e15c11a2a4eeac138780eb976aa173554548821f5cbe31a3413d47285a6e5dd2d6c7a0b55af35432b1cecfc1a8c012aafa246e1d024e927c7c6e7f1af01a934834ac94eb0bd9fd191ab2cdda8da912c6dad1424914c6e98363079567e050d4a3714f9619c39058a7558cdb0d382cf88c0b1127d1d964307bd195cbad6197f11019dff068739bc0ebe6c4f4308505b9f176747dd6cd4c118231ce3e6ab57f689c2964a2edcf8fb337924128944ce9fcbef24b94e2efe3b46241289442291f3e3070234a9c5" Name="BIT" Syntax="BIT" />

<PMDataType DescriptionSize="4096" Description="789ced90b14ec330108623c1c4c423dc84a8445b5aa90241f090ad12b495e8c2e826d7c4c23e073b569b3e392376a20e45eca892bfc19275e7ffbe739ab16cb97c4dc7194b57ecbd254dad82ad36b09e2f3ee68bf5ed64908e572c41b0a2242cc0702a118485e164fa088d86c9f46104eb0ac1d1ef96fb509fce66234833466108cca910396fd042e39f28be17ca292884ad256ffd8c03f661c78ac492cb937a080e999dd64e3b5940cea5eca4df9e166050f24668b295a8ef60e31ac89d31488d6c61e7d74004d2be8b5b4ddd23c53f0595dec79f16943608b956b5c4bd9f51b3ab74bcd145cbd271d528c912856a83c6c2ed8bf62b18d0a6e4240efdcc01702ac26a164f0bde9140502e5d1196a3169ced52eaaab5fe4724d4fe1a1246b0ec7271cf8304e8adf7a5e1b16fd8f741af113ee3e6cbe9e699c3962b21dbfef6a77924128944ce9fcbef24b94e2efe5b231289442291c8f9f10356aca9aa" Name="BOOL" Syntax="BOOL" />

<PMDataType DescriptionSize="4096" Description="789ced90cd4a033114850774e5ca47b82b51b033d232ade818687785560bf605d299db99607ec6fc60a74feed2a4431715f752c8b70809f7e4dc736f3123efcbe962317f5d17d98c142b32052328e7c0a4c51a750aeb06c1b05a62059aca1a8119188c8693f1235805e132e9454efe963d04c538cf47790ac58cc8d002e6b26225b568c0fa4f82ee9870022a665a4e3bdf698fbdddb1c2b1a6fca41eac87799e16d98a248e575086c05ba561f9f40a1a39b54c49d3b0f61e36ce42e9b4466979075f7e144490caaba851f2f049d00f266b9fc69f0684d208a5122dc79defd092ab22dba8aa2345d658c14922506c501bb87d517e000d4ad754b27ddff30ea8acc260064f0b3ea3f43b2db9abc268b203670e2e6dd319bf0f0ead7f068714de0ebeb8a32104a8adcf2b0747dda0d7411f23ace2e6d329fb4c614b05e35dfffa337924128944ce9fcbef24b94e2efe3b46241289442291f3e3078d8fa9aa" Name="SMALLINT" Syntax="SMALLINT(n)" />

<PMDataType DescriptionSize="4096" Description="789ced90cb4ec330104523c18a159f302b0412491fa84d042112152cba68e9023ec04da689851fc10fd1f4cb596237eaa2883daae4b3b03c9aeb3b779ccf8ac5cbf3fc7d315fbee5835991af8a27e05851cb634d77085418ac5125f0d620685a0bac401151bb8e8638bbcbb2e9300323a1bfa6bdd08adfd2a1d78ca6699a8e479304f25921fc3c988b8a96c4a006e3de71b2a5dc72a8a86e19e9c047e81d0f1d863561477def3e9e4c927cb02aa2fb252864c450297443db5b585b03a5550a85611d7cb91d104148a7225a0ad848e5ac3fa8a8dd7c776ae052219492b70cb7ceb32d2ef2c15a565d910f1ac3591171e46b541aae1fa58bac40aa9a08baeb67de0011955f45e371034a22dc6796cc567e19d181d57b97b6e9b4fb0106ad2bbd4302af7b5fdc121f02e4c6e515f14117f73ae863f8e5af3ead340f04368453d6f5d59fc90381402070fa9c7f47d16574f6df310281402010089c1e3fd5fea8e7" Name="MEDIUMINT" Syntax="MEDIUMINT(n)" />

<PMDataType DescriptionSize="4096" Description="789ced90cd4ec330108423c189138fb027041249a0a47f2244a2b75ea087be809b6c130b7b1d6c47347d728ed844452ae28e2af93b445aed787626f9a258beacf37451e4abe2194869c9446cf81e8193c51a7502eb06c1f09ab002cda8761b03f1e83e9b66b387493603abe0679a0ef28e7e3fb8f3b26c34cfe693e9683e4e205f14e4efc2922a5e328b06ac7b29d98ecb4e42c54d2b580f3ecae079d808ac9938da7bffd1789ce4e9aa8840a360962b320d6f6f61d359283bad91ace8e1c3354174359d8a1945b055da19bf71aadd75f73520954628956c05ee9c635b5ce4e946557d91a78d95a28824ca0d6a03d74fca05d6a074cd88ef879b37c0a8f2450c1e2fa064e47e6929baca57a11e3af3edd236bd71fd05b46ef40e09bc7efbe28ef910a0b62e2fc5075d3ce86088e1ab5fbd77ca3e32d832c9453f4c7f260f040281c0e973fe194597d1d97fc7080402814020707a7c0102f7a847" Name="INT" Syntax="INT(n)" />

<PMDataType DescriptionSize="4096" Description="789ced8f414b0331108517f4e4c99ff04ea2607741e8c9358742915eb448ff40ba3bed0693c99aec62d35feed16c17c18247a114f21102c33cdebc57cec4e265357f9ebf95c54c944bb16a94477c123eb0e560b0b10e5193a39c091e545870ad2ad99147d7108cdc29d31bd4cab75a0678b5a71cab5f1b4d5ba98ff6c38587e9342f8ba5c8fed70d8eb4ec9465dfa8f61eebbe43d53b47dce9804f822702dba892def2a19c91ef8ab7f17afc3d8c7584ca9a56d32e3ab6e2aa2cd6b60ea22c9ace689119326b721eb74f360676b06e2b59edc79b77905c0f453c1d2f504986e24af7f55085037a7f70699be0637f8d368e83438ed7832fede410027613f3f2e44737197518630cd56f3e7adb3d4a6ca4513a8cd39fc91389442271fe5c7e65d9757671ea18894422914824ce8f6f6b73ad2b" Name="INTEGER" Syntax="INTEGER(n)" />

<PMDataType DescriptionSize="4096" Description="789ced90bf4ec330108723c1c4c423dc846068923649938a10892ca80b74e80bb8c935b5f09f6027a2e993336237ea50604795fc0d96ec3bfffc9df3b228972fcbd7751e9445be2a9e8111d52050d16183ca87f50e41d346600d8a085bd13059cc665194cec2689e25719a2659984127e1f7713a06f4e2674468fba7591ccfd3380ed3280d1749329d4f131ff2b210d60696a2a615e95043673238d953de73a8a96e19198cd401c7f453856143d859ddbe344b123f0f5685d7b1013ecd3088202428245a0ad84a65eebf53d19847ccaa814b855049de32dc9b8b6d7193071b590f451eec3ace0a8f23dfa0d270ff248d9702a91a22e88174540afd0044d4d657e379012a22ccaf56acafadb118a0d7c794763768332683d66c6d820f6fc75cdc132b01726b7cc5e4d43719fb60d4b013de7df4b27b24b0259cb261dcfd69ee70381c8ecbe7facbf36ebdabffd670381c0e87c371797c03f176a2ed" Name="BIGINT" Syntax="BIGINT(n)" />

<PMDataType DescriptionSize="4096" Description="789ced90df4ac33014c60bfa003ec277250edb6eeb9f39b116369c329039703e40b6a6339026a54937f5c9bd341dcadc50bc94417e77c9f9ce77be7392617a7bff30989d95ada43d4c93693a40ce25d14c2cbd5232a121ea624e2b1f6545174c3129b02002738a53aeafae8308b9ac40a04c07a7de56f5a30d88c84caf5e532a10c49b671c7e5a64b29eff6de127ed699a7ce516aeda265705e11c67fb515abfad34e05cae89998915e1355520158517fa5127e80761d4eb8dcec33eb484d7f5bb17717419857177e4857d171d77937defbfd1eeb5fb18e7789a3c8eef26a31b3005559a5839a3990b419726d66a677cc6146962d1cc87d95234cb612c32b620da48f43345415e5851178db4e4e4d59cfe8dfa987dab7063cc77eacde4208e37c7732c168bc572b01cbf3bce8973f4df312c168bc562b11c1e1f6b8aa2f2" Name="FLOAT" Syntax="FLOAT(n,s)" />

<PMDataType DescriptionSize="4096" Description="789ced91cf4ec24010879be803f80873321269e91f4a4bac4d68404342804448b82e744b37d9ee36dd2da84feed12da81113ce6ab2df650f33d3f9e6d7288987b3653219459d248ee6f10018af0a444d415e31dca4bc5e536c9615de1041386b41463992846dcd92132681d5c51a57160c28e57ba47a6187688d05a00a83e958413fe8f53dc7eb863dd773fc6074ebd921480ea66bb9ae6f075ee887ea716da73b3255ad0d761b104be14cbd993df3590bc6192ca74fe3c7e9680844802895764670da0686b74a7b77a29712811a6d9c5ab0c83144495c363134a3323fd44b8a5e604f52991f9c5487f8de71bc1e7806a9daa46213161ce3544332e7b5548bb675819914c02b7898cc068b9b550bf6395602ae0fd754deddc3eae3f53d10522d1290a96e043fe33f97bef26207af314bc906497cd42bd03329eae2eb90e69f1e4ffdac50150b3da937a7b9be6f459d796c68341a8de6cf71f9661857c6c56f6b68341a8d46a3f97fbc03e290aa7c" Name="DOUBLE" Syntax="DOUBLE(n,s)" />

<PMDataType DescriptionSize="4096" Description="789ced91c14ec240108649f4017c8439198db494964289b50948354d08108184eb42b77493ed6ec36e417c728f6e291a49e4ac26fb5de630333bffffafdf0f06e3797f18c2e4257c8ca6d178e437fa813f09a67bc6d93e83846fa01a31fdc624a8518e24616b23e784496045b6c41b137a94f21d5a520c5b440b2c006d30184db3d3edb4bb4ed369796ddb69ba9df0ceb13c901c0cdbb46dd7ea389eeba9625bcd5668a85e1dac3a2016c3997eb97be65913a204e6a369f43c0a074004881caf4842705c0786d74af6f6445e4c042a65e3d884598ac1ef077969be5c95e9a19f53b4871d89657ad0a426c4f789ca3df004627529435498c7acd4924c7921d5a17591612605a81c9f86e3deec66710bbb142b01b60bd754de3fc0e2585d07845487c4217504312f54a446be51af0bc219243fa7af74b183ae88c5648524aee465e8956445f6654490375c59fdec50150b3de997d66cd7adfe5aa3d168347f8ecbf75aedaa76f1db32341a8d46a3d1fc3f3e007fd4a871" Name="DOUBLE PRECISION" Syntax="DOUBLE PRECISION(n,s)" />

<PMDataType DescriptionSize="4096" Description="789ced91d16ac23014860bdb03ec11ced5d898adda5a5b595750ec86202a53c1db68531b489362529d7bf25d2ead6e28cceb6d90ef2681ff9c9cfffc097ae16bd41d06f55e184cc2e99e71b6cf20e11be88fe7bd616405f549689cde294792b0b59973c224b0225be28d055d4af90e2d29862da20516803618cca6e575bc76c7693a2dbf6d3b4dd78b1e9c860f9283695bb6ed363cc7777d75d88d662b32955683460d108be1825ef65e78d6824102f3d174f0328afa4004881caf4842705c0386d7caf6f6cc5e4c042a6de3d882598a21e885791944d92ad34acf29dac38ec432ad3ca90a715a71d81e7802b19a94212aac636eaa49a6bc906ad0bac830930254a6cfc3717776b7b8875d8a9501db855b2a1f9f60713c5d0784548344f50308625ea848cd7ca35e178433487e4e5ff96295af018bc90a497cb097a1379215d9f72282bce3c3aa5f0a55b1d033bd5ccd76ddc35f6b341a8de6cf71fd611837c6d56fdbd068341a8d46f3fff8048c51a7f0" Name="REAL" Syntax="REAL(n,s)" />

<PMDataType DescriptionSize="4096" Description="789ced52c96e134110b5041fc027d4cd204d269028176459b2630b2c39c110c2d9e5999a712bbd8c7a71085fce91ea1edb51c201890b42ea7719cb5df5fa2d3d9a8e67f3cbc5d564393a9d8e47abf14443d01d56775443230d7aa1db93ce08ed4107b5215bc294b6b8230752dc11205c7e9c7c81cac8a0f47b58af0fdbc3212842edc06f69bf0ac281f3c632353ade74de327b01c1f1078c26a8b668b1f23cda180b84d5166ad10a0fa6493c3b94814af8ca3f6baa844209bd36d475917634b5ac7977b8d215696f7d3204275a5d005a3e329e0507ed5988d0309a8ebbe81e5e6f8207c7f22951f1a2a3a8d9f2d7eea87e53c2a289e32e8df3c9dba297e4e05e48093117667fa68da99ae84a181dff43eb7b070abf0b151458d42d4587fb260e94a2cfcea1a298579434fb743b5dce0b8842e319b306e6ec19e20042cbe6f591aaef85af7a800dc76b34678e42b3f1cd4362a8b64654e9f6630c9ce5d164727c7b7db3f8703d9fa5fe3af6d608e2b88f51eff5c6686be1504a734ff56f591925bc8f7b3eb5d760903e657898ecfe34f98e475756c46a0c5c3ddc7c5ec237ae987385f3f2ecbc9f7fb461dba088f357c1f1baae64a8a94f3455ac89eaf8c8fba6d3f348d6fdf3c7553e722e742d2af4d4377328904d77921376e2073dad567244f2c979f4717671518e4e57e341464646c65fe0e5cfc1e0d5e0c5bf9691919191919191f1ffe11738a52e15" Name="DECIMAL" Syntax="DECIMAL(p,s)" />

<PMDataType DescriptionSize="4096" Description="789cedc8cb09c0201040414bb1026d6059f093434041480fb9a9e0cdee93368437c791a8f94ae2a34ad3678f3976b7ef5cf6dfbb86e2c437350000000000e0641fc7240ad8" Name="DEC" Syntax="DEC(p,s)" />

<PMDataType DescriptionSize="4096" Description="789ced53db8a1341100de807f809f5a6c238abbbec5b0898dd2003498cc6f86ca7a766a6a12f435fb28e5feea3d53dd9eced411044843e2f03a953a7ea9cea4ce7b3f56eb5f85c5d4dcfe6b3e966b61db4d18382c658b85e5c55abf7cb727ab699c1743eeb23072a5d0bce3c3af01d8262df850a0a6ae17ac90670e20796f0e55e4562cbe4833a0807e79797e5c45ba1db0282a30f188dc03b6619f768d37c64bca3c65678304d9a7660321ce56be44291706f84f6c0745da41e4dd3bc3820e8a0f6685d91fabebd7949935b5d00b354321eb809da630d42df397bb50f1e5ccf3826296a7469574b5f7bc0fa75095513e92ed1a9f2b61857727023a4848ec5c1e6d16e24d54457c2e8f81bb3fe614096e916a3c363deb792624cd83185c0dc78918fbbf97251405c34d6483590e6a810090c5a32af4f52dcc8a0348d1a604ff11aedbc654293f1fd90147867044fd34f3150962793c9f16ebdad3eac17d77123d793b74620c57d8afab86f8c96cecca43437583fc9ca28e17decf3e97a0d0bd2a70c6f99fdef98ef88bab1229ec6c06ad87e5ac2573a31e50a17e5f9c5c8bfb361dba090f257c151bbe632d438269a4eac116bcae178e9f43c9275fff871957fe3edc7ffd424232323e30ff0fce764f262f2ec5faf91919191919191f1ffe1179bba2c45" Name="NUMERIC" Syntax="NUMERIC(p,s)" />

<PMDataType DescriptionSize="4096" Description="789ced534d8bdb30100db43fa03f616e6e21f6e6833d2c844052871248b629bb5bd85b156bec0864c9e823dbf497f7b823d9c976e9a1d04b29f8613096466fde7b23cf96f37c71bf9a5d2de7b3dd7c019c39cce0fe80607dd368e3908361aa42101692f168344a47637a12701a921b423a9ea4d37192c1f674f765035cd846b29385400b47263d5a100a924742badda6799e40a94dcddc10f6de0193523f5938691f2899b5a252e773b410690a2d7dad2c782b540528dc010d5867e8cb8236a07cbd4763b3d9d56e3ea89813473caf0d818ae15b9a40201e0233b4a51d517a15cc91b4d972de8400e07dd0631b566050180edae8dbd0db1c917fc8605d86721bcb6967343c4b7d1252c28185c61a3816a266121a2d940b024bc30a27b40a6bccb836e19a7d17b5afbb7c7509f9eae37abbd85c52b351bb6535522e5152fef961b959b5c1853d62f5c4d93284020615995717aa36396a75823dd297a2d49850647c7f8a0cc5418b2276bfc4c014bf988c8e1f6eefd69f6e577950641bf2560ae44350d845dde90dd1d2f8e34091ff9695ae8573e15c68cbb1645eba98e1b9b2f953e5984a774684d1e8eeba7da51153ae30cd26d3b6fec586a97c8d947fed2d1d5785f41cdb44e3881522a71cba49c7eb11adb74d7f1960f6c2b9565c14f48bb493390fb0bbf344f1035f8f565244f2d57ef031b9be6eaf6a8f1e3d7afc05defe1c0cde0ddefc6b193d7af4e8d1a3478fff0fcf12c9284c" Name="DATE" Syntax="DATE" />

<PMDataType DescriptionSize="4096" Description="789cedcec16a83401006e03eca7fdb4b359ad04344840403297421452f3dae716316745776765b7cfbda42fa10653efecbcce19f298f557d684fedab3c959b63555eaa037a153494ed11cca471755367ac0ac6d914ed5d83e23c3b1f740fafeca0610822cfb22cc9f235c8b2e23702c141ec5749be4d7639b6bbe265bf46a4904bf3fe86ded03caa85f0f8009f6a8c9a602cc4c72a9132a96b9ccf859445d308dc9c9f5478461703d438ba2fc2e2e2cf21456406fb2858177f9d5737c6c91222193b409b70d71e14fc3a119c878d53a73da5e5e6523d31c618638c31c61863ffd237be3d547b" Name="DATETIME" Syntax="DATETIME" />

<PMDataType DescriptionSize="4096" Description="789ced534d6fd340108d043f809f309cd28ac424a5a2a5449152a52895ea2a90f4d0e3c61ec70bf66eb41f89fccf3932b3765d4a7b07248ff6e0f5ecbc99f7666672395d5fc757abf52c5e4ede5f4e27cbe90c9c2cd13a51ee2258e70846a82d82b4d01f7f3a1b0d47633a301a5d84d307a7c1ea123908a4024711150a0327a30f67115c2b88abd5d71b388d4620540ae42a249a01b479612f0a8f16844148a5dd15a2c294a1eec9e2783e5f2ce278b51ac09fb7fa3e006d1a1764da94c20d20c51daa54aa2d6805871ca9280393cba9628e4c657c0a4714564a6be9d5f100c62703380f501f07b0f10e4451e883854a7b6628e8dd563d544a3f1eab4f74e14b65c13312a00cb9ac3374b38ca77cb9416323f86274d98a31fe5d002ac8a0f346116f619b6038105490b366057d663c8ce321115d2c2ee2f8623eef93c25928f22094e3c272b1478a224842124df6f0c2e6da1794204de1dd889f3276dbeb8647047399656890d15a5f816aebf2ba454a3bb07eb7d3c661dab0da1341495253932356929187438507d03bc78e4428d82069440c2973297e607864d1502cb942d95431b5fd116c1cc1ec99d2ac16e164be606148b8449bd06ac64b85c33066611c7546df707dbbbafab6e656dc2de7b3f515d5844684b2369808c202e9185578a749689950ef2b2acd3d88f40c957f96da3acece4a3d22caba1ba9567d075bb90fd8a21e1cf6188b4516c13dbd614d446175c824db64893741fda74937553383cc3440dededddcd4b8f59ab6e32dccd6978c20a89189a321544427d7070a7a49cc76e73e13b06db7b13888aaeeb875da50dfea013fa5521cf951247904b7da7123693a5be42375dcee04ad9ec1278b77ce7da0ed635c83f51031731a8e6651284816a472d8a317515f886df68d95a02474be7b1b144565bd694ad40a83e8060b2936a449ea69b65962838163bd11e4c276f968385cb543fb76f27e39ed75d6d9bf61af7ff67a6f7aaffe76199d75d659679d75d6d9ff67bf00a8d6bf77" Name="TIMESTAMP" Syntax="TIMESTAMP(n)" />

<PMDataType DescriptionSize="4096" Description="789cedcc410ac2301005508ff277d968bb10414b2958102a5850ea05528d6d204d249328bdbd5510779e601eb3f91fe6e76571ded7bb3c2d8bfc586c11f4a0129c7b052f6da7a00962b15eaeb3d5663a81e0207e31413d36a703ae9aee468e84f7161ed24445d016a2aab2bace9a46e0e6fc20c31c6d0c90c6b8276174f1bd27897467bf5f53f119b93813074b88a46d07a543af3c28f829119c878d43ab3c25797a2c668c31c618638c31c618fbe705781a3eff" Name="TIME" Syntax="TIME" />

<PMDataType DescriptionSize="4096" Description="789ced54db6e1a410c456a3fa09fe03e2551c30628499b94221141954821a209a994c761d70bd3cecea0b980f6cffb587b7621bde4bdadb4160f048f8f8f8f7d32b81c3e4e46778393cbe160361c4189c282d4d06b83b1d06f6772293de4c616c2c36186b908ca8374bbd451029faae447185c0e350325305f2108a5cc562c14c246a8800e8445e89e77bae00df4baa7a7c7d0a1e0669e9eef5a450255bf63103aa392779d76af73760e3287d204080e6345ef3772f4ecec9cf84ccbfbcf379049b756a274c0e3ed2850af478a3dfe22f88aa78bc8444c3827977af79e7e88e5a951a1d08e5a4bbd0494d4de82f396fe72ac930ec502ad4be090278f25be5c23eb14b4d808a9a2106b2be931815614bf5089341ade26bd5e723438990d5b9811831a19b6d4274e5a4f78c0dcdbd3697b3c86abab8be9f4623c3e48e0ba92652bb467ec95d8b03ed49a90444d2dbe702b131435c83278d3e1a78ced6581ce8b625d0f99c058e6395a64b47d4ea15efa55b5436d3cb8b05e1beb31a3f55b53c0a61ea59f74926eef3822b7db1ab760d69e13a9d0b040de5dc69d0bf1ad5aa2434bb5948ab4455cd11358378111ccafa793fbf9683aab1946551de641b1306031353663bd182f131ee3d9307730397d87ebdbfbc9dd9cf7f4301b8fe613e28456445a0b4c05df938c372d823724b44ce9264aa2e67722fd81ca3f16c679eece4a3d21d6479a197de0612937115b5407c519eb50e5093cd21bd64428676227b96f96061bd5ffb5e9a2ac6f93278d90b70f3737156e65b89dfd6849cb503082a045a69e2e54d3382bb3a5a2e7c4acad82d90702767bbbaa2ddb8737eebcb1b4b7eafafb44c5531e45ba4ae0d6785e245de71ef9501fed0db325a3fcc48c9abde73d74fb11d76275443c391d47ed222a926416134df62cea33b5b51959096a429fafc1454551bb606b8a466314dda29264c812b240b7cd125b8c33568e885edd998fffd99095ddebe8cf269af837e2e5f756eb55ebc5dfa6d144134d34d144134dfc7ff1034f41c280" Name="YEAR" Syntax="YEAR(n)" />

<PMDataType DescriptionSize="4096" Description="789ced53d16edb300cdca7f0ad0990a45d8a3e74080238c5801548d32ecd06ec9191e958a82c79929cd47f3fd27212ec1f7c6fb2c8d31d8f5eac964f3fb2ede276b55cbc2d3328f427e55343f6104b08d16b7b805862041d00cd09db005e1fca38ad31cf29879396ba1a1505888e4b894fa474a1f9b2a739956499cb79ca67b0e30a8ff640e00a7811da3b699c3f3c802ad1a38ae4038cbe9e3fd65e3b2f8797f6fde71a7ef3ad7616ee67f3fb31b379d44634f612d0333b55ee28d2e459117444d390bce4890dd1516488e974919a82f3917bd0e6a05c55f3a71cb4058581a6da06b241477d24283094f23e2ae57cde4d27b9cea9c0c6c4ab090814a1b18642e80a56cf9b6cfb073ea83d71a7c83930a19dc126db3dbf6eb275d23462b73a06a0bf8d667d64238492c541e17c35818d148da55b387922d3c747e05844064bd096525c98d894334d6585a131393481fed32a25d9d3eefb56b44a344cdb339f4b7806dde0fb89c916243da58c8a355d49667d44688c3b05685d23a294278cc45dbd144e3db635756da3bbf1f5d50ab535ad682c1a93c2138a1279eaccb3a72e18a3912792b6ce55bc446c0b6bfeac30722e21b9cfa92696e752fef4a94324abba95bb08d937b12f76601d4f4cc586a5b7972975db71d5872638e050d88cd5cc7551684916e74cdb513a71a2904ff84130ef17ed1b6467db93cb4f254fa7e09824c0e675079b5febf5843d1a034ea9a66e139fe36cf73aa61d3d737737d707a41538949b9bd9e2f66df965c0800103060c183060c08001032ef807d2de52b6" Name="CHAR" Syntax="CHAR(n)" />

<PMDataType DescriptionSize="4096" Description="789ced545d681c55148e448ca80f62b5964ae1146a934077b209094de3666192465dd86c369b4d210f626f66eeec5c3373eff6feec326f3e8882f441ad7f9007c16a4b501f448c68158ae8538b8210b404a42858504404abf1a578eeecda44c8bb0a739887b9f7dcfb9def7ee7a730553ce1d6a61f756b85a1a962a15a74a1452423cb11cd45943774084a4bc61b0e5484a613a0256111ae4135894715104941d258b4a80fed9072d0214588c850600aef0a898e011de2c2674140a582408a383db6305fce1d3b8648d46301f38866820f3a50479724bc414104306b61f2a0058c8c8d811712493c6d510686ffde6c4a26a45dcc26880827d08b4030eae49d1184ebbeaf43aa435809a99116e13e78226e12cb9171f088a239c615e58a69d6a21010155a28c323aa54ca79aa54716b4bb04293b690be25d7c0937c3b0cee10502146082d7e80d4ecbe3b5d9fa9d9434ba5ca234e61a85aece93ffdd9639fdc5b995c1f33f1d90bbf5edfb8e3fdb177c223fbcf7cbae7d97b921f2fbf77ded977f6f9fe17d6bf58fcf87874e7ca8db7f3d239f8e1976b875fbe56bbf1dbdaf4a1b73e7ae9c2ed578ebe3bd43a7960aefcf9d36f7ef0caa0d93cb5f1cce1f1abd56f4e6f5c36f36169efb5f2e6fcc4a9d79f9bdb72f3bfdcfff3037e63f3cca5b907e7ce5f7df5d0c51f4cdfeae33f5d7f6a727f6f65ed1cdff3daf7d11f13e70e4caaf6d1affbdeb86ffcc5d5d52bdffd1eff492f3e794bef6d77edcb9fb43fce56df57dfd6d6a9efc0c3369bad1d9a0f8f1c4995cae5386d8368daaca2b41c962918854a63a662b242d3438a4abc8bae90a0de44d9346c830d3be042bd343bb3507767ab98abc8c4dc2a8c388189527125f53011b6222d9e4f344df3aa599cd60fc62d5516666a75c0b38bd5e36e7d06395199161bc6f5086201d369de8c16313a3c12450952d396eaaea87633164adbe894eb1d882c804418f005efd76969586cd2ed08f44845a3c081253c6335219112692476339867a4b498ff0cba9ca03a8a35b87d690a59592c973bb89d96294c15b96d62acf086892d02c17ef3b402c1f139a168e3a5ddc4f4996a4624a1fe4308ac6ef649d42649b75d3a5d6c948d3d8a5434fa29f1c2ce5040d6446f230ff0c12eb8b21341ee6086c1c66d1e8647bb73a3d969447c39160737f1b2edec76c8225419b590bba3ee72b733a494550283e0f78451a9a2d8cb4676290a4e53d1258dec844bc03771339558d2f48da9feda0e3f68331c7db8c4e2d04993aa8369cb6696d97fc36eddeae9b9bba7f7dfa6915966996596596699fdffec2f6155e191" Name="VARCHAR" Syntax="VARCHAR(n)" />

<PMDataType DescriptionSize="4096" Description="789cedc8310ac2300005508ff2471d34582838840c050717c990a12e4208b109240dc4147b7c7b8c0eff8d4f0eca3c9e2f731f8d1483925a19bf36b892963ce3175b8045b66bcc4b46f2f3b445f9a0eb7b1cbbf70d675c4f70c156eb9aafdf8b145a1d888888888888886857fe829f1a5a" Name="TINYTEXT" Syntax="TINYTEXT" />

<PMDataType DescriptionSize="4096" Description="789ced545d681c55148e448c5405b1554b24700ab549a03bd98dd936ad9b854dbaeac26677b3d94453fce9cdcc9d9d6b66ee6cefbd93edbe89888af641ad7f988782b52d4145448c685b68459f2c0a42d012d0a260c12222588d2fc173efa64d84bcabb01ffbb073ce9def3bf73be74c6a385dc93e5449f50da753a574851e5260877e1470a833e50181801c624114804f791503a10bbb92c97b92d0d3ff686217c420d10bb64704b11515d24af595d26db7541f2ed6ce4d5e7ee3bdef9fdfb2bfebd926bc07579e3cdab95f4870451880f2288c8fe5637bf680ac519bb9cc268a85bcd7820aa604e155aad546814988830aa13f995c27053d89abc19a60a1d00fa30d648449cc22110c5871ab1fe92633e59107326598257e4425104141864251070877f0b6410d430e300e369134c6b8a45c32c56629b8447a9a2ae23e95d2d43c9c2b64ca5330431bf55038bab82a9ee46b321821203d54f034bf8ba5e97866a4922deb4353b9c2fd4d9fba0f7ff6c8992d85a18564141c3bf5db95c54d1f26dff576761ef974f373b7357e3effc1496bebb117bb5f5af872e2f43effa6999577e2c2daf6f157f33b5ebd545ef97d7e64fbdb9fbc72eac60bbbdfef9b3dd055cc7ffef4f18f5eeb8d960e2e3eb363f062e9dbc38be7a3312f77c7a5fcd2d8de836fbe505ccec47fbdf397bb9cead2912f8a77174f5e7c7dfbd99fa28eb9c72e5f796aa8b3bd307f826f3efaa3ffe7de135d43b2befb9b8eb76e1f7c796eeec20f7f047fd1b34f5cd77ec3cd5be307f41f6bb9e3ebefca0bd4b1e03eddcdd9759e27fa771aa762314eeb10d67457d15a0ed31422894e63a7023243cd214905be8b298fa0df44ea36ac91252cc84025379a1daf64464b5727131d461e37f28db982dad808c6ab86cf218a9abe2a1698f941dd5c613c5bae009e9d28edcb54b258131566d850d726c8054c99be452a0c306113df6f60694a97ba21ab0e06a1545a9d72b58e91b9d008237042deadcc68686ed21c3e9d1192faae055378467b427c191a25764dcc8e84d09cff149d6ea03b9255b9bea9a12c4ce4f34ddee6caa486d35cef314e78350a3403715d6a2b0921c7eb78611d5fdac84c87c99a4f1ad4b91789e5b53df1eba4b1ba2e2ad41b1249ad3d80a528cc53627b161442a51b49d41a730fef5d259750f7a85857198a0dea3e24060cafa0b5e622e2cd713878144cebcdae7bcc4797d10bb131eb06ef4a25b038a99d4011fc3d1e49e328ee7224564b0c3935a60bea33328d9e38515033160b6aee68fc5798a2cdcf1f3ee270a8468dca6d66655b68e1bf81eb97dbda6e6d6bffb7cb68a185165a68a18516fe7ff81b7a06e1b9" Name="TEXT" Syntax="TEXT" />

<PMDataType DescriptionSize="4096" Description="789cedc8310a83300005d01ee58fed6025a1364bc82075e8203844702a849056c128d8881edf1ea3c37fe3d3a5a9abc7b3ad6dd5599d974637c6863dc1cfe31a276c43eae110dd3ec435620cd3e717f31be2ae9492a2c059bee40d19c405be778bf3292cdfabce1b7322222222222222a2bf7000089f1c0d" Name="MEDIUMTEXT" Syntax="MEDIUMTEXT" />

<PMDataType DescriptionSize="4096" Description="789ced545d685c45148e448ca80f62fd2995c229d4a681e46e76dd3449dd2c6cd2b52eec5f371b310f6a27f7ceee1d73efcc767eb2bd6f3e8882f441ad7f9007c16a4b501fa418d12a14d1278b8210b404a42858504404abf1a578e6deb406c9bb0a7b58d8dd9939dff9e63bdf99dc74be5cab1e6e161f69e652d3f95c3ddfa4c735b8223021872ed33e1008c971169a1002cadbb8205a90cd4c66270f8c6726c7607fe6b1fb333002e921707d2289aba9540e5485a6a07da26181bac428fb8782a27289ca941b30ca3574a4d0024b01e11e54a2d26ca1029a2c0454814f14b8464a3c164448216021d3b672fa40053a5422c330349cb94433c1a143dc45aa2195a48314dd6188840197f0410d116e250c988a69747d614f11dea61633598f3ad4c9a5eaf93e45b9629a2d516811e55b78c39153923a5daa161af3b048a3ae901e60621b4f72071e2e34661e2a34ec0a01e50b8997c76bb58404bb5e9869161bf6d07ca97a38a93378e2d3473fbeb33ab53a66c253e77ebdb276cb7b63eff8c3bb4e7eb2e3d93ba21f2f9c3de3ec3cf5fce00bab5fcc7d7428b875f1eadba3d2d9f3c1972bfb5ebedcb8fadbcaccdeb73e7ce9dccd17c7df4d2d1ddd5d2b7ff6f49befbf3264d68fad3db36fe252fd9b136b17cc11bf74f7e5f2fa9183c75e7faeb65118fde59e9feff5daeb273fafdd573b73e9d5bde77f3003cb8fff74e5a9a95dfdd595d37cc76bdf077f1c3cbd7b4a75c7bf1e78e3ae891797972f7ef77bf8273dffe40dfd37ddb673f4a8fde16c0c7cf56d63957a0e3c284508d8546585ca3aa34e3a331c2b3532c2691744276e1036028d60bbe08116e8a8c5ad86c02d9fa0ded874c6b780a51d2840b35429ce360b95fa3557a2c288d332412caea42e3682f1768ce711b49dd55db330ee2dd62d55678b8d26e0d9b9faa142b3889ca84c7c73cd9be82ddb37a345881b2e09d0740a5d8354b745b58ba150da56b74efe1b91b562e379c21acf5ac36213582281a176472a1ab41c984fcc09245022aec4ae17dbb4fd3f8a2ee01428c5dadcde3486acce95cb09ae034dcccb4de7b99d6120b26d428b405a2dea6a0582e3757cd1c5a4edc4f498ea0424a2de0308ac12481423e89208bf2436490b897d33cad6ce22158dfb94b8fed631bf8ebc9f0f6d822b1c342ab730c36213b60fe96c8c2b6907c72471049a839b70015b8f490ca753a016727bd46d729596484e5925b0087e9e302a561467d9c84d8a82d35874490386ef44049e093bb1c492c6778cf54f9e90f8e9c3bff6d9c09741ed8947b617bdf86fc48d1b7d7db7f7f5ffdb347ad18b5ef4a217bde8c5ff2ffe025b25e27f" Name="LONGTEXT" Syntax="LONGTEXT" />

<PMDataType DescriptionSize="4096" Description="789cedc8b10a83301405d07eca1deba05241e81032bc4d10ebe0d2a5f008b6064c84a8b4fe7dfb191dee198f113b34dd5dda9b9852ace9adf8a8e9805be63d44bcfd364111f4e3c31e308ff1f58be589aaae71ae1e57e4b86470932675db98d6c294bd3d11111111111111d11ff902eba11af4" Name="TINYBLOB" Syntax="TINYBLOB" />

<PMDataType DescriptionSize="4096" Description="789ced545d685c45148e468ca80f6afd2991e229d4a481e46eb666d3503781dd34eac2ee66bbd90879503b7befecde31f7ce6ce727eb7df34114a40f6aaa16f2205a6d09ea8388f1a7164ad1278ba210b504a4a858b08808ada62fc533f7465b24ef2aec21ec6667e67ce7ccf77d67b2f9897c713a9f4de527b295893ce34446e08ac0841cda4cfb4020244fb0d0841050dec405d180d14ce6be0cecdcf5687a1486203d00ae4f24713595cac9a62a135d3f7ee0b516fbccdae1af4f1d3a317e6b125fde73e9daf3aff65ea032e5068c720d2d29b4c06240b807a5a830932b8126f5802af08902d74889c782089b0858c8b4ad9d1e2d418b4aec310c0d672ed14c706811779e6a4825e920457b102261c025bc5f43845b4651d03e53f841a1ed0b7b8af026b598c97ad4a249f78a72c5345ba0d020cab7f086634f496abe50ce55e7609e466d213dc0c4269ee40e3c9cab4e3e94abda1502ca1752fbf65a0d21c1aee7266b53557b68ae507e30a9d37ff093474edc5e1e5fc998f0c8f1df2eaedef85ee66d7fb077f1d496676f8b7e3efdee3167eb91e7fb5f58f97cf6e3bdc14df397df1a96cef60fbf58ee7be95cf5f285e5c91d6f7ef4e2f11bceec7e27b5b07fdb74f1d3a7df78ffe501b37660f599beb1b3956f0fae9e36fbfcc29de78a6bfbf61c78edb9e9f5dcf0af77fd72b7d75c5bfc6cfadee963670fef38f993e9597aecfcc5a7c67bbbcbcb47f996577e08fed87374dbb86aeffea6e7f53bc60e2d2d9df9fef7f0123df9e435ddd7dfbc7578bffdc759eff9eabbea0af51c78408a1016507a4bd48833eca4770dc64c0d0d71da06d18a054221a04ead0a1e68819e9aa7f1214525e6e2964f906f149df1abc0d20ee4a056284dcdd472a5ca5fbe448611a76182985c495d1482f1668ce7114d633b6916c6da62dd427966aa5a033c3b5bd99bab4d614f5426bea953975867a0b7ac6e468b10375c12a0e914ba065bdd14d52e8642695bdd3af90a226bc4c6f384359eb586c526b0400243ed8e543468383097981348a0445c89fd5d6cc3f6ff285ac729508a35b9bd690c599e2d16135c076a9897cd4f703bc74064d3841681341ad4d50a04c7ebf8a28d499b91e931d50a4844bdfb115825904846d026117e4914490b89ba19656b8f602b1af729717d07ca425b2189be82bc930f6c802b1c342aafea0c8b8d591dd22331aea42d1c93c411680e6ec23a4a8f490ca75320177273d44d729596d89cb24c6011fc7bdca898519c6523375a149cc6a44b1a307c2722f04cd88a299634be63cc7ff284c48f1ffeb4cf06be0c6a7b3cb29de8c47f23ae5befeabaa5abfbdf6ea3139de844273ad1894efcffe24fd2c0e546" Name="BLOB" Syntax="BLOB" />

<PMDataType DescriptionSize="4096" Description="789cedc8b10ac2301405503fe58e76d092a06609191e3a082d76711542a836d0a4105bd4bfd7cf70b8673c565c7b3a9eafad3417b1b538db3989d9970fc2342e29e315e7011ec9bf635a12c63e3f7e31dda10ec618adf658eb9bde610355210cbef830f7e5b9b575e75644444444444444f407be6e011ca7" Name="MEDIUMBLOB" Syntax="MEDIUMBLOB" />

<PMDataType DescriptionSize="4096" Description="789ced545d685c45148e448ca80f62fd2995c229d4a681e46e76dd3449dd2ceca6b12eec5f379b421ed44eee9ddd3be6de99edfc64bd6f3e8882f441ad7f9007c16a4b501f441ad12a94a24f16052168094851b0a0880856e34bf1ccbd690d927715f6b0b0bb3373bef3cd77be33b962be5cab1e2e966bc55caa98cfd5f345c6898cc0158109397499f68140489e64a10921a0bc8d0ba205d9cc6476f2c07866720cf6671e7b300323901e02d72792b89a4ae54055680ada271a16a84b8cb27f28282a97a84cb901a35c43470a2db01410ee41252acd162aa0c9424015f844816ba4c4634184140216326d2ba70f54a04325320c43c3994b34131c3ac45da41a52493a48d11d86481870091fd410e156c280a99846d717f614e16d6a3193f5a8439d5caa9eefe38a69b644a145946fc10d47464962b1542d34e66191465d213dc0b4369ee40e1c2d34a61f2934ec0a01e50b8957c74bb58404bb5e986ece34eca1f952f5705265f0c4a78f7e7277756a75cc84a7cefd7a75edb6b363effac3bb4e5ed8f1dc5dd18f17df3fe3ec3cf5c2e08bab5fcc7d7c28b87df1da3ba3d2d9f3e1972bfb5eb9d2b8f6dbcaf4deb73f7af9dcad97c6df4b2d1ddb5d2b7ff6cc5b1fbc3a64d68faf3dbb6fe272fd9b136b17cd11bf74ef95f2fa9183c7df78beb65118fde5be9feff7daeb273faf3d503b73f9b5bde77f3003cb8fff74f5e9a95dfdd595d37cc7ebdf077f1c3cbd7b4a75c7bf1e78f39e899796972f7df77bf8273dffd44dfdb7dcb173f498fde16c0c7cf56d63957a0e3c2c4508d8526585ca3aa34e3a331c2b3532c2691744276e0fb6016d607be08116e8a7c5ad76c02d9fa0ded872c6b780a51d2840b35499996d162af5eb9e448511a76582585c495d6c04e3ed18cf23683aabbb6661dc59ac5baacece349a8067e7ea870acd19e44465e29aebce4467d9be192d42dc7049809653e819a4ba2daa5d0c85d2b6baf5f1df88ac15dbce13d676d61a169bc012090cb53b52d1a0e5c07c624d208112712576a3d8a6e9ff517401674029d6e6f6a6316475ae5c4e701d68625eae98e7768681c8b6092d0269b5a8ab15088ed7f1451793b613d363aa1390887a0f21b04a20518ca04b22fc92d8242d24f6cd285b3b8b5434ee53e2fa5b87fc06f27e3eb409ae70cca8dcc20c8b4dd83ea4b331aea41d1c93c411680e6ec2056c3d26319c4d815ac8ed51b7c9555a22396595c022f879c2a85851ca95919b1405a7b1e892060c5f89083c13766289258def18eb9f3c20f1c3877feda381ef82da138f6c2f7af1df889b37fafaeeecebffb769f4a217bde8452f7ad18bff5ffc05a6dbe241" Name="LONGBLOB" Syntax="LONGBLOB" />

<PMDataType DescriptionSize="4096" Description="789cedcd410ac2301005508ff20f2076217555022db854baf100b14e6da499409316bdbd290a1ec0ed7f8bd9ccccff55638ee7cba92a1a53b5a65688ce5e269b5cd01d6ac43439bd235c1fd225a4c126745631d84510747ce52158ec38cb16dd10a228fa29f87c29185d4c08fd671d739a62edfa055878fb747ef6ebd5a12cf7256ef9c769aefa3e55456b3644444444444444f49737a1263761" Name="ENUM" Syntax="ENUM" />

<PMDataType DescriptionSize="4096" Description="789ced545d681c55148e448ca80f62b5964ae1146a63219d2492b6a16e163669d48564b3dd6c843c88bd3b7376679ab9f76eefbd93757cf24114a40f6afd833c08565b82fa206244ab508a3e591484a0252045c1822222588d2fc57366428d907715f6b030b3f79ef39d33dff9ce298c176727eb85c1f162a15a2c8145e7013d9c89540b74e338fa0e5c281cf842412816119e40a3411b90da202c8a38413b0028fc1074133a61442f32b10e1a087ea82d2a681a2d0904218ee89cbcf2284e44b9ff461620c5e3914c24fb1c1c0189b281c67a85c16ab187826594450f1f9c86361af0b594898a7ce122ada02dfc057430084e346204a33b0390ea84d1fb1da4749558a42a229b95d209357b09d542c6cccfd336e6c9948d5c441535850d193c5131da3c70bc5c29d5e66101d38e360150588b3c95078f946a130f976a7c22c086da106d2a802651c5e7a589fa648d9de6cb9587f22cfd273f7df4933b2b632b071279fadcaf57576f79ffc03be1c0ce5317b63d7b47fae3c5f7ce7a3b4e3fdfffc2ca17731f1f896f5db8f6f690f1767ff8e5f2de97afd4aefdb63cb1e7ad8f5e3a77f3a543ef0e2e1edb3533f5d9d36f7ef0cabe64edc4ea337b472f57bf39b97a31391a96b75f995a3b7af8c4ebcfcdac97867eb9fbe77b82d6daa9cf67ee9d397bf9d53de77f48fa961efbe9ea53633b7b2bcb67d4b6d7be8fff387c66d798ed1cfabaef8dbb465f5c5abaf4ddeff24f3cffe40dbd37ddb663e818bf78eb7d5f7d5b5bc1c08307b9bb8bd427266ac41bf286ef1fc898dabf5f6107743b6b0f379914413d08c0696af402664e160dc5d255ae000b91da0436cc1aa997a72767eba5e92a753c4ea4628609a799c419b9067d6a04cb95f102e10886787791cc3a4b79cb95d9c95a9d353b573d52aa4f524d6872d534d017ac0b5216f72d715ad2852fe238e559e052b744e543a949cd941d95db84183533d9059a65c7d2606c914b9e6f8cc5b8e9c17c2e4d10b1d559a6e87a323f318631ff99b491123b366a29fed20cb232373595e37a50a7b8c27851f1208330ad4432826836697e2d68459f13ea0e056d456610d9762c520c1e2060bb319d545947a4f4a029b78e663d20d239f70895e2e89e47de838a76982f88ebc8f7a97d1be096c60ccda6ca28d928f7617824c335d8a631c91541e2504936efbc446836357161b646dd2236df589699a024f43bce3b88ee50d9c46c94a81566a41b8c23da122904896c67141bccbe31e33f5f209dc885fc979706ed05bb3b1bd9ae75edbf6137aef7f4dcded3fb6f97d1b5ae75ad6b5deb5ad7fe7ff617a1d7e255" Name="SET" Syntax="SET" />

</Grammar>

<MYDomain ScriptCreateSQLCreateManual="0" OID="103" ScriptCreateSQLDrop="0" ScriptCreateSQLDropManual="0" ScriptCreateSQLCreate="1" />

</MYModel>

<DDiagram Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" BackgroundColor="#ffffff" FontBold="0" BackgroundImagePlacement="0" FontItalic="0" ModificationDate="2007-04-16T10:17:27" Author="Tomas Dulik" TextFlag="2048" CreationDate="2007-04-15T18:48:38" BackgroundType="0" FontStrikeOut="0" Name="Network_example" BackgroundStyle="none" Version="2.2" NextOID="22" FontFamily="MS Shell Dlg" ><![CDATA[This drawing shows the relationship between network segments and subnets...]]><DRectangle width="98" x="285" TextField="2" Align="68" y="92" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="1" height="69" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="switch" NextOID="4" FontFamily="MS Shell Dlg" ><![CDATA[Switch]]><sink x="0.989796" y="0.492754" OID="3" />

<sink x="0" y="0.217391" OID="2" />

<sink x="0" y="0.826087" OID="1" />

</DRectangle>

<DRectangle width="100" x="329" TextField="2" Align="68" y="225" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="2" height="36" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="switch" NextOID="2" FontFamily="MS Shell Dlg" ><![CDATA[Switch]]><sink x="0.979592" y="0.449275" OID="1" />

</DRectangle>

<DRectangle width="98" x="502" TextField="2" Align="68" y="117" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="3" height="54" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="router" NextOID="4" FontFamily="MS Shell Dlg" ><![CDATA[Router]]><sink x="0.704082" y="0.981481" OID="3" />

<sink x="-0.0204082" y="0.185185" OID="2" />

<sink x="0.44898" y="0.981481" OID="1" />

</DRectangle>

<DLine TextField="2" Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" EndArrowDirection="393331" EndArrowFlags="0" EndArrowType="0" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="4" BeginArrowDirection="26695400" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" FontItalic="0" EndTruncate="0" TextFlag="2048" FontStrikeOut="0" BeginTruncate="0" BeginArrowFlags="0" NextOID="4" FontFamily="MS Shell Dlg" ><![CDATA[segment1]]><point x="382" y="126" OID="1" SinkObjectOID="1" SinkOID="3" />

<point x="500" y="127" OID="2" SinkObjectOID="3" SinkOID="2" />

<TextHandle x="0.172414" y="-4" OID="3" />

</DLine>

<DLine TextField="2" Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" EndArrowDirection="393319" EndArrowFlags="0" EndArrowType="0" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="5" BeginArrowDirection="26508976" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" FontItalic="0" EndTruncate="0" TextFlag="2048" FontStrikeOut="0" BeginTruncate="0" BeginArrowFlags="0" NextOID="4" FontFamily="MS Shell Dlg" ><![CDATA[segment2]]><point x="546" y="170" OID="1" SinkObjectOID="3" SinkOID="1" />

<point x="426" y="242" OID="2" SinkObjectOID="2" SinkOID="1" />

<TextHandle x="0.516393" y="0.597701" OID="3" />

</DLine>

<DText width="81" x="441" TextField="2" Align="68" y="171" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="none" FontColor="#000000" FontPointSize="8" OID="6" height="15" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" NextOID="1" FontFamily="MS Shell Dlg" ><![CDATA[10.143.10.1/24]]></DText>

<DText width="81" x="458" TextField="2" Align="68" y="104" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="none" FontColor="#000000" FontPointSize="8" OID="7" height="15" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" NextOID="1" FontFamily="MS Shell Dlg" ><![CDATA[10.143.9.1/24]]></DText>

<DRectangle width="61" x="118" TextField="2" Align="68" y="92" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="8" height="39" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" NextOID="2" FontFamily="MS Shell Dlg" ><![CDATA[PC1]]><sink x="1" y="0.384615" OID="1" />

</DRectangle>

<DRectangle width="61" x="116" TextField="2" Align="68" y="147" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="9" height="39" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" NextOID="2" FontFamily="MS Shell Dlg" ><![CDATA[PC2]]><sink x="1.01639" y="0.487179" OID="1" />

</DRectangle>

<DLine TextField="2" Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" EndArrowDirection="41505584" EndArrowFlags="0" EndArrowType="0" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="10" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" FontItalic="0" EndTruncate="0" TextFlag="2048" FontStrikeOut="0" BeginTruncate="0" BeginArrowFlags="0" NextOID="4" FontFamily="MS Shell Dlg" ><![CDATA[segment4]]><point x="285" y="107" OID="1" SinkObjectOID="1" SinkOID="2" />

<point x="179" y="107" OID="2" SinkObjectOID="8" SinkOID="1" />

<TextHandle x="0.45" y="0.5" OID="3" />

</DLine>

<DLine TextField="2" Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" EndArrowDirection="16796104" EndArrowFlags="0" EndArrowType="0" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="11" BeginArrowDirection="16997192" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" FontItalic="0" EndTruncate="0" TextFlag="2048" FontStrikeOut="0" BeginTruncate="0" BeginArrowFlags="0" NextOID="4" FontFamily="MS Shell Dlg" ><![CDATA[segment3]]><point x="285" y="149" OID="1" SinkObjectOID="1" SinkOID="1" />

<point x="178" y="166" OID="2" SinkObjectOID="9" SinkOID="1" />

<TextHandle x="0.287037" y="1.16667" OID="3" />

</DLine>

<DText width="81" x="581" TextField="2" Align="68" y="170" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="none" FontColor="#000000" FontPointSize="8" OID="12" height="15" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" NextOID="1" FontFamily="MS Shell Dlg" ><![CDATA[10.143.11.1/24]]></DText>

<DRectangle width="61" x="482" TextField="2" Align="68" y="268" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="13" height="39" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" NextOID="2" FontFamily="MS Shell Dlg" ><![CDATA[PC5]]></DRectangle>

<DRectangle width="61" x="602" TextField="2" Align="68" y="224" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="14" height="39" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" NextOID="3" FontFamily="MS Shell Dlg" ><![CDATA[PC6]]><sink x="0" y="0.333333" OID="2" />

</DRectangle>

<DLine TextField="2" Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" EndArrowDirection="0" EndArrowFlags="0" EndArrowType="0" FontUnderline="0" FillColor="#000000" LineStyle="Dot" FontColor="#000000" FontPointSize="8" OID="15" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" FontItalic="0" EndTruncate="0" TextFlag="2048" FontStrikeOut="0" BeginTruncate="0" BeginArrowFlags="0" NextOID="4" FontFamily="MS Shell Dlg" ><![CDATA[segment5 (wifi or coax ethernet)]]><point x="571" y="170" OID="1" SinkObjectOID="3" SinkOID="3" />

<point x="572" y="491" OID="2" />

<TextHandle x="0.45" y="0.5" OID="3" />

</DLine>

<DLine TextField="2" Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" EndArrowDirection="393248" EndArrowFlags="0" EndArrowType="0" FontUnderline="0" FillColor="#000000" LineStyle="Dot" FontColor="#000000" FontPointSize="8" OID="16" BeginArrowDirection="15998216" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" FontItalic="0" EndTruncate="0" TextFlag="2048" FontStrikeOut="0" BeginTruncate="0" BeginArrowFlags="0" NextOID="4" FontFamily="MS Shell Dlg" >

<point x="602" y="237" OID="1" SinkObjectOID="14" SinkOID="2" />

<point x="573" y="237" OID="2" />

<TextHandle x="0.45" y="0.5" OID="3" />

</DLine>

<DLine TextField="2" Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" EndArrowDirection="393248" EndArrowFlags="0" EndArrowType="0" FontUnderline="0" FillColor="#000000" LineStyle="Dot" FontColor="#000000" FontPointSize="8" OID="17" BeginArrowDirection="15998216" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" FontItalic="0" EndTruncate="0" TextFlag="2048" FontStrikeOut="0" BeginTruncate="0" BeginArrowFlags="0" NextOID="4" FontFamily="MS Shell Dlg" >

<point x="568" y="284" OID="1" />

<point x="539" y="284" OID="2" />

<TextHandle x="0.45" y="0.5" OID="3" />

</DLine>

<DLine TextField="2" Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" EndArrowDirection="393248" EndArrowFlags="0" EndArrowType="0" FontUnderline="0" FillColor="#000000" LineStyle="Dot" FontColor="#000000" FontPointSize="8" OID="18" BeginArrowDirection="15998216" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" FontItalic="0" EndTruncate="0" TextFlag="2048" FontStrikeOut="0" BeginTruncate="0" BeginArrowFlags="0" NextOID="4" FontFamily="MS Shell Dlg" >

<point x="598" y="369" OID="1" />

<point x="569" y="369" OID="2" />

<TextHandle x="0.45" y="0.5" OID="3" />

</DLine>

<DLine TextField="2" Align="68" LineColor="#000000" FillStyle="none" LineWidth="1" EndArrowDirection="393248" EndArrowFlags="0" EndArrowType="0" FontUnderline="0" FillColor="#000000" LineStyle="Dot" FontColor="#000000" FontPointSize="8" OID="19" BeginArrowDirection="15998216" DefaultsLoaded="1" BeginArrowType="0" FontBold="0" FontItalic="0" EndTruncate="0" TextFlag="2048" FontStrikeOut="0" BeginTruncate="0" BeginArrowFlags="0" NextOID="4" FontFamily="MS Shell Dlg" >

<point x="569" y="410" OID="1" />

<point x="540" y="410" OID="2" />

<TextHandle x="0.3" y="6" OID="3" />

</DLine>

<DRectangle width="61" x="599" TextField="2" Align="68" y="349" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="20" height="39" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" NextOID="2" FontFamily="MS Shell Dlg" ><![CDATA[PC7]]></DRectangle>

<DRectangle width="61" x="482" TextField="2" Align="68" y="392" LineColor="#000000" FillStyle="none" LineWidth="1" FontUnderline="0" FillColor="#000000" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="21" height="39" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" NextOID="2" FontFamily="MS Shell Dlg" ><![CDATA[PC8]]></DRectangle>

</DDiagram>

<SAProject Name="FreeNetIS" Version="2.2" >

<Properties PromptUserID="1" PromptDataSourceName="0" UserID="" DataSourceName="" AutoConnect="0" SavePassword="0" PromptPassword="1" />

<Child Class="LMModel" Location="" />

<Child Class="LMModel" Location="FreeNetIs.LMModel" />

<Child Class="MYModel" Location="" />

<Child Class="MYModel" Location="" />

<Child Class="SQLFile" Location="" />

</SAProject>

-- phpMyAdmin SQL Dump

-- version 2.9.1.1-Debian-6

-- http://www.phpmyadmin.net

--

-- Po??ta?: localhost

-- Vygenerov?no: Pond?l? 21. ledna 2008, 19:47

-- Verze MySQL: 5.0.32

-- Verze PHP: 5.2.0-8+etch7

--

-- Datab?ze: `freenetis`

--

--

-- Vypisuji data pro tabulku `acl`

--

INSERT INTO `acl` (`id`, `section_value`, `allow`, `enabled`, `return_value`, `note`, `updated_date`) VALUES

(10, 'user', 1, 1, '', 'V?ichni lide na svete maji pravo se registrovat jako zajemci o clenstvi', 1180619687),

(11, 'user', 1, 1, '', 'Registrovan? z?jemci i &#345;?dn? &#269;lenov? sdru?en? maj? pr?vo m&#283;nit kontaktn? ?daje v tabulce &#269;len&#367;', 1180620482),

(12, 'user', 1, 1, '', 'P&#345;edseda a jednatel mohou v datab?zi m&#283;nit jak?koli ?daje. Nemohou ale m&#283;nit log &#269;innost?, tak?e v?echno, co v datab?zi provedou, bude zaznamen?no v logu.', 1180621673),

(13, 'user', 1, 1, '', 'Pr?vo prohl?et log akc? ve Freenetisu maj? pouze Spr?vn? rada a Spr?vci syst?mu Freenetis', 1180621803);

--

-- Vypisuji data pro tabulku `acl_sections`

--

INSERT INTO `acl_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES

(1, 'system', 1, 'System', 0),

(2, 'user', 2, 'User', 0);

--

-- Vypisuji data pro tabulku `acl_seq`

--

INSERT INTO `acl_seq` (`id`) VALUES

(13);

--

-- Vypisuji data pro tabulku `aco`

--

INSERT INTO `aco` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES

(10, 'Syst?m freenetis', 'view', 1, 'Pr?va prohl?et', 0),

(11, 'Syst?m freenetis', 'create', 2, 'Pr?vo vytvaret nove zaznamy', 0),

(12, 'Syst?m freenetis', 'edit_any', 3, 'Pr?vo editovat jak?koli zaznamy', 0),

(13, 'Syst?m freenetis', 'delete', 4, 'Pr?vo mazat jak?koli zaznamy', 0),

(14, 'Syst?m freenetis', 'edit_own', 5, 'Pr?vo editovat svoje z?znamy', 0),

(15, 'Syst?m freenetis', 'delete_own', 6, 'Pr?vo mazat svoje z?znamy', 0);

--

-- Vypisuji data pro tabulku `aco_map`

--

INSERT INTO `aco_map` (`acl_id`, `section_value`, `value`) VALUES

(10, 'Syst?m freenetis', 'create'),

(11, 'Syst?m freenetis', 'edit_own'),

(12, 'Syst?m freenetis', 'create'),

(12, 'Syst?m freenetis', 'delete'),

(12, 'Syst?m freenetis', 'edit_any'),

(12, 'Syst?m freenetis', 'view'),

(13, 'Syst?m freenetis', 'view');

--

-- Vypisuji data pro tabulku `aco_sections`

--

INSERT INTO `aco_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES

(10, 'Syst?m freenetis', 1, 'Syst?m freenetis', 0);

--

-- Vypisuji data pro tabulku `aco_sections_seq`

--

INSERT INTO `aco_sections_seq` (`id`) VALUES

(10);

--

-- Vypisuji data pro tabulku `aco_seq`

--

INSERT INTO `aco_seq` (`id`) VALUES

(15);

--

-- Vypisuji data pro tabulku `aro`

--

INSERT INTO `aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES

(10, 'clenove', 'dulik', 1, 'Tomas Dulik', 0),

(11, 'clenove', 'sedlar', 2, 'Honza Sedlar', 0),

(12, 'clenove', 'sevcik', 3, 'Roman Sevcik', 0);

--

-- Vypisuji data pro tabulku `aro_groups`

--

INSERT INTO `aro_groups` (`id`, `parent_id`, `lft`, `rgt`, `name`, `value`) VALUES

(10, 0, 1, 22, 'V?ichni lid? na sv&#283;t&#283;', 'vsichni_lide'),

(11, 10, 2, 3, 'Registrovan? z?jemci o &#269;lenstv?', 'registrovani zajemci'),