
[dbo].[arg_link_location_note]
CREATE TABLE [dbo].[arg_link_location_note]
(
[location_uuid] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__ARG_LINK___VERSI__29E1370A] DEFAULT ('0 '),
[tenant] [binary] (16) NULL,
[note_id] [bigint] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_link_location_note] ADD CONSTRAINT [xpkarg_link_location_note] PRIMARY KEY CLUSTERED ([location_uuid], [note_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_link_location_note] ADD CONSTRAINT [FK_LINK_LOCATION_NOTE_TENANT] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[arg_link_location_note] ADD CONSTRAINT [LLONOJOIN01] FOREIGN KEY ([location_uuid]) REFERENCES [dbo].[ca_location] ([location_uuid])
GO
ALTER TABLE [dbo].[arg_link_location_note] ADD CONSTRAINT [LLONOJOIN02] FOREIGN KEY ([note_id]) REFERENCES [dbo].[al_notes] ([note_id])
GO