PRIMARY KEY CLUSTERED ([Id] ASC)
CREATE TABLE [dbo].[DataAdditional] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Alpha] INT NULL,
[Bravo] BIGINT NULL,
[Charlie] BIGINT NULL,
[Delta] INT NULL,
[Echo] INT NULL,
[Foxtrot] INT NULL,
[Golf] INT NULL,
[Hotel] NVARCHAR (MAX) NULL
-- , PRIMARY KEY CLUSTERED ([Id] ASC)
);
DB dbA = new DB();
dbA.Id = 0;
db.ParentId = null;
DB dbB = new DB();
dbB.Id = 1;
dbB.ParentId = 0;
DB dbC = new DB();
dbC.Id = 2;
dbC.ParentId = 0;
DB dbD = new DB();
dbD.Id = 3;
dbD.ParentId = 2;
dbA (id=0)
|---dbB (id=1)
|---dbC (id=2)
|---dbD (id=3)