generated: '2026-08-12'
method: derived
source: openapi/adready-cpxi-kickstart-openapi.yml
note: Entity-relationship graph derived mechanically from components.schemas $ref links and <name>Id reference fields
  in the published OpenAPI 3.1 description. Digital Remedy publishes no object reference, so no id-prefix or domain
  naming could be searched; nothing here is authored, it is all read out of the spec.
summary:
  schemas_total: 285
  response_envelope_schemas: 106
  domain_schemas: 179
  entities_with_id: 86
  relationships_derived: 222
domains:
- name: Account & Identity
  path_prefixes:
  - /api/users
  - /api/accounts
  - /api/organizations
  - /api/agencies
  - /api/advertisers
  - /api/auth
  - /api/token
  - /api/whitelabel_domains
- name: Media Planning
  path_prefixes:
  - /api/plans
  - /api/rateCards
  - /api/budgetGroup
  - /api/productHierarchy
- name: Campaign Execution
  path_prefixes:
  - /api/ios
  - /api/lineItems
  - /api/dmm
  - /api/segments
- name: Supply & Deals
  path_prefixes:
  - /api/mediaPublisher
  - /api/publisherDeal
  - /api/mediaTypes
  - /api/vendor
- name: Attribution & Measurement
  path_prefixes:
  - /api/advertisers/{advertiserId}/flipPixels
  - /api/pixel
  - /api/incrementality
  - /api/brand_lift
- name: Reporting & Analytics
  path_prefixes:
  - /api/reports
  - /api/tableau
  - /api/token/tableau
  - /api/token/thoughtSpot
  - /api/export
- name: App Console
  path_prefixes:
  - /api/ac
core_entities:
- entity: Account
  fields: 24
  referenced_by: 14
- entity: Advertiser
  fields: 34
  referenced_by: 12
- entity: FileData
  fields: 10
  referenced_by: 10
- entity: User
  fields: 28
  referenced_by: 9
- entity: ProductType
  fields: 3
  referenced_by: 7
- entity: Plan
  fields: 51
  referenced_by: 6
- entity: Organization
  fields: 13
  referenced_by: 5
- entity: ProductCategory
  fields: 2
  referenced_by: 5
- entity: LineItem
  fields: 58
  referenced_by: 4
- entity: Solution
  fields: 14
  referenced_by: 4
- entity: Role
  fields: 4
  referenced_by: 4
- entity: Creative
  fields: 33
  referenced_by: 3
- entity: BudgetGroup
  fields: 5
  referenced_by: 3
- entity: Note
  fields: 3
  referenced_by: 3
- entity: Kpi
  fields: 6
  referenced_by: 2
- entity: UserApplication
  fields: 2
  referenced_by: 2
- entity: MarketingObjective
  fields: 2
  referenced_by: 2
- entity: Location
  fields: 2
  referenced_by: 2
- entity: Industry
  fields: 2
  referenced_by: 2
- entity: RateCardItemDTO
  fields: 21
  referenced_by: 1
- entity: DmmIoPackageFeedRaw
  fields: 19
  referenced_by: 1
- entity: DmmIoPackageFeedRawHistory
  fields: 19
  referenced_by: 1
- entity: ReportTemplate
  fields: 18
  referenced_by: 1
- entity: DmmIoCampaignFeedRaw
  fields: 18
  referenced_by: 1
relationships:
- from: UserAdvertiser
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: UserAdvertiser
  type: belongs_to
  to: User
  via: userId
- from: UserAccount
  type: belongs_to
  to: Account
  via: accountId
- from: UserAccount
  type: belongs_to
  to: User
  via: userId
- from: Role
  type: has_many
  to: Permission
  via: permissions
- from: User
  type: belongs_to
  to: Organization
  via: organizationId
- from: User
  type: has_one
  to: Role
  via: role
- from: User
  type: has_many
  to: User
  via: teams
- from: User
  type: has_many
  to: UserApplication
  via: userApplications
- from: UserApplication
  type: belongs_to
  to: Application
  via: applicationId
- from: UserDTO
  type: belongs_to
  to: Organization
  via: organizationId
- from: UserDTO
  type: has_one
  to: Role
  via: role
- from: UserDTO
  type: has_many
  to: User
  via: teams
- from: UserDTO
  type: has_many
  to: UserApplication
  via: userApplications
- from: RateCardItem
  type: belongs_to
  to: Account
  via: accountId
- from: RateCardItem
  type: belongs_to
  to: ProductType
  via: productTypeId
- from: RateCardItemDTO
  type: belongs_to
  to: Account
  via: accountId
- from: RateCardItemDTO
  type: belongs_to
  to: ProductType
  via: productTypeId
- from: RateCardItemDTO
  type: belongs_to
  to: ProductCategory
  via: productCategoryId
- from: BudgetGroup
  type: belongs_to
  to: BudgetGroup
  via: budgetGroupId
- from: BudgetGroup
  type: belongs_to
  to: Plan
  via: planId
- from: CompanionAsset
  type: has_many
  to: FileData
  via: images
- from: Creative
  type: has_many
  to: CompanionAsset
  via: companionAssets
- from: Creative
  type: has_many
  to: FileData
  via: files
- from: Creative
  type: has_many
  to: Headline
  via: headlines
- from: Kpi
  type: belongs_to
  to: Kpi
  via: kpiId
- from: LineItem
  type: has_one
  to: BudgetGroup
  via: budgetGroup
- from: LineItem
  type: belongs_to
  to: BudgetGroup
  via: budgetGroupId
- from: LineItem
  type: has_many
  to: LineItem
  via: crLineItems
- from: LineItem
  type: has_many
  to: Creative
  via: creatives
- from: LineItem
  type: has_many
  to: LineItemDeviceTypes
  via: deviceTypes
- from: LineItem
  type: has_many
  to: Kpi
  via: kpis
- from: LineItem
  type: has_one
  to: Note
  via: note
- from: LineItem
  type: belongs_to
  to: Plan
  via: planId
- from: LineItem
  type: belongs_to
  to: ProductCategory
  via: productCategoryId
- from: LineItem
  type: has_many
  to: LineItemProductType
  via: productTypes
- from: LineItem
  type: has_many
  to: LineItemTargeting
  via: targetings
- from: LineItem
  type: has_many
  to: TrackingPixelData
  via: trackingPixels
- from: LineItem
  type: has_many
  to: LineItemVendors
  via: vendors
- from: LineItemProductType
  type: belongs_to
  to: ProductType
  via: productTypeId
- from: LocationData
  type: belongs_to
  to: Location
  via: locationId
- from: Note
  type: has_many
  to: FileData
  via: files
- from: Plan
  type: belongs_to
  to: Account
  via: accountId
- from: Plan
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: Plan
  type: belongs_to
  to: Agency
  via: agencyId
- from: Plan
  type: belongs_to
  to: BrandSafetyLevel
  via: brandSafetyLevelId
- from: Plan
  type: has_many
  to: Plan
  via: crPlans
- from: Plan
  type: has_many
  to: FileData
  via: files
- from: Plan
  type: belongs_to
  to: Industry
  via: industryId
- from: Plan
  type: has_one
  to: Note
  via: internalNote
- from: Plan
  type: has_many
  to: LineItem
  via: lineItems
- from: Plan
  type: has_one
  to: LocationData
  via: location
- from: Plan
  type: belongs_to
  to: MarketingObjective
  via: marketingObjectiveId
- from: Plan
  type: has_one
  to: Note
  via: note
- from: Plan
  type: has_many
  to: ProductCategoryAllocation
  via: productCategoryAllocations
- from: PlanningMatrixEntry
  type: belongs_to
  to: Industry
  via: industryId
- from: PlanningMatrixEntry
  type: belongs_to
  to: Location
  via: locationId
- from: PlanningMatrixEntry
  type: belongs_to
  to: MarketingObjective
  via: marketingObjectiveId
- from: ProductCategoryAllocation
  type: belongs_to
  to: ProductCategory
  via: productCategoryId
- from: ProductTypeAllocation
  type: belongs_to
  to: ProductType
  via: productTypeId
- from: TrackingPixelData
  type: has_many
  to: FileData
  via: files
- from: CalcReq
  type: belongs_to
  to: ProductCategory
  via: productCategoryId
- from: CalcReq
  type: belongs_to
  to: ProductType
  via: productTypeId
- from: Organization
  type: has_one
  to: FileData
  via: appConsoleLogoFile
- from: Organization
  type: has_one
  to: FileData
  via: appConsoleSquareLogoFile
- from: Organization
  type: has_one
  to: FileData
  via: favIconLogoFile
- from: Organization
  type: has_one
  to: FileData
  via: logoFile
- from: PublisherMediaTypeMapping
  type: has_one
  to: ProductCategory
  via: productCategory
- from: PublisherMediaTypeMapping
  type: has_one
  to: ProductType
  via: productType
- from: Advertiser
  type: belongs_to
  to: Account
  via: accountId
- from: Advertiser
  type: has_one
  to: FileData
  via: logoFile
- from: Advertiser
  type: belongs_to
  to: Organization
  via: organizationId
- from: Agency
  type: belongs_to
  to: Account
  via: accountId
- from: Agency
  type: has_many
  to: Advertiser
  via: advertisers
- from: Account
  type: has_many
  to: Advertiser
  via: advertisers
- from: Account
  type: has_many
  to: DashboardUrl
  via: dashboardUrls
- from: Account
  type: has_one
  to: Organization
  via: organization
- from: Account
  type: belongs_to
  to: Organization
  via: organizationId
- from: DashboardUrl
  type: belongs_to
  to: Account
  via: accountId
- from: DropdownUserMaster
  type: belongs_to
  to: Account
  via: accountId
- from: DropdownUserMaster
  type: belongs_to
  to: User
  via: userId
- from: ReportTemplate
  type: belongs_to
  to: Account
  via: accountId
- from: ReportTemplate
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: ReportTemplate
  type: has_one
  to: ReportFilter
  via: filters
- from: AdvertiserSolution
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: AdvertiserSolution
  type: has_one
  to: Solution
  via: solution
- from: AdvertiserSolution
  type: belongs_to
  to: Solution
  via: solutionId
- from: UserRole
  type: has_one
  to: Role
  via: role
- from: UserRole
  type: belongs_to
  to: Role
  via: roleId
- from: UserRole
  type: belongs_to
  to: User
  via: userId
- from: EmailNotification
  type: has_many
  to: LineItem
  via: lineItems
- from: ExportSchedule
  type: belongs_to
  to: LineItem
  via: lineItemId
- from: ExportSchedule
  type: belongs_to
  to: Plan
  via: planId
- from: PixelDTO
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: Pixel
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: CommentNotification
  type: belongs_to
  to: Plan
  via: planId
- from: CommentNotification
  type: belongs_to
  to: Account
  via: accountId
- from: ValidateResetPasswordTokenRequest
  type: belongs_to
  to: User
  via: userId
- from: CreatePasswordRequest
  type: belongs_to
  to: User
  via: userId
- from: StandardApiRequest
  type: belongs_to
  to: Solution
  via: solutionId
- from: StandardApiRequest
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: ReportRequest
  type: belongs_to
  to: Account
  via: accountId
- from: ReportRequest
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: TokenWrapper
  type: belongs_to
  to: User
  via: userId
- from: RateCardDTO
  type: has_many
  to: RateCardItemDTO
  via: rateCardItems
- from: ProductCategoryDTO
  type: has_many
  to: ProductType
  via: productTypes
- from: WorkflowStats
  type: belongs_to
  to: Plan
  via: planId
- from: ProductHierarchy
  type: belongs_to
  to: Account
  via: accountId
- from: DemoConfig
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: DemoConfig
  type: belongs_to
  to: Account
  via: accountId
- from: DemoConfig
  type: belongs_to
  to: Solution
  via: solutionId
- from: ReportGenerationLog
  type: belongs_to
  to: ReportTemplate
  via: reportTemplateId
- from: ReportTemplateResponseDto
  type: belongs_to
  to: Account
  via: accountId
- from: ReportTemplateResponseDto
  type: belongs_to
  to: Advertiser
  via: advertiserId
- from: DmmIoPlacementFeedRaw
  type: belongs_to
  to: Creative
  via: creativeId
- from: DmmIoPlacementFeedRawHistory
  type: belongs_to
  to: Creative
  via: creativeId
- from: PageDmmIoPackageFeedRaw
  type: has_many
  to: DmmIoPackageFeedRaw
  via: content
- from: PageDmmIoPackageFeedRawHistory
  type: has_many
  to: DmmIoPackageFeedRawHistory
  via: content
- from: PageDmmIoCampaignFeedRaw
  type: has_many
  to: DmmIoCampaignFeedRaw
  via: content