Table: dbo.licenses (Users and License keys)

Schema dbo
Name licenses
Title Users and License keys
Module Utils

User accounts and corresponding license keys.

Columns
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
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
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30