farzinmonsef
commented
4 years ago USE [EQM] GO
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
Drop table [dbo].[Transaction] Go
CREATE TABLE [dbo].[Transaction]( Id [int] IDENTITY(1,1) NOT NULL, TransactionType [int] NULL, TodayDate [datetime] NULL, TransactionEffectiveDate [datetime] NULL, RequisitionNumber [int] NULL, ReserveName varchar NULL, TotalVestedShares [float] NULL, Memo varchar NULL, Attachments varchar NULL, Status[int] NULL, Actions[int] NULL
CONSTRAINT [PK_Id] PRIMARY KEY NONCLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] GO
• Transaction Type • Today’s Date • Transaction Effective Date • Requisition Number • Reserve Name • Total Vested Shares • Memo (in the overflow panel) • Attachments icon (see attached) • Status • Actions –icons for edit and delete (see attached)