Schema | dbo |
Name | licenses |
Title | Users and License keys |
Module | Utils |
User accounts and corresponding license keys.
PK | Name | Data type | Null | Attributes | Description | |
---|---|---|---|---|---|---|
1 | license_id | int | Identity / Auto increment column | Row ID. | ||
Row ID. Identity / Auto increment column |
||||||
2 | login | nvarchar(1024) | Dataedo user login. This matches repository database login. | |||
Dataedo user login. This matches repository database login. | ||||||
3 | key | varchar(256) | License key. That includes Free license key. This entry is further encrypted. | |||
License key. That includes Free license key. This entry is further encrypted. | ||||||
4 | host | nvarchar(50) | Name of host that user logged in from. 2 last hosts and dates are remembered. | |||
Name of host that user logged in from. 2 last hosts and dates are remembered. | ||||||
5 | host2 | nvarchar(50) | Name of second host that user logged in from. 2 last hosts and dates are remembered. | |||
Name of second host that user logged in from. 2 last hosts and dates are remembered. | ||||||
6 | host1_last_login | datetime | Date and time of last login from first host. | |||
Date and time of last login from first host. | ||||||
7 | host2_last_login | datetime | Date and time of last login from second host. | |||
Date and time of last login from second host. | ||||||
8 | creation_date | datetime | Default: getdate() | Standard row creation timestamp. | ||
Standard row creation timestamp. Default: getdate() |
||||||
9 | created_by | nvarchar(100) | Default: NULL | Database/Dataedo username that created row. | ||
Database/Dataedo username that created row. Default: NULL |
||||||
10 | last_modification_date | datetime | Default: getdate() | Standard row last update timestamp. | ||
Standard row last update timestamp. Default: getdate() |
||||||
11 | modified_by | nvarchar(100) | Default: NULL | Database/Dataedo username that last updated row. | ||
Database/Dataedo username that last updated row. Default: NULL |
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. |
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 |