arcognito.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 ((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))))
mrp_bom_line	mrp_bom_line_bom_qty_zero	((product_qty >= (0)::numeric))
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))))
mrp_workcenter_capacity	mrp_workcenter_capacity_positive_capacity	((capacity > (0)::double precision))
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 ((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)))
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))
resource_resource	resource_resource_check_time_efficiency	((time_efficiency > (0)::double precision))
auth_totp_device	auth_totp_device_index_check	((char_length((index)::text) = 8))
mail_activity	mail_activity_check_res_id_is_set	(((res_id IS NOT NULL) AND (res_id <> 0)))
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))))
mrp_production	mrp_production_qty_positive	((product_qty > (0)::numeric))
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)))
mrp_unbuild	mrp_unbuild_qty_positive	((product_qty > (0)::double precision))
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)))
sale_order_template_line	sale_order_template_line_accountable_product_id_required	(((display_type IS NOT NULL) OR ((product_id IS NOT NULL) AND (product_uom_id IS NOT NULL))))
sale_order_template_line	sale_order_template_line_non_accountable_fields_null	(((display_type IS NULL) OR ((product_id IS NULL) AND (product_uom_qty = (0)::numeric) AND (product_uom_id IS NULL))))
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))))
res_users_apikeys	res_users_apikeys_index_check	((char_length((index)::text) = 8))
mrp_bom	mrp_bom_qty_positive	((product_qty > (0)::numeric))
product_packaging	product_packaging_positive_qty	((qty > (0)::numeric))