| Список таблиц |
| Index |
| Table:[dbo].[ATS_Call_Log] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | DateCall | SMALLDATETIME | Y | |
| 3 | src | NVARCHAR(160) | Y | |
| 4 | dst | NVARCHAR(160) | Y | |
| 5 | uniqueid | NVARCHAR(72) | Y | |
| 6 | disposition | NVARCHAR(90) | Y | |
| 7 | dcontext | NVARCHAR(160) | Y | |
| 8 | lastapp | NVARCHAR(160) | Y | |
| 9 | duration | INT | Y | |
| 10 | recordingfile | NVARCHAR(510) | Y | |
| 11 | type_ats | NVARCHAR(20) |
| Index |
| Table:[dbo].[DepartmentObject] |
|---|
| Description |
| Объекты |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | Первичный ключ |
| 2 | FK_Spr_Nconfig | BIGINT | Y | Код конфигурации |
| 3 | FK_Status | BIGINT | Y | Статус объекта |
| 4 | FK_Spr_Objects | BIGINT | Y | Тип объекта |
| 5 | FK_ParentObject | BIGINT | Y | Родительский объект |
| 6 | FK_Main_Parent | BIGINT | Y | Главный родительский объект |
| 7 | Path_Node | NVARCHAR(-1) | Y | Путь к объекту |
| 8 | Level_Node | BIGINT | Y | Уровень объекта |
| 9 | DepartmentObjectName | NVARCHAR(-1) | Y | Название объекта |
| 10 | Visible | BIGINT | Y | Видимость объекта |
| 11 | UID | UNIQUEIDENTIFIER | Y | Идентификатор объекта |
| 12 | XE_Status | BIGINT | N | Статус объекта при обмене |
| 13 | XE_ConfirmedOut | BIT | N | |
| 14 | XE_ConfirmedIn | BIT | N | |
| 15 | XE_Version | BIGINT | N | |
| 16 | XE_RR | BIGINT | N | Признак необходимости расчета объекта |
| 17 | XE_Count | BIGINT | N | |
| 18 | XE_Type | BIGINT | N | |
| 19 | AllowCopy | BIT | N | |
| 20 | AllowDelete | BIT | N | |
| 21 | AllowMove | BIT | N | |
| 22 | DateCreated | DATETIME | Y |
| Index |
| Table:[dbo].[DepartmentObject_Deleted] |
|---|
| Description |
| Объекты удаленные |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | Y | |
| 2 | FK_Spr_Nconfig | BIGINT | Y | |
| 3 | FK_Status | BIGINT | Y | |
| 4 | FK_Spr_Objects | BIGINT | Y | |
| 5 | FK_ParentObject | BIGINT | Y | |
| 6 | FK_Main_Parent | BIGINT | Y | |
| 7 | Path_Node | NVARCHAR(-1) | Y | |
| 8 | Level_Node | BIGINT | Y | |
| 9 | DepartmentObjectName | NVARCHAR(-1) | Y | |
| 10 | Interval_Start | SMALLDATETIME | Y | |
| 11 | Interval_Stop | SMALLDATETIME | Y | |
| 12 | UID | UNIQUEIDENTIFIER | Y |
| Index |
| Table:[dbo].[DepartmentObject_Image] |
|---|
| Description |
| Файлы объектов |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | Первичный ключ |
| 2 | FK_DepartmentData | BIGINT | Y | Ключ объекта |
| 3 | Npp | BIGINT | Y | Номер строки |
| 4 | ColumnImage | BIGINT | Y | Номер столбца |
| 5 | PhotoFileName | NVARCHAR(510) | Y | Имя файла |
| 6 | DescriptionImage | NVARCHAR(510) | Y | Описание файла |
| 7 | ImageData | IMAGE | Y | Файл |
| Index |
| Table:[dbo].[ETP_OBJECT] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | FK_Spr_Nconfig | BIGINT | Y | |
| 3 | FK_Status | BIGINT | Y | |
| 4 | FK_Spr_Objects | BIGINT | Y | |
| 5 | FK_ParentObject | BIGINT | Y | |
| 6 | FK_Main_Parent | BIGINT | Y | |
| 7 | Path_Node | NVARCHAR(-1) | Y | |
| 8 | Level_Node | BIGINT | Y | |
| 9 | DepartmentObjectName | NVARCHAR(-1) | Y | |
| 10 | Visible | BIGINT | Y | |
| 11 | UID | UNIQUEIDENTIFIER | Y | |
| 12 | XE_Status | BIGINT | N | |
| 13 | XE_ConfirmedOut | BIT | N | |
| 14 | XE_ConfirmedIn | BIT | N | |
| 15 | XE_Version | BIGINT | N | |
| 16 | XE_RR | BIGINT | N | |
| 17 | XE_Count | BIGINT | N | |
| 18 | XE_Type | BIGINT | N | |
| 19 | AllowCopy | BIT | N | |
| 20 | AllowDelete | BIT | N | |
| 21 | AllowMove | BIT | N | |
| 22 | DateCreated | DATETIME | Y |
| Index |
| Table:[dbo].[ETP_OBJECT_FIDD] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | FK_EnergyPassport | BIGINT | N | |
| 3 | FK_DepartmentData | BIGINT | N | |
| 4 | Npp | BIGINT | Y | |
| 5 | Value01 | NVARCHAR(-1) | Y | |
| 6 | Value02 | NVARCHAR(-1) | Y | |
| 7 | Value03 | NVARCHAR(-1) | Y | |
| 8 | Value04 | NVARCHAR(-1) | Y | |
| 9 | Value05 | NVARCHAR(-1) | Y | |
| 10 | Value06 | NVARCHAR(-1) | Y | |
| 11 | Description | NVARCHAR(-1) | Y | |
| 12 | Value01BG | BIGINT | Y | |
| 13 | Value01FL | FLOAT | Y |
| Index |
| Table:[dbo].[EX_Doc] |
|---|
| Description |
| Типы документов синхронизации |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | TypeDoc | BIGINT | N | |
| 3 | XE_Date | DATETIME | N | |
| 4 | XE_UID | UNIQUEIDENTIFIER | N | |
| 5 | XE_Status | BIGINT | N | Статус объекта при обмене |
| 6 | XE_ConfirmedOut | BIT | N | |
| 7 | XE_ConfirmedIn | BIT | N | |
| 8 | XE_Version | BIGINT | N | |
| 9 | Date0 | DATETIME | Y | |
| 10 | Date1 | DATETIME | Y | |
| 11 | Date2 | DATETIME | Y | |
| 12 | Date3 | DATETIME | Y | |
| 13 | Date4 | DATETIME | Y | |
| 14 | Count0 | BIGINT | Y | |
| 15 | Count1 | BIGINT | Y | |
| 16 | Count2 | BIGINT | Y | |
| 17 | Count3 | BIGINT | Y | |
| 18 | Count4 | BIGINT | Y | |
| 19 | Money0 | FLOAT | Y | |
| 20 | Money1 | FLOAT | Y | |
| 21 | Money2 | FLOAT | Y | |
| 22 | Money3 | FLOAT | Y | |
| 23 | Money4 | FLOAT | Y | |
| 24 | Text0 | NVARCHAR(-1) | Y | |
| 25 | Text1 | NVARCHAR(-1) | Y | |
| 26 | Text2 | NVARCHAR(-1) | Y | |
| 27 | Text3 | NVARCHAR(-1) | Y | |
| 28 | Text4 | NVARCHAR(-1) | Y | |
| 29 | Image0 | VARBINARY | Y | |
| 30 | Image1 | VARBINARY | Y | |
| 31 | Image2 | VARBINARY | Y | |
| 32 | Image3 | VARBINARY | Y | |
| 33 | Image4 | VARBINARY | Y | |
| 34 | UID0 | UNIQUEIDENTIFIER | Y | |
| 35 | UID1 | UNIQUEIDENTIFIER | Y | |
| 36 | UID2 | UNIQUEIDENTIFIER | Y | |
| 37 | UID3 | UNIQUEIDENTIFIER | Y | |
| 38 | UID4 | UNIQUEIDENTIFIER | Y |
| Index |
| Table:[dbo].[FirstInputDD] |
|---|
| Description |
| Данные сегментов |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | FK_EnergyPassport | BIGINT | N | |
| 3 | FK_DepartmentData | BIGINT | N | |
| 4 | Npp | BIGINT | Y | |
| 5 | Value01 | NVARCHAR(-1) | Y | |
| 6 | Value02 | NVARCHAR(-1) | Y | |
| 7 | Value03 | NVARCHAR(-1) | Y | |
| 8 | Value04 | NVARCHAR(-1) | Y | |
| 9 | Value05 | NVARCHAR(-1) | Y | |
| 10 | Value06 | NVARCHAR(-1) | Y | |
| 11 | Description | NVARCHAR(-1) | Y | |
| 12 | Value01BG | BIGINT | Y | |
| 13 | Value01FL | FLOAT | Y |
| Index |
| Table:[dbo].[FirstInputDD_Deleted] |
|---|
| Description |
| Данные сегментов удаленные |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | Y | |
| 2 | FK_EnergyPassport | BIGINT | Y | |
| 3 | FK_DepartmentData | BIGINT | Y | |
| 4 | FK_DepartmentObject | BIGINT | Y | |
| 5 | Npp | BIGINT | Y | |
| 6 | Value01 | NVARCHAR(-1) | Y | |
| 7 | Value02 | NVARCHAR(-1) | Y | |
| 8 | Value03 | NVARCHAR(-1) | Y | |
| 9 | Value04 | NVARCHAR(-1) | Y | |
| 10 | Value05 | NVARCHAR(-1) | Y | |
| 11 | Value06 | NVARCHAR(-1) | Y | |
| 12 | Description | NVARCHAR(-1) | Y |
| Index |
| Table:[dbo].[FirstInputDD_Updated] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PK | BIGINT | N | |
| 2 | PrimaryKey | BIGINT | Y | |
| 3 | Npp | BIGINT | Y | |
| 4 | Value01_Old | NVARCHAR(-1) | Y | |
| 5 | Value01 | NVARCHAR(-1) | Y | |
| 6 | DateUpdate | DATETIME | Y | |
| 7 | Closed | BIT | Y | |
| 8 | Processed | BIT | Y | |
| 9 | TypeCH | NCHAR(20) | Y |
| Index |
| Table:[dbo].[IdOrganization] |
|---|
| Description |
| Организации |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Name | NVARCHAR(100) | N | |
| 3 | RightsOrganization | BIGINT | N |
| Index |
| Table:[dbo].[IdUser] |
|---|
| Description |
| Пользователи |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Name | NVARCHAR(500) | Y | |
| 3 | Login | NVARCHAR(500) | Y | |
| 4 | Pass | NVARCHAR(500) | Y | |
| 5 | RightsUser | NVARCHAR(500) | N | |
| 6 | FK_IdOrganization | BIGINT | Y | |
| 7 | FIO | NVARCHAR(500) | Y | |
| 8 | NVARCHAR(100) | Y | ||
| 9 | Skype | NVARCHAR(100) | Y | |
| 10 | Phone | NVARCHAR(100) | Y | |
| 11 | ID_www | BIGINT | Y | |
| 12 | Start_object | NVARCHAR(500) | Y | |
| 13 | Start_segment | NVARCHAR(500) | Y | |
| 14 | Sync_On | NVARCHAR(500) | Y | |
| 15 | ExtendedRight | NVARCHAR(-1) | Y | |
| 16 | Vinterface | BIGINT | Y | |
| 17 | Maximize | BIGINT | Y | |
| 18 | Favorite_object | NVARCHAR(-1) | Y | |
| 19 | Sip | NVARCHAR(500) | Y | Номер SIP |
| 20 | UID | UNIQUEIDENTIFIER | Y | Идентификатор объекта |
| 21 | NLicense | NVARCHAR(500) | Y | № Лицензии на компьютере |
| 22 | SMStoRecall | BIGINT | Y | Если 1, то пользователю отправляется информация о звонивших |
| 23 | worker | BIGINT | Y | |
| 24 | UID_Org | UNIQUEIDENTIFIER | Y | Идентификатор объекта |
| 25 | ID_OTRS | BIGINT | Y | |
| 26 | Login_OTRS | NVARCHAR(100) | Y | |
| 27 | Pass_OTRS | NVARCHAR(100) | Y | |
| 28 | Idt | NVARCHAR(100) | Y |
| Index |
| Table:[dbo].[Import_XLSX] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | FN | NVARCHAR(-1) | Y | |
| 2 | NL | NVARCHAR(-1) | Y | |
| 3 | 1 | NVARCHAR(-1) | Y | |
| 4 | 2 | NVARCHAR(-1) | Y | |
| 5 | 3 | NVARCHAR(-1) | Y | |
| 6 | 4 | NVARCHAR(-1) | Y | |
| 7 | 5 | NVARCHAR(-1) | Y | |
| 8 | 6 | NVARCHAR(-1) | Y | |
| 9 | 7 | NVARCHAR(-1) | Y | |
| 10 | 8 | NVARCHAR(-1) | Y | |
| 11 | 9 | NVARCHAR(-1) | Y | |
| 12 | 10 | NVARCHAR(-1) | Y | |
| 13 | 11 | NVARCHAR(-1) | Y | |
| 14 | 12 | NVARCHAR(-1) | Y | |
| 15 | 13 | NVARCHAR(-1) | Y | |
| 16 | 14 | NVARCHAR(-1) | Y | |
| 17 | 15 | NVARCHAR(-1) | Y | |
| 18 | 16 | NVARCHAR(-1) | Y | |
| 19 | 17 | NVARCHAR(-1) | Y | |
| 20 | 18 | NVARCHAR(-1) | Y | |
| 21 | 19 | NVARCHAR(-1) | Y | |
| 22 | 20 | NVARCHAR(-1) | Y | |
| 23 | 21 | NVARCHAR(-1) | Y | |
| 24 | 22 | NVARCHAR(-1) | Y | |
| 25 | 23 | NVARCHAR(-1) | Y | |
| 26 | 24 | NVARCHAR(-1) | Y | |
| 27 | 25 | NVARCHAR(-1) | Y | |
| 28 | 26 | NVARCHAR(-1) | Y | |
| 29 | 27 | NVARCHAR(-1) | Y | |
| 30 | 28 | NVARCHAR(-1) | Y | |
| 31 | 29 | NVARCHAR(-1) | Y | |
| 32 | 30 | NVARCHAR(-1) | Y | |
| 33 | 31 | NVARCHAR(-1) | Y | |
| 34 | 32 | NVARCHAR(-1) | Y | |
| 35 | 33 | NVARCHAR(-1) | Y | |
| 36 | 34 | NVARCHAR(-1) | Y | |
| 37 | 35 | NVARCHAR(-1) | Y | |
| 38 | 36 | NVARCHAR(-1) | Y | |
| 39 | 37 | NVARCHAR(-1) | Y | |
| 40 | 38 | NVARCHAR(-1) | Y | |
| 41 | 39 | NVARCHAR(-1) | Y | |
| 42 | 40 | NVARCHAR(-1) | Y | |
| 43 | 41 | NVARCHAR(-1) | Y | |
| 44 | 42 | NVARCHAR(-1) | Y | |
| 45 | 43 | NVARCHAR(-1) | Y | |
| 46 | 44 | NVARCHAR(-1) | Y | |
| 47 | 45 | NVARCHAR(-1) | Y | |
| 48 | 46 | NVARCHAR(-1) | Y | |
| 49 | 47 | NVARCHAR(-1) | Y | |
| 50 | 48 | NVARCHAR(-1) | Y | |
| 51 | 49 | NVARCHAR(-1) | Y | |
| 52 | 50 | NVARCHAR(-1) | Y | |
| 53 | 51 | NVARCHAR(-1) | Y | |
| 54 | 52 | NVARCHAR(-1) | Y | |
| 55 | 53 | NVARCHAR(-1) | Y | |
| 56 | 54 | NVARCHAR(-1) | Y | |
| 57 | 55 | NVARCHAR(-1) | Y | |
| 58 | 56 | NVARCHAR(-1) | Y | |
| 59 | 57 | NVARCHAR(-1) | Y | |
| 60 | 58 | NVARCHAR(-1) | Y | |
| 61 | 59 | NVARCHAR(-1) | Y | |
| 62 | 60 | NVARCHAR(-1) | Y | |
| 63 | 61 | NVARCHAR(-1) | Y | |
| 64 | 62 | NVARCHAR(-1) | Y | |
| 65 | 63 | NVARCHAR(-1) | Y | |
| 66 | 64 | NVARCHAR(-1) | Y | |
| 67 | 65 | NVARCHAR(-1) | Y | |
| 68 | 66 | NVARCHAR(-1) | Y | |
| 69 | 67 | NVARCHAR(-1) | Y | |
| 70 | 68 | NVARCHAR(-1) | Y | |
| 71 | 69 | NVARCHAR(-1) | Y | |
| 72 | 70 | NVARCHAR(-1) | Y | |
| 73 | 71 | NVARCHAR(-1) | Y | |
| 74 | 72 | NVARCHAR(-1) | Y | |
| 75 | 73 | NVARCHAR(-1) | Y | |
| 76 | 74 | NVARCHAR(-1) | Y | |
| 77 | 75 | NVARCHAR(-1) | Y | |
| 78 | 76 | NVARCHAR(-1) | Y | |
| 79 | 77 | NVARCHAR(-1) | Y | |
| 80 | 78 | NVARCHAR(-1) | Y | |
| 81 | 79 | NVARCHAR(-1) | Y | |
| 82 | 80 | NVARCHAR(-1) | Y | |
| 83 | 81 | NVARCHAR(-1) | Y | |
| 84 | 82 | NVARCHAR(-1) | Y | |
| 85 | 83 | NVARCHAR(-1) | Y | |
| 86 | 84 | NVARCHAR(-1) | Y | |
| 87 | 85 | NVARCHAR(-1) | Y | |
| 88 | 86 | NVARCHAR(-1) | Y | |
| 89 | 87 | NVARCHAR(-1) | Y | |
| 90 | 88 | NVARCHAR(-1) | Y | |
| 91 | 89 | NVARCHAR(-1) | Y | |
| 92 | 90 | NVARCHAR(-1) | Y | |
| 93 | 91 | NVARCHAR(-1) | Y | |
| 94 | 92 | NVARCHAR(-1) | Y | |
| 95 | 93 | NVARCHAR(-1) | Y | |
| 96 | 94 | NVARCHAR(-1) | Y | |
| 97 | 95 | NVARCHAR(-1) | Y | |
| 98 | 96 | NVARCHAR(-1) | Y | |
| 99 | 97 | NVARCHAR(-1) | Y | |
| 100 | 98 | NVARCHAR(-1) | Y | |
| 101 | 99 | NVARCHAR(-1) | Y | |
| 102 | 100 | NVARCHAR(-1) | Y | |
| 103 | PK | BIGINT | N |
| Index |
| Table:[dbo].[Log_ATS] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | N_License | NVARCHAR(100) | Y | |
| 3 | N_User | NVARCHAR(100) | Y | |
| 4 | N_Base | NVARCHAR(100) | Y | |
| 5 | N_Date_Record | DATETIME | Y | |
| 6 | Log_0 | NVARCHAR(-1) | Y | |
| 7 | Log_1 | NVARCHAR(-1) | Y | |
| 8 | Log_2 | NVARCHAR(-1) | Y | |
| 9 | Log_3 | NVARCHAR(-1) | Y | |
| 10 | Log_4 | NVARCHAR(-1) | Y | |
| 11 | Log_5 | NVARCHAR(-1) | Y | |
| 12 | Log_6 | NVARCHAR(-1) | Y | |
| 13 | Log_7 | NVARCHAR(-1) | Y | |
| 14 | Log_8 | NVARCHAR(-1) | Y | |
| 15 | Log_9 | NVARCHAR(-1) | Y | |
| 16 | Log_10 | NVARCHAR(-1) | Y | |
| 17 | Log_11 | NVARCHAR(2000) | Y | |
| 18 | Log_12 | NVARCHAR(2000) | Y | |
| 19 | Log_13 | NVARCHAR(2000) | Y | |
| 20 | Log_14 | NVARCHAR(2000) | Y | |
| 21 | Log_15 | NVARCHAR(2000) | Y | |
| 22 | Log_16 | NVARCHAR(2000) | Y | |
| 23 | Log_17 | NVARCHAR(2000) | Y | |
| 24 | Log_18 | NVARCHAR(2000) | Y | |
| 25 | Log_19 | NVARCHAR(2000) | Y | |
| 26 | Log_20 | NVARCHAR(2000) | Y | |
| 27 | Log_21 | NVARCHAR(2000) | Y | |
| 28 | Log_22 | NVARCHAR(2000) | Y | |
| 29 | Log_23 | NVARCHAR(2000) | Y | |
| 30 | Log_24 | NVARCHAR(2000) | Y | |
| 31 | Log_25 | NVARCHAR(2000) | Y | |
| 32 | Log_26 | NVARCHAR(2000) | Y | |
| 33 | Log_27 | NVARCHAR(2000) | Y | |
| 34 | Log_28 | NVARCHAR(2000) | Y | |
| 35 | Log_29 | NVARCHAR(2000) | Y | |
| 36 | Log_30 | NVARCHAR(2000) | Y | |
| 37 | Log_31 | NVARCHAR(2000) | Y | |
| 38 | Log_32 | NVARCHAR(2000) | Y | |
| 39 | Log_37 | NVARCHAR(2000) | Y | |
| 40 | Log_33 | NVARCHAR(2000) | Y | |
| 41 | Log_34 | NVARCHAR(2000) | Y | |
| 42 | Log_35 | NVARCHAR(2000) | Y | |
| 43 | Log_36 | NVARCHAR(2000) | Y | |
| 44 | Log_38 | NVARCHAR(2000) | Y | |
| 45 | Log_39 | NVARCHAR(2000) | Y | |
| 46 | Log_40 | NVARCHAR(2000) | Y | |
| 47 | Log_41 | NVARCHAR(2000) | Y | |
| 48 | Log_42 | NVARCHAR(2000) | Y | |
| 49 | Log_43 | NVARCHAR(2000) | Y | |
| 50 | Log_44 | NVARCHAR(2000) | Y | |
| 51 | Log_45 | NVARCHAR(2000) | Y | |
| 52 | Log_46 | NVARCHAR(2000) | Y | |
| 53 | Log_47 | NVARCHAR(2000) | Y | |
| 54 | Log_48 | NVARCHAR(2000) | Y | |
| 55 | Log_49 | NVARCHAR(2000) | Y | |
| 56 | Log_50 | NVARCHAR(2000) | Y |
| Index |
| Table:[dbo].[Log_base] |
|---|
| Description |
| Лог работы |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | N_License | NVARCHAR(100) | Y | |
| 3 | N_User | NVARCHAR(100) | Y | |
| 4 | N_Base | NVARCHAR(100) | Y | |
| 5 | N_Date_Record | DATETIME | Y | |
| 6 | Log_0 | NVARCHAR(-1) | Y | |
| 7 | Log_1 | NVARCHAR(-1) | Y | |
| 8 | Log_2 | NVARCHAR(-1) | Y | |
| 9 | Log_3 | NVARCHAR(-1) | Y | |
| 10 | Log_4 | NVARCHAR(-1) | Y | |
| 11 | Log_5 | NVARCHAR(-1) | Y | |
| 12 | Log_6 | NVARCHAR(-1) | Y | |
| 13 | Log_7 | NVARCHAR(-1) | Y | |
| 14 | Log_8 | NVARCHAR(-1) | Y | |
| 15 | Log_9 | NVARCHAR(-1) | Y | |
| 16 | Log_10 | NVARCHAR(-1) | Y | |
| 17 | Log_11 | NVARCHAR(2000) | Y | |
| 18 | Log_12 | NVARCHAR(2000) | Y | |
| 19 | Log_13 | NVARCHAR(2000) | Y | |
| 20 | Log_14 | NVARCHAR(2000) | Y | |
| 21 | Log_15 | NVARCHAR(2000) | Y | |
| 22 | Log_16 | NVARCHAR(2000) | Y | |
| 23 | Log_17 | NVARCHAR(2000) | Y | |
| 24 | Log_18 | NVARCHAR(2000) | Y | |
| 25 | Log_19 | NVARCHAR(2000) | Y | |
| 26 | Log_20 | NVARCHAR(2000) | Y | |
| 27 | Log_21 | NVARCHAR(2000) | Y | |
| 28 | Log_22 | NVARCHAR(2000) | Y | |
| 29 | Log_23 | NVARCHAR(2000) | Y | |
| 30 | Log_24 | NVARCHAR(2000) | Y | |
| 31 | Log_25 | NVARCHAR(2000) | Y | |
| 32 | Log_26 | NVARCHAR(2000) | Y | |
| 33 | Log_27 | NVARCHAR(2000) | Y | |
| 34 | Log_28 | NVARCHAR(2000) | Y | |
| 35 | Log_29 | NVARCHAR(2000) | Y | |
| 36 | Log_30 | NVARCHAR(2000) | Y | |
| 37 | Log_31 | NVARCHAR(2000) | Y | |
| 38 | Log_32 | NVARCHAR(2000) | Y | |
| 39 | Log_37 | NVARCHAR(2000) | Y | |
| 40 | Log_33 | NVARCHAR(2000) | Y | |
| 41 | Log_34 | NVARCHAR(2000) | Y | |
| 42 | Log_35 | NVARCHAR(2000) | Y | |
| 43 | Log_36 | NVARCHAR(2000) | Y | |
| 44 | Log_38 | NVARCHAR(2000) | Y | |
| 45 | Log_39 | NVARCHAR(2000) | Y | |
| 46 | Log_40 | NVARCHAR(2000) | Y | |
| 47 | Log_41 | NVARCHAR(2000) | Y | |
| 48 | Log_42 | NVARCHAR(2000) | Y | |
| 49 | Log_43 | NVARCHAR(2000) | Y | |
| 50 | Log_44 | NVARCHAR(2000) | Y | |
| 51 | Log_45 | NVARCHAR(2000) | Y | |
| 52 | Log_46 | NVARCHAR(2000) | Y | |
| 53 | Log_47 | NVARCHAR(2000) | Y | |
| 54 | Log_48 | NVARCHAR(2000) | Y | |
| 55 | Log_49 | NVARCHAR(2000) | Y | |
| 56 | Log_50 | NVARCHAR(2000) | Y |
| Indexes |
| Sr. | Name | Type | Columns |
|---|---|---|---|
| 1 | PK_Log_base | Clustered | PrimaryKey |
| Index |
| Table:[dbo].[OperationCurrent] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | License | NVARCHAR(100) | Y | |
| 3 | NameUser | NVARCHAR(100) | Y | |
| 4 | DateStart | DATETIME | Y | |
| 5 | PKO_Parent | BIGINT | Y | |
| 6 | PKO | BIGINT | Y | |
| 7 | PKO_Chapter | BIGINT | Y | |
| 8 | PKO_Config | BIGINT | Y | |
| 9 | Level_Node | BIGINT | Y | |
| 10 | StatusOperation | BIGINT | Y | |
| 11 | DescriptionOperation | NVARCHAR(800) | Y | |
| 12 | CommandOperation | NVARCHAR(-1) | Y | |
| 13 | DateStop | DATETIME | Y | |
| 14 | TimeRunSecond | INT | Y | |
| 15 | RunError | NVARCHAR(-1) | Y | |
| 16 | UID_ws | NVARCHAR(90) | Y | |
| 17 | UID_sr | NVARCHAR(90) | Y | |
| 18 | DTRUN | DATETIME | Y | Когда стартовать задание |
| Index |
| Table:[dbo].[OTRS_SMS] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Ticket_id | BIGINT | Y | |
| 3 | DateSMS | DATETIME | Y | |
| 4 | Subject | NVARCHAR(800) | Y | |
| 5 | Message | NVARCHAR(800) | Y | |
| 6 | Phone | NVARCHAR(80) | Y | |
| 7 | KeySMS | NVARCHAR(800) | Y | |
| 8 | Completed | BIGINT | Y | |
| 9 | Answer | BIT | N | |
| 10 | CallBack | BIT | N |
| Index |
| Table:[dbo].[Settings] |
|---|
| Description |
| Настройки |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Категория | NVARCHAR(100) | Y | |
| 3 | Название | NVARCHAR(100) | Y | |
| 4 | Примечание | NVARCHAR(200) | Y | |
| 5 | Значение | NVARCHAR(800) | Y | |
| 6 | Переменная | NVARCHAR(100) | N | |
| 7 | Пример | NVARCHAR(800) | Y |
| Index |
| Table:[dbo].[SipStatus] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Sip | NVARCHAR(100) | Y | |
| 3 | Phone | NVARCHAR(100) | Y | |
| 4 | Status | INT | Y | |
| 5 | DateLast | DATETIME | Y |
| Index |
| Table:[dbo].[Spr_Annotation] |
|---|
| Description |
| Справочник для 1,2 столбца сегмента |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Npp | BIGINT | Y | |
| 3 | documentation | NVARCHAR(2000) | Y | |
| 4 | Code | NVARCHAR(800) | Y | |
| 5 | TypeCode | NVARCHAR(800) | Y | |
| 6 | DocCode | NVARCHAR(800) | Y | |
| 7 | Level_documentation | BIGINT | Y | |
| 8 | UID | UNIQUEIDENTIFIER | Y |
| Index |
| Table:[dbo].[Spr_Check_Chapters] |
|---|
| Description |
| Проверка сегмента |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | FK_EnergyPassport | BIGINT | N | |
| 3 | FK_DepartmentData | BIGINT | N | |
| 4 | FK_IdUser | BIGINT | N | |
| 5 | FK_Spr_Nconfig | BIGINT | N | |
| 6 | FK_Spr_Nconfig_Chapter | BIGINT | N | |
| 7 | DateCheck | SMALLDATETIME | Y | |
| 8 | CheckChapters | INT | Y | |
| 9 | FK_IdUser_Change | BIGINT | Y | |
| 10 | DateChange | SMALLDATETIME | Y |
| Index |
| Table:[dbo].[Spr_CheckInput] |
|---|
| Description |
| Типы полей сегмента |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | NameFormat | NVARCHAR(100) | Y | |
| 3 | Type | NVARCHAR(100) | Y | |
| 4 | Mask_Input | NVARCHAR(100) | Y | |
| 5 | Capacity | INT | Y | |
| 6 | RO | INT | N | |
| 7 | BackColor | NVARCHAR(100) | N | |
| 8 | FontColor | NVARCHAR(100) | N | |
| 9 | BackColorNoData | NVARCHAR(100) | N | |
| 10 | FontColorNoData | NVARCHAR(100) | N | |
| 11 | FontName | NVARCHAR(100) | N | |
| 12 | SaveFast | BIGINT | N | |
| 13 | UID | UNIQUEIDENTIFIER | Y |
| Index |
| Table:[dbo].[Spr_Doc] |
|---|
| Description |
| Типы документов |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | NameDoc | NVARCHAR(800) | N | |
| 3 | UID | UNIQUEIDENTIFIER | Y |
| Index |
| Table:[dbo].[Spr_FirstInputDD] |
|---|
| Description |
| Настройка сегмента |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | NConfig | BIGINT | Y | |
| 3 | Npp | BIGINT | Y | |
| 4 | PrimaryKey01 | BIGINT | Y | |
| 5 | FK_Spr_CheckInput_PK1 | BIGINT | Y | |
| 6 | PrimaryKey02 | BIGINT | Y | |
| 7 | FK_Spr_CheckInput_PK2 | BIGINT | Y | |
| 8 | FK_Spr_CheckInput01 | BIGINT | Y | |
| 9 | Spr01 | NVARCHAR(-1) | Y | |
| 10 | Name_SP01 | NVARCHAR(800) | Y | |
| 11 | FK_Spr_CheckInput02 | BIGINT | Y | |
| 12 | Spr02 | NVARCHAR(800) | Y | |
| 13 | Name_SP02 | NVARCHAR(800) | Y | |
| 14 | FK_Spr_CheckInput03 | BIGINT | Y | |
| 15 | Spr03 | NVARCHAR(800) | Y | |
| 16 | Name_SP03 | NVARCHAR(800) | Y | |
| 17 | SubFunction | NVARCHAR(800) | Y | |
| 18 | FunctionHP | NVARCHAR(800) | Y | |
| 19 | FunctionTotal | NVARCHAR(-1) | Y | |
| 20 | FK_Spr_FirstInput_Shablon | BIGINT | Y | |
| 21 | Shablon_Start | BIGINT | Y | |
| 22 | Remote | BIGINT | Y | |
| 23 | Description | NVARCHAR(8000) | Y | |
| 24 | Links | NVARCHAR(800) | Y | |
| 25 | NameFrow | NVARCHAR(800) | Y | |
| 26 | Hidden | BIGINT | Y | |
| 27 | KH | NVARCHAR(100) | Y | |
| 28 | Dependent_rows | NVARCHAR(800) | Y | |
| 29 | SysName | NVARCHAR(800) | Y |
| Index |
| Table:[dbo].[Spr_Formula] |
|---|
| Description |
| Справочник формул для отчетов |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Chapter | NVARCHAR(800) | Y | |
| 3 | Npp | BIGINT | Y | |
| 4 | DescriptionImage | NVARCHAR(800) | Y | |
| 5 | ImageData | IMAGE | Y |
| Index |
| Table:[dbo].[Spr_Nconfig] |
|---|
| Description |
| Конфигурация |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Name | NVARCHAR(100) | Y | |
| 3 | Description | NVARCHAR(510) | Y | |
| 4 | NumberRows | INT | Y | |
| 5 | NumberRowsDD | INT | Y | |
| 6 | Help | NVARCHAR(8000) | Y |
| Index |
| Table:[dbo].[Spr_Nconfig_Chapter] |
|---|
| Description |
| Сегменты |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | FK_Nconfig | BIGINT | Y | |
| 3 | FK_Spr_Objects | BIGINT | Y | |
| 4 | Level_Chapter | BIGINT | Y | |
| 5 | FK_PK | BIGINT | Y | |
| 6 | Npp | BIGINT | Y | |
| 7 | Name_Chapter | NVARCHAR(510) | Y | |
| 8 | Type_Chapter | NVARCHAR(4) | Y | |
| 9 | Npp_Start | BIGINT | Y | |
| 10 | Npp_Stop | BIGINT | Y | |
| 11 | Panel_1 | BIGINT | Y | |
| 12 | Panel_2 | BIGINT | Y | |
| 13 | Panel_3 | BIGINT | Y | |
| 14 | Panel_4 | BIGINT | Y | |
| 15 | Panel_5 | BIGINT | Y | |
| 16 | Panel_6 | BIGINT | Y | |
| 17 | Panel_7 | BIGINT | Y | |
| 18 | Panel_8 | BIGINT | Y | |
| 19 | Panel_9 | BIGINT | Y | |
| 20 | NForm | BIGINT | Y | |
| 21 | Help | NVARCHAR(8000) | Y | |
| 22 | AutoR | BIGINT | Y | |
| 23 | AutoClose | BIGINT | Y | |
| 24 | CountRas | BIGINT | Y | |
| 25 | TypeAccess | BIGINT | Y | Тип изменения данных: 0 — по умолчанию все разрешено -1 — только создатель имеет право менять данные -2 — первое заполнение больше не изменяемо -3 — сегмент можно открыть только конкретному пользователю, который первый откроет этот раздел 1-….. — Код пользователя — только этот пользователь имеет право менять данные |
| 26 | Layout | IMAGE | Y | |
| 27 | LayoutPlanshet | IMAGE | Y | |
| 28 | LayoutXML | XML | Y | |
| 29 | LayoutXMLuser | XML | Y | |
| 30 | LayoutXMLandroid | XML | Y |
| Index |
| Table:[dbo].[Spr_Objects] |
|---|
| Description |
| Типы объектов |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | Первичный ключ |
| 2 | FK_Nconfig | BIGINT | Y | |
| 3 | Type_Object | NVARCHAR(100) | Y | |
| 4 | User_Object | NVARCHAR(100) | Y | |
| 5 | DepartmentObjectName | NVARCHAR(-1) | N | Номенклатура основной продукции (работ, услуг) |
| 6 | BackColor | NVARCHAR(100) | N | |
| 7 | ForeColor | NVARCHAR(100) | N | |
| 8 | Font | NVARCHAR(100) | N | |
| 9 | FontSize | NVARCHAR(100) | N | |
| 10 | BackColorWdata | NVARCHAR(100) | Y | |
| 11 | ForeColorWdata | NVARCHAR(100) | Y | |
| 12 | FontWdata | NVARCHAR(100) | Y | |
| 13 | FontSizeWdata | NVARCHAR(100) | Y | |
| 14 | NppWdata | BIGINT | Y | |
| 15 | Prefix_Reports | NVARCHAR(100) | N | |
| 16 | Level_Parent | BIGINT | Y | |
| 17 | Property_type | BIGINT | Y | |
| 18 | PictureImage | VARBINARY | Y | |
| 19 | PictureImageSelect | VARBINARY | Y | |
| 20 | PictureImageState | VARBINARY | Y | |
| 21 | UID | UNIQUEIDENTIFIER | Y | |
| 22 | XE_Status | BIGINT | N | Статус объекта при обмене |
| 23 | XE_ConfirmedOut | BIT | N | |
| 24 | XE_ConfirmedIn | BIT | N | |
| 25 | XE_Version | BIGINT | N | |
| 26 | XE_Type | BIGINT | N | Тип объекта синхронизации — 0 — нет, 1 — от офиса в филиал, 2 из филиала в офис, 3 — в любую сторону |
| 27 | XE_filial | NVARCHAR(-1) | N | Список филиалов для обмена, 0 — все , 1,2,3… филиалы, -1 |
| Index |
| Table:[dbo].[spr_ObjectVI] |
|---|
| Description |
| Настройка вида |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | FK_Spr_Annotation_TOOLTIP | BIGINT | Y | |
| 3 | FK_Spr_Annotation_NAME_TEXT | BIGINT | Y | |
| 4 | FK_Spr_CheckInput | BIGINT | Y | |
| 5 | Appendix | INT | Y | |
| 6 | ObjectName | NVARCHAR(100) | Y | |
| 7 | Select_Name_SP | NVARCHAR(510) | Y | |
| 8 | Help_Index | BIGINT | Y | |
| 9 | TypeInOut | BIT | Y |
| Index |
| Table:[dbo].[Spr_OTRS_service] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | id | BIGINT | Y | |
| 2 | name | NVARCHAR(400) | Y | |
| 3 | comments | NVARCHAR(500) | Y | |
| 4 | Code | BIGINT | Y |
| Index |
| Table:[dbo].[Spr_Prepare] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Npp | BIGINT | Y | |
| 3 | TextSQL | NVARCHAR(-1) | Y | |
| 4 | Description | NVARCHAR(-1) | Y | |
| 5 | Сцеп | NVARCHAR(-1) | Y |
| Index |
| Table:[dbo].[Spr_Reports] |
|---|
| Description |
| Справочник отчетов |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | N | INT | N | |
| 3 | NameReport | NVARCHAR(510) | N | |
| 4 | NameFileRep | NVARCHAR(510) | N | |
| 5 | Type_Form | NVARCHAR(510) | N | |
| 6 | LN_Start | BIGINT | N | |
| 7 | LN_Stop | BIGINT | N | |
| 8 | Formula | NVARCHAR(800) | Y | |
| 9 | Project | NVARCHAR(800) | Y | |
| 10 | FileReports | IMAGE | Y | |
| 11 | FileDate | DATETIME | Y | |
| 12 | FileXML | XML | Y |
| Index |
| Table:[dbo].[Spr_Reports_LN] |
|---|
| Description |
| Справочник отчетов дополнительный |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | PK_Spr_Reports | BIGINT | Y | |
| 3 | Description | NVARCHAR(800) | Y | |
| 4 | LN_Start | BIGINT | Y | |
| 5 | LN_Stop | BIGINT | Y | |
| 6 | Type | NVARCHAR(800) | Y |
| Index |
| Table:[dbo].[Spr_Status] |
|---|
| Description |
| Статус конфигурации |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Status | NVARCHAR(100) | Y |
| Index |
| Table:[dbo].[Spr_Status_EX] |
|---|
| Description |
| Статус конфигурации для синхронизации |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Status | NVARCHAR(100) | Y |
| Index |
| Table:[dbo].[Spr_Status_SMS] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | FK_Object | BIGINT | N | |
| 3 | DateTimeSend | DATETIME | Y | |
| 4 | Phone | NVARCHAR(800) | N | |
| 5 | TextSMS | NVARCHAR(800) | N | |
| 6 | StatusSend | NVARCHAR(800) | N |
| Index |
| Table:[dbo].[Spr_Temp_HP] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | name | SYSNAME | N | |
| 2 | id | INT | N | |
| 3 | xtype | CHAR(2) | N | |
| 4 | Segment | NVARCHAR(-1) | Y | |
| 5 | InBase | INT | N |
| Index |
| Table:[dbo].[Spr_User_WWW] |
|---|
| Description |
| Справочник пользователей сайта |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | id | NVARCHAR(100) | Y | |
| 3 | xmlid | NVARCHAR(100) | Y | |
| 4 | account | NVARCHAR(100) | Y | |
| 5 | pass | NVARCHAR(100) | Y | |
| 6 | firstname | NVARCHAR(100) | Y | |
| 7 | secondname | NVARCHAR(100) | Y | |
| 8 | fathername | NVARCHAR(100) | Y | |
| 9 | NVARCHAR(100) | Y | ||
| 10 | phone | NVARCHAR(100) | Y | |
| 11 | skype | NVARCHAR(100) | Y | |
| 12 | address | NVARCHAR(800) | Y | |
| 13 | active | NVARCHAR(100) | Y | |
| 14 | created | NVARCHAR(100) | Y | |
| 15 | modified | NVARCHAR(100) | Y |
| Index |
| Table:[dbo].[SysLog] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Дата | DATETIME | Y | |
| 3 | Тип | NVARCHAR(100) | Y | |
| 4 | conn | NVARCHAR(100) | Y | |
| 5 | rule | NVARCHAR(100) | Y | |
| 6 | sesid | NVARCHAR(100) | Y | |
| 7 | connipproto | NVARCHAR(100) | Y | |
| 8 | connsrcip | NVARCHAR(100) | Y | |
| 9 | connsrcport | NVARCHAR(100) | Y | |
| 10 | origsent | BIGINT | Y | |
| 11 | conndestip | NVARCHAR(100) | Y | |
| 12 | conndestport | NVARCHAR(100) | Y | |
| 13 | termsent | BIGINT | Y | |
| 14 | packet | NVARCHAR(-1) | Y |
| Index |
| Table:[dbo].[Update_config] |
|---|
| Description |
| Таблица для синхронизации |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PK | BIGINT | N | |
| 2 | PrimaryKey_OLD | BIGINT | Y | Первичный ключ |
| 3 | PrimaryKey | BIGINT | Y | Первичный ключ |
| 4 | NameTable | NVARCHAR(800) | Y | |
| 5 | Npp | BIGINT | Y | |
| 6 | Npp_Start | BIGINT | Y | |
| 7 | Npp_Stop | BIGINT | Y | |
| 8 | TextU | NVARCHAR(-1) | Y | |
| 9 | UID | UNIQUEIDENTIFIER | Y | |
| 10 | UID_Parent | UNIQUEIDENTIFIER | Y | |
| 11 | PK_Parent | BIGINT | Y | |
| 12 | FK_Main_Parent | BIGINT | Y | |
| 13 | FK_Spr_Nconfig | BIGINT | Y | |
| 14 | FK_Status | BIGINT | Y | |
| 15 | FK_EnergyPassport | BIGINT | Y |
| Index |
| Table:[dbo].[User_settings_panels] |
|---|
| Description |
| Настройки панелей |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | FK_Iduser | INT | N | |
| 3 | FK_Nconfig | INT | N | |
| 4 | FK_Nchapters | INT | N | |
| 5 | Npanels | INT | N | Название |
| 6 | Wpanels | INT | N | |
| 7 | FK_Nobject | INT | N |
| Index |
| Table:[dbo].[User_Text] |
|---|
| Description |
| Справочник пользовательских констант |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | Utext | NVARCHAR(800) | N | |
| 3 | UID | UNIQUEIDENTIFIER | Y |
| Index |
| Table:[dbo].[UserMessages] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | PrimaryKey | BIGINT | N | |
| 2 | IdMessage | BIGINT | N | |
| 3 | FromUser | BIGINT | N | |
| 4 | ToUser | BIGINT | N | |
| 5 | DateCreate | DATETIME | Y | |
| 6 | DateSend | DATETIME | Y | |
| 7 | UserRead | BIT | Y | |
| 8 | TextMessage | NVARCHAR(-1) | Y |
| Index |
| Table:[dbo].[Users] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | ID | INT | N | |
| 2 | Deleted | BIT | Y | |
| 3 | Name | NVARCHAR(200) | Y | |
| 4 | Password | NVARCHAR(200) | Y | |
| 5 | GroupID | INT | Y | |
| 6 | NVARCHAR(200) | Y |
| Index |
| Table:[dbo].[v_xml_cdr] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | xml_cdr_uuid | CHAR(36) | N | |
| 2 | caller_id_name | NVARCHAR(-1) | Y | |
| 3 | caller_id_number | NVARCHAR(-1) | Y | |
| 4 | start_stamp | DATETIME2 | Y | |
| 5 | remote_media_ip | NVARCHAR(-1) | Y | |
| 6 | record_name | NVARCHAR(-1) | Y |
| Index |
| Table:[dbo].[v_xml_cdr_full] |
|---|
| Description |
| Table Columns |
| Sr. | Name | Datatype | Nullable | Description |
|---|---|---|---|---|
| 1 | xml_cdr_uuid | CHAR(36) | N | |
| 2 | domain_uuid | CHAR(36) | Y | |
| 3 | extension_uuid | CHAR(36) | Y | |
| 4 | domain_name | NVARCHAR(-1) | Y | |
| 5 | accountcode | NVARCHAR(-1) | Y | |
| 6 | direction | NVARCHAR(-1) | Y | |
| 7 | default_language | NVARCHAR(-1) | Y | |
| 8 | context | NVARCHAR(-1) | Y | |
| 9 | xml | NVARCHAR(-1) | Y | |
| 10 | json | VARCHAR(-1) | Y | |
| 11 | caller_id_name | NVARCHAR(-1) | Y | |
| 12 | caller_id_number | NVARCHAR(-1) | Y | |
| 13 | caller_destination | NVARCHAR(-1) | Y | |
| 14 | source_number | NVARCHAR(-1) | Y | |
| 15 | destination_number | NVARCHAR(-1) | Y | |
| 16 | start_epoch | DECIMAL(38,30) | Y | |
| 17 | start_stamp | DATETIME2 | Y | |
| 18 | answer_stamp | DATETIME2 | Y | |
| 19 | answer_epoch | DECIMAL(38,30) | Y | |
| 20 | end_epoch | DECIMAL(38,30) | Y | |
| 21 | end_stamp | NVARCHAR(-1) | Y | |
| 22 | duration | DECIMAL(38,30) | Y | |
| 23 | mduration | DECIMAL(38,30) | Y | |
| 24 | billsec | DECIMAL(38,30) | Y | |
| 25 | billmsec | DECIMAL(38,30) | Y | |
| 26 | bridge_uuid | NVARCHAR(-1) | Y | |
| 27 | read_codec | NVARCHAR(-1) | Y | |
| 28 | read_rate | NVARCHAR(-1) | Y | |
| 29 | write_codec | NVARCHAR(-1) | Y | |
| 30 | write_rate | NVARCHAR(-1) | Y | |
| 31 | remote_media_ip | NVARCHAR(-1) | Y | |
| 32 | network_addr | NVARCHAR(-1) | Y | |
| 33 | record_path | NVARCHAR(-1) | Y | |
| 34 | record_name | NVARCHAR(-1) | Y | |
| 35 | leg | NCHAR(2) | Y | |
| 36 | pdd_ms | DECIMAL(38,30) | Y | |
| 37 | rtp_audio_in_mos | DECIMAL(38,30) | Y | |
| 38 | last_app | NVARCHAR(-1) | Y | |
| 39 | last_arg | NVARCHAR(-1) | Y | |
| 40 | cc_side | NVARCHAR(-1) | Y | |
| 41 | cc_member_uuid | CHAR(36) | Y | |
| 42 | cc_queue_joined_epoch | DECIMAL(38,30) | Y | |
| 43 | cc_queue | NVARCHAR(-1) | Y | |
| 44 | cc_member_session_uuid | CHAR(36) | Y | |
| 45 | cc_agent_uuid | CHAR(36) | Y | |
| 46 | cc_agent | NVARCHAR(-1) | Y | |
| 47 | cc_agent_type | NVARCHAR(-1) | Y | |
| 48 | cc_agent_bridged | NVARCHAR(-1) | Y | |
| 49 | cc_queue_answered_epoch | DECIMAL(38,30) | Y | |
| 50 | cc_queue_terminated_epoch | DECIMAL(38,30) | Y | |
| 51 | cc_queue_canceled_epoch | DECIMAL(38,30) | Y | |
| 52 | cc_cancel_reason | NVARCHAR(-1) | Y | |
| 53 | cc_cause | NVARCHAR(-1) | Y | |
| 54 | waitsec | DECIMAL(38,30) | Y | |
| 55 | conference_name | NVARCHAR(-1) | Y | |
| 56 | conference_uuid | CHAR(36) | Y | |
| 57 | conference_member_id | NVARCHAR(-1) | Y | |
| 58 | digits_dialed | NVARCHAR(-1) | Y | |
| 59 | pin_number | NVARCHAR(-1) | Y | |
| 60 | hangup_cause | NVARCHAR(-1) | Y | |
| 61 | hangup_cause_q850 | DECIMAL(38,30) | Y | |
| 62 | sip_hangup_disposition | NVARCHAR(-1) | Y | |
| 63 | missed_call | VARCHAR(5) | Y |
Структура базы
Автор публикации
Комментарии: 1Публикации: 5Регистрация: 18-03-2016