teamMemberTb

30 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team_id, user_id, role, joined_at, joined_at (date)

CREATE TABLE teamMemberTb (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            team_id INTEGER NOT NULL,
            user_id INTEGER NOT NULL,
            role TEXT NOT NULL DEFAULT 'member',
            joined_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
            UNIQUE(team_id, user_id)
        );
CREATE INDEX idx_team_member_team ON teamMemberTb(team_id);
CREATE INDEX idx_team_member_user ON teamMemberTb(user_id);