Database

23 Firestore collections verified against production — project max-inventory-scanner-b0b53

Infrastructure

Cloud Firestore

23 Collections

Firebase Storage

Files & Exports

Archive DB

Secondary Firestore

Core Collections

Catalog Collections

User & Auth

System Collections

Core Collections

Packages

Every package in the system

packageID string — Document ID
clientID string — Owner reference
trackingNumber string — Cleaned tracking #
rawTrackingNumber string — Original scan
status string — Pipeline stage
logistic string — Carrier name
containerID string — Assigned container
dimensions map — h/l/w
scanHistory array — Scan log
lastScanned timestamp
isMainPackage boolean
consolidatedInto string
containsPackages array

Clients

Client directory with Square integration

clientID string — Document ID
firstName, lastName, name string
emailAddress string — Contact email
phoneNumber string — E.164 format
referenceId / showID string — Client #
squareCustomerId string
location string — Roatan, Utila, etc.
discountCode string — Default discount
creationSource string
needsAdminReview boolean

Invoices

Billing with Square payment sync

invoiceID string — Document ID
clientID, containerID string
squareCustomerId string
status string — APPROVED / UNAPPROVED
packages array — Line items with costs
subTotal, tax, totalCost number
automaticallySent number — 0-4 status code
isAllUnloaded boolean
invoiceSent boolean
sentToSquareAt timestamp

Containers

Shipping containers with nested invoices

containerName string — e.g. "Container - 01/27/2026"
containerCreatedAt timestamp
isBackedUp boolean — Archived flag
invoices array — [{invoiceID, packages: [{packageID, status}]}]

Catalog Collections

Items

Product catalog with Square tokens

itemID string
itemName string — e.g. "70 Inch TV"
itemCost number
categoryID string — Ref to Categories
tokenID string — Square catalog ID

User & Auth Collections

User

Staff accounts

userID, username, name
password, userRole
isSuperAdmin, isLoggedIn
activeDeviceId, lastActiveAt

Password

Shared app password

password string
Single document

UserLogs

Session tracking

userID string
loginTime, logoutTime timestamp
isActive boolean

activeDevices

Logged-in devices

userId, deviceId
loggedInAt timestamp

webPermissions

Web app access control

action string
allowedUsers array

AppPermissions

Scanner app access control

action string
userIDs array

System Collections (9)

Collection	Purpose	Key Fields
Temp	System timers (password expiry)	isPasswordExpired
systemVars	Auto-incrementing IDs and counters	labelCounter.lastNumber, lastRefId per series
webLogs	Activity audit trail	action, message, timestamp, userID, isFromApp, isBadScan
ProcessedOperations	Invoice processing idempotency	invoiceID, processedAt
PubSubQueue	PubSub deduplication	operationID, enqueuedAt
squareAPILog	Square API call audit	orderData, invoiceData (full request payloads)
checkResults	Daily data quality results	issues[], runDate, updatedAt
userDailyData	Daily activity aggregation	Written by dailyDataReport
UserAppVersion	App version tracking	userID, version

Data Relationships

Clients

→

Packages

→

Containers

Packages

→

Invoices

→

Square API

Client owns many Packages (via clientID)
Packages loaded into Containers (via containerID)
Invoices generated per client per container
Items linked to Categories (via categoryID) for tax rules
Invoices sync with Square for payment (via squareCustomerId)
User referenced by webPermissions, AppPermissions, UserLogs, activeDevices

Storage Buckets

Path	Contents
loadedPackages/	Loaded package manifests and packing lists
prepaid/	Prepaid shipment documentation
excelsheets/	Generated XLSX reports (loaded packages, prepaid)
json/packages.json	Combined package data for scanner app

Bucket: max-inventory-scanner-b0b53.appspot.com

📖 Deep dive: Full Data Model Reference — all 23 collections with complete field schemas

← Back to MaxShipping