Hire Expert
CockroachDB Developers

-- CockroachDB geo-distributed table
CREATE TABLE users (
  id        UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  email     TEXT UNIQUE NOT NULL,
  region    TEXT NOT NULL CHECK (region IN ('us-east', 'eu-west', 'ap-south')),
  created_at TIMESTAMPTZ DEFAULT now()
) PARTITION BY LIST (region);

CREATE TABLE users_us PARTITION OF users FOR VALUES IN ('us-east');
CREATE TABLE users_eu PARTITION OF users FOR VALUES IN ('eu-west');
CREATE TABLE users_ap PARTITION OF users FOR VALUES IN ('ap-south');

-- Pin each partition to its home region
ALTER PARTITION users_us OF TABLE users CONFIGURE ZONE USING constraints = '[+region=us-east-1]';