1CREATE TABLE "feature_flags" (
 2    "id" SERIAL PRIMARY KEY,
 3    "flag" VARCHAR(255) NOT NULL UNIQUE
 4);
 5
 6CREATE UNIQUE INDEX "index_feature_flags" ON "feature_flags" ("id");
 7
 8CREATE TABLE "user_features" (
 9    "user_id" INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
10    "feature_id" INTEGER NOT NULL REFERENCES feature_flags(id) ON DELETE CASCADE,
11    PRIMARY KEY (user_id, feature_id)
12);
13
14CREATE UNIQUE INDEX "index_user_features_user_id_and_feature_id" ON "user_features" ("user_id", "feature_id");
15CREATE INDEX "index_user_features_on_user_id" ON "user_features" ("user_id");
16CREATE INDEX "index_user_features_on_feature_id" ON "user_features" ("feature_id");