1  CREATE TABLE organizations (
 2      id UUID PRIMARY KEY DEFAULT generate_uuid_v7(),
 3      name TEXT NOT NULL UNIQUE,
 4      slug TEXT GENERATED ALWAYS AS (
 5          lower(trim(both '-' FROM regexp_replace(name, '[^a-zA-Z0-9]+', '-', 'g')))
 6      ) STORED UNIQUE,
 7      domain TEXT UNIQUE,
 8      symbol_asset_id UUID REFERENCES assets(id),
 9      created_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
10      modified_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP
11  );