{"id":76,"date":"2024-10-22T15:02:51","date_gmt":"2024-10-22T15:02:51","guid":{"rendered":"https:\/\/mydatasolutions.co.uk\/index.php\/docs\/nfrs-asset-management\/technical-specifications\/data-model\/"},"modified":"2024-10-22T16:56:55","modified_gmt":"2024-10-22T16:56:55","slug":"data-model","status":"publish","type":"docs","link":"https:\/\/mydatasolutions.co.uk\/index.php\/docs\/nfrs-asset-management\/technical-specifications\/data-model\/","title":{"rendered":"Data Model"},"content":{"rendered":"\n

Here are the entities and their attributes: <\/p>\n\n\n\n

    \n
  1. Assets<\/strong>\n
      \n
    • Id\u00a0<\/li>\n\n\n\n
    • Asset\u00a0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
    • Asset Type<\/strong>\n
        \n
      • Id\u00a0<\/li>\n\n\n\n
      • Asset Type\u00a0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
      • Vendors<\/strong>\n
          \n
        • Id\u00a0<\/li>\n\n\n\n
        • Vendor ID\u00a0<\/li>\n\n\n\n
        • Vendor Name\u00a0<\/li>\n\n\n\n
        • Contact Person\u00a0<\/li>\n\n\n\n
        • Contact Number\u00a0<\/li>\n\n\n\n
        • Email Address\u00a0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
        • Personnel<\/strong>\n
            \n
          • Id\u00a0<\/li>\n\n\n\n
          • Personnel ID\u00a0<\/li>\n\n\n\n
          • First Name\u00a0<\/li>\n\n\n\n
          • Last Name\u00a0<\/li>\n\n\n\n
          • Date of Birth\u00a0<\/li>\n\n\n\n
          • Gender\u00a0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
          • Locations<\/strong>\n
              \n
            • Id\u00a0<\/li>\n\n\n\n
            • Location ID\u00a0<\/li>\n\n\n\n
            • Location Name\u00a0<\/li>\n\n\n\n
            • Address\u00a0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
            • Asset Assignments<\/strong>\n
                \n
              • Id\u00a0<\/li>\n\n\n\n
              • Assignment ID\u00a0<\/li>\n\n\n\n
              • Asset ID\u00a0<\/li>\n\n\n\n
              • Personnel ID\u00a0<\/li>\n\n\n\n
              • Location ID\u00a0<\/li>\n\n\n\n
              • Assignment Date\u00a0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
              • Incident Reports<\/strong>\n
                  \n
                • Id\u00a0<\/li>\n\n\n\n
                • Incident Report ID\u00a0<\/li>\n\n\n\n
                • Incident Date\u00a0<\/li>\n\n\n\n
                • Incident Type\u00a0<\/li>\n\n\n\n
                • Asset ID\u00a0<\/li>\n\n\n\n
                • Personnel ID\u00a0<\/li>\n\n\n\n
                • Description\u00a0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
                • Inspection Reports<\/strong>\n
                    \n
                  • Id\u00a0<\/li>\n\n\n\n
                  • Inspection Report ID\u00a0<\/li>\n\n\n\n
                  • Asset ID\u00a0<\/li>\n\n\n\n
                  • Inspection Date\u00a0<\/li>\n\n\n\n
                  • Inspector ID\u00a0<\/li>\n\n\n\n
                  • Inspection Type\u00a0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
                  • Service Schedules<\/strong>\n
                      \n
                    • Id\u00a0<\/li>\n\n\n\n
                    • Service Schedule ID\u00a0<\/li>\n\n\n\n
                    • Asset ID\u00a0<\/li>\n\n\n\n
                    • Service Type\u00a0<\/li>\n\n\n\n
                    • Service Description\u00a0<\/li>\n\n\n\n
                    • Service Interval\u00a0<\/li>\n<\/ul>\n<\/li>\n\n\n\n
                    • Maintenance Records<\/strong>\n
                        \n
                      • Id\u00a0<\/li>\n\n\n\n
                      • Maintenance Record ID\u00a0<\/li>\n\n\n\n
                      • Asset ID\u00a0<\/li>\n\n\n\n
                      • Maintenance Date\u00a0<\/li>\n\n\n\n
                      • Maintenance Type\u00a0<\/li>\n\n\n\n
                      • Performed By\u00a0<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n

                        2. Defining Relationships<\/strong> <\/p>\n\n\n\n

                        Relationships are defined based on foreign key references. The primary keys are unique identifiers for each entity, while foreign keys reference primary keys from other entities to establish relationships. Here’s a more detailed look at the relationships: <\/p>\n\n\n\n

                          \n
                        • Assets<\/strong>\u00a0to\u00a0Asset Type<\/strong>: Assets have a type that categorizes them.\u00a0<\/li>\n\n\n\n
                        • Assets<\/strong>\u00a0to\u00a0Vendors<\/strong>: Assets may be procured from vendors.\u00a0<\/li>\n\n\n\n
                        • Assets<\/strong>\u00a0to\u00a0Locations<\/strong>: Assets are located at specific locations.\u00a0<\/li>\n\n\n\n
                        • Assets<\/strong>\u00a0to\u00a0Personnel<\/strong>: Assets may be assigned to personnel.\u00a0<\/li>\n\n\n\n
                        • Assets<\/strong>\u00a0to\u00a0Asset Assignments<\/strong>: Assets are assigned to personnel or locations.\u00a0<\/li>\n\n\n\n
                        • Assets<\/strong>\u00a0to\u00a0Incident Reports<\/strong>: Incident reports are linked to assets.\u00a0<\/li>\n\n\n\n
                        • Assets<\/strong>\u00a0to\u00a0Inspection Reports<\/strong>: Inspection reports are linked to assets.\u00a0<\/li>\n\n\n\n
                        • Assets<\/strong>\u00a0to\u00a0Service Schedules<\/strong>: Service schedules are linked to assets.\u00a0<\/li>\n\n\n\n
                        • Assets<\/strong>\u00a0to\u00a0Maintenance Records<\/strong>: Maintenance records are linked to assets.\u00a0<\/li>\n<\/ul>\n","protected":false},"featured_media":0,"parent":56,"menu_order":2,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"doc_tag":[],"class_list":["post-76","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/docs\/76","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/comments?post=76"}],"version-history":[{"count":1,"href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/docs\/76\/revisions"}],"predecessor-version":[{"id":113,"href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/docs\/76\/revisions\/113"}],"up":[{"embeddable":true,"href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/docs\/56"}],"next":[{"title":"Architecture","link":"https:\/\/mydatasolutions.co.uk\/index.php\/docs\/nfrs-asset-management\/technical-specifications\/architecture\/","href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/docs\/75"}],"prev":[{"title":"Security","link":"https:\/\/mydatasolutions.co.uk\/index.php\/docs\/nfrs-asset-management\/technical-specifications\/security\/","href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/docs\/77"}],"wp:attachment":[{"href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/media?parent=76"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/mydatasolutions.co.uk\/index.php\/wp-json\/wp\/v2\/doc_tag?post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}