MAILEXPRESS

Basic Index   Expanded Index

Table Name: medatabase.PickupConfigLog
Description: Auditing table for changes to corresponding with table PickupConfig.
Primary Keys: identifier
logNumber
Field Type Defaults Nulls? Comments
identifier numeric (19) None No Unique ID for an entry.
logNumber numeric (19) None No Audit log identifier.
requireEmailVerification tinyint None Yes Whether auto-generated external users must activate account through separate email to use pick-up portal.
requireVerifiedUser tinyint None Yes Whether users must log in to use pick-up portal.
serviceEnabled tinyint None Yes Whether or not the pick-up portal is enabled.

Index Clustered? Unique? Fields
PK__PickupCo__B55535B70A6000BE Yes Yes

No check constraints
Internal Foreign Key Constraint Affected Field Source Table
FK609AA166D247948F identifier AbstractSingletonLog
FK609AA166D247948F logNumber AbstractSingletonLog

No primary keys as foreign key constraints
No triggers