dbo.licenses (Users and License keys)
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | licenses |
Title | Users and License keys |
Module | Utils |
Type | Internal |
Status | Active |
User accounts and corresponding license keys.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | license_id | int | Identity | Row id | Metadata | Active | ||||
Row id Identity Type: Metadata Status: Active |
||||||||||
2 | login | nvarchar(1024) | Dataedo user login. This matches repository database login. | Internal | Active | |||||
Dataedo user login. This matches repository database login. Type: Internal Status: Active |
||||||||||
3 | key | varchar(256) | License key. That includes Free license key. This entry is further encrypted. | Internal | Active | |||||
License key. That includes Free license key. This entry is further encrypted. Type: Internal Status: Active |
||||||||||
4 | host | nvarchar(50) | Name of host that user logged in from. 2 last hosts and dates are remembered. | Internal | Active | |||||
Name of host that user logged in from. 2 last hosts and dates are remembered. Type: Internal Status: Active |
||||||||||
5 | host2 | nvarchar(50) | Name of second host that user logged in from. 2 last hosts and dates are remembered. | Internal | Active | |||||
Name of second host that user logged in from. 2 last hosts and dates are remembered. Type: Internal Status: Active |
||||||||||
6 | host1_last_login | datetime | Date and time of last login from first host | Internal | Active | |||||
Date and time of last login from first host Type: Internal Status: Active |
||||||||||
7 | host2_last_login | datetime | Date and time of last login from second host | Internal | Active | |||||
Date and time of last login from second host 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_licenses | license_id | Table primary key | |
Table primary key | |||
UK_licenses_login | login | Login is uinque in repository user database | |
Login is uinque in repository user database |
Triggers
Key name | When | Description | |
---|---|---|---|
trg_licenses_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_licenses_Modify
|
dbo.licenses (Users and License keys)
|
Used by
Name |
---|
dbo.licenses (Users and License keys)
|
dbo.trg_licenses_Modify
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07