Skip to content

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

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.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Projects

No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions