SQLite Forum

3.31.1: create table with multiple primary key columns
Login
I want to confirm I'm using correct syntax for a table with multiple columns as the primary key:

create table WeatherData (
    wxsite_id INT references WeatherSites(wxsite_id)
       on delete cascade on update cascade,
    sampdate TEXT,
    samptime TEXT,
    sampby TEXT,
    wxparam_name TEXT references WeaatherParams(wxparam_name)
       on delete cascade on update cascade,
    wxquant REAL,
    notes TEXT,
    constraint primary key (wxsite_id, sampdate, samptime, wxparam_name),
    without rowid
    );

Is this correct?