Subscriptions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
apsContexts.subscriptionId apsContexts_ibfk_1 R
PlansSubscriptions.subscription_id PlansSubscriptions_ibfk_1 R
ServiceInstances.servicePackageId ServiceInstances_ibfk_2 R
SubscriptionOutgoingMessagesPeaks.subscriptionId SubscriptionOutgoingMessagesPeaks_ibfk_1 R
SubscriptionOutgoingMessagesStats.subscriptionId SubscriptionOutgoingMessagesStats_ibfk_1 R
SubscriptionProperties.subscription_id SubscriptionProperties_ibfk_1 R
object_id INT UNSIGNED 10 null
object_type enum('client', 'domain') 7 null
locked enum('false', 'true') 6 false
synchronized enum('false', 'true') 6 true
custom enum('false', 'true') 6 false
uuid VARCHAR 36 √ null
external_id VARCHAR 255 √ null
BlUpgrades.id Implied Constraint R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
object_id_and_type Must be unique Asc/Asc object_id + object_type
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation