SQLite Forum

3.31.1: create table with multiple primary key columns
Login
> Note that the columns in a primary key must be constrained NOT NULL for a "without rowid" table.

I assumed that since the exsite_id column must match a value in the WeatherSites(wxsite_id) column that 'not null' was implicit.

> The keyword "constraint" 

Oops! I forgot that. Thanks.

> The keywords WITHOUT ROWID to designate that a table does not have a rowid is a qualifier of the table, not of the contents in the table. As such it follows the ()'s delimiting the contents of the table.

I must have missed that when reading the syntax page. 

Data are entered by users, not automatically.

Thanks,

Rich