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