Datamodel and Entities

Перелік таблиць з посиланнями

Datamodel

Auditories

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Amount	int, not null
Name	nvarchar(100)
Description	nvarchar(500)
BuildingId, FK	int, not null
TypeId, FK	int, not null
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

AuditoryTypes

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(100)
Description	nvarchar(500)
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Buildings

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(100)
Description	nvarchar(500)
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Disciplines

Attribute	Type	Description	Mapping to University
Id
Name	nvarchar(max)
Description	nvarchar(max)
Semester	int, not null
Year	int, not null
SpecialtyId, FK	int, not null
SubjectId, FK	int, not null
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Faculties

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(100)
Description	nvarchar(500)
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Groups

Attribute	Type	Description	Mapping to University
Id, PK	int not null
Name	nvarchar(100)
Description	nvarchar(500)
Semester	int, not null
Year	int, not null
SpecialtyId, FK	int, not null
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

ScheduleInSubGroup

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
ScheduleId, FK	int, not null
SubGroupId, FK	int, not null
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Schedules

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(100)
Description	nvarchar(500)
IsOddWeek	int, not null
LessonNumber	int, not null
WeekDay	int, not null
AuditoryId	int, not null
ScheduleTypeId	int, not null
SubjectId	int, not null
TeacherId	int, not null
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

ScheduleTypes

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(100)
Description	nvarchar(500)
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Specialties

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(100)
Description	nvarchar(500)
FacultyId, FK	int, not null
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Students

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(255), not null
RecordBook	int, not null
StudentIdCard	int, not null
ApplicationUserId	nvarchar(450)
GroupId	int, not null
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

SubGroups

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(100)
GroupId	int, not null
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Subjects

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(100)
Description	nvarchar(500)
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Teachers

Attribute	Type	Description	Mapping to University
Id, PK	int, not null
Name	nvarchar(100), not null
Email	nvarchar(200), not null
Phone	nvarchar(10), not null
ApplicationUserId	nvarchar(450)
GroupId	int, not null
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime

Test

Attribute	Type	Description	Mapping to University
CreatedBy	nvarchar(max)
CreatedOn	datetime, not null
ModifiedBy	nvarchar(max)
ModifiedOn	datetime