Content Comparison

Table

Change

Justification

ApiServers

• Add Name column with unique constraint.
• Replace ApiVersion column with ApiVersionId column with FK.

To help differentiate between API connections, each is associated with a name.

Agents

• Add ApiServerId column. Nullable to support disassociated on archive of agent.

An agent executes against an API connection.

IngestionLogs

• Add ApiVersionId with FK to ApiVersions.
• Replace AgentId column with AgentName.
• Add ApiServerName column.

Denormalize columns to preserve history.

ApiVersions

• New table, primary key ApiVersionId (identity column), attribute Version.

A master table is established to support ApiVersion as a first-class citizen (e.g. to populate dropdown list of versions in UI) and FK relationships associated with it.

Resources

• Add ApiVersionId column with FK to ApiVersions.

Supports the persistence of resource metadata per API version.

DataMaps

• Add ApiVersionId column with FK to ApiVersions.

Maps are version specific.

BootstrapDatas

• Add ApiVersionId column with FK to ApiVersions.
• Remove ProcessedDate column.

Bootstrap datas are version specific.

Migrate connection specific bootstrap information to a new table.

BootstrapDataAgents

• New junction table.

Associate a bootstrap data item with an agent.

BootstrapDataApiServers

• New junction table.

Migrate ProcessedDate from BootstrapDatas to track if bootstrap data needs to be posted to the API.