source: backend/src/main/resources/authentication-table.sql

CREATE TABLE IF NOT EXISTS project.user_credentials (
                                                        user_id INTEGER NOT NULL,
                                                        password_hash VARCHAR(255) NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

    CONSTRAINT pk_user_credentials PRIMARY KEY (user_id),

    CONSTRAINT fk_user_credentials_users FOREIGN KEY (user_id)
    REFERENCES project.users(user_id)
    ON DELETE CASCADE
    ON UPDATE CASCADE
    );