daxxer sql challenge

tables.sql

CREATE TABLE workspaces (
    id SERIAL PRIMARY KEY,
    name VARCHAR(255) NOT NULL
);

CREATE TABLE users (
    id SERIAL,
    workspace_id INT NOT NULL,
    email VARCHAR(255) NOT NULL,
    PRIMARY KEY (workspace_id, id),
    FOREIGN KEY (workspace_id) REFERENCES workspaces(id),
    UNIQUE (workspace_id, email)
);

CREATE INDEX idx_users_email ON users(email);

CREATE TABLE orders (
    id SERIAL,
    workspace_id INT NOT NULL,
    user_id INT NOT NULL,
    data JSONB NOT NULL,
    PRIMARY KEY (workspace_id, id),
    FOREIGN KEY (workspace_id, user_id) REFERENCES users(workspace_id, id),
    UNIQUE (workspace_id, user_id, id)
);

CREATE INDEX idx_orders_user ON orders(workspace_id, user_id);