CW Data Relationships

Introduction

The central custom data types and database entities in Government Contract Writing (CW) are associated with solicitations, awards, vendors, tasks, line items, documents, Other Transaction Agreements (OTs), and more. Understanding the relationships between these entities can help you understand how the data in the application works together.

The entity relationship diagrams (ERD) on this page illustrate the main entities used in the Government Contract Writing solution and their relationships to each other.

CW ERD

This ERD covers two things. First, the diagram illustrates the main relationships between the solicitations and awards in the CW solution. Second, it provides a graphic overview of the tables used for the reference list of all solicitations and awards in the CW solution.

Solicitation ERD

This ERD describes the relationships between the solicitation parent and child CDTs.

Solicitation and Award ERD

This ERD describes the relationships between the solicitation and award CDTs.

Solicitation and Line Item ERD

This ERD describes the relationships between the solicitation and line item CDTs.

Solicitation and Task ERD

This ERD describes the relationships between the solicitation and task CDTs.

Solicitation, Award, and OTs ERD

This ERD describes the relationships between the solicitation, award, documents, and OTs CDTs.

Feedback