Differences

This shows you the differences between two versions of the page.

--- guides:reference:database:datamodel [2019/12/23 16:12] – ↷ Page moved from maintenance:general:datamodel to guides:reference:database:datamodel yspeerte
+++ guides:reference:database:datamodel [2024/07/03 12:31] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+===== YCE datamodel ERD =====
+The main database, 'YCE', forms the heart of the application and is accessible but not alterable by the customer. A second database, 'NMS', is used to contain custom tables or tables used by integrations with NMS applications. This database is open to the customer.
+The YCE database itself consists of three parts: The Modeling tables, the Network tables and the Support tables. It is the Network tables that are of most interest to customers since its content will reflect their networks. Knowledge if its tables and their function is required to create or modify NetYCE Relations.
+The entity-relationship diagram, or ERD, of the Network tables is given below.
+{{:general:erd_yce_network_tables.png|}}
+A different representation of the same set of tables (mostly):
+{{ :general:yce_erd_20130119.png |}}
+A detailed description of the tables, their field and usage can be found in the article [[internal:designs:database_documentation|Database documentation]]