dbo.licenses (Users and License keys)

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

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

		Name	Data type	Attributes	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
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-08-06 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= CREATE TRIGGER [trg_licenses_Modify] ON [licenses] AFTER INSERT,UPDATE AS BEGIN UPDATE [licenses] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE license_id IN (SELECT DISTINCT license_id FROM Inserted) END
Standard insert/update trigger setting last_modification_date, modified by columns
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-08-06 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= CREATE TRIGGER [trg_licenses_Modify] ON [licenses] AFTER INSERT,UPDATE AS BEGIN UPDATE [licenses] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE license_id IN (SELECT DISTINCT license_id FROM Inserted) END

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