Database.txt

USE [Online Tutor]
GO
/****** Object:  Table [dbo].[apply]    Script Date: 6/1/2023 8:35:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[apply](
	[apply_id] [int] IDENTITY(1,1) NOT NULL,
	[std_id] [int] NULL,
	[tid] [int] NULL,
	[slot] [varchar](max) NULL,
	[aproval_status] [int] NULL,
	[tutor_address] [varchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[apply_id] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[dr]    Script Date: 6/1/2023 8:35:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dr](
	[std_id] [int] IDENTITY(1,1) NOT NULL,
	[fname] [varchar](max) NULL,
	[lname] [varchar](max) NULL,
	[gender] [varchar](10) NULL,
	[phone_no] [varchar](max) NULL,
	[password] [varchar](max) NULL,
	[classlevel] [varchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[std_id] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[tutor]    Script Date: 6/1/2023 8:35:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tutor](
	[tid] [int] IDENTITY(1,1) NOT NULL,
	[fname] [varchar](max) NULL,
	[lname] [varchar](max) NULL,
	[gender] [varchar](10) NULL,
	[phone_no] [varchar](max) NULL,
	[city] [varchar](max) NULL,
	[password] [varchar](max) NULL,
	[subject] [varchar](max) NULL,
	[class_t] [varchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[tid] 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] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[apply]  WITH CHECK ADD FOREIGN KEY([std_id])
REFERENCES [dbo].[dr] ([std_id])
GO
ALTER TABLE [dbo].[apply]  WITH CHECK ADD FOREIGN KEY([tid])
REFERENCES [dbo].[tutor] ([tid])
GO