zinzinthan / budgetmvcapp Goto Github PK

USE [DotNetCore] GO /****** Object: Table [dbo].[Tbl_Budget] Script Date: 19-Feb-24 1:35:49 PM / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Tbl_Budget]( [BudgetId] [int] IDENTITY(1,1) NOT NULL, [UserId] [int] NOT NULL, [BudgetName] nvarchar NOT NULL, [Budget] [int] NOT NULL, [BudgetCreationDate] [datetime] NOT NULL, CONSTRAINT [PK_Tbl_Budget] PRIMARY KEY CLUSTERED ( [BudgetId] 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 / Object: Table [dbo].[Tbl_Expense] Script Date: 19-Feb-24 1:35:50 PM / SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Tbl_Expense]( [ExpenseId] [int] IDENTITY(1,1) NOT NULL, [BudgetId] [int] NOT NULL, [ExpenseName] nvarchar NOT NULL, [Amount] [int] NOT NULL, [ExpenseDateTime] [datetime] NOT NULL, CONSTRAINT [PK_Tbl_Expense] PRIMARY KEY CLUSTERED ( [ExpenseId] 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 / Object: Table [dbo].[Tbl_Users] Script Date: 19-Feb-24 1:35:50 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Tbl_Users]( [UserId] [int] IDENTITY(1,1) NOT NULL, [UserName] nvarchar NOT NULL, [PhoneNumber] nvarchar NOT NULL, CONSTRAINT [PK_Tbl_Users] PRIMARY KEY CLUSTERED ( [UserId] 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

////////////////////////////////////////////////////////////////////////////////////////////////////