metering_log table - SuperOffice

metering_log Table (501)

Metering log table

Fields

Name	Description	Type	Nullable
metering_log_id	Primary key	PK	No
table_id	Which table the event relates to	TableNumber	Yes
record_id	The record within that table	RecordId	Yes
event_type	Type of the metering event	Enum MeteringEventType	No
status	Status of the metering event	Enum MeteringStatus	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description
table_id, record_id, event_type	TableNumber, RecordId, Enum	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

Enum values for MeteringStatus Enum values for MeteringEventType Database table listing log_events table log_debug table ticket_log table

⌘I