public.subuserusagedata

public.subuserusagedata

Description

Subscription Detailed Data

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
keyid	varchar(100)		false			Primary Key
date	timestamp without time zone		true			Date
userlogin	varchar(50)		true			User GUID
licensename	varchar(200)		true			License Used
secs	numeric(20,2)		true			Time in Secs
hoursstr	varchar(50)		true
updated	timestamp without time zone		true			Date Row Updated (UTC)

Constraints

Name	Type	Definition
subuserusagedata_pkey	PRIMARY KEY	PRIMARY KEY (keyid)

Indexes

Name	Definition
subuserusagedata_pkey	CREATE UNIQUE INDEX subuserusagedata_pkey ON public.subuserusagedata USING btree (keyid)