Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Code | varchar | 5 | null |
|
|
|||
| Description | varchar | 50 | √ | null |
|
|
||
| DatabaseName | nvarchar | 256 | √ | null |
|
|
||
| BuildNumber | varchar | 30 | null |
|
|
|||
| VersionNumber | decimal | 16,8 | √ | null |
|
|
||
| VersionInstalledDate | datetime | 16,3 | √ | null |
|
|
||
| Type | varchar | 10 | null |
|
|
|||
| VersionInstalledByWorkstation | varchar | 50 | null |
|
|
|||
| ScriptName | varchar | 50 | √ | null |
|
|
||
| SchemaName | varchar | 128 | √ | null |
|
|
||
| CrystalReportUserName | nvarchar | 1073741823 | √ | null |
|
|
||
| CrystalReportPassword | varchar | 2147483647 | √ | null |
|
|
||
| SSRSUserName | varchar | 2147483647 | √ | null |
|
|
||
| SSRSPassword | varchar | 2147483647 | √ | null |
|
|
||
| SingleDatabaseFlag | bit | 1 | √ | null |
|
|
||
| DatabaseOrSchemaName | varchar | 50 | null |
|
|
|||
| CrystalReportPortalUserName | nvarchar | 400 | null |
|
|
|||
| CrystalReportPortalPassword | varchar | 100 | √ | null |
|
|
||
| CrystalReportPortalRole | varchar | 99 | null |
|
|
|||
| ReportRole | varchar | 83 | null |
|
|
|||
| SynergeticUserName | nvarchar | 370 | null |
|
|
|||
| SynergeticPassword | varchar | 100 | √ | null |
|
|
||
| SynergeticRole | varchar | 81 | null |
|
|
|||
| CommunityPortalUserName | nvarchar | 392 | null |
|
|
|||
| CommunityPortalRole | varchar | 92 | null |
|
|
|||
| CommunityPortalPassword | varchar | 100 | √ | null |
|
|
||
| CommunityPortalUserFormRole | varchar | 100 | null |
|
|
|||
| JournalTransferUserName | nvarchar | 392 | null |
|
|
|||
| JournalTransferRole | varchar | 92 | null |
|
|
|||
| ServiceSuiteUserName | nvarchar | 386 | null |
|
|
|||
| ServiceSuitePassword | varchar | 100 | √ | null |
|
|
||
| ServiceSuiteRole | varchar | 89 | null |
|
|
|||
| ArrivalDepartureUserName | nvarchar | 394 | null |
|
|
|||
| ArrivalDeparturePassword | varchar | 100 | √ | null |
|
|
||
| ArrivalDepartureRole | varchar | 93 | null |
|
|
|||
| SynAPIUserName | nvarchar | 374 | null |
|
|
|||
| SynAPIPassword | varchar | 100 | √ | null |
|
|
||
| SynAPIRole | varchar | 83 | null |
|
|
|||
| CoreAPIUserName | nvarchar | 376 | null |
|
|
|||
| CoreAPIPassword | varchar | 100 | √ | null |
|
|
||
| CoreAPIRole | varchar | 84 | null |
|
|
|||
| WebServiceUserName | nvarchar | 382 | null |
|
|
|||
| WebServicePassword | varchar | 100 | √ | null |
|
|
||
| WebServiceRole | varchar | 87 | null |
|
|
|||
| UserFormSimpleUserName | nvarchar | 390 | null |
|
|
|||
| UserFormSimplePassword | varchar | 100 | √ | null |
|
|
||
| UserFormSimpleRole | varchar | 91 | null |
|
|
|||
| SystemEmailUserName | nvarchar | 282 | null |
|
|
|||
| SystemEmailPassword | varchar | 100 | √ | null |
|
|
||
| SystemEmailRole | varchar | 37 | null |
|
|
|||
| StudyPeriodUserName | nvarchar | 384 | null |
|
|
|||
| StudyPeriodPassword | varchar | 100 | √ | null |
|
|
||
| StudyPeriodRole | varchar | 88 | null |
|
|
|||
| SIFUserName | nvarchar | 368 | null |
|
|
|||
| SIFPassword | varchar | 100 | √ | null |
|
|
||
| SIFRole | varchar | 80 | null |
|
|
|||
| PowerBIRole | varchar | 84 | null |
|
|
Table contained 0 rows