Tables [Tzdb].[Links]
BUILD09 > MoversSuite2 > Tables > Tzdb.Links
Properties
PropertyValue
HeapYes
Row Count (~)206
Created7:29:31 PM Tuesday, September 24, 2024
Last Modified7:29:43 PM Tuesday, September 24, 2024
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key PK_Links: LinkZoneIdForeign Keys FK_Links_Zones_1: [Tzdb].[Zones].LinkZoneIdLinkZoneIdint4
No
Foreign Keys FK_Links_Zones_2: [Tzdb].[Zones].CanonicalZoneIdCanonicalZoneIdint4
No
Indexes Indexes
NameColumnsUnique
Primary Key PK_Links: LinkZoneIdPK_LinksLinkZoneId
Yes
Foreign Keys Foreign Keys
NameColumns
FK_Links_Zones_2CanonicalZoneId->[Tzdb].[Zones].[Id]
FK_Links_Zones_1LinkZoneId->[Tzdb].[Zones].[Id]
SQL Script
CREATE TABLE [Tzdb].[Links]
(
[LinkZoneId] [int] NOT NULL,
[CanonicalZoneId] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [Tzdb].[Links] ADD CONSTRAINT [PK_Links] PRIMARY KEY NONCLUSTERED  ([LinkZoneId]) ON [PRIMARY]
GO
ALTER TABLE [Tzdb].[Links] ADD CONSTRAINT [FK_Links_Zones_2] FOREIGN KEY ([CanonicalZoneId]) REFERENCES [Tzdb].[Zones] ([Id])
GO
ALTER TABLE [Tzdb].[Links] ADD CONSTRAINT [FK_Links_Zones_1] FOREIGN KEY ([LinkZoneId]) REFERENCES [Tzdb].[Zones] ([Id])
GO
Uses
Created 25 September 2024 15:31
Copyright  2024 - All Rights Reserved