departments
_id
objectId
NN
name
string
NN
description
string
Primary
departments_ix_name
vendors
_id
objectId
NN
name
string
NN
website
website
contactEmail
email
contactPhone
phone
address{}
object
Primary
vendors_ix_name
Sensitive data stored
payments
_id
objectId
NN
subscriptionId
objectId
NN
paymentDate
date
NN
amount
double
NN
currency
currencyEnum
NN
paymentMethod
string
invoiceNumber
string
paidBy
objectId
notes
string
Primary
payments_ix_paidBy
payments_ix_invoiceNumber
address { }
city
string
street
string
state
string
country
string
Primary key
users
_id
objectId
NN
username
string
NN
email
email
NN
firstName
string
lastName
string
phone
phone
departmentId
objectId
role
string
Primary
users_ix_username
users_ix_email
Sensitive data stored
licenseAssignments [{ }]
userId
objectId
assignedAt
date
NN
unassignedAt
date
Primary key
software
_id
objectId
NN
name
string
NN
version
string
vendorId
objectId
description
string
website
website
Primary
software_ix_name
subscriptions
_id
objectId
NN
softwareId
objectId
NN
userId
objectId
startDate
date
NN
endDate
date
renewalDate
date
NN
autoRenewal
bool
NN
status
string
NN
cost
double
NN
currency
currencyEnum
NN
licenseKeys[]
string
seats
int
NN
paymentMethod
string
licenseAssignments[{}]
object
Primary
subscriptions_ix_status
subscriptions_ix_softwareId
subscriptions_ix_userId
subscriptions_ix_renewalDate
vendors
Subscription Tracking
Data model for MongoDB
subscriptions
Other
sample data