◆ Odoo 17 Community — Entity Relationship Diagram

Database: testing · localhost:5432 · PostgreSQL 15 · Generated 2026-03-19

Total tables: 476
Installed modules: 76
Core tables mapped: 36
Odoo: 17.0
📓 Accounting
🛒 Sales & Projects
📦 Products
🤝 Partners & Users
📋 Table Schema
🔗 Foreign Keys
🚗 Fleet
👥 HR & Leaves
📊 Stats

Accounting — account_move, account_journal, account_account

Rendering diagram…

Sales & Projects — sale_order, sale_order_line, project_task

Click tab to render…

Products — product_template, product_product, uom

Click tab to render…

Partners & Users — res_partner, res_users, res_company

Click tab to render…

Fleet — fleet_vehicle, fleet_vehicle_model, contracts & services

Click tab to render…

HR & Leaves — hr_employee, hr_department, hr_leave

Click tab to render…

Core Table Schemas — key fields only

Foreign Key Relationships — Core Tables (from 1,369 total)

Source TableColumn (FK)References TableRef Col
476
Total Tables
76
Installed Modules
36
Core Tables Mapped
17.0
Odoo Version
15
PostgreSQL Version
6
Business Modules

Module breakdown

account_*

~85 tables · Accounting, Invoicing, Payments

sale_*

~20 tables · Sales Orders, Quotations

purchase_*

~15 tables · Purchase Orders, RFQs

stock_*

~40 tables · Inventory, Movements

product_*

~25 tables · Products, Attributes, Variants

project_*

~15 tables · Projects, Tasks, Milestones

hr_*

~30 tables · HR, Employees, Payroll

mrp_*

~20 tables · Manufacturing, BOM

crm_*

~10 tables · CRM, Leads, Pipeline

res_*

~20 tables · Partners, Users, Companies

mail_*

~15 tables · Messaging, Chatter

ir_*

~30 tables · Framework, Menus, Actions

fleet_*

15 tables · Vehicles, Contracts, Services ✓ installed

hr_*

~47 tables · Employees, Departments, Leaves ✓ installed

mass_mailing_*

~8 tables · Email Campaigns ✓ installed

calendar_*

~5 tables · Events, Attendees ✓ installed