HRMS

Tables (20)

DeptMst

  • DeptKey — int — Primary key — NOT NULL
  • DeptCode — varchar(20) — NOT NULL
  • DeptName — nvarchar(256) — NOT NULL
  • DeptNameEng — nvarchar(256)
  • StartDate — datetime
  • EndDate — datetime
  • DeptLevel — int
  • ParentDeptKey — int — Foreign key → DeptMst.DeptKey
  • PreDeptKey — varchar(110)
  • WorkPlace — char(8)
  • Email — varchar(100)
  • CaptainCode — varchar(20)
  • UseYN — bit
  • MailBox — varchar(10)

Employee

  • EmployeeCode — nvarchar(10) — Primary key — NOT NULL
  • UserId — uniqueidentifier — Foreign key → aspnet_Users.UserId
  • Saluation — nvarchar(50)
  • Lname — nvarchar(50)
  • Mname — nvarchar(50)
  • Fname — nvarchar(50)
  • Nick — nvarchar(50)
  • EmployeeNameInLang — nvarchar(250)
  • PunchCardNo — nvarchar(20)
  • Gender — nvarchar(50)
  • Address — nvarchar(150)
  • City — nvarchar(50)
  • State — nvarchar(50)
  • Country — nvarchar(50)
  • ZipCode — nvarchar(20)
  • Phone — nvarchar(20)
  • EMail — nvarchar(100)
  • EmergencyPhone — nvarchar(20)
  • EmergencyPersonName — nvarchar(50)
  • Nationality — nvarchar(50)
  • MotherLanguage — nvarchar(50)
  • SecondLanguage — nvarchar(50)
  • MaritalStatus — nvarchar(50)
  • SpouseName — nvarchar(50)
  • SpouseOccupation — nvarchar(50)
  • NoOfChildren — numeric(18)
  • NoOfRelative — numeric(18)
  • EmpType — nvarchar(50)
  • DOB — datetime
  • DOJ — datetime
  • LastReviewDate — datetime
  • TypeOfGap — nvarchar(50)
  • TotDays — numeric(18,4)
  • NextReviewDate — datetime
  • SeparationDate — datetime
  • PromotionDate — datetime
  • IncrementationDate — datetime
  • TransferDate — datetime
  • RefPersonName — nvarchar(50)
  • RefAddress — nvarchar(150)
  • Address2 — nvarchar(150)
  • Remarks — nvarchar(250)
  • RouteNo — nvarchar(10)
  • StopNo — nvarchar(10)
  • BEPZACodeNo — nvarchar(20)
  • Applied — nvarchar(1)
  • EmployeeStatus — nvarchar(50)
  • Shift — nvarchar(50)
  • OT — nvarchar(50)
  • Restricted — nvarchar(50)
  • LeaveEncashment — nvarchar(1)
  • PF — nvarchar(1)
  • PfEntitledDate — datetime
  • PFAcctNo — nvarchar(20)
  • BankAcctNo — nvarchar(20)
  • StaffCategory — nvarchar(50)
  • SubStaffCategory — nvarchar(50)
  • Unit — nvarchar(50)
  • Dept — varchar(20) — Foreign key → DeptMst.DeptCode
  • Desig — nvarchar(50)
  • … +47

T_SC_Common

  • Code — nvarchar(50) — Primary key — NOT NULL
  • GroupCode — nvarchar(256)
  • Name — nvarchar(256) — NOT NULL
  • Vietnamese — nvarchar(256)
  • Korean — nvarchar(256)
  • Remark — nvarchar(256)
  • Value_1 — nvarchar(50)
  • Value_2 — nvarchar(50)
  • Value_3 — nvarchar(50)
  • Value_4 — nvarchar(50)
  • Value_5 — nvarchar(50)
  • UseYN — bit
  • IsSystemCode — bit

T_SC_EmpMst

  • EmpCode — varchar(20) — Primary key — NOT NULL
  • UserId — uniqueidentifier — Foreign key → aspnet_Users.UserId
  • EmpName — nvarchar(30)
  • EmpNameEng — nvarchar(30)
  • IdCardNo — varchar(14)
  • DeptCode — varchar(20) — Foreign key → DeptMst.DeptCode
  • PstType — varchar(8)
  • AptType — varchar(8)
  • RankType — varchar(8)
  • WorkPlace — varchar(8)
  • SexType — varchar(1)
  • StartDate — datetime
  • EndDate — datetime
  • WorkState — char(8)
  • BirthDate — datetime
  • HomePhone — varchar(20)
  • MobilePhone — varchar(20)
  • CompanyPhone — varchar(20)
  • Email — varchar(50)
  • ZipCode — varchar(10)
  • Address — nvarchar(100)
  • ContactName — nvarchar(30)
  • ContactRelation — nvarchar(20)
  • ContactPhone — varchar(20)
  • ContactAddress — nvarchar(200)
  • PictureId — uniqueidentifier
  • IsAdmin — bit
  • UseYN — bit
  • AbsState — bit
  • AbsFromDate — datetime
  • AbsToDate — datetime
  • SubApprEmpCode — varchar(20)
  • ApprPassword — varchar(20)
  • ApprSignImg — uniqueidentifier
  • LastUpdated — datetime
  • EdUseYN — bit
  • LastName — nvarchar(50)
  • FirstName — nvarchar(50)
  • EmpImage — varbinary(max)
  • MailDivide — nvarchar(10)
  • MailType — nvarchar(50)
  • DeptPlace — nvarchar(50)
  • Remark — nvarchar(max)
  • Saluation — varchar(10)
  • Lname — varchar(20)
  • Mname — varchar(20)
  • Fname — varchar(20)
  • Nick — varchar(20)
  • EmployeeNameInLang — nvarchar(250)
  • PunchCardNo — varchar(20)
  • Gender — varchar(1)
  • City — varchar(35)
  • State — varchar(35)
  • Country — varchar(35)
  • EmergencyPhone — varchar(20)
  • EmergencyPersonName — varchar(50)
  • Nationality — varchar(20)
  • MotherLanguage — varchar(20)
  • SecondLanguage — varchar(20)
  • MaritalStatus — varchar(10)
  • … +74

T_SC_FileGroup

  • GroupId — int — Primary key — NOT NULL
  • Description — nvarchar(500)
  • Name — nvarchar(100)

T_SC_FileList

  • FileId — uniqueidentifier — Primary key — NOT NULL
  • GroupId — int — Foreign key → T_SC_FileGroup.GroupId — NOT NULL
  • UpOrder — int
  • Name — nvarchar(200) — NOT NULL
  • Ext — nvarchar(100) — NOT NULL
  • Size — numeric(18) — NOT NULL
  • PhysicalPath — nvarchar(max) — NOT NULL
  • Status — bit

T_SC_GroupCode

  • GroupCode — nvarchar(4) — Primary key — NOT NULL
  • CodeName — nvarchar(20)
  • CodeType — nvarchar(50)
  • CodeDesc — nvarchar(100)
  • Description — nvarchar(500)
  • UseYN — bit
  • isSystem — bit

T_SC_MainImageFile

  • ImageId — int — Primary key — NOT NULL
  • ImageType — int
  • SlidingTime — int
  • Active — bit
  • ImageUrl — nvarchar(256)
  • FileId — uniqueidentifier — Foreign key → T_SC_FileList.FileId
  • SortOrder — int

T_SC_Menu

  • MenuID — int — Primary key — NOT NULL
  • MenuName — nvarchar(60)
  • MenuNameEn — nvarchar(60)
  • MenuNameVi — nvarchar(60)
  • MenuType — int
  • MenuURL — nvarchar(100)
  • Controller — nvarchar(100)
  • Action — nvarchar(100)
  • UseRender — bit
  • ChildRenderUrl — varchar(80)
  • PopupWidth — int
  • PopupHeight — int
  • MenuDesc — nvarchar(200)
  • MenuOrder — int
  • MenuLevel — int
  • UseYN — bit
  • UpMenuID — int — Foreign key → T_SC_Menu.MenuID
  • MenuIconUrl — nvarchar(100)
  • MenuHoverIconUrl — nvarchar(100)
  • MenuSectionImgUrl — nvarchar(100)

T_SC_MenuBanner

  • BannerId — int — Primary key — NOT NULL
  • BannerName — nvarchar(100) — NOT NULL
  • BannerNameEn — nvarchar(100)
  • BannerOrder — int — NOT NULL
  • UseYN — bit — NOT NULL

T_SC_MenuGroupPermission

  • GroupId — int — Primary key — NOT NULL
  • MenuId — int — Foreign key → T_SC_Menu.MenuID — NOT NULL
  • IsCreate — bit
  • IsRead — bit
  • IsUpdate — bit
  • IsDelete — bit
  • IsExportExcel — bit
  • IsPrint — bit

T_SC_MyMenu

  • UserId — uniqueidentifier — Foreign key → aspnet_Users.UserId — NOT NULL
  • MenuId — int — Foreign key → T_SC_Menu.MenuID — NOT NULL
  • MenuOrder — int
  • MenuName — nvarchar(50)
  • MenuNameEn — nvarchar(50)

T_SC_NationalCode

  • Code — nvarchar(20) — Primary key — NOT NULL
  • ParentCode — nvarchar(20) — Primary key — NOT NULL
  • Name — nvarchar(255)
  • Vietnamese — nvarchar(255)
  • English — nvarchar(255)
  • Remark — nvarchar(255)
  • UseYn — bit
  • InsertBy — nvarchar(255)
  • InsertDate — datetime
  • UpdateBy — nvarchar(255)
  • UpdateDate — datetime
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

T_SC_SubCode

  • SubCode — nvarchar(4) — Primary key — NOT NULL
  • GroupCode — nvarchar(4) — Foreign key → T_SC_GroupCode.GroupCode — NOT NULL
  • CodeName — nvarchar(30) — NOT NULL
  • NameEn — nvarchar(100)
  • NameVn — nvarchar(100)
  • CodeAlias — nvarchar(60)
  • CodeDesc — nvarchar(200)
  • Option1 — nvarchar(40)
  • Option2 — nvarchar(40)
  • Option3 — nvarchar(40)
  • UseYN — bit
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

T_SC_UnMaskingHistory

  • recordId — int — Primary key — NOT NULL
  • sysType — char(3) — Primary key — NOT NULL
  • readLoginId — varchar(20) — Primary key — NOT NULL
  • readName — varchar(20) — Primary key — NOT NULL
  • readUI — varchar(256)
  • accessIPAddr — varchar(16)
  • readTime — datetime
  • readData — varchar(256)
  • readReason — varchar(256)
  • FILLFACTOR — =
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

T_SC_UserGroup

  • GroupId — int — Primary key — NOT NULL
  • Code — nvarchar(4) — NOT NULL
  • Name — nvarchar(50) — NOT NULL
  • DefaultGroup — bit
  • LangId — varchar(6) — NOT NULL

T_SC_UserInGroup

  • GroupId — int — Foreign key → T_SC_UserGroup.GroupId — NOT NULL
  • UserId — uniqueidentifier — Foreign key → aspnet_Users.UserId — NOT NULL

aspnet_Applications

  • ApplicationId — uniqueidentifier — Primary key — NOT NULL
  • ApplicationName — nvarchar(256) — NOT NULL
  • LoweredApplicationName — nvarchar(256) — NOT NULL
  • Description — nvarchar(256)

aspnet_Membership

  • UserId — uniqueidentifier — Primary key — NOT NULL
  • ApplicationId — uniqueidentifier — Foreign key → aspnet_Applications.ApplicationId — NOT NULL
  • Password — nvarchar(128) — NOT NULL
  • PasswordFormat — int — NOT NULL
  • PasswordSalt — nvarchar(128) — NOT NULL
  • MobilePIN — nvarchar(16)
  • Email — nvarchar(256)
  • LoweredEmail — nvarchar(256)
  • PasswordQuestion — nvarchar(256)
  • PasswordAnswer — nvarchar(128)
  • IsApproved — bit — NOT NULL
  • IsLockedOut — bit — NOT NULL
  • CreateDate — datetime — NOT NULL
  • LastLoginDate — datetime — NOT NULL
  • LastPasswordChangedDate — datetime — NOT NULL
  • LastLockoutDate — datetime — NOT NULL
  • FailedPasswordAttemptCount — int — NOT NULL
  • FailedPasswordAttemptWindowStart — datetime — NOT NULL
  • FailedPasswordAnswerAttemptCount — int — NOT NULL
  • FailedPasswordAnswerAttemptWindowStart — datetime — NOT NULL
  • Comment — nvarchar(max) — varchar(max) COLLATE Korean_Wansung_CI_AS NUL

aspnet_Users

  • UserId — uniqueidentifier — Primary key — NOT NULL
  • ApplicationId — uniqueidentifier — Foreign key → aspnet_Applications.ApplicationId — NOT NULL
  • UserName — nvarchar(256) — NOT NULL
  • LoweredUserName — nvarchar(256) — NOT NULL
  • MobileAlias — nvarchar(16)
  • IsAnonymous — bit — NOT NULL
  • LastActivityDate — datetime — NOT NULL