Create Table for Catalog Table

[ThatMegamind]

Instructions

• Using the DB model provided, write a CREATE TABLE statement in SQL for the Catalog table.
• Drop the table if it already exists.

Notes

• For now, assume that all attributes should be NOT NULL unless otherwise specified.
• Arrows on the DB model indicate foreign key constraints
• For any ENUM fields, make sure to define them in a line above the CREATE TABLE statement.

Acceptance Criteria

• SQL creation code should exist in a file located in server/schema/catalog.sql

Resources

• DB Model
• Create Table Tutorial
• Creating Enums Tutorial