Программное средство по контролю за уровнем компетенций сотрудников оперативно-технической службы системы эксплуатации регионального пункта управления (стр. 6 )

Для установки клиенсткого модуля ( мониторинга уведомлений из ПС Компетенции необходимо:

1.  В файле конфигурации по пути MonitoringService\bin\release\ MonitoringService. exe. config в секции <appSettings> изменить параметры ITCompetenceURL и UserLogin, выставив соответственно URL ПС Компетенции и логин пользователя в ПС Компетенции, для которого необходимо получать уведомления.

2.  В файле конфигурации по пути MonitoringManager. ClientApp\bin \release \MonitoringManager. ClientApp. exe. config в секции <appSettings> изменить значение параметра LoginUrl в соответствии с видом "<url_ПС_Компетенции>/Account/RemoteLogOn";

3.  Запустить install_module. bat из корня дистрибутива от имени администратора. Данный скрипт установит в систему службу-хост WCF-сервиса и службу мониторинга уведомлений;

4.  Запустить клиентское приложение по пути MonitoringManager. ClientApp\bin \release\MonitoringManager. ClientApp. exe. Приложение также нужно запустить от администратора. Ввести учетные данные пользователя и после этого приложение начнет свою работу. Все выполняемые приложением действия логгируются в файл: MonitoringManager. ClientApp\bin\release \MonitoringManager. ClientApp. log. txt. Работа службы мониторинга также логгируется в файл: MonitoringService\bin\release\MonitoringService. log. txt.

Для удаления сервиса необходимо остановить работу клиентского приложения и затем запустить из корня дистриутива скрипт uninstall_service. bat от имени администратора.

4  Проверка программы

Для проверки работоспособности ПС КОМПЕТЕНЦИИ необходимо выполнение следующих требований:

1)  все серверы и телекоммуникационное оборудование, образующие работу с ПС КОМПЕТЕНЦИИ должны быть запущены и должны обеспечивать функциональность, соответствующую штатному режиму работы;

2)  произведена проверка правильности установки на сервер компонент и модулей программного обеспечения.

Для того чтобы убедиться что ПС КОМПЕТЕНЦИИ установлено правильно необходимо открыть Internet Explorer на сервере IIS и перейти по адресу http://localhost. В результате должен появиться экран приглашения для входа в систему (Рис. 4.1. Экран приглашения для входа в систему).

Рис. 4.1. Экран приглашения для входа в систему.

Для того чтобы выполнить вход в систему следует воспользоваться учетной записью «admin», пароль: «1». После входа в систему должно появиться главное окно ПС (Рис. 4.2. Главное окно ПС КОМПЕТЕНЦИИ)

Рис. 4.2. Главное окно ПС КОМПЕТЕНЦИИ.

При переходе по команде меню «Справочники/Сотрудники» отобразиться список зарегистрированных пользователей (Рис. 4.3. Зарегистрированные пользователи ПС КОМПЕТЕНЦИИ)

Рис. 4.3. Зарегистрированные пользователи ПС «КОМПЕТЕНЦИИ».

5  Режимы работы программы

Предусмотрено два режима штатного функционирования ПС КОМПЕТЕНЦИИ:

1)  Обычный режим;

2)  Режим технологического обслуживания.

В обычном режиме все модули ПС «КОМПЕТЕНЦИИ» доступны пользователям в рамках назначенных полномочий.

Режим технологического обслуживания предусмотрен для выполнения операций, при которых доступ пользователей к ПС не желателен или не допустим (например, резервное копирование БД ПС). В этом режиме при попытке пользователей ПС (кроме пользователей, имеющих полномочия «Технический администратор») будет выводиться форма с информацией о текущем режиме функционирования ПС КОМПЕТЕНЦИИ и таймером обратного отсчета времени до ориентировочного восстановления обычного режима функционирования ПС.

Для перевода ПС в режим технологического обслуживания пользователю с набором прав «Технический администратор» следует воспользоваться пунктом главного меню ПС «Настройки/Управление доступностью ПС» (Рис. 5.1. Управление доступностью ПС).

Рис. 5.1. Управление доступностью ПС.

В форме управления доступностью ПС следует выбрать дату и время планового завершения работ (время перевода ПС в обычный режим функционирования) и нажать кнопку «Запуск».

ПС будет переведено в режим технологического обслуживания на период с текущего времени до указанного в форме.

На экран будет выведена форма с результатами работы операции (Рис. 5.2. Управление доступностью ПС. Отчет).

Рис. 5.2. Управление доступностью ПС. Отчет.

6  Сообщения системному программисту

6.1  Тексты сообщений, выдаваемых в ходе выполнения настройки программы

В процессе работы ПС возможно появление информационных сообщений об ошибках доступа к СУБД, которые описаны в документации к данным программным продуктам.

6.1.1  Сообщения при выполнении обновления схемы базы данных

В ходе выполнения обновления схемы базы данных возможно появление следующих сообщений:

1) Error : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Ошибка появляется ввиду неверно установленных параметров доступа к СУБД. Для ее устранения необходимо убедиться что параметры доступа к СУБД установленный в файле install. cmd верны.

2) Также возможны сообщения, зависящие от содержимого пакета обновления схемы базы данных. Данные сообщения выводятся утилитой обновления на экран.

6.1.2  Сообщения при начале работы с ПС «КОМПЕТЕНЦИИ» (ошибка соединения с БД)

При начале работы ПС «КОМПЕТЕНЦИИ» возможно появление следующего сообщения (Рис. 6.1.2.1. Окно ошибки подключения к базе данных ПС КОМПЕТЕНЦИИ).

Рис. 6.1.2.1. Окно ошибки подключения к базе данных ПС КОМПЕТЕНЦИИ.

Появление данной ошибки связано с некорректной настройкой параметров подключения к базе данных в файле web. config.

6.1.3  Сообщения при начале работы с ПС «КОМПЕТЕНЦИИ» (ошибка соединения с почтовым сервером)

При назначении задания на ознакомление с документом или на прохождение тестирования возможно появление следующего сообщения (Рис. 6.1.3.1. Ошибка подключения к почтовому серверу).

Рис. 6.1.3.1. Ошибка подключения к почтовому серверу.

Появление данной ошибки связано с некорректной настройкой параметров подключения к почтовому серверу в файле web. config.

7  Структура и описание базы данных ПС

7.1  Перечень таблиц БД

Название	Описание
dbo. Acq­Journal	Журнал ознакомления с документами
dbo. Answer	Ответы на вопросы тестов (матрицы компетенций, эталонные ответы)
dbo. AnswerConnection	Ответы на вопросы типа Сопоставление один-ко-многоим и многие-ко-многим
dbo. aspnet_­Applications	Служебные таблицы Membership. Содержат информацию об учетных данных пользователей, распределение прав доступа (роли).
dbo. aspnet_­Membership
dbo. aspnet_­Paths
dbo. aspnet_­Personalization­All­Users
dbo. aspnet_­Personalization­Per­User
dbo. aspnet_­Profile
dbo. aspnet_­Roles
dbo. aspnet_­Schema­Versions
dbo. aspnet_­Users
dbo. aspnet_­Users­In­Roles
dbo. aspnet_­Web­Event_­Events
dbo. Assignment­Journal	Журнал назначения заданий
dbo. Chief­Task	Журнал назначений групп заданий руководителям
dbo. Chief­Task­Person	Журнал персональных заданий руководителям
dbo. Chief­Task­Person­Status	Состояние (статус) персональных заданий руководителям
dbo. Chief­Task­Type	Тип персональных заданий руководителям
pareOption	Справочная таблица, в ней содержатся способы сравнения строк
petence	Справочник компетенций
petenceArea	Области компетенции
petenceAreaDocument	Связи областей компетенций и документов
petenceAreaInstrument	Связь областей компетенций и инструментов
petenceMark	Оценка уровня компетенции сотрудника
petence­Matrix­Import­Buffer	Временная таблица для импорта матрицы компетенций из xls файла
petence­Question­Import­Buffer	Временная таблица для импорта контрольных вопросов теста из xls файла
petence­Role	Таблица связей роль-компетенция с указанием целевого уровня компетенций и признаком критичности
dbo. DBAudit	Аудит БД
dbo. DeleteCookiesUser	Таблица для хранения логинов пользователей, для которых необходимо очистить кэш
dbo. DBError­Log	Журнал ошибок работы БД
dbo. Department	Справочник подразделений
dbo. Document	Справочник документов
dbo. Document­Category	Справочник категорий документов
dbo. Document­Role	Таблица связей документ-роль
dbo. EduCourse	Обучающие курсы
dbo. EduPersonCourse	Назначения сотрудника на курсы
dbo. EduPersonCourseStatus	Статусы прохождения сотрудников курса
dbo. EduProgram	Программа обучения
dbo. Error­Message	Журнал ошибок работы ПС
dbo. ExternalSystem	Внешние системы, взаимодействующие с Компетенцией
dbo. Holiday­Interval	Общий справочник выходных дней
dbo. Holiday­Interval­Person	Общий справочник выходных дней
dbo. Instrument	Инструменты подготовки сотрудников
dbo. Job	Таблица назначенных групповых заданий на тестирование
dbo. Job­Answer	Ответы на вопросы тестов (сформированных заданий)
dbo. JobAnswerConnection	Ответы на вопросы типа Сопоставление один-ко-многоим и многие-ко-многим (сформированный заданий)
dbo. JobAnswerIteration	Ответы на вопросы заданий на интервальное повторение (сформированных заданий)
dbo. Job­Detailed	Группы заданий сотрудника, сгруппированные по компетенциям, содержащимся в персональном задании
dbo. Job­Person	Таблица персональных заданий сотрудника
dbo. JobPersonIteration	Таблица персональных заданий сотрудника на интервальное повторение
dbo. Job­Person­Status	Состояние (статус) персональных заданий сотрудника
dbo. Job­Question	Таблица вопросов назначенных заданий
dbo. JobQuestionCompareOption	Справочная таблица, в ней содержатся способы сравнения строк (для сформированных заданий)
dbo. JobQuestionIteration	Таблица вопросов назначенных заданий на интервальное повторение
dbo. JobQuestionsQueueType	Типы очередей вопросов для заданий на интервальное повторение
dbo. Job­Status	Состояние (статус) назначенных групповых заданий
dbo. Job­Status­Log	Журнал состояний назначенных групповых заданий
dbo. Job­Type	Справочник типов заданий
dbo. LearningOrganization	Обучающие организации
dbo. MailboxReaderJournal	Таблица для хранения прочитанных сообщений
dbo. Module­Versions	Таблица версии БД
dbo. Notification­Journal	Журнал отправленных уведомлений
dbo. Notification­Message­Type	Тип уведомлений
dbo. Notification­Settings	Справочник настроек уведомлений
dbo. Notification­Target	Справочник целей уведомлений
dbo. Notification­Target­Type	Справочник типов целей уведомлений
dbo. Person	Справочник сотрудников
dbo. Person­Role	Справочник связей сотрудник-роль (назначение сотрудников на роли)
dbo. PersonTapeMessageFilter	Хранение настроек фильтров ленты
dbo. Person­Working­Area	Таблица связей сотрудник-рабочая область
dbo. Process	Справочник процессов
dbo. Question	Таблица эталонных вопросов для тестирования
dbo. QuestionCompareOption	Справочная таблица, в ней содержатся способы сравнения строк (для конкретного вопроса)
dbo. Question­Type	Справочник типов вопросов
dbo. Recommendation	Позиции плана подготовки сотрудника
dbo. RecommendationStatus	Типы статусов позиции плана подготовки сотурдников
dbo. RelevancePeriodType	Типы периода действия результатов заданий
dbo. Role	Справочник ролей
dbo. RoleRate	Виды уровней компетенций сотрудников
dbo. SelectedJobAnswerConnection	Выделеные отчеты на вопросы типа Сопоставление один-ко-многоим и многие-ко-многим (сформированный заданий)
dbo. Setting	Справочник системных параметров ПС
dbo. Setting­Data­Type	Справочник типов значения параметров
dbo. Setting­Person	Справочник пользовательских параметров ПС
dbo. Setting­Working­Area	Таблица связей параметров ПС с рабочими областями
dbo. Tape­Message	Журнал сообщений Ленты
dbo. Tape­Message­Category	Справочник типов сообщений Ленты
dbo. Tape­Message­Person	Таблица связей сообщение_Ленты-Сотрудник
dbo. Tape­Message­Priority	Справочник приоритетов сообщений Ленты
dbo. Tape­Message­Working­Area	Таблица связей сообщение_Ленты-Рабочая_область
dbo. TargetAction	Коллекция действий по отработке целевого действия
dbo. tmp_RoleRegedit	Служебная таблица для импорта
dbo. tmp­Person	Вспомогательная таблица для импорта справочника сотрудников
dbo. VersionHistory	Версия бд
dbo. VisualItemLayout	Данные лэйаута devexpress таблиц
dbo. Working­Area	Справочник рабочих областей

7.2  Структура таблиц БД

Table: dbo. AcqJournal

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

AcqJournalID

bigint

8

No

2

AssignmentJournalID

bigint

8

No

3

PersonID

bigint

8

No

4

AssignmentDate

datetime

8

No

5

AcqDate

datetime

8

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_AcqJournal_AssignmentJournal

AssignmentJournalID

REFERENCES ITCompetence_Develop_ForTest. dbo. AssignmentJournal (AssignmentJournalID)

FOREIGN KEY

FK_AcqJournal_Person

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK_AcqJournal

AcqJournalID

Indexes (1)

Name

Details

Keys

Description

PK_AcqJournal

clustered, unique, primary key located on PRIMARY

AcqJournalID

Table: dbo. Answer

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

AnswerID

bigint

8

No

2

QuestionID

bigint

8

No

3

Variant

varchar

-1

No

4

IsCorrect

int

4

No

5

CreatedBy

varchar

50

Yes

6

ModifiedBy

varchar

50

Yes

7

CreatedDate

datetime

8

Yes

8

ModifiedDate

datetime

8

Yes

9

CorrectOrderNumber

smallint

2

Yes

Constraints (4)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsCorrect

DF_t_Answer_f_AnswerIsCorrect

((0))

FOREIGN KEY

FK_Answer_Question

QuestionID

REFERENCES ITCompetence_Develop_ForTest. dbo. Question (QuestionID)

PRIMARY KEY (clustered)

PK_t_Answer

AnswerID

Indexes (1)

Name

Details

Keys

Description

PK_t_Answer

clustered, unique, primary key located on PRIMARY

AnswerID

Table: dbo. AnswerConnection

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

AnswerConnectionID

bigint

8

No

2

LeftAnswerID

bigint

8

Yes

3

RightAnswerID

bigint

8

Yes

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__AnswerCon__LeftA__5FA91635

LeftAnswerID

REFERENCES ITCompetence_Develop_ForTest. dbo. Answer (AnswerID)

FOREIGN KEY

FK__AnswerCon__Right__609D3A6E

RightAnswerID

REFERENCES ITCompetence_Develop_ForTest. dbo. Answer (AnswerID)

PRIMARY KEY (clustered)

PK__AnswerCo__9CF421085DC0CDC3

AnswerConnectionID

Indexes (1)

Name

Details

Keys

Description

PK__AnswerCo__9CF421085DC0CDC3

clustered, unique, primary key located on PRIMARY

AnswerConnectionID

Table: dbo. aspnet_Applications

Columns (4)

№

Name

System Type

Length

Nullable

Description

1

ApplicationName

nvarchar

256

No

2

LoweredApplicationName

nvarchar

256

No

3

ApplicationId

uniqueidentifier

16

No

4

Description

nvarchar

256

Yes

Constraints (4)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column ApplicationId

DF__aspnet_Ap__Appli__2739D489

(newid())

PRIMARY KEY (non-clustered)

PK__aspnet_Applicati__245D67DE

ApplicationId

UNIQUE (non-clustered)

UQ__aspnet_Applicati__25518C17

LoweredApplicationName

UNIQUE (non-clustered)

UQ__aspnet_Applicati__2645B050

ApplicationName

Indexes (4)

Name

Details

Keys

Description

aspnet_Applications_Index

clustered located on PRIMARY

LoweredApplicationName

PK__aspnet_Applicati__245D67DE

nonclustered, unique, primary key located on PRIMARY

ApplicationId

UQ__aspnet_Applicati__2645B050

nonclustered, unique, unique key located on PRIMARY

ApplicationName

UQ__aspnet_Applicati__25518C17

nonclustered, unique, unique key located on PRIMARY

LoweredApplicationName

Table: dbo. aspnet_Membership

Columns (21)

№

Name

System Type

Length

Nullable

Description

1

ApplicationId

uniqueidentifier

16

No

2

UserId

uniqueidentifier

16

No

3

Password

nvarchar

128

No

4

PasswordFormat

int

4

No

5

PasswordSalt

nvarchar

128

No

6

MobilePIN

nvarchar

16

Yes

7

Email

nvarchar

256

Yes

8

LoweredEmail

nvarchar

256

Yes

9

PasswordQuestion

nvarchar

256

Yes

10

PasswordAnswer

nvarchar

128

Yes

11

IsApproved

bit

1

No

12

IsLockedOut

bit

1

No

13

CreateDate

datetime

8

No

14

LastLoginDate

datetime

8

No

15

LastPasswordChangedDate

datetime

8

No

16

LastLockoutDate

datetime

8

No

17

FailedPasswordAttemptCount

int

4

No

18

FailedPasswordAttemptWindowStart

datetime

8

No

19

FailedPasswordAnswerAttemptCount

int

4

No

20

FailedPasswordAnswerAttemptWindowStart

datetime

8

No

21

Comment

ntext

16

Yes

Constraints (6)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column PasswordFormat

DF__aspnet_Me__Passw__3C34F16F

((0))

FOREIGN KEY

FK__aspnet_Me__Appli__3A4CA8FD

ApplicationId

REFERENCES ITCompetence_Develop_ForTest. dbo. aspnet_Applications (ApplicationId)

FOREIGN KEY

FK__aspnet_Me__UserI__3B40CD36

UserId

REFERENCES ITCompetence_Develop_ForTest. dbo. aspnet_Users (UserId)

PRIMARY KEY (non-clustered)

PK__aspnet_Membershi__395884C4

UserId

Indexes (2)

Name

Details

Keys

Description

aspnet_Membership_index

clustered located on PRIMARY

ApplicationId, LoweredEmail

PK__aspnet_Membershi__395884C4

nonclustered, unique, primary key located on PRIMARY

UserId

Table: dbo. aspnet_Paths

Columns (4)

№

Name

System Type

Length

Nullable

Description

1

ApplicationId

uniqueidentifier

16

No

2

PathId

uniqueidentifier

16

No

3

Path

nvarchar

256

No

4

LoweredPath

nvarchar

256

No

Constraints (4)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column PathId

DF__aspnet_Pa__PathI__6CD828CA

(newid())

FOREIGN KEY

FK__aspnet_Pa__Appli__6BE40491

ApplicationId

REFERENCES ITCompetence_Develop_ForTest. dbo. aspnet_Applications (ApplicationId)

PRIMARY KEY (non-clustered)

PK__aspnet_Paths__6AEFE058

PathId

Indexes (2)

Name

Details

Keys

Description

aspnet_Paths_index

clustered, unique located on PRIMARY

ApplicationId, LoweredPath

PK__aspnet_Paths__6AEFE058

nonclustered, unique, primary key located on PRIMARY

PathId

Table: dbo. aspnet_PersonalizationAllUsers

Columns (3)

№

Name

System Type

Length

Nullable

Description

1

PathId

uniqueidentifier

16

No

2

PageSettings

image

16

No

3

LastUpdatedDate

datetime

8

No

Constraints (3)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__aspnet_Pe__PathI__719CDDE7

PathId

REFERENCES ITCompetence_Develop_ForTest. dbo. aspnet_Paths (PathId)

PRIMARY KEY (clustered)

PK__aspnet_Personali__70A8B9AE

PathId

Indexes (1)

Name

Details

Keys

Description

PK__aspnet_Personali__70A8B9AE

clustered, unique, primary key located on PRIMARY

PathId

Table: dbo. aspnet_PersonalizationPerUser

Columns (5)

№

Name

System Type

Length

Nullable

Description

1

Id

uniqueidentifier

16

No

2

PathId

uniqueidentifier

16

Yes

3

UserId

uniqueidentifier

16

Yes

4

PageSettings

image

16

No

5

LastUpdatedDate

datetime

8

No

Constraints (6)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column Id

DF__aspnet_Perso__Id__74794A92

(newid())

FOREIGN KEY

FK__aspnet_Pe__PathI__756D6ECB

PathId

REFERENCES ITCompetence_Develop_ForTest. dbo. aspnet_Paths (PathId)

FOREIGN KEY

FK__aspnet_Pe__UserI__76619304

UserId

REFERENCES ITCompetence_Develop_ForTest. dbo. aspnet_Users (UserId)

PRIMARY KEY (non-clustered)

PK__aspnet_Personali__73852659

Id

Indexes (3)

Name

Details

Keys

Description

aspnet_PersonalizationPerUser_index1

clustered, unique located on PRIMARY

PathId, UserId

PK__aspnet_Personali__73852659

nonclustered, unique, primary key located on PRIMARY

Id

aspnet_PersonalizationPerUser_ncindex2

nonclustered, unique located on PRIMARY

UserId, PathId

Table: dbo. aspnet_SchemaVersions

Columns (3)

№

Name

System Type

Length

Nullable

Description

1

Feature

nvarchar

128

No

2

CompatibleSchemaVersion

nvarchar

128

No

3

IsCurrentVersion

bit

1

No

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__aspnet_SchemaVer__2EDAF651

Feature, CompatibleSchemaVersion

Indexes (1)

Name

Details

Keys

Description

PK__aspnet_SchemaVer__2EDAF651

clustered, unique, primary key located on PRIMARY

Feature, CompatibleSchemaVersion

Table: dbo. aspnet_Users

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

ApplicationId

uniqueidentifier

16

No

2

UserId

uniqueidentifier

16

No

3

UserName

nvarchar

256

No

4

LoweredUserName

nvarchar

256

No

5

MobileAlias

nvarchar

16

Yes

6

IsAnonymous

bit

1

No

7

LastActivityDate

datetime

8

No

Constraints (6)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsAnonymous

DF__aspnet_Us__IsAno__2CF2ADDF

((0))

DEFAULT on column MobileAlias

DF__aspnet_Us__Mobil__2BFE89A6

(NULL)

DEFAULT on column UserId

DF__aspnet_Us__UserI__2B0A656D

(newid())

FOREIGN KEY

FK__aspnet_Us__Appli__2A164134

ApplicationId

REFERENCES ITCompetence_Develop_ForTest. dbo. aspnet_Applications (ApplicationId)

PRIMARY KEY (non-clustered)

PK__aspnet_Users__29221CFB

UserId

Indexes (3)

Name

Details

Keys

Description

aspnet_Users_Index

clustered, unique located on PRIMARY

ApplicationId, LoweredUserName

aspnet_Users_Index2

nonclustered located on PRIMARY

ApplicationId, LastActivityDate

PK__aspnet_Users__29221CFB

nonclustered, unique, primary key located on PRIMARY

UserId

Table: dbo. aspnet_UsersInRoles

Columns (2)

№

Name

System Type

Length

Nullable

Description

1

UserId

uniqueidentifier

16

No

2

RoleId

uniqueidentifier

16

No

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__aspnet_Us__RoleI__5D95E53A

RoleId

REFERENCES ITCompetence_Develop_ForTest. dbo. aspnet_Roles (RoleId)

FOREIGN KEY

FK__aspnet_Us__UserI__5CA1C101

UserId

REFERENCES ITCompetence_Develop_ForTest. dbo. aspnet_Users (UserId)

PRIMARY KEY (clustered)

PK__aspnet_UsersInRo__5BAD9CC8

UserId, RoleId

Indexes (2)

Name

Details

Keys

Description

PK__aspnet_UsersInRo__5BAD9CC8

clustered, unique, primary key located on PRIMARY

UserId, RoleId

aspnet_UsersInRoles_index

nonclustered located on PRIMARY

RoleId

Table: dbo. aspnet_WebEvent_Events

Columns (15)

№

Name

System Type

Length

Nullable

Description

1

EventId

char

32

No

2

EventTimeUtc

datetime

8

No

3

EventTime

datetime

8

No

4

EventType

nvarchar

256

No

5

EventSequence

decimal

9

No

6

EventOccurrence

decimal

9

No

7

EventCode

int

4

No

8

EventDetailCode

int

4

No

9

Message

nvarchar

1024

Yes

10

ApplicationPath

nvarchar

256

Yes

11

ApplicationVirtualPath

nvarchar

256

Yes

12

MachineName

nvarchar

256

No

13

RequestUrl

nvarchar

1024

Yes

14

ExceptionType

nvarchar

256

Yes

15

Details

ntext

16

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__aspnet_WebEvent___05A3D694

EventId

Indexes (1)

Name

Details

Keys

Description

PK__aspnet_WebEvent___05A3D694

clustered, unique, primary key located on PRIMARY

EventId

Table: dbo. AssignmentJournal

Columns (13)

№

Name

System Type

Length

Nullable

Description

1

AssignmentJournalID

bigint

8

No

2

AssignedObjectID

bigint

8

No

3

AssignedByPersonID

bigint

8

No

4

DocumentID

bigint

8

Yes

5

AssignmentDate

datetime

8

No

6

Deadline

datetime

8

Yes

7

RootAssignmentJournalID

bigint

8

Yes

8

Note

varchar

-1

Yes

9

CreatedBy

varchar

50

Yes

10

ModifiedBy

varchar

50

Yes

11

CreatedDate

datetime

8

Yes

12

ModifiedDate

datetime

8

Yes

13

WorkingAreaID

bigint

8

Yes

Constraints (7)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__Assignmen__Worki__32616E72

WorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

FOREIGN KEY

FK_AssignmentJournal_Document

DocumentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Document (DocumentID)

FOREIGN KEY

FK_AssignmentJournal_Person

AssignedByPersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK_AssignmentJournal

AssignmentJournalID

Indexes (1)

Name

Details

Keys

Description

PK_AssignmentJournal

clustered, unique, primary key located on PRIMARY

AssignmentJournalID

Table: dbo. AssignmentScormCourseJournal

Columns (10)

№

Name

System Type

Length

Nullable

Description

1

AssignmentScormJournalID

bigint

8

No

2

AssignedByPersonID

bigint

8

No

3

CourseID

bigint

8

Yes

4

AssignmentDate

datetime

8

No

5

Deadline

datetime

8

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

10

WorkingAreaID

bigint

8

Yes

Constraints (7)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__Assignmen__Worki__7493E88C

WorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

FOREIGN KEY

FK_AssignmentScormCourseJournal_CourseID

CourseID

REFERENCES ITCompetence_Develop_ForTest. dbo. ScormCourse (CourseID)

FOREIGN KEY

FK_AssignmentScormCourseJournal_Person

AssignedByPersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK_AssignmentScormCourseJournal

AssignmentScormJournalID

Indexes (1)

Name

Details

Keys

Description

PK_AssignmentScormCourseJournal

clustered, unique, primary key located on PRIMARY

AssignmentScormJournalID

Table: dbo. ChiefTask

Columns (12)

№

Name

System Type

Length

Nullable

Description

1

ChiefTaskID

bigint

8

No

2

Title

varchar

-1

Yes

3

Deadline

datetime

8

No

4

DocumentID

bigint

8

No

5

ResponsibleID

bigint

8

No

6

Type

smallint

2

No

7

CreatedBy

varchar

50

Yes

8

ModifiedBy

varchar

50

Yes

9

CreatedDate

datetime

8

Yes

10

ModifiedDate

datetime

8

Yes

11

StartDate

datetime

8

Yes

12

WorkingAreaID

bigint

8

Yes

Constraints (9)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__ChiefTask__Worki__2D67AF2B

WorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

FOREIGN KEY

FK_ChiefTask_fk

Type

REFERENCES ITCompetence_Develop_ForTest. dbo. ChiefTaskType (ChiefTaskTypeID)

FOREIGN KEY

FK_t_CheifTask_t_Person

ResponsibleID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

FOREIGN KEY

FK_t_ChiefTask_t_Document

DocumentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Document (DocumentID)

PRIMARY KEY (clustered)

PK_ChiefTask

ChiefTaskID

Indexes (4)

Name

Details

Keys

Description

PK_ChiefTask

clustered, unique, primary key located on PRIMARY

ChiefTaskID

IX_FK_t_CheifTask_t_Person

nonclustered located on PRIMARY

ResponsibleID

IX_FK_t_ChiefTask_t_Document

nonclustered located on PRIMARY

DocumentID

IX_FK_ChiefTask_fk

nonclustered located on PRIMARY

Type

Table: dbo. ChiefTaskPerson

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

ChiefTaskPersonID

bigint

8

No

2

ChiefTaskID

bigint

8

Yes

3

PersonID

bigint

8

No

4

Status

smallint

2

No

5

CreatedBy

varchar

50

Yes

6

ModifiedBy

varchar

50

Yes

7

CreatedDate

datetime

8

Yes

8

ModifiedDate

datetime

8

Yes

9

IsActive

smallint

2

No

Constraints (8)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsActive

DF__ChiefTask__IsAct__31A25463

((1))

FOREIGN KEY

FK_ChiefTaskPerson_ChiefTask

ChiefTaskID

REFERENCES ITCompetence_Develop_ForTest. dbo. ChiefTask (ChiefTaskID)

FOREIGN KEY

FK_ChiefTaskPerson_fk

Status

REFERENCES ITCompetence_Develop_ForTest. dbo. ChiefTaskPersonStatus (ChiefTaskPersonStatusID)

FOREIGN KEY

FK_ChiefTaskPerson_Person

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK_ChiefTaskPerson

ChiefTaskPersonID

Indexes (4)

Name

Details

Keys

Description

PK_ChiefTaskPerson

clustered, unique, primary key located on PRIMARY

ChiefTaskPersonID

IX_FK_ChiefTaskPerson_ChiefTask

nonclustered located on PRIMARY

ChiefTaskID

IX_FK_ChiefTaskPerson_Person

nonclustered located on PRIMARY

PersonID

IX_FK_ChiefTaskPerson_fk

nonclustered located on PRIMARY

Status

Table: dbo. ChiefTaskPersonStatus

Columns (6)

№

Name

System Type

Length

Nullable

Description

1

ChiefTaskPersonStatusID

smallint

2

No

2

Name

varchar

50

No

3

CreatedBy

varchar

50

Yes

4

ModifiedBy

varchar

50

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_ChiefTaskPersonStatus

ChiefTaskPersonStatusID

Indexes (1)

Name

Details

Keys

Description

PK_ChiefTaskPersonStatus

clustered, unique, primary key located on PRIMARY

ChiefTaskPersonStatusID

Table: dbo. ChiefTaskType

Columns (6)

№

Name

System Type

Length

Nullable

Description

1

ChiefTaskTypeID

smallint

2

No

2

Name

varchar

50

No

3

CreatedBy

varchar

50

Yes

4

ModifiedBy

varchar

50

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_ChiefTaskType

ChiefTaskTypeID

Indexes (1)

Name

Details

Keys

Description

PK_ChiefTaskType

clustered, unique, primary key located on PRIMARY

ChiefTaskTypeID

Table: pareOption

Columns (3)

№

Name

System Type

Length

Nullable

Description

1

CompareOptionID

smallint

2

No

2

Name

nvarchar

50

No

3

Description

nvarchar

1000

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__CompareO__4AC6977470D3A237

CompareOptionID

Indexes (1)

Name

Details

Keys

Description

PK__CompareO__4AC6977470D3A237

clustered, unique, primary key located on PRIMARY

CompareOptionID

Table: petence

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

CompetenceID

bigint

8

No

2

DocumentID

bigint

8

Yes

3

Name

varchar

-1

No

4

Description

varchar

-1

Yes

5

IsActive

smallint

2

No

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

Constraints (4)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsActive

DF_t_Competence_f_CompetenceInvisible

((1))

FOREIGN KEY

FK_Competence_Document

DocumentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Document (DocumentID)

PRIMARY KEY (clustered)

PK_t_Competence

CompetenceID

Indexes (1)

Name

Details

Keys

Description

PK_t_Competence

clustered, unique, primary key located on PRIMARY

CompetenceID

Table: petenceArea

Columns (8)

№

Name

System Type

Length

Nullable

Description

1

CompetenceAreaID

int

4

No

2

Name

nvarchar

250

No

3

PersonID

bigint

8

No

4

ParentCompetenceAreaID

int

4

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

7

CreatedBy

varchar

50

Yes

8

ModifiedBy

varchar

50

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_CompetenceArea_CompetenceArea

ParentCompetenceAreaID

REFERENCES ITCompetence_Develop_ForTest. petenceArea (CompetenceAreaID)

FOREIGN KEY

FK_CompetenceArea_Person

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK_CompetenceAreaID

CompetenceAreaID

Indexes (1)

Name

Details

Keys

Description

Table: petenceAreaDocument

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

CompetenceAreaDocumentID

bigint

8

No

2

CompetenceAreaID

int

4

No

3

DocumentID

bigint

8

No

4

CreatedDate

datetime

8

Yes

5

ModifiedDate

datetime

8

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_CompetenceAreaDocument_CompetenceArea

CompetenceAreaID

REFERENCES ITCompetence_Develop_ForTest. petenceArea (CompetenceAreaID)

FOREIGN KEY

FK_CompetenceAreaDocument_Document

DocumentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Document (DocumentID)

PRIMARY KEY (clustered)

PK_CompetenceAreaDocumentID

CompetenceAreaDocumentID

Indexes (1)

Name

Details

Keys

Description

PK_CompetenceAreaDocumentID

clustered, unique, primary key located on PRIMARY

CompetenceAreaDocumentID

Table: petenceAreaInstrument

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

CompetenceAreaInstrumentID

bigint

8

No

2

CompetenceAreaID

int

4

No

3

InstrumentID

bigint

8

No

4

CreatedDate

datetime

8

Yes

5

ModifiedDate

datetime

8

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_CompetenceAreaInstrument_CompetenceArea

CompetenceAreaID

REFERENCES ITCompetence_Develop_ForTest. petenceArea (CompetenceAreaID)

FOREIGN KEY

FK_CompetenceAreaInstrument_Instrument

InstrumentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Instrument (InstrumentID)

PRIMARY KEY (clustered)

PK_CompetenceAreaInstrumentID

CompetenceAreaInstrumentID

Indexes (1)

Name

Details

Keys

Description

PK_CompetenceAreaInstrumentID

clustered, unique, primary key located on PRIMARY

CompetenceAreaInstrumentID

Table: petenceMark

Columns (10)

№

Name

System Type

Length

Nullable

Description

1

CompetenceMarkID

bigint

8

No

2

PersonID

bigint

8

No

3

CompetenceRoleID

bigint

8

No

4

RoleRateID

int

4

Yes

5

DateStart

datetime

8

Yes

6

DateEnd

datetime

8

Yes

7

CreatedDate

datetime

8

Yes

8

ModifiedDate

datetime

8

Yes

9

CreatedBy

varchar

50

Yes

10

ModifiedBy

varchar

50

Yes

Constraints (7)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_CompetenceMark_CompetenceRole

CompetenceRoleID

REFERENCES ITCompetence_Develop_ForTest. petenceRole (CompetenceRoleID)

FOREIGN KEY

FK_CompetenceMark_Person

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

FOREIGN KEY

FK_CompetenceMark_RoleRate

RoleRateID

REFERENCES ITCompetence_Develop_ForTest. dbo. RoleRate (RoleRateId)

PRIMARY KEY (clustered)

PK_CompetenceMarkID

CompetenceMarkID

Indexes (1)

Name

Details

Keys

Description

PK_CompetenceMarkID

clustered, unique, primary key located on PRIMARY

CompetenceMarkID

Table: petenceMatrixImportBuffer
Columns (5)
	№	Name	System Type	Length	Nullable	Description
	1	DocumentName	varchar	1024	No
	2	Role	varchar	1024	No
	3	Competence	varchar	1024	No
	4	DemandedLevel	int	4	No
	5	IsCritical	int	4	No

Table: petenceQuestionImportBuffer
Columns (4)
	№	Name	System Type	Length	Nullable	Description
	1	Competence	varchar	1024	No
	2	Question	varchar	1024	No
	3	Answer	varchar	1024	No
	4	IsCorrect	int	4	No

Table: petenceRole

Columns (15)

№

Name

System Type

Length

Nullable

Description

1

CompetenceRoleID

bigint

8

No

2

RoleID

bigint

8

No

3

CompetenceID

bigint

8

No

4

DemandedLevel

smallint

2

No

5

IsCritical

smallint

2

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

10

TestingResult_For3

smallint

2

Yes

11

TestingResult_For4

smallint

2

Yes

12

TestingResult_For5

smallint

2

Yes

13

RelevancePeriod

int

4

Yes

14

RelevancePeriodTypeID

int

4

Yes

15

CorrectAnswersNumber

int

4

Yes

Constraints (9)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column DemandedLevel

DF_t_CompetenceRole_f_DemandedLevel

((0))

DEFAULT on column IsCritical

DF_t_CompetenceRole_f_IsCritical

((0))

FOREIGN KEY

FK_CompetenceRole_Competence

CompetenceID

REFERENCES ITCompetence_Develop_ForTest. petence (CompetenceID)

FOREIGN KEY

FK_CompetenceRole_RelevancePeriodTypeID

RelevancePeriodTypeID

REFERENCES ITCompetence_Develop_ForTest. dbo. RelevancePeriodType (RelevancePeriodTypeID)

FOREIGN KEY

FK_CompetenceRole_Role

RoleID

REFERENCES ITCompetence_Develop_ForTest. dbo. Role (RoleID)

PRIMARY KEY (clustered)

PK_t_CompetenceRole

CompetenceRoleID

Indexes (1)

Name

Details

Keys

Description

PK_t_CompetenceRole

clustered, unique, primary key located on PRIMARY

CompetenceRoleID

Table: dbo. DBAudit

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

AuditId

bigint

8

No

2

ObjectID

bigint

8

Yes

3

RevisionStamp

datetime

8

Yes

4

TableName

nvarchar

50

Yes

5

UserName

nvarchar

50

Yes

6

Actions

nvarchar

1

Yes

7

OldData

nvarchar

4000

Yes

8

NewData

nvarchar

4000

Yes

9

ChangedColumns

nvarchar

1000

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__DBAudit__A17F23982E46C4CB

AuditId

Indexes (1)

Name

Details

Keys

Description

PK__DBAudit__A17F23982E46C4CB

clustered, unique, primary key located on PRIMARY

AuditId

Table: dbo. DeleteCookiesUser

Columns (6)

№

Name

System Type

Length

Nullable

Description

1

DeleteCookiesUserID

bigint

8

No

2

Login

varchar

50

No

3

CreatedDate

datetime

8

Yes

4

ModifiedDate

datetime

8

Yes

5

CreatedBy

varchar

50

Yes

6

ModifiedBy

varchar

50

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_DeleteCookiesUserID

DeleteCookiesUserID

Indexes (1)

Name

Details

Keys

Description

PK_DeleteCookiesUserID

clustered, unique, primary key located on PRIMARY

DeleteCookiesUserID

Table: dbo. Department

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

DepartmentID

bigint

8

No

2

Name

varchar

100

No

3

IsActive

smallint

2

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (2)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsActive

DF_t_Department_f_DepartmentInvisible

((1))

PRIMARY KEY (clustered)

PK_t_Department

DepartmentID

Indexes (1)

Name

Details

Keys

Description

PK_t_Department

clustered, unique, primary key located on PRIMARY

DepartmentID

Table: dbo. Document

Columns (18)

№

Name

System Type

Length

Nullable

Description

1

DocumentID

bigint

8

No

2

Date

datetime

8

Yes

3

Number

varchar

50

Yes

4

Title

varchar

50

No

5

SignedBy

varchar

50

Yes

6

Description

varchar

-1

Yes

7

Link

varchar

-1

Yes

8

IsActive

smallint

2

No

9

CreatedBy

varchar

50

Yes

10

ModifiedBy

varchar

50

Yes

11

CreatedDate

datetime

8

Yes

12

ModifiedDate

datetime

8

Yes

13

ProcessID

bigint

8

Yes

14

CreatedWorkingAreaID

bigint

8

Yes

15

DocumentCategoryID

bigint

8

No

16

IsRequiredForNewbie

int

4

No

18

OwnerID

bigint

8

Yes

19

IsForJobPerson

int

4

No

Constraints (12)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsForJobPerson

DF__Document__IsForJ__0C1C9550

((0))

DEFAULT on column OwnerID

DF__Document__OwnerI__4DAA618B

(NULL)

DEFAULT on column IsActive

DF_t_Document_f_DocumentVisible

((1))

FOREIGN KEY

FK__Document__Docume__63F8CA06

DocumentCategoryID

REFERENCES ITCompetence_Develop_ForTest. dbo. DocumentCategory (DocumentCategoryID)

FOREIGN KEY

FK__Document__Proces__29CC2871

ProcessID

REFERENCES ITCompetence_Develop_ForTest. dbo. Process (ProcessID)

FOREIGN KEY

FK__Document__Workin__30792600

CreatedWorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

FOREIGN KEY

FK_Document_Person

OwnerID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK_t_Document

DocumentID

Indexes (1)

Name

Details

Keys

Description

PK_t_Document

clustered, unique, primary key located on PRIMARY

DocumentID

Table: dbo. DocumentCategory

Columns (8)

№

Name

System Type

Length

Nullable

Description

1

DocumentCategoryID

bigint

8

No

2

WorkingAreaID

bigint

8

No

3

Name

varchar

200

Yes

4

ShortName

varchar

50

No

5

CreatedBy

varchar

50

Yes

6

ModifiedBy

varchar

50

Yes

7

CreatedDate

datetime

8

Yes

8

ModifiedDate

datetime

8

Yes

Constraints (3)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__DocumentC__Worki__6304A5CD

WorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

PRIMARY KEY (clustered)

PK__DocumentCategory__62108194

DocumentCategoryID

Indexes (1)

Name

Details

Keys

Description

PK__DocumentCategory__62108194

clustered, unique, primary key located on PRIMARY

DocumentCategoryID

Table: dbo. DocumentRole

Columns (6)

№

Name

System Type

Length

Nullable

Description

1

DocumentID

bigint

8

No

2

RoleID

bigint

8

No

3

CreatedBy

varchar

50

Yes

4

ModifiedBy

varchar

50

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_DocumentRole_Document

DocumentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Document (DocumentID)

FOREIGN KEY

FK_DocumentRole_Role

RoleID

REFERENCES ITCompetence_Develop_ForTest. dbo. Role (RoleID)

PRIMARY KEY (clustered)

PK_DocumentRole

DocumentID, RoleID

Indexes (1)

Name

Details

Keys

Description

PK_DocumentRole

clustered, unique, primary key located on PRIMARY

DocumentID, RoleID

Table: dbo. EduCourse

Columns (10)

№

Name

System Type

Length

Nullable

Description

1

EduCourseID

bigint

8

No

2

Year

bigint

8

No

3

Name

varchar

-1

No

4

LearningOrganizationID

bigint

8

No

5

IsActive

smallint

2

No

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

10

Notes

varchar

-1

Yes

Constraints (4)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsActive

DF_EduCourse_IsActive_1_EduCourse

((1))

FOREIGN KEY

FK_EduCourse_LearningOrganization_EduCourse

LearningOrganizationID

REFERENCES ITCompetence_Develop_ForTest. dbo. LearningOrganization (LearningOrganizationID)

PRIMARY KEY (clustered)

PK_EduCourse_1_EduCourse

EduCourseID

Indexes (1)

Name

Details

Keys

Description

PK_EduCourse_1_EduCourse

clustered, unique, primary key located on PRIMARY

EduCourseID

Table: dbo. EduPersonCourse

Columns (16)

№

Name

System Type

Length

Nullable

Description

1

EduPersonCourseID

bigint

8

No

2

EduCourseID

bigint

8

No

3

StatusID

bigint

8

No

4

PersonID

bigint

8

No

5

BeginDatePlan

datetime

8

No

6

EndDatePlan

datetime

8

No

7

BeginDateFact

datetime

8

Yes

8

EndDateFact

datetime

8

Yes

9

Report

varchar

-1

Yes

10

IsActive

smallint

2

No

11

CreatedBy

varchar

50

Yes

12

ModifiedBy

varchar

50

Yes

13

CreatedDate

datetime

8

Yes

14

ModifiedDate

datetime

8

Yes

15

LinkToCerf

varchar

150

Yes

16

WorkingAreaID

bigint

8

Yes

Constraints (10)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsActive

DF_EduPersonCourse_IsActive_EduPersonCourse

((1))

FOREIGN KEY

FK_EduCourse_Person_EduPersonCourse

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

FOREIGN KEY

FK_EduPersonCourse_EduCourse_EduPersonCourse

EduCourseID

REFERENCES ITCompetence_Develop_ForTest. dbo. EduCourse (EduCourseID)

FOREIGN KEY

FK_EduPersonCourse_EduPersonCourseStatus_EduPersonCourse

StatusID

REFERENCES ITCompetence_Develop_ForTest. dbo. EduPersonCourseStatus (EduPersonCourseStatusID)

FOREIGN KEY

FK_EduPersonCourse_WorkingArea

WorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

PRIMARY KEY (clustered)

PK_EduCourse_EduPersonCourse

EduPersonCourseID

Indexes (1)

Name

Details

Keys

Description

PK_EduCourse_EduPersonCourse

clustered, unique, primary key located on PRIMARY

EduPersonCourseID

Table: dbo. EduPersonCourseStatus

Columns (2)

№

Name

System Type

Length

Nullable

Description

1

EduPersonCourseStatusID

bigint

8

No

2

Name

varchar

50

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_EduPpersonCourseState

EduPersonCourseStatusID

Indexes (1)

Name

Details

Keys

Description

PK_EduPpersonCourseState

clustered, unique, primary key located on PRIMARY

EduPersonCourseStatusID

Table: dbo. EduProgram

Columns (10)

№

Name

System Type

Length

Nullable

Description

1

EduProgramID

bigint

8

No

2

Year

bigint

8

No

3

Code

varchar

50

Yes

4

Tittle

varchar

150

No

5

Notes

varchar

-1

Yes

6

IsActive

smallint

2

Yes

7

CreatedBy

varchar

50

Yes

8

ModifiedBy

varchar

50

Yes

9

CreatedDate

datetime

8

Yes

10

ModifiedDate

datetime

8

Yes

Constraints (2)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsActive

DF_EduProgram_IsActive

((1))

PRIMARY KEY (clustered)

PK_EduProgram

EduProgramID

Indexes (1)

Name

Details

Keys

Description

PK_EduProgram

clustered, unique, primary key located on PRIMARY

EduProgramID

Table: dbo. ErrorMessage

Columns (2)

№

Name

System Type

Length

Nullable

Description

1

ErrorMessageID

bigint

8

No

2

Message

varchar

1024

No

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_ErrorMessage

ErrorMessageID

Indexes (1)

Name

Details

Keys

Description

PK_ErrorMessage

clustered, unique, primary key located on PRIMARY

ErrorMessageID

Table: dbo. ExternalSystem

Columns (5)

№

Name

System Type

Length

Nullable

Description

1

ExternalSystemID

bigint

8

No

2

ExternalSystemName

nvarchar

100

No

3

Description

nvarchar

250

No

4

TapeMessageCategoryID

int

4

No

5

PersonAuthorIDAlias

bigint

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__ExternalSystem__41049384

ExternalSystemID

Indexes (1)

Name

Details

Keys

Description

PK__ExternalSystem__41049384

clustered, unique, primary key located on PRIMARY

ExternalSystemID

Table: dbo. HolidayInterval

Columns (11)

№

Name

System Type

Length

Nullable

Description

1

HolidayIntervalID

bigint

8

No

2

Description

varchar

254

Yes

3

ForAllPersons

smallint

2

No

4

IsWorkingDay

smallint

2

No

5

IntervalStart

datetime

8

No

6

IntervalFinish

datetime

8

No

7

AuthorPersonID

bigint

8

Yes

8

CreatedBy

varchar

50

Yes

9

ModifiedBy

varchar

50

Yes

10

CreatedDate

datetime

8

Yes

11

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__HolidayInterval__68BD7F23

HolidayIntervalID

Indexes (1)

Name

Details

Keys

Description

PK__HolidayInterval__68BD7F23

clustered, unique, primary key located on PRIMARY

HolidayIntervalID

Table: dbo. HolidayIntervalPerson

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

HolidayIntervalPersonID

bigint

8

No

2

HolidayIntervalID

bigint

8

No

3

PersonID

bigint

8

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__HolidayIn__Holid__6B99EBCE

HolidayIntervalID

REFERENCES ITCompetence_Develop_ForTest. dbo. HolidayInterval (HolidayIntervalID)

FOREIGN KEY

FK__HolidayIn__Perso__6C8E1007

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK__HolidayIntervalP__6AA5C795

HolidayIntervalPersonID

Indexes (1)

Name

Details

Keys

Description

PK__HolidayIntervalP__6AA5C795

clustered, unique, primary key located on PRIMARY

HolidayIntervalPersonID

Table: dbo. Instrument

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

InstrumentID

bigint

8

No

3

InstrumentName

varchar

100

Yes

4

IsCustom

bit

1

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

7

CreatedBy

varchar

50

Yes

8

ModifiedBy

varchar

50

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_Instrument

InstrumentID

Indexes (1)

Name

Details

Keys

Description

PK_Instrument

clustered, unique, primary key located on PRIMARY

InstrumentID

Table: dbo. Job

Columns (17)

№

Name

System Type

Length

Nullable

Description

1

JobID

bigint

8

No

2

Name

nvarchar

150

Yes

3

RootJobID

bigint

8

Yes

4

Deadline

datetime

8

No

5

DepartmentID

bigint

8

No

6

ResponsibleID

bigint

8

No

7

StatusID

bigint

8

No

8

Review

varchar

-1

Yes

9

Type

smallint

2

No

10

CreatedBy

varchar

50

Yes

11

ModifiedBy

varchar

50

Yes

12

CreatedDate

datetime

8

Yes

13

ModifiedDate

datetime

8

Yes

14

WorkingAreaID

bigint

8

Yes

15

JobTypeID

int

4

No

16

GroupName

nvarchar

1024

Yes

17

IsSelfTrainingJob

bit

1

No

Constraints (13)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsSelfTrainingJob

DF__Job__IsSelfTrain__17BC5DE1

('False')

DEFAULT on column Type

DF_Job_Type

((1))

FOREIGN KEY

FK__Job__JobTypeID__5F3414E9

JobTypeID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobType (JobTypeID)

FOREIGN KEY

FK__Job__WorkingArea__316D4A39

WorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

FOREIGN KEY

FK_t_Job_t_Department

DepartmentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Department (DepartmentID)

FOREIGN KEY

FK_t_Job_t_JobStatus

StatusID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobStatus (JobStatusID)

FOREIGN KEY

FK_t_Job_t_Person

ResponsibleID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK_t_Job

JobID

Indexes (1)

Name

Details

Keys

Description

PK_t_Job

clustered, unique, primary key located on PRIMARY

JobID

Table: dbo. JobAnswer

Columns (11)

№

Name

System Type

Length

Nullable

Description

1

JobAnswerID

bigint

8

No

2

JobQuestionID

bigint

8

No

3

Variant

varchar

-1

No

4

IsCorrect

smallint

2

Yes

5

Selected

int

4

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

10

CorrectOrderNumber

smallint

2

Yes

11

SelectedOrderNumber

smallint

2

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsCorrect

DF_t_JobAnswer_f_JobAnswerIsCorrect

((0))

DEFAULT on column Selected

DF_t_JobAnswer_f_JobAnswerSelected

((0))

FOREIGN KEY

FK_t_JobAnswer_t_JobQuestion

JobQuestionID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobQuestion (JobQuestionID)

PRIMARY KEY (clustered)

PK_t_JobAnswer

JobAnswerID

Indexes (1)

Name

Details

Keys

Description

PK_t_JobAnswer

clustered, unique, primary key located on PRIMARY

JobAnswerID

Table: dbo. JobAnswerConnection

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

JobAnswerConnectionID

bigint

8

No

2

LeftJobAnswerID

bigint

8

Yes

3

RightJobAnswerID

bigint

8

Yes

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__JobAnswer__LeftJ__6561EF8B

LeftJobAnswerID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobAnswer (JobAnswerID)

FOREIGN KEY

FK__JobAnswer__Right__665613C4

RightJobAnswerID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobAnswer (JobAnswerID)

PRIMARY KEY (clustered)

PK__JobAnswe__C8A9931C6379A719

JobAnswerConnectionID

Indexes (1)

Name

Details

Keys

Description

PK__JobAnswe__C8A9931C6379A719

clustered, unique, primary key located on PRIMARY

JobAnswerConnectionID

Table: dbo. JobDetailed

Columns (16)

№

Name

System Type

Length

Nullable

Description

1

JobDetailedID

bigint

8

No

2

JobPersonID

bigint

8

No

3

DocumentID

bigint

8

No

4

Role

varchar

-1

No

5

Competence

varchar

-1

No

6

CompetenceDemandedLevel

smallint

2

No

7

CompetenceIsCritical

smallint

2

Yes

8

CompetenceFactLevel

smallint

2

Yes

9

CreatedBy

varchar

50

Yes

10

ModifiedBy

varchar

50

Yes

11

CreatedDate

datetime

8

Yes

12

ModifiedDate

datetime

8

Yes

13

TestingResult_For3

smallint

2

Yes

14

TestingResult_For4

smallint

2

Yes

15

TestingResult_For5

smallint

2

Yes

16

CompetenceRoleID

bigint

8

Yes

Constraints (8)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column CompetenceIsCritical

DF_JobDetailed_f_JobDetailedCompetenceIsCritical

((0))

FOREIGN KEY

FK_JobDetailed_CompetenceRole

CompetenceRoleID

REFERENCES ITCompetence_Develop_ForTest. petenceRole (CompetenceRoleID)

FOREIGN KEY

FK_JobDetailed_Document

DocumentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Document (DocumentID)

FOREIGN KEY

FK_JobDetailed_JobPerson

JobPersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobPerson (JobPersonID)

PRIMARY KEY (clustered)

PK_t_JobDetailed

JobDetailedID

Indexes (1)

Name

Details

Keys

Description

PK_t_JobDetailed

clustered, unique, primary key located on PRIMARY

JobDetailedID

Table: dbo. JobPerson

Columns (12)

№

Name

System Type

Length

Nullable

Description

1

JobPersonID

bigint

8

No

2

JobID

bigint

8

Yes

3

PersonID

bigint

8

No

4

StatusID

bigint

8

Yes

5

Review

varchar

-1

Yes

6

TimeLimit

bigint

8

Yes

7

CreatedBy

varchar

50

Yes

8

ModifiedBy

varchar

50

Yes

9

CreatedDate

datetime

8

Yes

10

ModifiedDate

datetime

8

Yes

11

FinishDate

datetime

8

Yes

12

RelevanceDate

datetime

8

Yes

Constraints (7)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_JobPerson_Job

JobID

REFERENCES ITCompetence_Develop_ForTest. dbo. Job (JobID)

FOREIGN KEY

FK_JobPerson_JobPersonStatus

StatusID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobPersonStatus (JobPersonStatusID)

FOREIGN KEY

FK_JobPerson_Person

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK_JobPerson

JobPersonID

Indexes (1)

Name

Details

Keys

Description

PK_JobPerson

clustered, unique, primary key located on PRIMARY

JobPersonID

Table: dbo. JobPersonIteration

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

JobPersonIterationID

bigint

8

No

2

JobPersonID

bigint

8

No

3

IterationNumber

int

4

No

4

CreatedDate

datetime

8

Yes

5

ModifiedDate

datetime

8

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

TimeElapsed

bigint

8

Yes

9

IsFinished

bit

1

No

Constraints (3)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_JobPersonIteration_JobPerson

JobPersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobPerson (JobPersonID)

PRIMARY KEY (clustered)

PK_JobPersonIterationID

JobPersonIterationID

Indexes (1)

Name

Details

Keys

Description

PK_JobPersonIterationID

clustered, unique, primary key located on PRIMARY

JobPersonIterationID

Table: dbo. JobPersonStatus

Columns (6)

№

Name

System Type

Length

Nullable

Description

1

JobPersonStatusID

bigint

8

No

2

Name

varchar

50

No

3

CreatedBy

varchar

50

Yes

4

ModifiedBy

varchar

50

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_JobPersonStatus

JobPersonStatusID

Indexes (1)

Name

Details

Keys

Description

PK_JobPersonStatus

clustered, unique, primary key located on PRIMARY

JobPersonStatusID

Table: dbo. JobQuestion

Columns (17)

№

Name

System Type

Length

Nullable

Description

1

JobQuestionID

bigint

8

No

2

JobDetailedId

bigint

8

No

3

IsAnswered

int

4

No

4

Question

varchar

-1

No

5

Type

smallint

2

No

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

10

PersonNote

nvarchar

512

Yes

11

LinkForAnswer

nvarchar

1024

Yes

12

AnswerComment

nvarchar

1000

Yes

14

AnswerTime

int

4

Yes

15

UserInputValue

nvarchar

2000

Yes

16

TotalAnswersNumber

int

4

Yes

17

CorrectAnswersNumber

int

4

Yes

19

IncorrectAnswersNumber

int

4

Yes

Constraints (4)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column Type

DF_t_JobQuestion_f_JobQuestionType

((0))

FOREIGN KEY

FK_t_JobQuestion_t_JobDetailed

JobDetailedId

REFERENCES ITCompetence_Develop_ForTest. dbo. JobDetailed (JobDetailedID)

PRIMARY KEY (clustered)

PK_t_JobQuestion

JobQuestionID

Indexes (1)

Name

Details

Keys

Description

PK_t_JobQuestion

clustered, unique, primary key located on PRIMARY

JobQuestionID

Table: dbo. JobQuestionCompareOption

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

JobQuestionCompareOptionID

bigint

8

No

2

JobQuestionID

bigint

8

No

3

CompareOptionID

smallint

2

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__JobQuesti__Compa__7D39791C

CompareOptionID

REFERENCES ITCompetence_Develop_ForTest. pareOption (CompareOptionID)

FOREIGN KEY

FK__JobQuesti__JobQu__7C4554E3

JobQuestionID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobQuestion (JobQuestionID)

PRIMARY KEY (clustered)

PK__JobQuest__DF21CD017A5D0C71

JobQuestionCompareOptionID

Indexes (1)

Name

Details

Keys

Description

PK__JobQuest__DF21CD017A5D0C71

clustered, unique, primary key located on PRIMARY

JobQuestionCompareOptionID

Table: dbo. JobQuestionIteration

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

JobQuestionIterationID

bigint

8

No

2

JobPersonIterationID

bigint

8

No

3

JobQuestionID

bigint

8

No

4

IsCorrect

bit

1

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

7

CreatedBy

varchar

50

Yes

8

ModifiedBy

varchar

50

Yes

9

JobQuestionsQueueTypeID

int

4

No

Constraints (8)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column JobQuestionsQueueTypeID

DF__JobQuesti__JobQu__0BC09B50

((1))

FOREIGN KEY

FK_JobQuestionIteration_JobPersonIteration

JobPersonIterationID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobPersonIteration (JobPersonIterationID)

FOREIGN KEY

FK_JobQuestionIteration_JobQuestion

JobQuestionID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobQuestion (JobQuestionID)

FOREIGN KEY

FK_JobQuestionIteration_JobQuestionsQueueType

JobQuestionsQueueTypeID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobQuestionsQueueType (JobQuestionsQueueTypeID)

PRIMARY KEY (clustered)

PK_JobQuestionIterationID

JobQuestionIterationID

Indexes (1)

Name

Details

Keys

Description

PK_JobQuestionIterationID

clustered, unique, primary key located on PRIMARY

JobQuestionIterationID

Table: dbo. JobQuestionsQueueType

Columns (2)

№

Name

System Type

Length

Nullable

Description

1

JobQuestionsQueueTypeID

int

4

No

2

Name

varchar

50

No

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_JobQuestionsQueueTypeID

JobQuestionsQueueTypeID

Indexes (1)

Name

Details

Keys

Description

PK_JobQuestionsQueueTypeID

clustered, unique, primary key located on PRIMARY

JobQuestionsQueueTypeID

Table: dbo. JobStatus

Columns (6)

№

Name

System Type

Length

Nullable

Description

1

JobStatusID

bigint

8

No

2

Name

varchar

50

No

3

CreatedBy

varchar

50

Yes

4

ModifiedBy

varchar

50

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_t_JobStatus

JobStatusID

Indexes (1)

Name

Details

Keys

Description

PK_t_JobStatus

clustered, unique, primary key located on PRIMARY

JobStatusID

Table: dbo. JobStatusLog

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

JobStatusLogID

bigint

8

No

2

JobID

bigint

8

Yes

3

JobPersonID

bigint

8

Yes

4

OldStatusID

bigint

8

Yes

5

NewStatusID

bigint

8

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__JobStatusLog__0E240DFC

JobStatusLogID

Indexes (1)

Name

Details

Keys

Description

PK__JobStatusLog__0E240DFC

clustered, unique, primary key located on PRIMARY

JobStatusLogID

Table: dbo. JobType

Columns (3)

№

Name

System Type

Length

Nullable

Description

1

JobTypeID

int

4

No

2

JobTypeName

nvarchar

50

No

3

Description

nvarchar

1024

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__JobType__5E3FF0B0

JobTypeID

Indexes (1)

Name

Details

Keys

Description

PK__JobType__5E3FF0B0

clustered, unique, primary key located on PRIMARY

JobTypeID

Table: dbo. LearningOrganization

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

LearningOrganizationID

bigint

8

No

2

Name

varchar

-1

No

3

IsActive

smallint

2

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (2)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsActive

DF_LearningOrganization_IsActive_LearningOrganization

((1))

PRIMARY KEY (clustered)

PK_LearningOrganization_LearningOrganization

LearningOrganizationID

Indexes (1)

Name

Details

Keys

Description

PK_LearningOrganization_LearningOrganization

clustered, unique, primary key located on PRIMARY

LearningOrganizationID

Table: dbo. MailboxReaderJournal

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

MailboxReaderJournalID

bigint

8

No

2

MailUID

nvarchar

1024

No

3

MailSubject

nvarchar

1024

Yes

4

TapeMessageID

bigint

8

Yes

5

ReadDate

datetime

8

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

Constraints (3)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__MailboxRe__TapeM__7306036C

TapeMessageID

REFERENCES ITCompetence_Develop_ForTest. dbo. TapeMessage (TapeMessageID)

PRIMARY KEY (clustered)

PK__MailboxReaderJou__7211DF33

MailboxReaderJournalID

Indexes (1)

Name

Details

Keys

Description

PK__MailboxReaderJou__7211DF33

clustered, unique, primary key located on PRIMARY

MailboxReaderJournalID

Table: dbo. MailboxReaderJournal

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

MailboxReaderJournalID

bigint

8

No

2

MailUID

nvarchar

1024

No

3

MailSubject

nvarchar

1024

Yes

4

TapeMessageID

bigint

8

Yes

5

ReadDate

datetime

8

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

Constraints (3)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__MailboxRe__TapeM__7306036C

TapeMessageID

REFERENCES ITCompetence_Develop_ForTest. dbo. TapeMessage (TapeMessageID)

PRIMARY KEY (clustered)

PK__MailboxReaderJou__7211DF33

MailboxReaderJournalID

Indexes (1)

Name

Details

Keys

Description

PK__MailboxReaderJou__7211DF33

clustered, unique, primary key located on PRIMARY

MailboxReaderJournalID

Table: dbo. NotificationJournal

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

NotificationJournalID

bigint

8

No

2

Date_Time

datetime

8

No

3

MailTo

varchar

150

Yes

4

NotificationTargetID

bigint

8

No

5

ObjectID

bigint

8

No

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

Constraints (3)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_NotificationJournal_NotificationTarget

NotificationTargetID

REFERENCES ITCompetence_Develop_ForTest. dbo. NotificationTarget (NotificationTargetID)

PRIMARY KEY (clustered)

PK_NotificationJournal

NotificationJournalID

Indexes (1)

Name

Details

Keys

Description

PK_NotificationJournal

clustered, unique, primary key located on PRIMARY

NotificationJournalID

Table: dbo. NotificationMessageType

Columns (6)

№

Name

System Type

Length

Nullable

Description

1

NotificationMessageTypeID

int

4

No

2

TypeName

varchar

150

No

3

CreatedBy

varchar

50

Yes

4

ModifiedBy

varchar

50

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_NotificationMessageType

NotificationMessageTypeID

Indexes (1)

Name

Details

Keys

Description

PK_NotificationMessageType

clustered, unique, primary key located on PRIMARY

NotificationMessageTypeID

Table: dbo. NotificationSettings

Columns (10)

№

Name

System Type

Length

Nullable

Description

1

NotificationSettingsID

bigint

8

No

2

PersonID

bigint

8

No

3

JobPersonCreated

int

4

Yes

4

AssignmentJournalCreated

int

4

Yes

5

JobPersonCompleted

int

4

Yes

6

JobCompleted

int

4

Yes

7

CreatedBy

varchar

50

No

8

ModifiedBy

varchar

50

No

9

CreatedDate

datetime

8

No

10

ModifiedDate

datetime

8

No

Constraints (3)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_Notification_Person

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

PRIMARY KEY (clustered)

PK_Notification

NotificationSettingsID

Indexes (1)

Name

Details

Keys

Description

PK_Notification

clustered, unique, primary key located on PRIMARY

NotificationSettingsID

Table: dbo. NotificationTarget

Columns (12)

№

Name

System Type

Length

Nullable

Description

1

NotificationTargetID

bigint

8

No

2

NotificationMessageTypeID

int

4

No

3

NotificationTargetTypeID

int

4

No

4

TargetValue

int

4

No

5

CreatedBy

varchar

50

Yes

6

ModifiedBy

varchar

50

Yes

7

CreatedDate

datetime

8

Yes

8

ModifiedDate

datetime

8

Yes

9

FontColor

varchar

50

Yes

10

ForeColor

varchar

50

Yes

11

IsBold

smallint

2

Yes

12

TargetActionID

smallint

2

Yes

Constraints (7)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__Notificat__Targe__25077354

TargetActionID

REFERENCES ITCompetence_Develop_ForTest. dbo. TargetAction (TargetActionID)

FOREIGN KEY

FK_NotificationTarget_NotificationMessageType

NotificationMessageTypeID

REFERENCES ITCompetence_Develop_ForTest. dbo. NotificationMessageType (NotificationMessageTypeID)

FOREIGN KEY

FK_NotificationTarget_NotificationTargetType

NotificationTargetTypeID

REFERENCES ITCompetence_Develop_ForTest. dbo. NotificationTargetType (NotificationTargetTypeID)

PRIMARY KEY (clustered)

PK_NotificationTarget

NotificationTargetID

Indexes (1)

Name

Details

Keys

Description

PK_NotificationTarget

clustered, unique, primary key located on PRIMARY

NotificationTargetID

Table: dbo. NotificationTargetType

Columns (6)

№

Name

System Type

Length

Nullable

Description

1

NotificationTargetTypeID

int

4

No

2

TargetTypeName

varchar

150

Yes

3

CreatedBy

varchar

50

Yes

4

ModifiedBy

varchar

50

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_NotificationTargetType

NotificationTargetTypeID

Indexes (1)

Name

Details

Keys

Description

PK_NotificationTargetType

clustered, unique, primary key located on PRIMARY

NotificationTargetTypeID

Table: dbo. Person

Columns (16)

№

Name

System Type

Length

Nullable

Description

1

PersonID

bigint

8

No

2

DepartmentID

bigint

8

Yes

3

Login

varchar

50

No

4

LastName

varchar

50

No

5

FirstName

varchar

50

No

6

MiddleInitial

varchar

50

Yes

7

Title

varchar

50

Yes

8

IsChief

smallint

2

Yes

9

Email

varchar

50

Yes

10

IsActive

smallint

2

No

11

CreatedBy

varchar

50

Yes

12

ModifiedBy

varchar

50

Yes

13

CreatedDate

datetime

8

Yes

14

ModifiedDate

datetime

8

Yes

15

DirectChiefPersonID

bigint

8

Yes

16

LMSUserID

int

4

Yes

Constraints (4)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsActive

DF_Person_IsActive

((1))

FOREIGN KEY

FK_t_Person_t_Department

DepartmentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Department (DepartmentID)

PRIMARY KEY (clustered)

PK_t_Person

PersonID

Indexes (1)

Name

Details

Keys

Description

PK_t_Person

clustered, unique, primary key located on PRIMARY

PersonID

Table: dbo. PersonRole

Columns (8)

№

Name

System Type

Length

Nullable

Description

1

PersonRoleID

bigint

8

No

2

PersonID

bigint

8

No

3

RoleID

bigint

8

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

8

PracticalExperience

numeric

9

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK_t_PersonRole_t_Person

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

FOREIGN KEY

FK_t_PersonRole_t_Role

RoleID

REFERENCES ITCompetence_Develop_ForTest. dbo. Role (RoleID)

PRIMARY KEY (clustered)

PK_t_PersonRole

PersonRoleID

Indexes (2)

Name

Details

Keys

Description

PK_t_PersonRole

clustered, unique, primary key located on PRIMARY

PersonRoleID

IX_PersonRole

nonclustered, unique located on PRIMARY

PersonRoleID

Table: dbo. PersonTapeMessageFilter

Columns (15)

№

Name

System Type

Length

Nullable

Description

1

PersonTapeMessageFilterID

bigint

8

No

2

PersonID

bigint

8

No

3

FilterPriorityID

int

4

No

4

FilterCategoryID

int

4

No

5

FilterReadStatus

int

4

Yes

6

FilterDestination

int

4

Yes

7

FilterArchive

int

4

Yes

8

FilterFrom

int

4

Yes

9

FilterStartDate

datetime

8

Yes

10

FilterEndDate

datetime

8

Yes

11

FilterSearchCriteria

nvarchar

1024

Yes

12

CreatedBy

varchar

50

Yes

13

ModifiedBy

varchar

50

Yes

14

CreatedDate

datetime

8

Yes

15

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__PersonTapeMessag__5A6F5FCC

PersonTapeMessageFilterID

Indexes (1)

Name

Details

Keys

Description

PK__PersonTapeMessag__5A6F5FCC

clustered, unique, primary key located on PRIMARY

PersonTapeMessageFilterID

Table: dbo. PersonWorkingArea

Columns (8)

№

Name

System Type

Length

Nullable

Description

1

PersonWorkingAreaID

bigint

8

No

2

PersonID

bigint

8

No

3

WorkingAreaID

bigint

8

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

8

Roles

nvarchar

100

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__PersonWor__Perso__2E90DD8E

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

FOREIGN KEY

FK__PersonWor__Worki__2F8501C7

WorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

PRIMARY KEY (clustered)

PK__PersonWorkingAre__2D9CB955

PersonWorkingAreaID

Indexes (1)

Name

Details

Keys

Description

PK__PersonWorkingAre__2D9CB955

clustered, unique, primary key located on PRIMARY

PersonWorkingAreaID

Table: dbo. Process

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

ProcessID

bigint

8

No

2

Name

varchar

150

No

3

IsActive

smallint

2

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (2)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column IsActive

DF_Process_IsActive

((1))

PRIMARY KEY (clustered)

PK_ProcessRole

ProcessID

Indexes (1)

Name

Details

Keys

Description

PK_ProcessRole

clustered, unique, primary key located on PRIMARY

ProcessID

Table: dbo. ProgramInaccessibilityJournal

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

ProgramInaccessibilityJournalID

bigint

8

No

2

StartDate

datetime

8

No

3

EndDate

datetime

8

Yes

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__ProgramInaccessi__6F357288

ProgramInaccessibilityJournalID

Indexes (1)

Name

Details

Keys

Description

PK__ProgramInaccessi__6F357288

clustered, unique, primary key located on PRIMARY

ProgramInaccessibilityJournalID

Table: dbo. Question

Columns (11)

№

Name

System Type

Length

Nullable

Description

1

QuestionID

bigint

8

No

2

CompetenceID

bigint

8

No

3

QuestionText

varchar

-1

No

4

Type

smallint

2

No

0 - 1 вариант ответа 1 - возможны несколько вариантов

5

CreatedBy

varchar

50

Yes

6

ModifiedBy

varchar

50

Yes

7

CreatedDate

datetime

8

Yes

8

ModifiedDate

datetime

8

Yes

9

LinkForAnswer

nvarchar

1024

Yes

10

AnswerComment

nvarchar

1000

Yes

11

UseInSelectiveJob

smallint

2

No

Constraints (4)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column Type

DF_t_Question_f_QuestionType

((0))

FOREIGN KEY

FK_t_Question_t_Competence

CompetenceID

REFERENCES ITCompetence_Develop_ForTest. petence (CompetenceID)

PRIMARY KEY (clustered)

PK_t_Question

QuestionID

Indexes (1)

Name

Details

Keys

Description

PK_t_Question

clustered, unique, primary key located on PRIMARY

QuestionID

Table: dbo. QuestionCompareOption

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

QuestionCompareOptionID

bigint

8

No

2

QuestionID

bigint

8

No

3

CompareOptionID

smallint

2

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__QuestionC__Compa__77809FC6

CompareOptionID

REFERENCES ITCompetence_Develop_ForTest. pareOption (CompareOptionID)

FOREIGN KEY

FK__QuestionC__Quest__768C7B8D

QuestionID

REFERENCES ITCompetence_Develop_ForTest. dbo. Question (QuestionID)

PRIMARY KEY (clustered)

PK__Question__EE6911D274A4331B

QuestionCompareOptionID

Indexes (1)

Name

Details

Keys

Description

PK__Question__EE6911D274A4331B

clustered, unique, primary key located on PRIMARY

QuestionCompareOptionID

Table: dbo. QuestionType

Columns (8)

№

Name

System Type

Length

Nullable

Description

1

QuestionTypeID

bigint

8

No

2

Name

varchar

50

No

3

CreatedBy

varchar

50

Yes

4

ModifiedBy

varchar

50

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

7

IsUsed

int

4

No

8

SCORMName

nvarchar

150

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_QuestionType

QuestionTypeID

Indexes (1)

Name

Details

Keys

Description

PK_QuestionType

clustered, unique, primary key located on PRIMARY

QuestionTypeID

Table: dbo. Recommendation

Columns (13)

№

Name

System Type

Length

Nullable

Description

1

RecommendationID

int

4

No

2

RoleID

bigint

8

No

3

PersonID

bigint

8

No

4

InstrumentID

bigint

8

No

5

CreatedDate

datetime

8

Yes

6

Status

int

4

No

7

ModifiedDate

datetime

8

Yes

8

ModifiedBy

varchar

50

Yes

9

CreatedBy

varchar

50

Yes

10

DateAssigned

datetime

8

No

11

Description

varchar

500

Yes

12

CompetenceID

bigint

8

Yes

13

Report

varchar

300

Yes

Constraints (13)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column CreatedDate

DF_Recommendation_CreatedDate

(getdate())

DEFAULT on column Status

DF_Recommendation_Status

((0))

FOREIGN KEY

FK_Recommendation_Competence

CompetenceID

REFERENCES ITCompetence_Develop_ForTest. petence (CompetenceID)

FOREIGN KEY

FK_Recommendation_Instrument

InstrumentID

REFERENCES ITCompetence_Develop_ForTest. dbo. Instrument (InstrumentID)

FOREIGN KEY

FK_Recommendation_Person

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

FOREIGN KEY

FK_Recommendation_RecommendationStatus

Status

REFERENCES ITCompetence_Develop_ForTest. dbo. RecommendationStatus (StatusId)

FOREIGN KEY

FK_Recommendation_Role

RoleID

REFERENCES ITCompetence_Develop_ForTest. dbo. Role (RoleID)

PRIMARY KEY (clustered)

PK_Recommendation

RecommendationID

Indexes (1)

Name

Details

Keys

Description

PK_Recommendation

clustered, unique, primary key located on PRIMARY

RecommendationID

Table: dbo. RecommendationStatus

Columns (2)

№

Name

System Type

Length

Nullable

Description

1

StatusId

int

4

No

2

Name

nvarchar

50

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_RecommendationStatus

StatusId

Indexes (1)

Name

Details

Keys

Description

PK_RecommendationStatus

clustered, unique, primary key located on PRIMARY

StatusId

Table: dbo. RelevancePeriodType

Columns (2)

№

Name

System Type

Length

Nullable

Description

1

RelevancePeriodTypeID

int

4

No

2

Name

varchar

50

No

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_RelevancePeriodTypeID

RelevancePeriodTypeID

Indexes (1)

Name

Details

Keys

Description

PK_RelevancePeriodTypeID

clustered, unique, primary key located on PRIMARY

RelevancePeriodTypeID

Table: dbo. Role

Columns (12)

№

Name

System Type

Length

Nullable

Description

1

RoleID

bigint

8

No

2

ProcessID

bigint

8

Yes

3

Name

varchar

100

No

4

Description

varchar

-1

Yes

5

IsActive

int

4

No

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

10

WorkingAreaID

bigint

8

Yes

11

RecommendedRate

int

4

No

12

OptimalExperience

numeric

9

Yes

Constraints (9)

Constraint Type

Constraint Name

Constraint Keys

Description

DEFAULT on column RecommendedRate

DF_Role_RecommendedRate

((1))

DEFAULT on column IsActive

DF_t_Role_f_RoleInvisible

((1))

FOREIGN KEY

FK__Role__WorkingAre__335592AB

WorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

FOREIGN KEY

FK_Role_Process

ProcessID

REFERENCES ITCompetence_Develop_ForTest. dbo. Process (ProcessID)

FOREIGN KEY

FK_Role_RoleRate

RecommendedRate

REFERENCES ITCompetence_Develop_ForTest. dbo. RoleRate (RoleRateId)

PRIMARY KEY (clustered)

PK_t_Role

RoleID

Indexes (1)

Name

Details

Keys

Description

PK_t_Role

clustered, unique, primary key located on PRIMARY

RoleID

Table: dbo. RoleRate

Columns (2)

№

Name

System Type

Length

Nullable

Description

1

RoleRateId

int

4

No

2

Name

varchar

50

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_RoleRate

RoleRateId

Indexes (1)

Name

Details

Keys

Description

PK_RoleRate

clustered, unique, primary key located on PRIMARY

RoleRateId

Table: dbo. SelectedJobAnswerConnection

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

SelectedJobAnswerConnectionID

bigint

8

No

2

LeftJobAnswerID

bigint

8

Yes

3

RightJobAnswerID

bigint

8

Yes

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__SelectedJ__LeftJ__6B1AC8E1

LeftJobAnswerID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobAnswer (JobAnswerID)

FOREIGN KEY

FK__SelectedJ__Right__6C0EED1A

RightJobAnswerID

REFERENCES ITCompetence_Develop_ForTest. dbo. JobAnswer (JobAnswerID)

PRIMARY KEY (clustered)

PK__Selected__87B0DF716932806F

SelectedJobAnswerConnectionID

Indexes (1)

Name

Details

Keys

Description

PK__Selected__87B0DF716932806F

clustered, unique, primary key located on PRIMARY

SelectedJobAnswerConnectionID

Table: dbo. Setting

Columns (10)

№

Name

System Type

Length

Nullable

Description

1

SettingID

bigint

8

No

2

SettingName

nvarchar

50

No

3

Description

nvarchar

200

Yes

4

DataTypeID

smallint

2

Yes

5

Value

nvarchar

2000

Yes

6

SettingLevel

smallint

2

No

7

CreatedBy

varchar

50

Yes

8

ModifiedBy

varchar

50

Yes

9

CreatedDate

datetime

8

Yes

10

ModifiedDate

datetime

8

Yes

Constraints (3)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__Setting__DataTyp__41A3B202

DataTypeID

REFERENCES ITCompetence_Develop_ForTest. dbo. SettingDataType (SettingDataTypeID)

PRIMARY KEY (clustered)

PK__Setting__40AF8DC9

SettingID

Indexes (1)

Name

Details

Keys

Description

PK__Setting__40AF8DC9

clustered, unique, primary key located on PRIMARY

SettingID

Table: dbo. SettingDataType

Columns (3)

№

Name

System Type

Length

Nullable

Description

1

SettingDataTypeID

smallint

2

No

2

Name

nvarchar

50

Yes

3

Description

nvarchar

50

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__SettingDataType__3EC74557

SettingDataTypeID

Indexes (1)

Name

Details

Keys

Description

PK__SettingDataType__3EC74557

clustered, unique, primary key located on PRIMARY

SettingDataTypeID

Table: dbo. SettingPerson

Columns (8)

№

Name

System Type

Length

Nullable

Description

1

SettingPersonID

bigint

8

No

2

SettingID

bigint

8

No

3

PersonID

bigint

8

No

4

Value

nvarchar

2000

No

5

CreatedBy

varchar

50

Yes

6

ModifiedBy

varchar

50

Yes

7

CreatedDate

datetime

8

Yes

8

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__SettingPe__Perso__4944D3CA

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

FOREIGN KEY

FK__SettingPe__Setti__4850AF91

SettingID

REFERENCES ITCompetence_Develop_ForTest. dbo. Setting (SettingID)

PRIMARY KEY (clustered)

PK__SettingPerson__475C8B58

SettingPersonID

Indexes (1)

Name

Details

Keys

Description

PK__SettingPerson__475C8B58

clustered, unique, primary key located on PRIMARY

SettingPersonID

Table: dbo. sysdiagrams

Columns (5)

№

Name

System Type

Length

Nullable

Description

1

name

nvarchar

128

No

2

principal_id

int

4

No

3

diagram_id

int

4

No

4

version

int

4

Yes

5

definition

varbinary

-1

Yes

Constraints (2)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__sysdiagrams__2D12A970

diagram_id

UNIQUE (non-clustered)

UK_principal_name

principal_id, name

Indexes (2)

Name

Details

Keys

Description

PK__sysdiagrams__2D12A970

clustered, unique, primary key located on PRIMARY

diagram_id

UK_principal_name

nonclustered, unique, unique key located on PRIMARY

principal_id, name

Table: dbo. TapeMessage

Columns (12)

№

Name

System Type

Length

Nullable

Description

1

TapeMessageID

bigint

8

No

2

MessageText

nvarchar

1024

No

3

AuthorPersonID

bigint

8

Yes

4

TapeMessageCategoryID

int

4

No

5

TapeMessagePriorityID

int

4

No

6

ActivePeriodStart

datetime

8

Yes

7

ActivePeriodFinish

datetime

8

Yes

8

CreatedBy

varchar

50

Yes

9

ModifiedBy

varchar

50

Yes

10

CreatedDate

datetime

8

Yes

11

ModifiedDate

datetime

8

Yes

13

IsBroadcastMessage

smallint

2

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__TapeMessa__TapeM__4FF1D159

TapeMessageCategoryID

REFERENCES ITCompetence_Develop_ForTest. dbo. TapeMessageCategory (TapeMessageCategoryID)

FOREIGN KEY

FK__TapeMessa__TapeM__50E5F592

TapeMessagePriorityID

REFERENCES ITCompetence_Develop_ForTest. dbo. TapeMessagePriority (TapeMessagePriorityID)

PRIMARY KEY (clustered)

PK__TapeMessage__4EFDAD20

TapeMessageID

Indexes (1)

Name

Details

Keys

Description

PK__TapeMessage__4EFDAD20

clustered, unique, primary key located on PRIMARY

TapeMessageID

Table: dbo. TapeMessageCategory

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

TapeMessageCategoryID

int

4

No

2

WorkingAreaID

bigint

8

Yes

3

CategoryName

nvarchar

50

No

4

Description

nvarchar

250

Yes

5

IconURL

nvarchar

1024

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__TapeMessageCateg__4D1564AE

TapeMessageCategoryID

Indexes (1)

Name

Details

Keys

Description

PK__TapeMessageCateg__4D1564AE

clustered, unique, primary key located on PRIMARY

TapeMessageCategoryID

Table: dbo. TapeMessagePerson

Columns (9)

№

Name

System Type

Length

Nullable

Description

1

TapeMessagePersonID

bigint

8

No

2

TapeMessageID

bigint

8

No

3

PersonID

bigint

8

No

4

ReadDate

datetime

8

Yes

5

IsArchive

int

4

Yes

6

CreatedBy

varchar

50

Yes

7

ModifiedBy

varchar

50

Yes

8

CreatedDate

datetime

8

Yes

9

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__TapeMessa__Perso__54B68676

PersonID

REFERENCES ITCompetence_Develop_ForTest. dbo. Person (PersonID)

FOREIGN KEY

FK__TapeMessa__TapeM__53C2623D

TapeMessageID

REFERENCES ITCompetence_Develop_ForTest. dbo. TapeMessage (TapeMessageID)

PRIMARY KEY (clustered)

PK__TapeMessagePerso__52CE3E04

TapeMessagePersonID

Indexes (1)

Name

Details

Keys

Description

PK__TapeMessagePerso__52CE3E04

clustered, unique, primary key located on PRIMARY

TapeMessagePersonID

Table: dbo. TapeMessagePriority

Columns (3)

№

Name

System Type

Length

Nullable

Description

1

TapeMessagePriorityID

int

4

No

2

PriorityName

nvarchar

50

No

3

IconURL

nvarchar

1024

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__TapeMessagePrior__4B2D1C3C

TapeMessagePriorityID

Indexes (1)

Name

Details

Keys

Description

PK__TapeMessagePrior__4B2D1C3C

clustered, unique, primary key located on PRIMARY

TapeMessagePriorityID

Table: dbo. TapeMessageWorkingArea

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

TapeMessageWorkingAreaID

bigint

8

No

2

WorkingAreaID

bigint

8

No

3

TapeMessageID

bigint

8

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (5)

Constraint Type

Constraint Name

Constraint Keys

Description

FOREIGN KEY

FK__TapeMessa__TapeM__5887175A

TapeMessageID

REFERENCES ITCompetence_Develop_ForTest. dbo. TapeMessage (TapeMessageID)

FOREIGN KEY

FK__TapeMessa__Worki__5792F321

WorkingAreaID

REFERENCES ITCompetence_Develop_ForTest. dbo. WorkingArea (WorkingAreaID)

PRIMARY KEY (clustered)

PK__TapeMessageWorki__569ECEE8

TapeMessageWorkingAreaID

Indexes (1)

Name

Details

Keys

Description

PK__TapeMessageWorki__569ECEE8

clustered, unique, primary key located on PRIMARY

TapeMessageWorkingAreaID

Table: dbo. TargetAction

Columns (6)

№

Name

System Type

Length

Nullable

Description

1

TargetActionID

smallint

2

No

2

TargetActionName

varchar

150

No

3

CreatedBy

varchar

50

Yes

4

ModifiedBy

varchar

50

Yes

5

CreatedDate

datetime

8

Yes

6

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__TargetAction__24134F1B

TargetActionID

Indexes (1)

Name

Details

Keys

Description

PK__TargetAction__24134F1B

clustered, unique, primary key located on PRIMARY

TargetActionID

Table: dbo. tmp_RoleRegedit
Columns (10)
	№	Name	System Type	Length	Nullable	Description
	1	Role	varchar	-1	Yes
	2	Competence	varchar	-1	Yes
	3	DemandedLevel	smallint	2	Yes
	4	FactLevel	smallint	2	Yes
	5	IsCritical	smallint	2	Yes
	6	DocName	varchar	50	Yes
	7	DocNumber	varchar	50	Yes
	8	DocDate	datetime	8	Yes
	9	PersonFIO	varchar	150	Yes
	10	DepartmentName	varchar	200	Yes

Table: dbo. tmpPerson

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

tmpID

bigint

8

No

2

tmpLogin

varchar

50

Yes

3

tmpLastName

varchar

50

Yes

4

tmpFirstName

varchar

50

Yes

5

tmpMiddleInitial

varchar

50

Yes

6

tmpemail

varchar

50

Yes

7

tmpdepartmentID

varchar

50

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_tmpPerson

tmpID

Indexes (1)

Name

Details

Keys

Description

PK_tmpPerson

clustered, unique, primary key located on PRIMARY

tmpID

Table: dbo. VersionHistory

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

VH_ID

int

4

No

2

VH_FileName

varchar

-1

No

3

VH_DateApplied

datetime

8

No

4

VH_Major

int

4

No

5

VH_Minor

int

4

No

6

VH_Build

int

4

No

7

VH_Revision

int

4

No

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK_VersionHistory

VH_ID

Indexes (1)

Name

Details

Keys

Description

PK_VersionHistory

clustered, unique, primary key located on PRIMARY

VH_ID

Table: dbo. VisualItemLayout

Columns (8)

№

Name

System Type

Length

Nullable

Description

1

UserItemID

bigint

8

No

2

UserLogin

nvarchar

50

No

3

ItemName

nvarchar

200

No

4

ContentString

nvarchar

-1

No

5

CreatedBy

varchar

50

Yes

6

ModifiedBy

varchar

50

Yes

7

CreatedDate

datetime

8

Yes

8

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__VisualItemLayout__0C3BC58A

UserItemID

Indexes (1)

Name

Details

Keys

Description

PK__VisualItemLayout__0C3BC58A

clustered, unique, primary key located on PRIMARY

UserItemID

Table: dbo. WorkingArea

Columns (7)

№

Name

System Type

Length

Nullable

Description

1

WorkingAreaID

bigint

8

No

2

Name

nvarchar

250

Yes

3

ShortName

nvarchar

50

No

4

CreatedBy

varchar

50

Yes

5

ModifiedBy

varchar

50

Yes

6

CreatedDate

datetime

8

Yes

7

ModifiedDate

datetime

8

Yes

Constraints (1)

Constraint Type

Constraint Name

Constraint Keys

Description

PRIMARY KEY (clustered)

PK__WorkingArea__2BB470E3

WorkingAreaID

Indexes (1)

Name

Details

Keys

Description

PK__WorkingArea__2BB470E3

clustered, unique, primary key located on PRIMARY

WorkingAreaID

Структурная схема БД ПС «КОМПЕТЕНЦИИ»

ПЕРЕЧЕНЬ СОКРАЩЕНИЙ

АРМ	Автоматизированное рабочее место
БД	База данных
ИТС	Информационно-телекоммуникационные системы
МЦИ	Межрегиональный центр информатизации
ОС	Операционная система
ОТС	Оперативно-техническая служба
ПС	Программное средство
ПО	Программное обеспечение
СКОИ	Система коллективной обработки информации
ТРД	Техно-рабочая документация
ЦОВ	Центр обработки вызовов

ЛИСТ РЕГИСТРАЦИИ ИЗМЕНЕНИЙ

Изм.	Номера листов (страниц)	Всего листов (страниц) в документе	№ разреш. документа	Подпись	Дата	Примечание
Измененных	Замененных	Новых	Аннулированных