odoo.public

Table	Constraint Name	Constraint
account_report_expression	account_report_expression_domain_engine_subformula_required	((((engine)::text <> 'domain'::text) OR (subformula IS NOT NULL)))
uom_uom	uom_uom_factor_gt_zero	((factor <> (0)::numeric))
uom_uom	uom_uom_factor_reference_is_one	(((((uom_type)::text = 'reference'::text) AND (factor = 1.0)) OR ((uom_type)::text <> 'reference'::text)))
uom_uom	uom_uom_rounding_gt_zero	((rounding > (0)::numeric))
ir_model_fields	ir_model_fields_name_manual_field	((((state)::text <> 'manual'::text) OR ((name)::text ~~ 'x\_%'::text)))
ir_model_fields	ir_model_fields_size_gt_zero	((size >= 0))
purchase_order_line	purchase_order_line_accountable_required_fields	(((display_type IS NOT NULL) OR is_downpayment OR ((product_id IS NOT NULL) AND (product_uom IS NOT NULL) AND (date_planned IS NOT NULL))))
purchase_order_line	purchase_order_line_non_accountable_null_fields	(((display_type IS NULL) OR ((product_id IS NULL) AND (price_unit = (0)::numeric) AND (product_uom_qty = (0)::double precision) AND (product_uom IS NULL) AND (date_planned IS NULL))))
res_users_settings_volumes	res_users_settings_volumes_partner_or_guest_exists	((((partner_id IS NOT NULL) AND (guest_id IS NULL)) OR ((partner_id IS NULL) AND (guest_id IS NOT NULL))))
stock_package_type	stock_package_type_positive_height	((height >= (0.0)::double precision))
stock_package_type	stock_package_type_positive_length	((packaging_length >= (0.0)::double precision))
stock_package_type	stock_package_type_positive_max_weight	((max_weight >= (0.0)::double precision))
stock_package_type	stock_package_type_positive_width	((width >= (0.0)::double precision))
account_move_line	account_move_line_check_accountable_required_fields	((((display_type)::text = ANY ((ARRAY['line_section'::character varying, 'line_note'::character varying])::text[])) OR (account_id IS NOT NULL)))
account_move_line	account_move_line_check_amount_currency_balance_sign	((((display_type)::text = ANY ((ARRAY['line_section'::character varying, 'line_note'::character varying])::text[])) OR (((balance <= (0)::numeric) AND (amount_currency <= (0)::numeric)) OR ((balance >= (0)::numeric) AND (amount_currency >= (0)::numeric)))))
account_move_line	account_move_line_check_credit_debit	((((display_type)::text = ANY ((ARRAY['line_section'::character varying, 'line_note'::character varying])::text[])) OR ((credit * debit) = (0)::numeric)))
account_move_line	account_move_line_check_non_accountable_fields_null	((((display_type)::text <> ALL ((ARRAY['line_section'::character varying, 'line_note'::character varying])::text[])) OR ((amount_currency = (0)::numeric) AND (debit = (0)::numeric) AND (credit = (0)::numeric) AND (account_id IS NULL))))
bus_presence	bus_presence_partner_or_guest_exists	((((user_id IS NOT NULL) AND (guest_id IS NULL)) OR ((user_id IS NULL) AND (guest_id IS NOT NULL))))
sale_order_line	sale_order_line_accountable_required_fields	(((display_type IS NOT NULL) OR is_downpayment OR ((product_id IS NOT NULL) AND (product_uom IS NOT NULL))))
sale_order_line	sale_order_line_non_accountable_null_fields	(((display_type IS NULL) OR ((product_id IS NULL) AND (price_unit = (0)::numeric) AND (product_uom_qty = (0)::numeric) AND (product_uom IS NULL) AND (customer_lead = (0)::double precision))))
res_company	res_company_check_quotation_validity_days	((quotation_validity_days >= 0))
mail_notification	mail_notification_notification_partner_required	((((notification_type)::text <> ALL ((ARRAY['email'::character varying, 'inbox'::character varying])::text[])) OR (res_partner_id IS NOT NULL)))
discuss_channel	discuss_channel_group_public_id_check	((((channel_type)::text = 'channel'::text) OR (group_public_id IS NULL)))
discuss_channel	discuss_channel_sub_channel_no_group_public_id	(((parent_channel_id IS NULL) OR (group_public_id IS NULL)))
ir_model_data	ir_model_data_name_nospaces	(((name)::text !~~ '% %'::text))
res_partner	res_partner_check_name	(((((type)::text = 'contact'::text) AND (name IS NOT NULL)) OR ((type)::text <> 'contact'::text)))
res_currency_rate	res_currency_rate_currency_rate_check	((rate > (0)::numeric))
ir_cron	ir_cron_check_strictly_positive_interval	((interval_number > 0))
rating_rating	rating_rating_rating_range	(((rating >= (0)::double precision) AND (rating <= (5)::double precision)))
resource_resource	resource_resource_check_time_efficiency	((time_efficiency > (0)::double precision))
crm_recurring_plan	crm_recurring_plan_check_number_of_months	((number_of_months >= 0))
auth_totp_device	auth_totp_device_index_check	((char_length((index)::text) = 8))
ir_mail_server	ir_mail_server_certificate_requires_tls	((((smtp_encryption)::text <> 'none'::text) OR ((smtp_authentication)::text <> 'certificate'::text)))
mail_activity	mail_activity_check_res_id_is_set	(((res_id IS NOT NULL) AND (res_id <> 0)))
res_groups	res_groups_check_api_key_duration	((api_key_duration >= (0)::double precision))
discuss_channel_member	discuss_channel_member_partner_or_guest_exists	((((partner_id IS NOT NULL) AND (guest_id IS NULL)) OR ((partner_id IS NULL) AND (guest_id IS NOT NULL))))
stock_storage_category	stock_storage_category_positive_max_weight	((max_weight >= (0)::numeric))
sale_order	sale_order_date_order_conditional_required	(((((state)::text = 'sale'::text) AND (date_order IS NOT NULL)) OR ((state)::text <> 'sale'::text)))
ir_ui_view	ir_ui_view_inheritance_mode	((((mode)::text <> 'extension'::text) OR (inherit_id IS NOT NULL)))
ir_ui_view	ir_ui_view_qweb_required_key	((((type)::text <> 'qweb'::text) OR (key IS NOT NULL)))
ir_filters	ir_filters_check_res_id_only_when_embedded_action	((NOT ((embedded_parent_res_id IS NOT NULL) AND (embedded_action_id IS NULL))))
ir_filters	ir_filters_check_sort_json	(((sort IS NULL) OR (jsonb_typeof((sort)::jsonb) = 'array'::text)))
account_group	account_group_check_length_prefix	((char_length((COALESCE(code_prefix_start, ''::character varying))::text) = char_length((COALESCE(code_prefix_end, ''::character varying))::text)))
res_currency	res_currency_rounding_gt_zero	((rounding > (0)::numeric))
res_users	res_users_notification_type	((((notification_type)::text = 'email'::text) OR (NOT share)))
delivery_carrier	delivery_carrier_margin_not_under_100_percent	((margin >= ('-1'::integer)::double precision))
delivery_carrier	delivery_carrier_shipping_insurance_is_percentage	(((shipping_insurance >= 0) AND (shipping_insurance <= 100)))
product_attribute	product_attribute_check_multi_checkbox_no_variant	((((display_type)::text <> 'multi'::text) OR ((create_variant)::text = 'no_variant'::text)))
ir_rule	ir_rule_no_access_rights	(((perm_read <> false) OR (perm_write <> false) OR (perm_create <> false) OR (perm_unlink <> false)))
stock_location	stock_location_inventory_freq_nonneg	((cyclic_inventory_frequency >= 0))
account_payment	account_payment_check_amount_not_negative	((amount >= 0.0))
stock_warehouse_orderpoint	stock_warehouse_orderpoint_qty_multiple_check	((qty_multiple >= (0)::numeric))
stock_storage_category_capacity	stock_storage_category_capacity_positive_quantity	((quantity > (0)::double precision))
mail_message_reaction	mail_message_reaction_partner_or_guest_exists	((((partner_id IS NOT NULL) AND (guest_id IS NULL)) OR ((partner_id IS NULL) AND (guest_id IS NOT NULL))))
crm_lead	crm_lead_check_probability	(((probability >= (0)::double precision) AND (probability <= (100)::double precision)))
ir_embedded_actions	ir_embedded_actions_check_only_one_action_defined	((((action_id IS NOT NULL) AND (python_method IS NULL)) OR ((action_id IS NULL) AND (python_method IS NOT NULL))))
ir_embedded_actions	ir_embedded_actions_check_python_method_requires_name	((NOT ((python_method IS NOT NULL) AND (name IS NULL))))
res_users_apikeys	res_users_apikeys_index_check	((char_length((index)::text) = 8))
calendar_recurrence	calendar_recurrence_month_day	((((rrule_type)::text <> 'monthly'::text) OR ((month_by)::text <> 'day'::text) OR ((day >= 1) AND (day <= 31)) OR (((weekday)::text = ANY ((ARRAY['MON'::character varying, 'TUE'::character varying, 'WED'::character varying, 'THU'::character varying, 'FRI'::character varying, 'SAT'::character varying, 'SUN'::character varying])::text[])) AND ((byday)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying, '-1'::character varying])::text[])))))
product_packaging	product_packaging_positive_qty	((qty > (0)::numeric))