api_external.sponsor_assets
View
Brand assets of the entitlements the caller's sponsor account is owed (journey 47), once the org submits them, while the Sponsor engagement is in the operational area. Drafts the org has not submitted and who decided on the org side never appear.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Asset. |
| sponsor_entitlement_id | uuid | Yes | Entitlement. |
| project_id | uuid | Yes | Project. |
| project_name | text | Yes | Project name. |
| account_id | uuid | Yes | The caller's sponsor account. |
| entitlement_description | text | Yes | What the entitlement is. |
| asset_kind | app.sponsor_asset_kind | Yes | Logo, Artwork, Copy, Video or Other. |
| title | text | Yes | What the asset is. |
| usage_note | text | Yes | Where and how it is used. |
| due_on | date | Yes | When it is needed. |
| revision | integer | Yes | Revision number. |
| asset_state | app.review_state | Yes | Submitted, Approved, Returned or Canceled. |
| decided_at | timestamp with time zone | Yes | When it was last approved or returned. |
| awaiting_sponsor | boolean | Yes | True while the sponsor's answer is awaited. |