Is This A Valid Table Schema

GO

CREATE TABLE [dbo].[CmnLanguage]
(
 [Id] [char](2) NOT NULL CONSTRAINT PkCmnLanguage_Id PRIMARY KEY,
 [UniqueName] [varchar](26) NOT NULL,
 [NativeName] [nvarchar](26) NOT NULL,
 [DirectionType] [smallint] NOT NULL,
 [IsVisible] [bit] NOT NULL,
 [CreatedDateTime] [datetime] NOT NULL DEFAULT GETDATE(),
 [ModifiedDateTime] [datetime] NULL
)

 GO

CREATE TABLE [dbo].[CmnLink]
(
 [Id] [int] IDENTITY(1,1) NOT NULL CONSTRAINT PkCmnLink_Id PRIMARY KEY,
 [UniqueName] [varchar](52) NOT NULL,
 [IsVisible] [bit] NOT NULL,
 [CreatedDateTime] [datetime] NOT NULL DEFAULT GETDATE(),
 [ModifiedDateTime] [datetime] NULL
)

GO

CREATE TABLE [dbo].[CmnLinkCmnLanguage]
(
 [LinkId] [int] NOT NULL CONSTRAINT FkCmnLinkCmnLanguage_LinkId FOREIGN KEY (LinkId) REFERENCES CmnLink(Id) ON DELETE CASCADE,
 [LanguageId] [char](2) NOT NULL CONSTRAINT FkCmnLinkCmnLanguage_LanguageId FOREIGN KEY (LanguageId) REFERENCES CmnLanguage(Id) ON UPDATE CASCADE ON DELETE CASCADE,
 [CreatedDateTime] [datetime] NOT NULL DEFAULT GETDATE(),
 [ModifiedDateTime] [datetime] NULL
)