How can I resolve this issue?
Once you make ID the PK you won't have any trouble adding the foreign key. You will have to change the partitioning. You can still partition by ID if you want.
Or you could have one column that is both the PK and the timestamp, eg Generate a unique time-based id on a table in SQL Server