01-create-0003-orders-table.sql

CREATE TABLE orders
(
    id          uuid                        NOT NULL DEFAULT gen_random_uuid(),
    customer_id uuid                        NOT NULL,
    product_id  uuid                        NOT NULL,
    amount      smallint                    NOT NULL,

    created_at  timestamp without time zone NOT NULL DEFAULT (current_timestamp AT TIME ZONE 'UTC'),
    updated_at  timestamp without time zone NOT NULL DEFAULT (current_timestamp AT TIME ZONE 'UTC'),
    created_by  varchar(256)                NOT NULL DEFAULT current_user,
    updated_by  varchar(256)                NOT NULL DEFAULT current_user,

    PRIMARY KEY (id),
    FOREIGN KEY (customer_id)
        REFERENCES customers (id)
        ON DELETE CASCADE
        ON UPDATE CASCADE,
    FOREIGN KEY (product_id)
        REFERENCES products (id)
        ON DELETE CASCADE
        ON UPDATE CASCADE
);