Database Documentation
ZeyOS features an open database model that gives developers direct access to all business data, from custom reports to integrations and automation.
- Entities
- 82
- Views
- 4
- Meta Tables
- 33
Access Methods
Choose the approach that best fits your use case.
Database Reference
Browse the complete schema, or search by table name and description.
Core Entities
Customer and supplier accounts with billing, financial, and contact information.
Time-tracked action steps linked to tasks, tickets, or accounts.
Billing and shipping addresses linking accounts to contacts.
Static assets and files belonging to ZeyOS applications.
ZeyOS applications with settings, versioning, and OAuth configuration.
Calendar appointments with recurrence, location, and color coding.
Generic many-to-many relationships between any two entities.
Binary file storage with hash-based deduplication.
Marketing campaigns with status tracking and date ranges.
User-defined categories for organizing entities.
changes data table.
Communication channels for entity notifications and updates.
User comments attached to activity records.
Bill of materials linking parent items to component items.
Contact records with personal, company, and address information.
Junction table linking related contacts to each other.
Recurring contracts with billing cycles and auto-billing settings.
Individual coupon codes with redemption tracking.
Discount coupons with value, tax rate, and validity periods.
CPU usage statistics for system monitoring.
Aggregated CPU metrics from the collector service.
Custom field definitions for extending entity schemas.
CalDAV/CardDAV sync identifiers for external calendar/contact sync.
CalDAV/CardDAV server configurations for sync.
Serialized inventory devices with charge and expiration tracking.
Document records with versioning support.
Payment reminder notices with dunning levels and status.
Junction table linking dunning notices to transactions.
Junction table linking entities to communication channels.
Timeline events linked to entities with date ranges and metadata.
Extended data field definitions for custom entity attributes.
RSS/Atom feed item identifiers for deduplication.
RSS/Atom feed server configurations.
File attachments linked to records or comments.
User follows for entity notifications.
Database fork configurations for multi-tenant setups.
User groups for permission management and ownership.
Junction table linking users to groups with write permissions.
IMAP message identifiers for email deduplication.
Saved import configurations for data migration.
Appointment invitations with contact and response status.
Inventory items with pricing, barcodes, and stock settings.
Financial ledgers for payment categorization.
User likes on activity records.
Bookmarked URLs with credentials and visit tracking.
User login session records.
Email mailing lists with sender and campaign associations.
Recipients for mailing list campaigns.
Email server configurations for sending and receiving.
Read receipts for messages by user.
Email messages with threading, attachments, and ticket linking.
Rich text notes with file attachments.
User notification flags for activity records.
Auto-incrementing number counters for document numbering.
Generic JSON data objects with entity typing.
Sales opportunities with probability and revenue forecasting.
Campaign and mailing list participants with contact info.
Payment records linked to ledgers and transactions.
Group-based access permissions for views and features.
Price lists with date validity and account assignments.
Junction table linking price lists to accounts.
Item prices per price list with rebates and discounts.
Project records for organizing tasks and tickets.
Recently accessed entities per user.
Activity feed records with comments, files, and monitor entries.
Related item associations for cross-selling.
Reusable script resources for applications.
Background services and scheduled jobs.
Inventory stock movements with serial and charge tracking.
Warehouse and storage location definitions.
Supplier associations for items with pricing and lead times.
Tag name definitions per entity type.
Task records with priority, effort, and project linking.
Support tickets with status, priority, and billing items.
API access tokens per user and application.
Billing and procurement transactions (quotes, orders, invoices).
Platform usage statistics and metrics.
User-specific field display preferences.
Saved user filters for list views.
User accounts with authentication and session management.
User view configurations and layout preferences.
UI weblets for embedding custom views in ZeyOS.
Views
Meta Database
World cities with coordinates and population data.
ISO country codes with regional and currency data.
Country border relationships.
Languages spoken per country.
Localized country names.
ISO currency codes with symbols and formatting.
Localized currency names.
ISO language codes.
Localized language names.
ZeyOS module definitions.
Localized module names.
Postal code lookup data by country.
World regions (continents/areas).
Localized region names.
Country states/provinces.
World subregions.
Localized subregion names.
CN (Combined Nomenclature) product codes.
Localized CN code descriptions.
CPV (Common Procurement Vocabulary) codes.
Localized CPV code descriptions.
Google product taxonomy codes.
Localized Google taxonomy descriptions.
GPC (Global Product Classification) codes.
Localized GPC code descriptions.
HTS (Harmonized Tariff Schedule) codes.
Localized HTS code descriptions.
UNSPSC product classification codes.
Localized UNSPSC code descriptions.
Timezone definitions.
Timezone UTC offsets including DST.
Top-level domain (TLD) codes.
Unit of measure codes (UN/CEFACT).