You do not need to write SQL. But three decisions depend on understanding roughly how Odoo stores data:<\/p>\n
Whether your data is portable.<\/strong> Can you get it out if you ever leave?<\/p>\n Why some changes are blocked.<\/strong> Odoo refuses certain edits, and the reason is structural rather than arbitrary.<\/p>\n Why reports can be trusted.<\/strong> Or not.<\/p>\n This article covers the shape of it, without the technical detail.<\/p>\n Odoo stores everything in PostgreSQL<\/strong> \u2014 a standard, widely used, open-source database.<\/p>\n Three consequences that matter commercially.<\/p>\n No proprietary format.<\/strong> Your data is not locked in an encrypted file only the vendor can open. A backup can be read with standard tools.<\/p>\n Portable.<\/strong> You can host it on Odoo’s cloud, on your own server, or move between them.<\/p>\n Yours if you leave.<\/strong> Compare that with systems where getting your own history out requires a paid export service and a three-month wait.<\/p>\n One thing to know:<\/strong> attachments and images are not in the database. They live in a separate filestore<\/strong> on disk. A backup needs both \u2014 a database backup alone restores your invoices with every attachment missing.<\/p>\n FIGURE 1: WHAT A COMPLETE BACKUP CONTAINS<\/p>\n The database<\/p>\n The filestore<\/p>\n Odoo organises data into models<\/strong>. A model is a type of thing \u2014 a customer, a product, a sales order, a journal entry.<\/p>\n Each model has fields<\/strong> \u2014 the pieces of information it holds. A customer has a name, an address, a payment term.<\/p>\n Each individual entry is a record<\/strong>.<\/p>\n That is the whole vocabulary. When somebody says “the sale.order model”, they mean the sales order table.<\/p>\n This is the part that explains a lot of Odoo’s behaviour.<\/p>\n Records are linked to each other. A sales order links to a customer, to a price list, to order lines, to deliveries, to invoices.<\/p>\n Those links are why deleting is often blocked<\/strong>.<\/p>\n If a customer has invoices, Odoo will not let you delete the customer \u2014 the invoices would point at nothing, and your accounts would break.<\/p>\n This is a protection, not an obstacle.<\/strong> The right answer is almost always to archive<\/strong> rather than delete. Archiving removes the record from normal views and keeps every link intact.<\/p>\n A useful rule:<\/strong> archive by default, delete almost never.<\/p>\n FIGURE 2: THREE THINGS THE STRUCTURE EXPLAINS<\/p>\n Why deleting is blocked<\/p>\n Why archiving exists<\/p>\n Why some changes are refused<\/p>\n Two examples that come up constantly, and both make sense once you see the structure.<\/p>\n Unit of measure on a product.<\/strong> Once a product has stock moves and order lines, its unit is embedded in all of them. Changing it would make every historical record wrong. Odoo blocks it.<\/p>\n Editing a posted invoice.<\/strong> It has a sequence number and journal entries. Changing it silently would break your audit trail. You issue a credit note instead.<\/p>\n Neither is Odoo being awkward.<\/strong> Both protect the integrity of data other records depend on.<\/p>\n The practical lesson: get units of measure and your chart of accounts right before you start<\/strong>, because those are the decisions the structure makes permanent.<\/p>\n A rough map, useful when somebody asks where something is stored.<\/p>\n Partners.<\/strong> Customers, suppliers and contacts are all the same model, distinguished by flags. One company appearing as both a customer and a supplier is one record, not two.<\/p>\n Products.<\/strong> Split into templates and variants. A shirt is a template; each size and colour is a variant with its own stock.<\/p>\n Stock.<\/strong> Quants hold current quantity by location. Moves hold the history of every change.<\/p>\n Accounting.<\/strong> Journal entries, each with lines that must balance. Odoo enforces that at the database level.<\/p>\n Documents.<\/strong> Sales orders, purchase orders, invoices \u2014 each a header record with line records attached.<\/p>\n When a developer adds a field, it becomes a real column in the database, defined by the module that added it.<\/p>\n Why that matters:<\/strong><\/p>\n Uninstalling the module removes the field and its data.<\/strong> Never uninstall a custom module on a live system without understanding what it holds.<\/p>\n Version upgrades touch the structure.<\/strong> Fields get renamed, models get restructured. Custom modules built against the old structure need checking.<\/p>\n Studio changes are also structural.<\/strong> They create fields too, with less visibility over what was added and why.<\/p>\n Three things, and the third is the one people skip.<\/p>\n Back up both parts.<\/strong> Database and filestore.<\/p>\n Store a copy off the server.<\/strong> A backup on the same machine does not survive the machine failing or being encrypted.<\/p>\n Test a restore quarterly.<\/strong> Restore into a separate database. Open it. Check a recent invoice, an attachment and a stock figure.<\/p>\n An untested backup is not a backup.<\/strong> The number of companies who discover theirs have been silently failing \u2014 at the moment they need one \u2014 is not small.<\/p>\n FIGURE 3: WHAT THE STRUCTURE MEANS IN PRACTICE<\/p>\n Your data is portable<\/p>\n Archive, do not delete<\/p>\n Get units and accounts right early<\/p>\n Back up both parts, and test it<\/p>\n Four practical positions.<\/p>\n Your data is not trapped.<\/strong> That is a genuine advantage over many alternatives, and it is worth knowing.<\/p>\n Archive instead of deleting.<\/strong> Safe, reversible, and it keeps your history intact.<\/p>\n Decide units of measure and chart of accounts before go-live.<\/strong> The structure makes them expensive to change afterwards.<\/p>\n Test your backups.<\/strong> Both parts, off the server, restored properly, at least quarterly.<\/p>\n Writing queries.<\/strong> Odoo’s reporting reads the same data and applies your permission rules. Direct database access bypasses those rules and is rarely necessary.<\/p>\n Table names.<\/strong> Unless you are commissioning an integration, and then your developer handles it.<\/p>\n Optimising it.<\/strong> Routine database maintenance is a server administration task, and it is an argument for hosted Odoo if nobody in your company does it.<\/p>\n Odoo stores everything in one standard PostgreSQL database, plus a filestore for attachments.<\/p>\n Records are linked, which is why deleting is often blocked and archiving is the right answer<\/strong>.<\/p>\n Some things become permanent once you have transactions \u2014 units of measure and your chart of accounts especially. Decide those early.<\/p>\n And back up both parts<\/strong>, off the server, and actually test a restore.<\/p>\n Not sure whether your backups would actually restore?<\/p>\n Get in touch. We will check that both the database and the filestore are covered, and restore one to prove it.<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":" Why a business owner should care You do not need to write SQL. But three decisions depend on understanding roughly how Odoo stores data: Whether your data is portable. Can you get it out if you ever leave? Why some changes are blocked. Odoo refuses certain edits, and the reason is structural rather than arbitrary. […]<\/p>\n","protected":false},"author":3,"featured_media":9113,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-9112","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-odoo"],"yoast_head":"\nOne database, standard format<\/h2>\n
\n
\n
Models and records<\/h2>\n
Relationships<\/h2>\n
\n
\n
\n
Why some changes are refused<\/h2>\n
Where your business data lives<\/h2>\n
Custom fields and modules<\/h2>\n
Backups, practically<\/h2>\n
\n
\n
\n
\n
What this means for you<\/h2>\n
What you do not need to worry about<\/h2>\n
The short version<\/h2>\n