CREATE TABLE users (
    id          BLOB PRIMARY KEY,
    userName    TEXT NOT NULL,
    mainChannel BLOB NOT NULL,
    FOREIGN KEY (mainChannel) REFERENCES channels (id)
);

CREATE TABLE actors (
    id           TEXT PRIMARY KEY,
    inbox        TEXT,
    outbox       TEXT,
    followers    TEXT,
    following    TEXT,
    accountName  TEXT NOT NULL,
    displayName  TEXT,
    bio          TEXT,
    keyId        TEXT NOT NULL,
    publicKeyPem BLOB NOT NULL,
    locked       BOOL NOT NULL,
    type         TEXT NOT NULL
);

CREATE TABLE channels (
    id            BLOB PRIMARY KEY,
    linkedActorId TEXT NOT NULL,
    privateKeyPem BLOB NOT NULL,
    FOREIGN KEY (linkedActorId) REFERENCES actors (id)
);

CREATE TABLE channel_owners (
    channelId BLOB NOT NULL,
    userId BLOB NOT NULL,
    FOREIGN KEY (channelId) REFERENCES channels (id),
    FOREIGN KEY (userId) REFERENCES users (id)
);