Create 7 Gold Bridge tables in gld schema and add them to the semantic model

Title: Create 7 Gold Bridge tables in gld schema and add them to the semantic model

User Story:
I want to design and implement bridge tables in the gld schema,
So that many-to-many relationships between Facts and Dimensions are properly modeled and usable in the semantic model.

Acceptance Criteria:
DDL scripts created for the following bridge tables in gld schema:
gld.ApplicationDelayBridge
gld.IncidentCategoryBridge
gld.IncidentComplianceArticleBridge
gld.InspectionLocationBridge
gld.NonComplianceLegislationBridge
gld.NonCompliancePermitBridge
gld.OrderStopDetailBridge

Each bridge table uses surrogate keys and includes an “Unknown” (-1) row.
PK and FK (NOT ENFORCED) constraints defined to reference related Fact/Dim tables.

Tables deployed successfully in the Fabric Warehouse (MDP-DWH).
All bridge tables are added into the Gold semantic model with correct relationships.
Model is validated in Direct Lake mode for query performance and joins.

Additional Notes / References:
Use existing staging views (dbo.v_*Bridge) as design references.
Ensure naming conventions align with other gld schema objects.
Related issues: Create MDP-DWH Gold semantic model, Design/migrate Gold Fact/Dim tables