SQL Syntax Error - error at or near end

Can someone help me find the error? I am a little confused -

CREATE TYPE expires AS ENUM (
    'never',
    '1h',
    '2h',
    '10h',
    '1d',
    '2d',
    '1w',
    '1m',
    '1y'
);
CREATE TABLE snips (
    id varchar(255) PRIMARY KEY,
    code TEXT NOT NULL,
    password TEXT,
    language TEXT,
    expires_in expires,
    created_at TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    user_id UUID,
    CONSTRAINT user FOREIGN KEY(user_id) REFERENCES user(id)
)


By running it, it's showing up an error as Failed to validate sql query: syntax error at or near "user"

Can someone help me resolve this issue?
Was this page helpful?