app_access

0 rows where app_id = "01kwjk7289pmy4h2xrkpct13y5"

✎ View and edit SQL

This data as json

id ▼ app_id action subject_type subject_id allow created_at updated_at

0 records

CREATE TABLE app_access (
    id INTEGER PRIMARY KEY,
    app_id TEXT REFERENCES apps(id),
    action TEXT NOT NULL,
    subject_type TEXT NOT NULL,
    subject_id TEXT,
    allow INTEGER NOT NULL DEFAULT 1,
    created_at TEXT NOT NULL,
    updated_at TEXT NOT NULL,
    CHECK (subject_type IN ('authenticated')),
    CHECK (allow IN (0, 1))
);
CREATE INDEX idx_app_access_lookup
    ON app_access(action, app_id, subject_type, subject_id);