AI PostgreSQL schema generator

CREATE TABLE analytics.dim_customer (
  customer_sk   TEXT          NOT NULL PRIMARY KEY,
  customer_id   TEXT          NOT NULL,
  name          TEXT,
  plan_id       TEXT,
  valid_from    DATE          NOT NULL,
  valid_to      DATE,
  metadata      JSONB         DEFAULT '{}'::jsonb,
  CHECK (valid_to IS NULL OR valid_to >= valid_from)
);

CREATE INDEX idx_dim_customer_customer_id
  ON analytics.dim_customer (customer_id, valid_from);

CREATE TABLE analytics.fct_usage (
  usage_id      TEXT          NOT NULL,
  customer_sk   TEXT          NOT NULL,
  plan_id       TEXT          NOT NULL,
  event_ts      TIMESTAMPTZ   NOT NULL,
  api_calls     BIGINT        NOT NULL,
  PRIMARY KEY (usage_id, event_ts)
) PARTITION BY RANGE (event_ts);

CREATE TABLE analytics.fct_usage_2026_05
  PARTITION OF analytics.fct_usage
  FOR VALUES FROM ('2026-05-01') TO ('2026-06-01');