Database Schema

Table: public.product

Column	Type	Nullable	Default
id	integer	not null
created_at	timestamp without time zone	not null
updated_at	timestamp without time zone	not null
odoo_id	integer
json_data	json
error_message	text
error_traceback	text
external_id	character varying	not null
external_json_data	json
external_updated	boolean
processing_date	timestamp without time zone
processing_state	character varying
retry_count	integer	not null	0
context	character varying

Indexes: - product_pkey PRIMARY KEY, btree (id) - ix_product_external_id btree (external_id)

Referenced by: - TABLE updated_product CONSTRAINT updated_product_product_id_fkey FOREIGN KEY (product_id) REFERENCES product(id)

---

Table: public.sale_order

Column	Type	Nullable	Default
id	integer	not null	nextval('sale_order_id_seq'::regclass)
created_at	timestamp without time zone	not null
updated_at	timestamp without time zone	not null
external_id	character varying	not null
odoo_id	integer
external_json_data	json
json_data	json
external_updated	boolean
error_message	text
error_traceback	text
processing_date	timestamp without time zone
processing_state	character varying
retry_count	integer	not null	0

Indexes: - sale_order_pkey PRIMARY KEY, btree (id) - ix_sale_order_external_id btree (external_id)

Referenced by: - TABLE updated_sale_order CONSTRAINT updated_sale_order_sale_order_id_fkey FOREIGN KEY (sale_order_id) REFERENCES sale_order(id)

---

Table: public.partner

Column	Type	Nullable	Default
id	integer	not null	nextval('partner_id_seq'::regclass)
created_at	timestamp without time zone	not null
updated_at	timestamp without time zone	not null
external_id	character varying	not null
odoo_id	integer
external_json_data	json
json_data	json
external_updated	boolean
error_message	text
error_traceback	text
processing_date	timestamp without time zone
processing_state	character varying
address_type	character varying	not null
retry_count	integer	not null	0

Indexes: - partner_pkey PRIMARY KEY, btree (id) - ix_partner_external_id btree (external_id)

Referenced by: - TABLE updated_partner CONSTRAINT updated_partner_partner_id_fkey FOREIGN KEY (partner_id) REFERENCES partner(id)

---

Table: public.stock

Column	Type	Nullable	Default
id	integer	not null	nextval('stock_id_seq'::regclass)
created_at	timestamp without time zone	not null
updated_at	timestamp without time zone	not null
error_message	text
error_traceback	text
external_json_data	json
external_updated	boolean
processing_date	timestamp without time zone
processing_state	character varying
retry_count	integer	not null	0

Indexes: - stock_pkey PRIMARY KEY, btree (id)

---

Table: public.updated_product

Column	Type	Nullable	Default
id	integer	not null
created_at	timestamp without time zone	not null
updated_at	timestamp without time zone	not null
product_id	integer	not null
odoo_deleted	boolean	not null	false
context	character varying

Indexes: - updated_product_pkey PRIMARY KEY, btree (id)

Foreign-key constraints: - updated_product_product_id_fkey FOREIGN KEY (product_id) REFERENCES product(id)

---

Table: public.updated_partner

Column	Type	Nullable	Default
id	integer	not null	nextval('updated_partner_id_seq'::regclass)
created_at	timestamp without time zone	not null
updated_at	timestamp without time zone	not null
partner_id	integer	not null
odoo_deleted	boolean	not null	false

Indexes: - updated_partner_pkey PRIMARY KEY, btree (id)

Foreign-key constraints: - updated_partner_partner_id_fkey FOREIGN KEY (partner_id) REFERENCES partner(id)

---

Table: public.updated_sale_order

Column	Type	Nullable	Default
id	integer	not null	nextval('updated_sale_order_id_seq'::regclass)
created_at	timestamp without time zone	not null
updated_at	timestamp without time zone	not null
sale_order_id	integer	not null
odoo_deleted	boolean	not null	false

Indexes: - updated_sale_order_pkey PRIMARY KEY, btree (id)

Foreign-key constraints: - updated_sale_order_sale_order_id_fkey FOREIGN KEY (sale_order_id) REFERENCES sale_order(id)