shared/database/local/setup/009-GroupTable.sql

CREATE TABLE "Group" (
    "shorthand" VARCHAR(128) PRIMARY KEY,
    "googleID" VARCHAR(512) NOT NULL,
    "name" TEXT NOT NULL,
    "primaryEmail" VARCHAR(512) NOT NULL,
    "otherEmails" VARCHAR(512)[]
);