Revize 35
Přidáno uživatelem Tomáš Dulík před více než 16 roky(ů)
| freenetis/trunk/wwwroot/doc/OpenSystemArchitect/FreeNetIs.LMModel | ||
|---|---|---|
|
<LMModel DescriptionSize="4096" Description="789c8dce5b4854711006f06fe8422894811119d4618d6ea04b0a65767621294bb28bac4624a4c7ddbfeedad94bbbff2d57b007852ea00f2d7423a1848c4848052332b0a01b0915644442f660440646104541921d8ba0871ebe611e66e0c737630675d8f69a416505bc665869cb885861e5711d8a87fc41ad9ab4cbf047235a45b4c7b5ce65b8bda6fb8fad8b06524642a76c07d73b222f116a56c54531bde9f7566f854376aa78a7cff005956d1b5bec069737c38c792b83a184e1b43f198f3ba976cad041e5dc08c76ca59511b0b455672594131d4ffa7532ae8c68bd511a576a97d265be7cd31d7362dc33d7675e99791e5f64deaca97412102ffead69a7fece7390811f945b809f94cbc63bca2dc104e596e113e572f19c72ab314ab93cbca65c01ee516e031e52cec413ca6d461fe54a7193723b3048b93de8a25c152e536e3f7a285783eb940be034e5423847b9082e522e8156ca35e124e55ad04eb9562428771c8729d78e16ca9d422de5cea0817217d048b94ba8a05c372a29770dd594ebc501ca0d602be56e613be586b09b720f5040b9616ca4dc3398947b815cca8d6225e5de208f726f9145b9092ca6dc47e450ee338472df309b7253c8a49cc87ccacd95af94cb94ef94cb9269ca2d9271cae5c807ca2d9749caad9011caad919794cb9731ca15ca5dca15c923ca7964987225d24fb96d3240b972b94db90a19a2dc5ee9a65cb55ca55cadf4524e499a728d729e7251e9a49c9636caa5e418e58e4a07e5da2446b9137284721dd24cb9b458943b2b01ca75ca41ca7549847257a48a723db28f727d5243b91b5242b94129a3dc1d29a7dc7d29a4dc63594fb9a7e2a1dc8818947b25ab2837266b29372e0b29f75eb22937294bffe37e01e12d0b66" 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="2007-04-15T18:45:48" Author="Tomas Dulik" TextFlag="2048" CreationDate="2007-04-14T14:21:25" BackgroundType="0" FontStrikeOut="0" Name="FreeNetIS Database" BackgroundStyle="none" Version="2.2" NextOID="156" FontFamily="MS Shell Dlg" ><![CDATA[FreeNetIS database structure ER diagram]]><LMEntityNormal DescriptionSize="4096" width="131" Description="789cc556cf6f1b45147ebb71941fb54204870690d0c841855225690a842a75aca80d69116d5a9100bd3593f5c4bbca7a77bb3bb6e31caa485caa20a19480da63b8f506c75c90ca7fd063c49d9e39f682c437b3ebdf561b3b12249a7877defbbef7de376f5e9cb565d1cd656dc1f3b96c5148ce3c5e140b99fba163d9526ccb0cb37c4f0a4f2e6466336c26979d897d37fc7c9545b2eac279131e5391b323e62f07f28a7edbe445c7adcedf5a65abb6705db6e41632b9d16c90cb4601f75a8015e1146c393f77f16226b724222b7402e9f8de7c7646b92260a0816bb6601b3c722c568a44c8909123abd34c6d878247bec736fd909dbb5ff2e5955b624384f1237322266d2e19672bd76fb3b0e4798e57c09660cba1102b423ad154917bbc20f2cc13b2e2875bcc428a362f0be6f9de54605723cbe1ee54204215a6288a608fd8870b3e5842e68705ee393b5c251d9d67dccb2bf648b41a34a7e3596e292f18e25575196051f48ec55d16d347e7a7d96dcd2bb679317041b3594f43f9b5a6a1ca8b0be52cd63c7e9b8e659b51c7a4ce4c9d3211a3327172a944821628431ef958024f8c662847a3f86494c56e40921c6d6dc7ac62d7852ddf136a096f11d93d627cd8fa89725a64273e8b2755b5526b15b62ade44ddb6098b8bdf6b5a1b9f42ec2a9f2061b7eafb8ad343ac62629904b6f1db1ab1c6da88f7eab3688e58c3aafd9329f05ff682c06e84bfb37de22ef589fbb84fdc277de23eed1337d727eeb39e703774473ab4a3ad52db7ac17f83cf505bad9eb1d780f49173d413ea2ade2cda42c50e9e0a3d619775b5fd201bb97643abc9d079536bb6da5def766665ad9ca07b983b6afadcd3f3456a553775a5a2e35e2beb76c76c5273a7a8e3287c7bac35f03be067e015d8e7f54a236d0960e1ba3e07b579dab333934867e26b5f861bdfc8ff5539169185abe3d5a6a7f2986dcbdfd2d6a023f3d90eee0d64e0b7f55a962ac8939f02afaa5175c6b9ae25f9b7b3ad344dc8664e57ab2b7b98b5cd4c27edc295a4937a9d0c11d40db5ba35aff6eeed5e7d736fe5bb74f0c93af32a760bfae4bfd2baf7cbf33918f2a7e4b8aeef87d0bd22bbb09ca45b945e819e07417dfa298d95edff8b1cffec4607c621d6f6973952cb30247663c6714ad30f346cbe3460fbf5919140e819fc6bcfebb21d6fd3080de1760d9bcf80b33fface947a1ac493610a27c2f5ff0d46291aa41d236d2a9ecb32e61cc41ac752f107e87d7a007b2d9eca55d598a20fc832c6cce58e6f50718d29ba408584f749c23b922c55f72454d9a2b439e11e18eb7ffda4ed4358c358aa863360f0617f8efc27a6b7cde6bc2ccd9fc2d44e9beccfc7c69df4a3ba7d30d164004cdf1ac366ebf7b4b4394c6fd05de4650f96a9f967fcf8715dcf23e47b2c9bf5c45770fd7960a4e92c2d42d763ecdd1d7950c7dc2935cee36507fec01844755f007708dcdfeffe6c743f8f3d730077e526f2537c37a0b5ca2505ce73f435ba6dcc7c6ae6e8e9de8f461efd33fef69e9942a5979acea1f19fac6aaad829c49d4bce81955bcf2138da3727a0f43c7479181e18fbbfec99ddf458046ea2d45c8fd23bce7f1c3a67baf4e77ab9a10755daf16953f5e785d7f6e786eecfe924ffe3726b7f9ed1e73c496fc2aee2ed42abc5bacf119dc5fe52cb8c8ce826ba8aebb998471e79f0ff4eefd4fabf1263c792f504ef6fd11ff41ef41987eecfedaaf6339235a0fb2945e66bfa691d3cbb95e6fa1b7e43b8dfa3d0e137e8b0ffcf5edd725869e8b7fbe2a1d98aff9efe05ff3ae4fc" 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="Members" NextOID="25" 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.938931" y="0.0828025" OID="24" />
|
||
|
<sink x="0.21374" y="0.0127389" OID="23" />
|
||
|
<sink x="0.916667" y="0.1" OID="20" />
|
||
|
<LMAttribute OID="1" Identifier="1" >
|
||
|
<Uses Class="LMDataItem" Path="2" Name="ID" />
|
||
|
</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="Users" NextOID="23" 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.0852713" y="0.15942" OID="21" />
|
||
|
<sink x="0.899225" y="0.0108696" OID="20" />
|
||
|
<sink x="0.829457" y="0.141304" OID="18" />
|
||
|
<sink x="0.922481" y="0.110672" OID="14" />
|
||
|
<sink x="0.0650888" y="0.0931174" OID="1" />
|
||
|
<sink x="0.823077" y="0.957447" OID="22" />
|
||
|
<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="131" y="17" OID="4" />
|
||
|
<EndRoleHandle x="-149" 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.35" y="0.0574713" OID="13" />
|
||
|
<sink x="0.9" y="0.16092" OID="12" />
|
||
|
<sink x="0.555556" y="0.896552" OID="7" />
|
||
|
<sink x="0.172897" y="0.545455" OID="2" />
|
||
|
<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="789cc5564b6f1b55143e3371d424b582058b0690d09583caa34da2142855ea58511b4a116da84881ee9ac9ccb567947975e6fa954515894d1524941250bb0cbbee60990d52f9075d46ec61cdb21b24be7b67fcb6dad89120d68d3df79cef9cef7cf7dc63176ce1b9c582cd0dab58f0b830986f787c397f2f724c5bf0bac83333f005f7c5727e31cf168a8585c47733b01a2c160d17ce2578ccc5ce365fba148acbeaa964788edb58bab9ced66deeba6cd52de78b5385b0b81608ce4a41c484edf85b8e5f5e6281cf99c5ab8ec99969f830f020e2c2310dd76d30dba872e66103fb304adf4acca3f3ac668321ab0515d762d25505bdb9b4c622ee1ac209fcd876c2f36cb3229859892254806835ce62ce991fc0cb88035f813c43f25084ca7192cb0cbcd0e5f5f9c24208d60bb25859b9d48a3cee6df22866ef2e07a01ab1202a1bbeb39de47c8f19be254b8879b74195e6f8a65bb1508fe13754198812da8d58d6ca423cca08f3ec0b1597d70d49820525f0f5e79a7e73891f4b6830276667ef550271d96089e6c9d340e6c4a84a06b954214ecb94279f022c8e4f8c16a84853786754c06e48821c65edc5ac63d785cd1a0ab58aa798ec2131016ca3643929b21f5fc02759b5546b1db6069e78cb5682c5c5ebaad226a008bbd2274ca39bad7d19d3472e2fb5cc02db7e75676c466de77bf15974666c62e5fef114f82f7b816337c6ffc511711746c47d3022eec311711f8d88bb3822eee3a170d755473ab4adac42d986c17f8df74859cda1b157810cc0391e0a75054f266da162079fca4361afa96a4741b6b90e42cbc9d07f539bb6e65d1f746655a51ca7bb983b72fadc55f34528554baa52de77afa5b5de379be4dcf1541e89efcd751bf11dc46788cbb16fb42a8d952584c550f539a8cd579efd4c62c52450be0c37becdff451c3db07055bee6f4941e8b3dfc4d650dfb982ff6c5de0483a0a7d70a54034fe30478598dac33e17a3be5df1b6dad634276c67495ba628859db19e9b85db89676d2b0932186ba9152b7e9d5dbbd83abefec2d6b40071faf33af60b7ac4efe4ba5fba8713e4104eb84313e55f783ab5e1103a21ca75ba45ea19a07616bfa498da5edffcb9cfcedc4fbda0156fdf322c9a56902bb49c41c65e97b9ad09f6bb0fdf2504b21f414fecdcf1ba2176fd3249dc2ed9ad09f0267bfffad2ed4344826c31c4ec450df1b8c32344edb5a5697712e8924e638560e4be61fa3b7e93eeccd7c92abac3143ef90a94debd7fa7e41253566e81c95d3b88fd3b893e99275cf42952dcaea33eebeb6f1e78fca7e0a6b024bd6701a1102d89f81ffcc7c5defe465aaf8194cedaccefe78a4ddca3e6cd9c7534dc610e91b6d42effe9d96d527e815ba035ef678953aff72478f5a7a1e82ef91e8d4133fc1d5fbbe96a533b4025d8fb07767f27e0b73abd23e8fe77df87d6d1cd57d06dc01707fbff99336f83c76f531dc951be027e35d87d6924b0631cfd257e8b669fd895ea427bb3f6816fa27f7faae9e41a5173acea1fd4dd6d065ee0cf25e4ccf8155bbcf213cdcd367a0f412747910ed6b7b3fefea83f458016ea6d2598fd43be19f83cef901fdb9516deb41b55e7c5697fd79eea5fdb9a9fa733ee57f54edeecfd3ea9c67e955d865be1d68b5d2f239a433d85fed9a9131dd4057196a2e5ae06121fe6ff446b3ff6b09763a5d8ff1fc1afd4e6f419f1c747f6637949f96ae31d54f19d25fd24f1b88b353ebacbfed770af77b0a3afc0a1df6fed96d590e6a6dfd76fe7aa077e3bfa37f01b926e5b4" 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.0540541" y="0.330579" OID="13" />
|
||
|
<sink x="0.864865" y="0.206612" OID="14" />
|
||
|
<sink x="0.477064" y="0.859756" OID="10" />
|
||
|
<sink x="0.842105" y="0.585366" OID="11" />
|
||
|
<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.219178" y="0.242718" OID="10" />
|
||
|
<sink x="0.830508" y="0.266234" OID="7" />
|
||
|
<sink x="0.479452" y="0.893204" OID="8" />
|
||
|
<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.407407" y="0.157233" OID="8" />
|
||
|
<sink x="0.0833333" y="0.213836" OID="9" />
|
||
|
<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.890411" y="0.527273" OID="7" />
|
||
|
<sink x="0.722222" y="0.409722" OID="5" />
|
||
|
<sink x="0.462963" y="0.111111" OID="1" />
|
||
|
<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.0493827" y="0.204724" OID="7" />
|
||
|
<sink x="0.506173" y="0.023622" OID="6" />
|
||
|
<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.376147" y="0.921053" OID="2" />
|
||
|
<sink x="0.293578" y="0.0263158" OID="1" />
|
||
|
<sink x="0.440367" y="0.0394737" OID="6" />
|
||
|
<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="110" x="611" TextField="2" Align="68" y="454" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="108" height="213" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Payments" NextOID="17" FontFamily="MS Shell Dlg" ><![CDATA[This is the table where all payments from the bank account listings are stored.]]><sink x="0.171717" y="0.925373" OID="14" />
|
||
|
<sink x="0.434343" y="0.0646766" OID="15" />
|
||
|
<LMAttribute OID="1" Identifier="1" >
|
||
|
<Uses Class="LMDataItem" Path="109" Name="ID" />
|
||
|
</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="6" >
|
||
|
<Uses Class="LMDataItem" Path="114" Name="name" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="7" >
|
||
|
<Uses Class="LMDataItem" Path="115" Name="type" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="8" >
|
||
|
<Uses Class="LMDataItem" Path="116" Name="variable_symbol" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="9" >
|
||
|
<Uses Class="LMDataItem" Path="118" Name="constant_symbol" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="10" >
|
||
|
<Uses Class="LMDataItem" Path="119" Name="specific_symbol" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="11" >
|
||
|
<Uses Class="LMDataItem" Path="120" Name="amount" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="12" >
|
||
|
<Uses Class="LMDataItem" Path="121" Name="fee" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="2" >
|
||
|
<Uses Class="LMDataItem" Path="110" Name="ID_payer" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="16" >
|
||
|
<Uses Class="LMDataItem" Path="155" Name="unassigned_amount" />
|
||
|
</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="111" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Member_has_Payments" EndCardinality="0,n" BeginTruncate="1" BeginArrowFlags="4" NextOID="6" 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="380" OID="2" SinkObjectOID="147" SinkOID="2" />
|
||
|
<TextHandle x="0.45" y="0.5" OID="3" />
|
||
|
<BeginRoleHandle x="7" y="-32" OID="4" />
|
||
|
<EndRoleHandle x="18" y="22" OID="5" />
|
||
|
</LMRelationship>
|
||
|
<LMEntityNormal width="100" x="341" TextField="2" Align="68" y="76" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="122" height="139" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Credit_mods" NextOID="10" 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.15" y="0.942446" OID="9" />
|
||
|
<sink x="0.512397" y="0.870504" OID="1" />
|
||
|
<LMAttribute OID="2" Identifier="1" >
|
||
|
<Uses Class="LMDataItem" Path="127" Name="ID" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="3" >
|
||
|
<Uses Class="LMDataItem" Path="123" Name="ID_member" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="4" >
|
||
|
<Uses Class="LMDataItem" Path="126" Name="ID_user_admin" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="5" >
|
||
|
<Uses Class="LMDataItem" Path="124" Name="amount" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="6" >
|
||
|
<Uses Class="LMDataItem" Path="125" Name="timestamp" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="7" >
|
||
|
<Uses Class="LMDataItem" Path="128" Name="reason" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="8" >
|
||
|
<Uses Class="LMDataItem" Path="129" 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="130" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="Members_credit_has_Modifications" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" 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" />
|
||
|
<BeginRoleHandle x="11" y="24" OID="4" />
|
||
|
<EndRoleHandle x="8" y="-22" 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.595506" y="0.886667" OID="9" />
|
||
|
<sink x="0.820225" y="0.133333" OID="10" />
|
||
|
<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="141" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="User_Admin_made_Credit_modifications" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" 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" />
|
||
|
<BeginRoleHandle x="-41" y="3" OID="4" />
|
||
|
<EndRoleHandle x="1" 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="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>
|
||
|
<LMEntityNormal width="137" x="583" TextField="2" Align="68" y="283" LineColor="#0000ff" FillStyle="Solid" LineWidth="1" Generate="1" FontUnderline="0" FillColor="#00ffff" LineStyle="Solid" FontColor="#000000" FontPointSize="8" OID="147" height="113" DefaultsLoaded="1" FontBold="0" FontItalic="0" TextFlag="2048" FontStrikeOut="0" Name="Payments_Assignments" NextOID="8" 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.102041" y="0.283186" OID="1" />
|
||
|
<sink x="0.520408" y="0.858407" OID="2" />
|
||
|
<LMAttribute OID="3" >
|
||
|
<Uses Class="LMDataItem" Path="148" Name="ID_Member" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="4" >
|
||
|
<Uses Class="LMDataItem" Path="149" Name="ID_Payment" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="5" >
|
||
|
<Uses Class="LMDataItem" Path="150" Name="amount" />
|
||
|
</LMAttribute>
|
||
|
<LMAttribute OID="6" >
|
||
|
<Uses Class="LMDataItem" Path="152" Name="type" />
|
||
|
</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="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="596" y="315" 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" />
|
||
|
<BeginRoleHandle x="-43" y="10" OID="4" />
|
||
|
<EndRoleHandle x="10" y="10" 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="154" BeginArrowDirection="0" DefaultsLoaded="1" BeginArrowType="3" FontBold="0" FontItalic="0" EndTruncate="1" TextFlag="2048" FontStrikeOut="0" Name="User_made_Payment" EndCardinality="0,1" BeginTruncate="1" BeginArrowFlags="5" NextOID="6" 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" />
|
||
|
<BeginRoleHandle x="-60" y="-27" OID="4" />
|
||
|
<EndRoleHandle x="29" y="13" 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="65535" 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_payer" ><![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" />
|
||
|
<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_Member" ><![CDATA[ID of the Member to whom a payment is assigned to]]></LMDataItem>
|
||
|
<LMDataItem DataType="INTEGER" OID="149" Name="ID_Payment" ><![CDATA[ID of the Payment which is the "source of the money" that will be tranfered to member account(s).]]></LMDataItem>
|
||
|
<LMDataItem DataType="DOUBLE PRECISION" OID="150" Name="amount" ><![CDATA[The amount of money added to the member's credit]]></LMDataItem>
|
||
|
<LMDataItem Length="20" DataType="VARCHAR" OID="152" Name="type" ><![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>
|
||
|
</LMModel>
|
||
| freenetis/trunk/wwwroot/doc/OpenSystemArchitect/FreeNetIs-v_1_0.LMModel | ||
|---|---|---|
|
<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" />
|
||
Také k dispozici: Unified diff