CREATE TABLE [dbo].[al_notes]
(
[note_id] [bigint] NOT NULL,
[notype] [bigint] NULL,
[nodate] [datetime] NULL,
[notime] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[text] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[contact_uuid] [binary] (16) NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [df__al_notes__versi__38ee7070] DEFAULT ('0'),
[tenant] [binary] (16) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[al_notes] ADD CONSTRAINT [pkal_notes] PRIMARY KEY CLUSTERED ([note_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [noindex01] ON [dbo].[al_notes] ([notype]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_notes] ADD CONSTRAINT [fk_al_notes_tenant] FOREIGN KEY ([tenant]) REFERENCES [dbo].[ca_tenant] ([id])
GO
ALTER TABLE [dbo].[al_notes] ADD CONSTRAINT [NODLJOIN01] FOREIGN KEY ([notype]) REFERENCES [dbo].[arg_dl_note_types] ([id])
GO
ALTER TABLE [dbo].[al_notes] ADD CONSTRAINT [NOINJOIN02] FOREIGN KEY ([contact_uuid]) REFERENCES [dbo].[ca_contact] ([contact_uuid])
GO