in a relation, can you reference another scalar id on another table? or can it only be the

id

PK of the table. like on the table if you have

postId BigInt @map("post_id")

@@id([id, postId])

can i reference this

postId

on a relation?

You can refer to another scalar id but that should be unique, so you can add

@unique

to make the field unique.