It can't create record on composite primary key table

How to
#1

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"
	}

image

how can I specify product_id on create record?

as a side note, It can specify on update.

#2

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

1 Like