CREATE TABLE IF NOT EXISTS network_lexicons (
    id TEXT PRIMARY KEY,
    nsid TEXT NOT NULL UNIQUE,
    authority_did TEXT NOT NULL,
    target_collection TEXT,
    last_fetched_at TEXT,
    created_at TEXT NOT NULL DEFAULT (datetime('now'))
);