01-create-0001-customers-table.sql

CREATE TABLE customers
(
    id         uuid         NOT NULL DEFAULT gen_random_uuid(),
    name       varchar(128) 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),
    UNIQUE (name)
);