USER STORY: Define Tables and Relationships

[emidombek]

User Story: Define Tables and Relationships

User Story: As a developer, I want to define the tables and relationships in the database schema based on the initial design.

Acceptance Criteria:

1. Create individual tables for each entity in the schema.
2. Define relationships (e.g., one-to-many, many-to-many) between tables.
3. Ensure referential integrity through foreign key constraints.
4. Implement any required join tables for many-to-many relationships.
5. Verify that the schema aligns with the initial design.

Tasks:

• [x] Create database tables for each entity.
• [x] Define relationships between tables.
• [x] Add foreign key constraints to enforce referential integrity.
• [x] Implement join tables for many-to-many relationships.
• [x] Review the schema to confirm alignment with the design.

[emidombek]

See spreadsheet for models here and Database Design Documentation here

[emidombek]

All tasks complete