gistfile1.txt

CREATE TABLE IF NOT EXISTS event_user_invitation (
    event_id TEXT NOT NULL REFERENCES event(id) ON DELETE CASCADE,
    invited_user_id TEXT NOT NULL REFERENCES user$(id) ON DELETE CASCADE,
    invited_group_id TEXT REFERENCES friend_group(id) ON DELETE CASCADE,
    inviting_user_id TEXT NOT NULL REFERENCES user$(id) ON DELETE CASCADE,
    created_at TIMESTAMP NOT NULL,
    PRIMARY KEY (event_id, invited_user_id, inviting_user_id)
);

CREATE TABLE IF NOT EXISTS event_group_invitation (
    event_id TEXT NOT NULL REFERENCES event(id) ON DELETE CASCADE,
    invited_group_id TEXT REFERENCES friend_group(id) ON DELETE CASCADE,
    created_at TIMESTAMP NOT NULL,
    PRIMARY KEY (event_id, invited_group_id)