dbo.version (Repository version)
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | version |
Title | Repository version |
Module | Utils |
Type | Internal |
Status | Active |
Holds information about repository version and updates. Each update to a new version creates a new row in table.
If Version.update is greater than used Dataedo application version, you won't be able to connect to it.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | version_entry_id | int | Identity | Row id | Internal | Active | ||||
Row id Identity Type: Internal Status: Active |
||||||||||
2 | version | int | Dataedo version (eg. 4) | Internal | Active | |||||
Dataedo version (eg. 4) Type: Internal Status: Active |
||||||||||
3 | update | int | Default: 0 | Repository update. This is still the same version, but a patch has been applied. Eg. 4.1 | Internal | Active | ||||
Repository update. This is still the same version, but a patch has been applied. Eg. 4.1 Default: 0 Type: Internal Status: Active |
||||||||||
4 | release | int | Default: 0 | Not used anymore | Internal | Cancelled | ||||
Not used anymore Default: 0 Type: Internal Status: Cancelled |
||||||||||
5 | stable | bit | 1 when installation/upgrade was performed sucessfuly, 0 when it was stopped for some reason. | Internal | Active | |||||
1 when installation/upgrade was performed sucessfuly, 0 when it was stopped for some reason. Type: Internal Status: Active |
||||||||||
6 | installation_date | datetime | Default: getdate() | Time of repository installation/upgrade. | Internal | Active | ||||
Time of repository installation/upgrade. Default: getdate() Type: Internal Status: Active |
||||||||||
7 | installed_by | nvarchar(100) | Default: suser_sname() | Name of Database/Dataedo user that upgraded repository. | Internal | Active | ||||
Name of Database/Dataedo user that upgraded repository. Default: suser_sname() Type: Internal Status: Active |
||||||||||
8 | creation_date | datetime | Default: getdate() | Standard row creation timestamp | Metadata | Active | ||||
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
9 | created_by | nvarchar(1024) | Default: suser_sname() | Dataedo username that created row | Metadata | Active | ||||
Dataedo username that created row Default: suser_sname() Type: Metadata Status: Active |
||||||||||
10 | last_modification_date | datetime | Default: getdate() | Standard row last update timestamp | Metadata | Active | ||||
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
11 | modified_by | nvarchar(1024) | Default: suser_sname() | Dataedo username that last updated row | Metadata | Active | ||||
Dataedo username that last updated row Default: suser_sname() Type: Metadata Status: Active |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_version | version_entry_id | Table primary key | |
Table primary key | |||
UK_version | version, update, release | Version and update must be unique | |
Version and update must be unique |
Triggers
Key name | When | Description | |
---|---|---|---|
trg_version_Modify | After Insert, Update | Standard insert/update trigger setting last_modification_date, modified by columns | |
Standard insert/update trigger setting last_modification_date, modified by columns |
Uses
Name |
---|
dbo.trg_version_Modify
|
dbo.version (Repository version)
|
Used by
Name |
---|
dbo.version (Repository version)
|
dbo.trg_version_Modify
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07