AI 상태를 위한 이동 가능한 운영 계층

CREATE SCHEMA grid
  AUTHORIZATION enginegrids;

CREATE TABLE grid.base_actions (
  id uuid PRIMARY KEY,
  subject_id uuid NOT NULL,
  requested_by uuid NOT NULL,
  requested_at timestamptz NOT NULL DEFAULT now(),
  status text NOT NULL
);

CREATE TABLE stripe.invoices (
  invoice_id uuid NOT NULL,
  customer_id uuid NOT NULL,
  payment_method_id uuid,
  currency_code text NOT NULL,
  amount_due numeric(12, 6) NOT NULL
) INHERITS (grid.base_actions);

CREATE TABLE platform.audits (
  id uuid PRIMARY KEY,
  object_schema text NOT NULL,
  object_name text NOT NULL,
  action_name text NOT NULL,
  request jsonb NOT NULL,
  response jsonb,
  create_ts timestamptz NOT NULL DEFAULT now()
) WITH (
  autovacuum_enabled = true
);