It can't create record on composite primary key table

I want to create record to below table.

		product_color {
			int product_id FK "[NOT NULL] Product ID"
			int color_id FK "[NOT NULL] Color ID"
			timestamp created_at "[NOT NULL] Crated Datetime"


how can I specify product_id on create record?

as a side note, It can specify on update.

@daichi Unfortunately, we do not support composite primary keys.

1 Like