Skip to content

Instantly share code, notes, and snippets.

@nishanc

nishanc/Script.sql

Last active May 4, 2021
Embed
What would you like to do?
CREATE TABLE [TPCStudents] (
[Id] int NOT NULL IDENTITY,
[CGPA] nvarchar(max) NULL,
[Major] nvarchar(max) NULL,
[Username] nvarchar(max) NOT NULL,
[Email] nvarchar(max) NOT NULL,
CONSTRAINT [PK_TPCStudents] PRIMARY KEY ([Id])
);
CREATE TABLE [TPCTeachers] (
[Id] int NOT NULL IDENTITY,
[Designation] nvarchar(max) NULL,
[Speciality] nvarchar(max) NULL,
[Username] nvarchar(max) NOT NULL,
[Email] nvarchar(max) NOT NULL,
CONSTRAINT [PK_TPCTeachers] PRIMARY KEY ([Id])
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment