Pelton currently doesn't support the creation of Primary keys involving multiple table columns. This can be necessary in some tables as some combination of columns might be required for the unique identification of entries
Here is an example of a table where this is necessary. Running this create table with the current version of Pelton errors:
CREATE TABLE questions (lec int, q int, question text, PRIMARY KEY (lec, q));
Pelton currently doesn't support the creation of Primary keys involving multiple table columns. This can be necessary in some tables as some combination of columns might be required for the unique identification of entries
Here is an example of a table where this is necessary. Running this create table with the current version of Pelton errors:
CREATE TABLE questions (lec int, q int, question text, PRIMARY KEY (lec, q));