O2DIntranetDB_DEV
Tables (27)
TB_COMPANY
- Idcompany — int — Primary key — NOT NULL — NOT NULL
- CompanyName — varchar(100) — NOT NULL
- Address1 — varchar(Max) — NOT NULL
- Address2 — varchar(Max)
- City — varchar(200) — NOT NULL
- State — varchar(200) — NOT NULL
- Zip — char(5) — NOT NULL
- CompanyLogo — Binary(Max)
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
- MultiCompany — char(1)
TB_EVENTS
- IdEvent — int — Primary key — NOT NULL — NOT NULL
- Idcompany — int — Foreign key → TB_COMPANY.Idcompany — NOT NULL — NOT NULL
- EventName — varchar(200) — NOT NULL
- EventDesc — varchar(max) — NOT NULL
- StartDate — datetime — NOT NULL
- EndDate — datetime — NOT NULL
- IsFullDayEvent — char(1)
- NoOfDays — int
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enable — char(1) — NOT NULL
- Status — char(1) — NOT NULL
TB_EVENTS_HRGRP
- IdEventHrGrp — int — Primary key — NOT NULL
- IdHRGroup — int — Foreign key — NOT NULL
- Idcompany — int — Foreign key → TB_HR_GROUP.Idcompany — NOT NULL — NOT NULL
- IdEvent — int — Foreign key → TB_EVENTS.IdEvent — NOT NULL — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- Enabled — char(1) — NOT NULL
TB_EVENTS_SUBJGRP
- IdSubjEvents — int — Primary key — NOT NULL
- IdEvent — int — Foreign key → TB_EVENTS.IdEvent — NOT NULL — NOT NULL
- IdSubjectGroup — int — Foreign key → TB_SUBJECT_GROUP.IdSubjectGroup — NOT NULL — NOT NULL
- Idcompany — int — Foreign key → TB_SUBJECT_GROUP.Idcompany — NOT NULL — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- Enabled — char(1) — NOT NULL
TB_EVENTS_USER
- IdEventUser — int — Primary key — NOT NULL
- IdEvent — int — Foreign key → TB_EVENTS.IdEvent — NOT NULL — NOT NULL
- IdUser — int — Foreign key → TB_USER.IdUser — NOT NULL
- Idcompany — int — Foreign key → TB_USER.Idcompany — NOT NULL — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- Enabled — char(1) — NOT NULL
TB_HRG_USER
- IdHRGUser — int — Primary key — NOT NULL
- IdUser — int — Foreign key → TB_USER.IdUser — NOT NULL
- IdHRGroup — int — Foreign key → TB_HR_GROUP.IdHRGroup — NOT NULL
- Idcompany — int — Foreign key → TB_HR_GROUP.Idcompany — NOT NULL — NOT NULL
- GroupName — varchar(200) — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- Enabled — char(1) — NOT NULL
TB_HR_GROUP
- IdHRGroup — int — Primary key — NOT NULL
- Idcompany — int — Foreign key → TB_COMPANY.Idcompany — NOT NULL — NOT NULL
- GroupName — varchar(200) — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_LEVEL
- IdUserLevel (Key) — Primary key — NOT NULL
- IdUser — int — Foreign key → TB_USER.IdUser — NOT NULL
- Idcompany — int — Foreign key → TB_USER.Idcompany — NOT NULL — NOT NULL
- IdLevel — int — Foreign key → TB_LEVEL_MASTER.IdLevel — NOT NULL — NOT NULL
- LevelName — varchar(100) — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_LEVEL_MASTER
- IdLevel — int — Primary key — NOT NULL — NOT NULL
- Idcompany — int — Foreign key → TB_USER.Idcompany — NOT NULL — NOT NULL
- LevelName — varchar(100) — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_LOGIN_LOG
- IdLog — int — Primary key — NOT NULL
- IdUser — int — Foreign key → TB_USER.IdUser — NOT NULL
- Idcompany — int — Foreign key → TB_USER.Idcompany — NOT NULL — NOT NULL
- LastLoginTime — datetime — NOT NULL
- ApplicationType — varchar(1) — NOT NULL
TB_NOTICE
- IdNotice — int — Primary key — NOT NULL
- Idcompany — int — Foreign key → TB_COMPANY.Idcompany — NOT NULL — NOT NULL
- NoticeSubject — varchar(1000)
- NoticeContent — varchar(max)
- NoticeDate — datetime — NOT NULL
- AttachedFile — varbinary(max)
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
- Status — char(1) — NOT NULL
TB_NOTICE_HRGRP
- IdNoticeHrGrp — int — Primary key — NOT NULL
- IdNotice — int — Foreign key → TB_NOTICE.IdNotice — NOT NULL
- IdHRGroup — int — Foreign key → TB_HR_GROUP.IdHRGroup — NOT NULL
- Idcompany — int — Foreign key → TB_HR_GROUP.Idcompany — NOT NULL — NOT NULL
- Idcompany (Idcompany2) — int — Foreign key → TB_NOTICE.Idcompany — NOT NULL — NOT NULL
- NoticeRead — char(1) — NOT NULL
- NoticeReadTime — datetime
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_NOTICE_SUBJGRP
- IdNoticeUser — int — Primary key — NOT NULL
- IdNotice — int — Foreign key → TB_NOTICE.IdNotice — NOT NULL
- IdSubjectGroup — int — Foreign key → TB_SUBJECT_GROUP.IdSubjectGroup — NOT NULL — NOT NULL
- Idcompany — int — Foreign key → TB_SUBJECT_GROUP.Idcompany — NOT NULL — NOT NULL
- NoticeRead — char(1) — NOT NULL
- NoticeReadTime — datetime
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_NOTICE_USER
- IdNoticeUser — int — Primary key — NOT NULL
- IdUser — int — Foreign key → TB_USER.IdUser — NOT NULL
- IdNotice — int — Foreign key → TB_NOTICE.IdNotice — NOT NULL
- Idcompany — int — Foreign key → TB_USER.Idcompany — NOT NULL — NOT NULL
- NoticeRead — char(1) — NOT NULL
- NoticeReadTime — datetime
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_SUBJECT_GROUP
- IdSubjectGroup — int — Primary key — NOT NULL — NOT NULL
- Idcompany — int — Foreign key → TB_COMPANY.Idcompany — NOT NULL — NOT NULL
- SubGrrpName (SubGrpName) — varchar(200) — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_SUBJ_USER
- IdSubjUser — int — Primary key — NOT NULL
- IdUser — int — Foreign key → TB_USER.IdUser — NOT NULL
- IdSubjectGroup — int — Foreign key → TB_SUBJECT_GROUP.IdSubjectGroup — NOT NULL — NOT NULL
- Idcompany — int — Foreign key → TB_SUBJECT_GROUP.Idcompany — NOT NULL — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- Enabled — char(1) — NOT NULL
TB_SUBSUBJECT_GROUP
- IdSubSubjectGroup — int — Primary key — NOT NULL — NOT NULL
- IdSubjectGroup — int — Foreign key → TB_SUBJECT_GROUP.IdSubjectGroup — NOT NULL — NOT NULL
- Idcompany — int — Foreign key → TB_SUBJECT_GROUP.Idcompany — NOT NULL — NOT NULL
- SubSubjectGrpName — varchar(200) — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_TASK
- IdTask — int — Primary key — NOT NULL
- Idcompany — int — Foreign key → TB_COMPANY.Idcompany — NOT NULL — NOT NULL
- TaskSubject — varchar(1000)
- TaskDescription — varchar(max)
- CreatedTime — datetime
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
- Status — char(1) — NOT NULL
TB_TASK_HRGRP
- IdTaskHrp — int — Primary key — NOT NULL
- IdTask — int — Foreign key → TB_TASK.IdTask — NOT NULL
- IdHRGroup — int — Foreign key → TB_HR_GROUP.IdHRGroup — NOT NULL
- Idcompany — int — Foreign key → TB_HR_GROUP.Idcompany — NOT NULL — NOT NULL
- AssignedDate — datetime — NOT NULL
- DueDate — datetime — NOT NULL
- CompletionDate — datetime
- Enabled — char(1) — NOT NULL
- CompletionStatus — char(1) — NOT NULL
- TaskRead — char(1)
TB_TASK_SUBJGRP
- IdTaskSubjGrp — int — Primary key — NOT NULL
- IdSubjectGroup — int — Foreign key → TB_SUBJECT_GROUP.IdSubjectGroup — NOT NULL — NOT NULL
- Idcompany — int — Foreign key → TB_SUBJECT_GROUP.Idcompany — NOT NULL — NOT NULL
- IdTask — int — Foreign key → TB_TASK.IdTask — NOT NULL
- AssignedDate — datetime — NOT NULL
- DueDate — datetime — NOT NULL
- CompletionDate — datetime
- Enabled — char(1) — NOT NULL
- CompletionStatus — char(1) — NOT NULL
- CompletedBy — varchar(100)
- TaskRead — char(1)
TB_TASK_USER
- IdTaskUser — int — Primary key — NOT NULL
- IdTask — int — Foreign key → TB_TASK.IdTask — NOT NULL
- IdUser — int — Foreign key → TB_USER.IdUser — NOT NULL
- Idcompany — int — Foreign key → TB_USER.Idcompany — NOT NULL — NOT NULL
- AssignedDate — datetime — NOT NULL
- DueDate — datetime — NOT NULL
- CompletionDate — datetime
- Enabled — char(1) — NOT NULL
- CompletionStatus — char(1) — NOT NULL
- TaskRead — char(1)
TB_USER
- IdUser — int — Primary key — NOT NULL
- Idcompany — int — Foreign key → TB_COMPANY.Idcompany — NOT NULL — NOT NULL
- FirstName — nvarchar(40) — NOT NULL
- LastName — nvarchar(40) — NOT NULL
- Email — varchar(50) — NOT NULL
- UserName — varchar(50) — NOT NULL
- Password — Binary(64) — NOT NULL
- JobTitle — varchar(100)
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
- Salt — UniqueIdentifier — NOT NULL
TB_WIKI
- IdWiki — int — Primary key — NOT NULL
- Idcompany — int — Foreign key → TB_COMPANY.Idcompany — NOT NULL — NOT NULL
- WikiSubject — varchar(1000)
- WikiContent — varchar(max)
- WikiDate — datetime — NOT NULL
- WikiPic1 — varbinary(max)
- WikiPic2 — varbinary(max)
- WikiPic3 — varbinary(max0
- WikiPic4 — varbinary(max)
- WikiPic5 — varbinary(max)
- WikiPic6 — varbinary(max)
- WikiPic7 — varbinary(max)
- CreatedTime — datetime
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
- Status — char(1) — NOT NULL
TB_WIKI_CATEGORY
- IdWikiCategory — int — Primary key — NOT NULL
- IdWiki — int — Foreign key → TB_WIKI.IdWiki — NOT NULL
- Idcompany — int — Foreign key → TB_WIKI.Idcompany — NOT NULL — NOT NULL
- WikiCategoyName — varchar(100) — NOT NULL
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
- Status — char(1)
TB_WIKI_HRGRP
- IdWikiHrGrp — int — Primary key — NOT NULL
- IdWiki — int — Foreign key → TB_WIKI.IdWiki — NOT NULL
- IdHRGroup — int — Foreign key → TB_HR_GROUP.IdHRGroup — NOT NULL
- Idcompany — int — Foreign key → TB_HR_GROUP.Idcompany — NOT NULL — NOT NULL
- WikiRead — char(1) — NOT NULL
- WikiReadTime — datetime
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_WIKI_SUBJGRP
- IdWikiSubjGrp — int — Primary key — NOT NULL
- IdWiki — int — Foreign key → TB_WIKI.IdWiki — NOT NULL
- IdSubjectGroup — int — Foreign key → TB_SUBJECT_GROUP.IdSubjectGroup — NOT NULL — NOT NULL
- Idcompany — int — Foreign key → TB_SUBJECT_GROUP.Idcompany — NOT NULL — NOT NULL
- WikiRead — char(1) — NOT NULL
- WikiReadTime — datetime
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL
TB_WIKI_USER
- IdWikiUser — int — Primary key — NOT NULL
- IdWiki — int — Foreign key → TB_WIKI.IdWiki — NOT NULL
- IdUser — int — Foreign key → TB_USER.IdUser — NOT NULL
- Idcompany — int — Foreign key → TB_USER.Idcompany — NOT NULL — NOT NULL
- WikiRead — char(1) — NOT NULL
- WikiReadTime — datetime
- CreatedTime — datetime — NOT NULL
- CreatedBy — varchar(100) — NOT NULL
- UpdatedTime — datetime
- UpdatedBy — varchar(100)
- Enabled — char(1) — NOT NULL