﻿-- Table: platform
CREATE TABLE [platform] (
    [platform_id] int NOT NULL,
    [platform_gobject_id] int NOT NULL,
    [node_name] nvarchar(256) NOT NULL DEFAULT (''),
    [last_deployed_node_name] nvarchar(256) NOT NULL DEFAULT (''),
    [rmcNode_name] nvarchar(256) NOT NULL DEFAULT (''),
    [last_deployed_rmcNode_name] nvarchar(256) NOT NULL DEFAULT (''),
    [portNMX] int NOT NULL DEFAULT ((0)),
    [last_deployed_portNMX] int NOT NULL DEFAULT ((0)),
    [portRMC] int NOT NULL DEFAULT ((0)),
    [last_deployed_portRMC] int NOT NULL DEFAULT ((0)),
    [portRPC] int NOT NULL DEFAULT ((0)),
    [last_deployed_portRPC] int NOT NULL DEFAULT ((0)),
    CONSTRAINT [PK_platform] PRIMARY KEY ([platform_gobject_id], [platform_gobject_id])
);
GO

ALTER TABLE [platform] ADD FOREIGN KEY ([platform_gobject_id]) REFERENCES [gobject] ([gobject_id]);
GO

