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