public CountryMapping()
{
Table("`country`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.CountryCode, "countryCode");
Map(x => x.CreatedOn, "createdOn");
Map(x => x.LastModified, "lastModified");
Map(x => x.Name, "name");
Map(x => x.Nationality, "nationality");
HasMany(x => x.People)
.KeyColumn("countryOfBirthId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
HasMany(x => x.People1)
.KeyColumn("countryOfResidenceId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
HasMany(x => x.People2)
.KeyColumn("nationalityId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
Cache.ReadOnly();
}
public RouteListMap()
{
Table("route_lists");
OptimisticLock.Version();
Version(x => x.Version)
.Column("version");
Id(x => x.Id).Column("id").GeneratedBy.Native();
Map(x => x.ConfirmedDistance).Column("confirmed_distance");
Map(x => x.Date).Column("date");
Map(x => x.Status).Column("status").CustomType <RouteListStatusStringType> ();
Map(x => x.ClosingDate).Column("closing_date");
Map(x => x.ClosingComment).Column("closing_comment");
Map(x => x.LogisticiansComment).Column("logisticians_comment");
Map(x => x.ClosingFilled).Column("closing_filled");
Map(x => x.LastCallTime).Column("last_call_time");
Map(x => x.DifferencesConfirmed).Column("differences_confirmed");
Map(x => x.IsManualAccounting).Column("is_manual_accounting");
Map(x => x.OnLoadTimeStart).Column("on_load_start").CustomType <TimeAsTimeSpanType>();
Map(x => x.OnLoadTimeEnd).Column("on_load_end").CustomType <TimeAsTimeSpanType>();
Map(x => x.OnLoadGate).Column("on_load_gate");
Map(x => x.OnloadTimeFixed).Column("on_load_time_fixed");
Map(x => x.PlanedDistance).Column("plan_distance");
Map(x => x.Printed).Column("printed");
Map(x => x.AddressesOrderWasChangedAfterPrinted).Column("addresses_order_was_changed_after_printed");
Map(x => x.RecalculatedDistance).Column("recalculated_distance");
Map(x => x.MileageComment).Column("mileage_comment");
Map(x => x.MileageCheck).Column("mileage_check");
Map(x => x.NormalWage).Column("normal_wage");
Map(x => x.FixedDriverWage).Column("fixed_driver_wage");
Map(x => x.FixedForwarderWage).Column("fixed_forwarder_wage");
Map(x => x.NotFullyLoaded).Column("not_fully_loaded");
Map(x => x.CashierReviewComment).Column("cashier_review_comment");
Map(x => x.WasAcceptedByCashier).Column("was_accepted_by_cashier");
References(x => x.Car).Column("car_id");
References(x => x.Shift).Column("delivery_shift_id");
References(x => x.Driver).Column("driver_id");
References(x => x.Forwarder).Column("forwarder_id");
References(x => x.Logistician).Column("logistican_id");
References(x => x.BottleFine).Column("bottles_fine_id");
References(x => x.Cashier).Column("cashier_id");
References(x => x.FuelOutlayedOperation).Column("fuel_outlayed_operation_id").Cascade.All();
References(x => x.DriverWageOperation).Column("driver_wages_movement_operations_id");
References(x => x.ForwarderWageOperation).Column("forwarder_wages_movement_operations_id");
References(x => x.ClosedBy).Column("closed_by_employee_id");
References(x => x.ClosingSubdivision).Column("closing_subdivision_id");
References(x => x.LogisticiansCommentAuthor).Column("logisticians_comment_author_id");
HasMany(x => x.Addresses).Cascade.AllDeleteOrphan().Inverse()
.KeyColumn("route_list_id")
.AsList(x => x.Column("order_in_route"));
HasMany(x => x.FuelDocuments).Cascade.AllDeleteOrphan().Inverse().LazyLoad().KeyColumn("route_list_id");
HasManyToMany(x => x.GeographicGroups).Table("geographic_groups_to_entities")
.ParentKeyColumn("route_list_id")
.ChildKeyColumn("geographic_group_id")
.LazyLoad();
}
public MovementDocumentMap()
{
Table("store_movement_document");
OptimisticLock.Version();
Version(x => x.Version).Column("version");
Id(x => x.Id).Column("id").GeneratedBy.Native();
Map(x => x.TimeStamp).Column("time_stamp");
Map(x => x.Comment).Column("comment");
Map(x => x.DocumentType).Column("category").CustomType <MovementDocumentCategoryStringType> ();
Map(x => x.Status).Column("status").CustomType <MovementDocumentStatusStringType>();
Map(x => x.LastEditedTime).Column("last_edit_time");
Map(x => x.SendTime).Column("send_time");
Map(x => x.ReceiveTime).Column("delivered_time");
Map(x => x.DiscrepancyAcceptTime).Column("discrepancy_accept_time");
Map(x => x.HasDiscrepancy).Column("has_discrepancy");
References(x => x.Author).Column("author_id");
References(x => x.LastEditor).Column("last_editor_id");
References(x => x.Receiver).Column("receiver_id");
References(x => x.Sender).Column("sender_id");
References(x => x.DiscrepancyAccepter).Column("discrepancy_accepter_id");
References(x => x.MovementWagon).Column("transportation_wagon_id");
References(x => x.FromWarehouse).Column("warehouse_from_id");
References(x => x.ToWarehouse).Column("warehouse_to_id");
HasMany(x => x.Items).Cascade.AllDeleteOrphan().Inverse().KeyColumn("movement_document_id");
}
public GeneralInformationMapping()
{
Table("`general_information`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.Content, "content");
Map(x => x.CreatedOn, "createdOn");
Map(x => x.DefaultImageFilelName, "defaultImageFilelName");
Map(x => x.ShortDescription, "shortDescription");
Map(x => x.Title, "title");
References(x => x.User)
.Class(typeof(User))
.Column("userId")
.Fetch.Select()
.Cascade.All();
HasMany(x => x.GeneralInformationAttachments)
.KeyColumn("generalInformationId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
Cache.ReadWrite();
}
public BaseMap()
{
Id(x => x.Id).GeneratedBy.Native();
OptimisticLock.Version();
Version(x => x.Version);
}
public InformationDeskMapping()
{
Table("`information_desk`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.Content, "content");
Map(x => x.CreatedOn, "createdOn");
Map(x => x.DateOfEvent, "dateOfEvent");
Map(x => x.DefaultImageFileName, "defaultImageFileName");
Map(x => x.ShortDescription, "shortDescription");
Map(x => x.ShowEndDate, "showEndDate");
Map(x => x.ShowStartDate, "showStartDate");
Map(x => x.Title, "title");
Map(x => x.Type, "type");
HasMany(x => x.InformationDeskAttachments)
.KeyColumn("InformationDeskId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
HasMany(x => x.InformationDeskTargets)
.KeyColumn("informationDeskId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
References(x => x.User)
.Class(typeof(User))
.Column("userId")
.Fetch.Select()
.Cascade.All();
Cache.ReadWrite();
}
public RoleMapping()
{
Table("`role`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.RequiresAccessScope, "requiresAccessScope").CustomType <BoolAsTinyInt>();
Map(x => x.CanCreate, "canCreate").CustomType <BoolAsTinyInt>();
Map(x => x.CanDelete, "canDelete").CustomType <BoolAsTinyInt>();
Map(x => x.CanUpdate, "canUpdate").CustomType <BoolAsTinyInt>();
Map(x => x.CanRead, "canRead").CustomType <BoolAsTinyInt>();
Map(x => x.Type, "type");
References(x => x.Service)
.Class(typeof(Service))
.Column("serviceId")
.Fetch.Select()
.Cascade.All();
HasMany(x => x.UserRoles)
.KeyColumn("roleId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
//Cache.ReadWrite();
}
public SubCountyMapping()
{
Table("`sub_county`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.Code, "code");
Map(x => x.CreatedOn, "createdOn");
Map(x => x.LastModified, "lastModified");
Map(x => x.Name, "name");
References(x => x.County)
.Class(typeof(County))
.Not.Nullable()
.Column("countyId")
.Fetch.Select()
.Cascade.All();
HasMany(x => x.People)
.KeyColumn("subCountyOfBirthId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
HasMany(x => x.People1)
.KeyColumn("subCountyOfResidenceId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
Cache.ReadOnly();
}
public SyllabusMapping()
{
Table("`syllabus`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.Title, "title");
Map(x => x.Week, "week");
Map(x => x.Overview, "overview");
Map(x => x.Graded, "graded");
References(x => x.Course)
.Class(typeof(Course))
.Not.Nullable()
.Column("courseId")
.Fetch.Select()
.Cascade.All();
HasMany(x => x.SyllabusAttachments)
.KeyColumn("syllabusId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
Cache.ReadWrite();
}
public UserRoleMap()
{
Id(x => x.Id);
Map(x => x.Name);
OptimisticLock.Version();
Version(entity => entity.Version);
}
public UserRoleMapping()
{
Table("`user_role`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
References(x => x.User)
.Class(typeof(User))
.Not.Nullable()
.Column("userId")
.Fetch.Select()
.Cascade.All();
References(x => x.Role)
.Class(typeof(Role))
.Not.Nullable()
.Column("roleId")
.Fetch.Select()
.Cascade.All();
References(x => x.AccessRole)
.Class(typeof(AccessRole))
.Column("accessRoleId")
.Fetch.Select()
.Cascade.All();
//Cache.ReadWrite();
}
public StaffCourseMapping()
{
Table("`staff_course`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.AssessmentWindowId, "assessmentWindowId");
Map(x => x.CourseSummary, "courseSummary");
Map(x => x.Grading, "grading");
Map(x => x.IsMainInstructor, "isMainInstructor").CustomType <BoolAsTinyInt>();
Map(x => x.LecturePlan, "lecturePlan");
Map(x => x.Status, "status");
References(x => x.Course)
.Class(typeof(Course))
.Not.Nullable()
.Column("courseId")
.Fetch.Select()
.Cascade.All();
//References(x => x.Semester)
// .Class(typeof(Semester))
// .Not.Nullable()
// .Column("semesterId")
// .Fetch.Select()
// .Cascade.All();
References(x => x.StaffPosition)
.Class(typeof(InstructorPosition))
.Not.Nullable()
.Column("staffPositionId")
.Fetch.Select()
.Cascade.All();
Cache.ReadWrite();
}
public CampusMapping()
{
Table("`campus`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.Code, "code");
Map(x => x.Description, "description");
Map(x => x.Name, "name");
Map(x => x.ShortName, "shortName");
//HasMany(x => x.Programs)
// .KeyColumn("campusId")
// .Inverse()
// .Cascade.All()
// .Fetch.Select()
// .AsSet();
References(x => x.Institution)
.Class(typeof(Institution))
.Not.Nullable()
.Column("instituteId")
.Fetch.Select()
.Cascade.All();
Cache.ReadWrite();
}
public CategoryMap()
{
Table("Categories");
Id(x => x.Id).Column("Id").GeneratedBy.Native();
Map(x => x.Name).Column("Name").Length(20).Not.Nullable();
OptimisticLock.Version();
Version(x => x.Version).Column("Version").Not.Nullable();
}
public ItemMap()
{
Table("Items");
Id(x => x.Id).Column("Id").GeneratedBy.Native();
Map(x => x.Name).Column("Name").Length(20).Not.Nullable();
OptimisticLock.Version();
Version(x => x.Version).Column("Version").Not.Nullable();
References(x => x.Category).Column("CategoryId").Not.Nullable().Cascade.None().ForeignKey();
}
public EntityMap()
{
Id(x => x.Id);
OptimisticLock.Version();
Version(x => x.Version)
.CustomType("Timestamp");
Map(x => x.Created).Not.Nullable();
}
public UserMap()
{
Table("Users");
Id(x => x.Id);
Map(x => x.Name);
Map(x => x.SurName);
Version(X => X.EntityVersion);
OptimisticLock.Version();
}
public RatingMap()
{
Table("Ratings");
Id(x => x.Id).Column("Id").GeneratedBy.Native();
Map(x => x.Score).Column("Score").Length(1).Not.Nullable();
Map(x => x.Comment).Column("Comment").Length(100);
OptimisticLock.Version();
Version(x => x.Version).Column("Version").Not.Nullable();
References(x => x.Item).Column("ItemId").Not.Nullable().Cascade.None().ForeignKey();
References(x => x.User).Column("UserId").Not.Nullable().Cascade.None().ForeignKey();
}
public RouteListItemMap()
{
Table("route_list_addresses");
OptimisticLock.Version();
Version(x => x.Version).Column("version");
Id(x => x.Id).Column("id").GeneratedBy.Native();
Map(x => x.IndexInRoute).Column("order_in_route");
Map(x => x.BottlesReturned).Column("bottles_returned");
Map(x => x.DriverBottlesReturned).Column("driver_bottles_returned");
Map(x => x.OldBottleDepositsCollected).Column("deposits_collected");
Map(x => x.OldEquipmentDepositsCollected).Column("equipment_deposits_collected");
Map(x => x.ExtraCash).Column("extra_cash");
Map(x => x.TotalCash).Column("total_cash");
Map(x => x.DriverWage).Column("driver_wage");
Map(x => x.DriverWageSurcharge).Column("driver_wage_surcharge");
Map(x => x.ForwarderWage).Column("forwarder_wage");
Map(x => x.WithForwarder).Column("with_forwarder");
Map(x => x.StatusLastUpdate).Column("status_last_update");
Map(x => x.Comment).Column("comment").Length(150);
Map(x => x.Status).Column("status").CustomType <RouteListItemStatusStringType>();
Map(x => x.NeedToReload).Column("need_to_reload");
Map(x => x.WasTransfered).Column("was_transfered");
Map(x => x.CashierComment).Column("cashier_comment");
Map(x => x.CashierCommentCreateDate).Column("cashier_comment_create_date");
Map(x => x.CashierCommentLastUpdate).Column("cashier_comment_last_update");
Map(x => x.Notified30Minutes).Column("notified_30minutes");
Map(x => x.NotifiedTimeout).Column("notified_timeout");
Map(x => x.PlanTimeStart).Column("plan_time_start").CustomType <TimeAsTimeSpanType>();
Map(x => x.PlanTimeEnd).Column("plan_time_end").CustomType <TimeAsTimeSpanType>();
Map(x => x.CommentForFine).Column("comment_for_fine");
Map(x => x.IsDriverForeignDistrict).Column("is_driver_foreign_district");
Map(x => x.CreationDate).Column("creation_date")
.Insert().Not.Update().Access.ReadOnlyPropertyThroughCamelCaseField(Prefix.Underscore);
References(x => x.RouteList).Column("route_list_id").Not.Nullable();
References(x => x.Order).Column("order_id").Cascade.SaveUpdate();
References(x => x.TransferedTo).Column("transfered_to_id");
References(x => x.CashierCommentAuthor).Column("cashier_comment_author");
References(x => x.DriverWageCalculationMethodic).Column("driver_wage_calculation_methodic_id");
References(x => x.ForwarderWageCalculationMethodic).Column("forwarder_wage_calculation_methodic_id");
References(x => x.LateArrivalReason).Column("late_arrival_reason_id");
References(x => x.LateArrivalReasonAuthor).Column("late_arrival_reason_author_id");
References(x => x.CommentForFineAuthor).Column("comment_for_fine_author_id");
HasManyToMany(x => x.Fines)
.Table("fines_to_route_list_addresses")
.ParentKeyColumn("route_list_address_id")
.ChildKeyColumn("fine_id")
.LazyLoad();
}
public UserMap()
{
Table("Users");
Id(x => x.Id).Column("Id").GeneratedBy.Native();
Map(x => x.Username).Column("Username").Length(20).Not.Nullable();
Map(x => x.Firstname).Column("Firstname").Length(50);
Map(x => x.Lastname).Column("Lastname").Length(50).Not.Nullable();
Map(x => x.Password).Column("Password").Length(60).Not.Nullable();
Map(x => x.IsAdmin).Column("IsAdmin").Not.Nullable();
OptimisticLock.Version();
Version(x => x.Version).Column("Version").Not.Nullable();
}
public CourseSubjectMap()
{
Id(x => x.Id).GeneratedBy.Identity();
Map(e => e.Name).Not.Nullable().Unique().Length(150);
//Map(e => e.EnglishName).Not.Nullable().Unique().Length(150).Column("Name_en");
HasMany(x => x.Translations).Access.CamelCaseField(Prefix.Underscore)
.Cascade.AllDeleteOrphan()
.KeyColumn("SubjectId").Inverse().AsSet();
DynamicUpdate();
OptimisticLock.Version();
Version(x => x.Version).CustomSqlType("timestamp").Generated.Always();
}
public RefreshTokenMapping()
{
Table("`refresh_token`");
Schema("witu");
Id(x => x.Id, "id");
OptimisticLock.Version();
Map(x => x.Subject, "subject");
Map(x => x.IssuedUtc, "issuedUtc");
Map(x => x.ExpiresUtc, "expiresUtc");
Map(x => x.ProtectedTicket, "protectedTicket");
Map(x => x.ClientId, "clientId");
}
public BaseUserMap()
{
Id(x => x.Id).GeneratedBy.HiLo(nameof(HiLoGenerator), nameof(HiLoGenerator.NextHi), "10", $"{nameof(HiLoGenerator.TableName)}='User'");
Map(e => e.Email) /*.Not.Nullable()*/.Unique();
Map(e => e.Name).Not.Nullable();
Map(e => e.EmailConfirmed);
//Map(e => e.NormalizedName);
//Map(e => e.NormalizedEmail);
Map(e => e.SecurityStamp);
Map(e => e.Image).Length(5000).Nullable();
Map(e => e.ImageName).Length(5000).Nullable();
Map(e => e.AuthenticatorKey);
// Map(e => e.Culture);
Map(e => e.Country).Nullable().Length(2);
Map(e => e.Created).Insert().Not.Update();
Map(e => e.Fictive).ReadOnly();
Map(e => e.OldUser).Nullable();
References(x => x.University).Column("UniversityId2").ForeignKey("User_University2").Nullable();
Map(x => x.Language).Column("Language").CustomType <CultureInfo>().Nullable();
HasMany(x => x.Questions).Access.CamelCaseField(Prefix.Underscore).KeyColumn("UserId")
.Inverse()
.Cascade.AllDeleteOrphan();
HasMany(x => x.Followers).Access.CamelCaseField(Prefix.Underscore)
.Cascade.AllDeleteOrphan()
.KeyColumn("UserId").Inverse().AsSet();
Map(x => x.Score).ReadOnly();
Table("User"); //if not there is sql error
DynamicUpdate();
OptimisticLock.Version();
Version(x => x.Version).CustomSqlType("timestamp").Generated.Always();
DiscriminateSubClassesOnColumn("Fictive");
/*
* CREATE UNIQUE NONCLUSTERED INDEX idx_phoneNumber_notnull
* ON sb.[User](PhoneNumberHash)
* WHERE PhoneNumberHash IS NOT NULL;
*/
SchemaAction.Update();
}
public TemplateDocumentMapping()
{
Table("`template_document`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.Category, "category");
Map(x => x.Content, "content");
Map(x => x.FileType, "fileType");
Map(x => x.Name, "name");
Map(x => x.Subject, "subject");
}
public UserCourseMap()
{
CompositeId()
.KeyReference(x => x.User, "UserId")
.KeyReference(x => x.Course, "CourseId");
Map(e => e.IsTeach).Column("CanTeach").Not.Nullable();
Table("UsersCourses");
DynamicUpdate();
OptimisticLock.Version();
Version(x => x.Version).CustomSqlType("timestamp").Generated.Always();
}
public PetStoreMap()
{
Id(x => x.PetStoreUUID).GeneratedBy.GuidComb();
OptimisticLock.Version();
Version(x => x.TheVersionProperty)
.Column("MyVersionColumn")
.Not.Nullable()
.CustomSqlType("timestamp")
.Generated.Always();
Map(x => x.PetStoreName);
Map(x => x.CreateDate);
}
public ProductMap()
{
Id(x => x.Id);
Map(x => x.Name);
Map(x => x.Price);
HasManyToMany(x => x.StoresStockedIn)
.Cascade.All()
.Inverse()
.Table("StoreProduct");
Version(p => p.Version);
OptimisticLock.Version();
DynamicUpdate();
}
public ReverseAuctionMap()
{
Id(x => x.Id);
OptimisticLock.Version();
Version(x => x.Version)
.Not.Nullable()
.UnsavedValue("0");
Component(x => x.BuyerTerms).ColumnPrefix("BuyerTerms_");
Component(x => x.BiddingAllowed).ColumnPrefix("BiddingAllowed_");
//HasMany(x => x.Bids); // Not if Bids belong in a separate aggregate!
}
public ChatUserMap()
{
Id(x => x.Id).GeneratedBy.GuidComb();
Map(x => x.Unread).Not.Nullable();
References(x => x.ChatRoom)
.Not.Nullable().Column("ChatRoomId").ForeignKey("fChatUserChatRoom");
References(x => x.User)
.Not.Nullable().Column("UserId")
.ForeignKey("fChatUserUser");
DynamicUpdate();
OptimisticLock.Version();
Version(x => x.Version).CustomSqlType("timestamp").Generated.Always();
}
public CohortMapping()
{
Table("`semester`");
Schema("witu");
Id(x => x.Id, "id")
.GeneratedBy.Native();
OptimisticLock.Version();
Map(x => x.AssessmentEndDate, "assessmentEndDate");
Map(x => x.AssessmentStartDate, "assessmentStartDate");
Map(x => x.EndDate, "endDate");
Map(x => x.RegistrationDeadline, "registrationDeadline");
Map(x => x.ResultsUploadDeadline, "resultsUploadDeadline");
Map(x => x.SemesterSession, "semesterSession");
Map(x => x.StartDate, "startDate");
Map(x => x.Status, "status");
References(x => x.CohortYear)
.Class(typeof(CohortYear))
.Not.Nullable()
.Column("academicYearId")
.Fetch.Select()
.Cascade.All();
HasMany(x => x.SemesterRegistrations)
.KeyColumn("semsterId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
HasMany(x => x.StaffCourses)
.KeyColumn("semesterId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
HasMany(x => x.Students)
.KeyColumn("semesterEntryId")
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet();
HasMany(x => x.StudentCourses)
.KeyColumn("semesterId")
.KeyNullable()
.Inverse()
.Cascade.All()
.Fetch.Select()
.AsSet()
//deleted courses are not to be included...
.Where(x => x.ResultStatus != ResultStatus.DeletedApproved)
;
Cache.ReadWrite();
}