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
Managed by
Documentation for project Subscriptions
Subscriptions
Project
Name
Subscriptions
Diagram
Name
Main Diagram
Report
Generated
11/7/2026 | 12:59:48 AM
collections
Name
departments
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
name
string
Yes
Validation
"maxLength": 100
description
string
Indexes
departments_ix_name
Create statement
db.departments.createIndex(
{
"name": 1
},
 {
"name": "departments_ix_name"
}
)

References
Name
payments
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
subscriptionId
objectId
Yes
paymentDate
date
Yes
amount
double
Yes
currency
Yes
Enum
["USD","EUR","GBP"]
paymentMethod
string
Validation
"maxLength": 50
invoiceNumber
string
Validation
"maxLength": 100
paidBy
objectId
notes
string
Indexes
payments_ix_paidBy
Create statement
db.payments.createIndex(
{
"paidBy": 1
},
 {
"name": "payments_ix_paidBy"
}
)

payments_ix_invoiceNumber
Create statement
db.payments.createIndex(
{
"invoiceNumber": 1
},
 {
"name": "payments_ix_invoiceNumber"
}
)

Name
vendors
Description
Sensitive data stored
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
name
string
Yes
Validation
"maxLength": 255
website
contactEmail
contactPhone
address
Indexes
vendors_ix_name
Create statement
db.vendors.createIndex(
{
"name": 1
},
 {
"name": "vendors_ix_name"
}
)

References
Name
subscriptions
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
softwareId
objectId
Yes
userId
objectId
startDate
date
Yes
endDate
date
renewalDate
date
Yes
autoRenewal
bool
Yes
status
string
Yes
Validation
"maxLength": 30
cost
double
Yes
currency
Yes
Enum
["USD","EUR","GBP"]
licenseKeys
string
Yes
Validation
"maxLength": 255
seats
int
Yes
Validation
"minimum": 1
paymentMethod
string
Validation
"maxLength": 50
licenseAssignments
Yes
Validation
"uniqueItems": false
Indexes
subscriptions_ix_status
Create statement
db.subscriptions.createIndex(
{
"status": 1
},
 {
"name": "subscriptions_ix_status"
}
)

subscriptions_ix_softwareId
Create statement
db.subscriptions.createIndex(
{
"softwareId": 1
},
 {
"name": "subscriptions_ix_softwareId"
}
)

subscriptions_ix_userId
Create statement
db.subscriptions.createIndex(
{
"userId": 1
},
 {
"name": "subscriptions_ix_userId"
}
)

subscriptions_ix_renewalDate
Create statement
db.subscriptions.createIndex(
{
"renewalDate": 1
},
 {
"name": "subscriptions_ix_renewalDate"
}
)

Name
users
Description
Sensitive data stored
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
username
string
Yes
Validation
"maxLength": 100
email
Yes
firstName
string
Validation
"maxLength": 255
lastName
string
Validation
"maxLength": 255
phone
departmentId
objectId
role
string
Validation
"maxLength": 50
Indexes
users_ix_username
Create statement
db.users.createIndex(
{
"username": 1
},
 {
"name": "users_ix_username"
}
)

users_ix_email
Create statement
db.users.createIndex(
{
"email": 1
},
 {
"name": "users_ix_email"
}
)

Name
software
Fields
Name
Data type
Array
Key
Required
_id
objectId
Yes
Yes
name
string
Yes
Validation
"maxLength": 255
version
string
Validation
"maxLength": 50
vendorId
objectId
description
string
website
Indexes
software_ix_name
Create statement
db.software.createIndex(
{
"name": 1
},
 {
"name": "software_ix_name"
}
)

Lines
Objects
Name
address
Fields
Name
Data type
Array
Key
Required
city
string
street
string
state
string
country
string
Name
licenseAssignments
Fields
Name
Data type
Array
Key
Required
userId
objectId
assignedAt
date
Yes
unassignedAt
date
references
Name
subscriptions_payments
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
departments_users
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
software_subscriptions
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
users_subscriptions
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Caption:
Managed by
Name
users_licenseAssignments
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
users_payments
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Name
vendors_software
Name
Source
Target
Cardinality type:
One to
many
Ordinality:
Mandatory
Mandatory
Lines
Line name
email-email
Lines
Name
Source
Target
Line name
email-contactEmail
Lines
Line name
datatypealias1-phone
Lines
Line name
datatypealias1-contactPhone
Line name
currencyEnum-currency
Line name
currencyEnum-currency
Line name
website-website
Lines
Line name
website-website
Lines
Line name
sample data-departments
Other objects
Name
sample data
Type
Other
Code
db.departments.insertMany([
    { _id: ObjectId("656565656565656565650001"), name: "Engineering", description: "Builds and maintains products" },
    { _id: ObjectId("656565656565656565650002"), name: "Marketing", description: "Promotes and grows brand" },
    { _id: ObjectId("656565656565656565650003"), name: "Finance", description: "Manages budgets and payments" }
  ]);
Name
email
Type
DatatypeAlias
Description
Max length 255
Name
phone
Type
DatatypeAlias
Description
Max lenght 50
Name
currencyEnum
Type
DatatypeAlias
Description
Enumeration for currencies
Name
website
Type
DatatypeAlias
Description
Max length 255
Notes
Name
Subscription tracking
Note

Subscription Tracking

Data model for MongoDB

Name
vendors
Name
subscriptions