Package - Feature

The PackageFeature table is a many-to-many relationship table between the Package and Feature tables. It stores the relationship between packages and features, as well as any additional information about the relationship, such as feature values.

Table Structure

• [ID] (bigint, auto-incrementing, primary key): Represents the unique identifier for each record.

• [Package_ID] (bigint, not null): Represents the ID of the package associated with the feature.

• [Feature_ID] (bigint, not null): Represents the ID of the feature associated with the package.

• [Feature_Values] (int, nullable): Represents any additional values associated with the feature in the package.

• [Modified_By] (bigint, nullable): Represents the ID of the user who last modified the record.

• [Modified_Date] (datetime, not null): Represents the date and time when the record was last modified.

• [Created_By] (bigint, nullable): Represents the ID of the user who created the record.

• [Created_Date] (datetime, not null): Represents the date and time when the record was created.

Constraints

• [PK_PackageFeature]: Primary key constraint on the [ID] column.

• [UK_PackageFeature]: Unique constraint on the combination of [Package_ID] and [Feature_ID] columns.

• [FK_PackageFeature_Feature]: Foreign key constraint on the [Feature_ID] column, referencing the [ID] column of the [JFW].[Feature] table.

• [FK_PackageFeature_Package]: Foreign key constraint on the [Package_ID] column, referencing the [ID] column of the [JFW].[Package] table.

Usage

The PackageFeature table is used to:

• Associate features with packages.

• Store additional information about the relationship between packages and features.

• Manage feature values specific to each package.