Data models,
as plain text.

entity customer {
  description "A registered buyer."
  term Customer
  attribute id : bigint not null
  attribute email : domain email
  attribute full_name : text(200) not null
  attribute created_at : timestamptz not null default expr "now()"
  key primary pk_customer (id)
  key unique uq_customer_email (email)
}

CREATE TABLE public.customer (
  id bigint NOT NULL GENERATED ALWAYS AS IDENTITY,
  email varchar(320) NOT NULL,
  full_name varchar(200) NOT NULL,
  created_at timestamp with time zone NOT NULL DEFAULT now(),
  CONSTRAINT pk_customer PRIMARY KEY (id),
  CONSTRAINT uq_customer_email UNIQUE (email),
  CONSTRAINT ck_customer_email CHECK (email ~ '^[^@]+@[^@]+$')
);