SQL Server GDB - Create Node And Edge Tables

create_node_and_edge.sql

IF OBJECT_ID('dbo.Entity', 'U') IS NOT NULL
  DROP TABLE dbo.Entity
GO

-- Create Entity as NODE table
CREATE TABLE dbo.Entity
(
    [ID] INTEGER PRIMARY KEY IDENTITY,
    [Name] VARCHAR(100) NOT NULL,
    [Code] VARCHAR(100) NULL,	
    [Type] VARCHAR(100) NOT NULL 
)
AS NODE
GO

IF OBJECT_ID('dbo.Subsidiaries', 'U') IS NOT NULL
  DROP TABLE dbo.Subsidiaries
GO

-- Create Subsidiaries as Edge table
CREATE TABLE dbo.Subsidiaries 
(
	HoldingPercentage DECIMAL(5,2),
	EffectiveDate DATE
) AS EDGE;