Skip to content

Model Attributes and Relationships

Ethan-Strominger edited this page Jan 11, 2024 · 6 revisions

--< Many to Many --- Many to One

Asset, Asset Groups, Categories, Type Relationships

  • Asset Groups (Name, Description) --< Assets
  • Asset Category (Name) --< Asset Type (Name) ---< Assets

User / Contributor and Organization

User attributes are be the same as People Depot. Organization will use the same attributes as People Depot, once those are defined.

  • User >--< Org (Name)

Asset Groups and Related Tables

Asset Groups have the following fields in addition to the M-M data

  • Description - Display
  • Internal Source - Display if value provided
  • External Source - Display if value provided
  • Asset Group >--< Practice Areas (Name)
  • Asset Group >--< Topic Areas (Name)
  • Asset Group >--< Tools (Name)

Assets and Related Tables

  • Asset >-- Asset Group
  • Asset >-- Tool (Primary Tool)
  • Asset >-- Usability
  • Active (T/F) - Internal
  • Published (T/F) - InternalThe following tabes have an M-M relationship with assets:
  • Google ID - Internal
  • Title - Display
  • Description - Display
  • Slug - Internal
  • Published (T/F)? - Internal
  • Contributor(s) - Display
  • Asset >-- Phase (Name)