jl-backend-rs/migrations/2_agent.sql

CREATE TABLE IF NOT EXISTS "agent" (
    id UUID PRIMARY KEY,
    shortcode VARCHAR UNIQUE NOT NULL,
    full_name VARCHAR NOT NULL,
    credential VARCHAR NOT NULL,
    credential_type VARCHAR NOT NULL,
    profile_picture_url VARCHAR NOT NULL,
    time_created TIMESTAMPTZ NOT NULL,
    last_updated TIMESTAMPTZ NOT NULL
);