Skip to content

[DwC export]: Create exportdataset table to replace ExportFeed app resource #7745

@grantfitzsimmons

Description

@grantfitzsimmons

Goal

Create the exportdataset database table with all required fields, replacing the existing ExportFeed app resource mechanism for new-style exports.

Background

The current ExportFeed app resource is a legacy mechanism. The new exportdataset table provides a structured, queryable model for Export Packages with proper foreign key relationships. The legacy system must continue to function (backwards compatibility).

Schema

Field Type Notes
ExportDataSetID Int (PK) Auto-increment
ExportName VarChar Unique
FileName VarChar Unique, ends with .zip
RSS Boolean Default false
Frequency Int Nullable
Metadata FK → spappresource Nullable
CoreMapping FK → schemamapping Required
CollectionID FK → collection Required
TimestampCreated DateTime
TimestampModified DateTime
LastExported DateTime Nullable

Acceptance Criteria

  • Table created in migration with all fields above.
  • Uniqueness constraints on ExportName and FileName.
  • Foreign key constraints are enforced.
  • The legacy ExportFeed app resource system continues to function (backwards compatibility).
  • ORM model created and registered.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions