I have create two tables (Project and ProjectStatus) with multiple fields, where both tables contain one field with foreign key.
These are the deployment scripts created:
00100: creates the table ProjectStatus
00200: creates the table Project
00300: creates FKs for both tables so the name should reflect that and be for example:
“00300_Database_Entity_FK_Project_ProjectStatus” or similar.
Single FK has name as such “00060_Database_Entity_FK_Task_refPriorityId_Priority”, so there should be clear from the name that the script is for FKs and that it belongs to multiple entities.