Subscription

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SubscriptionID INT 10 √ null
OrganisationID INT 10 null
Organisation.OrganisationID Implied Constraint R

FK to Organisation table
SubscribingUserID INT 10 null

FK to User table
StripeCustomerID VARCHAR 255 √ null
StripeReference VARCHAR 255 √ null
SubscriptionStartDateTime DATETIME 19 √ null
SubscriptionEndDateTime DATETIME 19 √ null
PackageID INT 10 null

FK to Packages table
SubscriptionStatus VARCHAR 100
SubscriptionCancelledDateTime DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc SubscriptionID

Relationships

Close relationships within degrees of separation