-- Schema
CREATE TABLE IF NOT EXISTS transactions (
    id BIGINT PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
    membre_id VARCHAR(7) NOT NULL,
    given_at TIMESTAMP DEFAULT current_timestamp,
    is_perpetual BOOLEAN NOT NULL
);