Untitled

CREATE TABLE [dbo].[A2ARecords](
	[Ticker] [nvarchar](2048) NULL,
	[Issuer] [nvarchar](max) NULL,
	[ResourceProvider] [nvarchar](256) NULL,
	[StartDate] [date] NULL,
	[EndDate] [date] NULL,
	[StartTime] [nvarchar](8) NULL,
	[EndTime] [nvarchar](8) NULL,
	[Location] [nvarchar](256) NULL,
	[Region] [nvarchar](256) NULL,
	[Format] [nvarchar](256) NULL,
	[Value] [float] NULL,
	[Currency] [nvarchar](3) NULL,
	[Title] [nvarchar](max) NULL,
	[AggregatedStatus] [nvarchar](256) NULL,
	[Attendee] [nvarchar](256) NULL,
	[Status] [nvarchar](256) NULL,
	[IsReviewRequired] [bit] NULL,
	[Note] [nvarchar](max) NULL,
	[Team] [nvarchar](256) NULL,
	[CreatedAt] [datetime] NULL,
	[LastUpdate] [datetime] NULL,
	[CreatedBy] [nvarchar](256) NULL,
	[LastUpdateBy] [nvarchar](256) NULL,
	[InOffice] [bit] NULL,
	[AllDay] [bit] NULL,
	[CreatedByIngestor] [bit] NULL,
	[Id] [nvarchar](256) NULL,
	[UniqueId] [nvarchar](256) NULL,
	[EventId] [int] NULL,
	[BuysideStatus] [nvarchar](256) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO



-------------------------------------------------------------------------------





CREATE TABLE [core].[BrokerCommission](
	[TradeDate] [date] NOT NULL,
	[Account] [nvarchar](20) NOT NULL,
	[BrokerCode] [nvarchar](20) NOT NULL,
	[ParentBroker] [nvarchar](20) NOT NULL,
	[BrokerName] [nvarchar](20) NOT NULL,
	[SecType] [nvarchar](10) NOT NULL,
	[TotalCommission] [decimal](28, 6) NOT NULL,
	[Shares] [decimal](28, 12) NOT NULL,
	[Timestamp] [datetime] NOT NULL,
 CONSTRAINT [PK_BrokerCommission] PRIMARY KEY CLUSTERED 
(
	[TradeDate] ASC,
	[Account] ASC,
	[BrokerCode] ASC,
	[ParentBroker] ASC,
	[BrokerName] ASC,
	[SecType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

ALTER TABLE [core].[BrokerCommission] ADD  CONSTRAINT [DF_BrokerCommission_Timestamp]  DEFAULT (getdate()) FOR [Timestamp]
GO