Default Layout 20-11-2023 [Link]. Table comments as mouse-over tooltips.

sale_coupon sale_coupon_program sale_coupon_program_line sale_payment_provider_onboarding_wizard sale_promotion sale_promotion_line sale_promotion_category

id # id # id # id # id # id # id #
name t name t program_id # create_uid # name t promotion_id # name t
code # active # sequence # write_uid # active # name t sequence #
program_id # code # name t payment_method t date_start d sequence # parent_id #
partner_id # type # product_id # paypal_user_type t date_end d product_id # child_ids #
state t promo_applicability # product_category_id # paypal_email_account t promo_type # product_category_id # active #
discount_type # date_start d product_tmpl_id # paypal_seller_account t promo_applicability # product_tmpl_id # description t
discount_percentage # date_end d product_variant_ids # paypal_pdt_token t minimum_amount # product_variant_ids # created_at d
discount_fixed_amount # discount_type # product_uom_id # manual_name t discount_type # product_uom_id # updated_at d
discount_apply_on # discount_percentage # price_discount # journal_name t discount_percentage # price_discount # deleted_at d
minimum_amount # discount_fixed_amount # discount_type # acc_number t discount_fixed_amount # discount_type #
expiration_date d rule_min_amount # rule_min_quantity # manual_post_msg t rule_min_amount # rule_min_quantity #
usage_limit # rule_products_domain # rule_min_amount # created_at d rule_products_domain # rule_min_amount #
total_used # discount_apply_on # created_at d updated_at d total_used # created_at d
order_ids # minimum_items # updated_at d deleted_at d coupon_program_ids # updated_at d
created_at d total_used # deleted_at d created_at d deleted_at d
updated_at d coupon_ids # updated_at d
deleted_at d created_at d deleted_at d
updated_at d
deleted_at d

sale_promotion_rule
id #
sale_order
name t
id # sequence #
promotion_id #
discount_type #
discount_percentage #
discount_fixed_amount #
rule_min_quantity #
rule_min_amount #
sale_order_line
rule_products_domain #
id # active #
order_id # created_at d
sequence # updated_at d
company_id # deleted_at d
currency_id #
order_partner_id #
salesman_id #
product_id #
product_uom #
product_packaging_id #
state t
display_type t
qty_delivered_method t
invoice_status t
video_stream_category video_stream_channel video_stream_view video_stream_tag
analytic_distribution t
name t id # id # id # id #
product_uom_qty # name t name t video_stream_id # name t
price_unit # description t description t user_id # description t
discount # active # owner_id # view_date d active #
price_reduce # icon t category_id # view_duration # color t
price_subtotal # created_at d tag_ids # created_at d created_at d
price_total # updated_at d published_on d updated_at d updated_at d
price_reduce_taxexcl # deleted_at d active # deleted_at d deleted_at d
price_reduce_taxinc # icon t
qty_delivered # created_at d
qty_invoiced # updated_at d
qty_to_invoice # deleted_at d
untaxed_amount_invoiced #
untaxed_amount_to_invoice #
seller_rating_settings seller_rating_line
is_downpayment #
is_expense # id # id #
price_tax # company_id # seller_rating_id #
product_packaging_qty # auto_publish # rating #
video_stream_playlist
customer_lead # publish_mode # comment t
route_id # rating_min # date d id #
linked_line_id # rating_max # created_at d name t
shop_warning t allow_guest # updated_at d description t
create_uid # allow_comment t deleted_at d video_stream_ids #
write_uid # order_confirmation # active #
created_at d created_at d created_at d
updated_at d updated_at d updated_at d
deleted_at d deleted_at d deleted_at d

rating_rating rating_scale rating_vote payment_transaction discount_rule discount_coupon_history discount_coupon_line

id # id # id # id # id # id # id #
res_model_id # name t vote_date d provider_id # name t discount_coupon_id # discount_coupon_id #
payment_provider payment_provider_onboarding_wizard
res_id # ratingValues # rated_object t company_id # condition # date d discount_rule_id #
parent_res_model_id # sequence # rating_scale # currency_id # id # id # amount # order_id # sequence #
parent_res_id # company t user # token_id # sequence # create_uid # created_at d amount_discount # created_at d
rated_partner_id # created_at d rating_value # source_transaction_id # company_id # write_uid # updated_at d created_at d updated_at d
partner_id # updated_at d feedback t callback_model_id # redirect_form_view_id # payment_method t deleted_at d updated_at d deleted_at d
message_id # deleted_at d created_at d callback_res_id # inline_form_view_id # paypal_user_type t deleted_at d
create_uid # updated_at d partner_id # token_inline_form_view_id # paypal_email_account t
write_uid # deleted_at d partner_state_id # express_checkout_form_view_id # paypal_seller_account t
res_name t partner_country_id # color # paypal_pdt_token t
res_model t create_uid # module_id # manual_name t
parent_res_name t write_uid # create_uid # journal_name t
parent_res_model t reference t write_uid # acc_number t
rating_text t provider_reference t code t manual_post_msg t
access_token t state t state t created_at d
feedback t operation t module_state t updated_at d
is_internal # landing_route t name t deleted_at d
consumed # callback_method t display_as t
rating # callback_hash t pre_msg t
publisher_id # partner_name t pending_msg t
publisher_comment t partner_lang t auth_msg t
publisher_datetime # partner_email t done_msg t
created_at d partner_address t cancel_msg t
updated_at d partner_zip t maximum_amount #
deleted_at d partner_city t is_published #
partner_phone t allow_tokenization #
state_message t capture_manually #
amount # allow_express_checkout #
fees # fees_active #
is_post_processed # fees_dom_fixed #
tokenize # fees_dom_var #
callback_is_done # fees_int_fixed #
last_state_change d fees_int_var #
payment_id # so_reference_type t
is_donation # website_id #
created_at d created_at d
updated_at d updated_at d
deleted_at d deleted_at d

payment_token payment_link_wizard
id # id #
provider_id # res_id #
partner_id # currency_id #
company_id # partner_id #
payment_refund_wizard
create_uid # create_uid #
id # write_uid # write_uid #
payment_id # payment_details t res_model t
create_uid # provider_ref # description t
write_uid # verified # payment_provider_selection t
amount_to_refund # active # amount #
created_at d created_at d amount_max #
updated_at d updated_at d created_at d
deleted_at d deleted_at d updated_at d
deleted_at d
mail_activity
id #
res_model_id #
res_id #
activity_type_id #
payment_icon
user_id #
request_partner_id # id #
recommended_activity_type_id # create_uid #
previous_activity_type_id # write_uid #
report_layout report_paperformat
create_uid # payment_method t
write_uid # paypal_user_type t id # id #
res_model t paypal_email_account t view_id # page_height #
res_name t paypal_seller_account t sequence # page_width #
summary t paypal_pdt_token t create_uid # header_spacing #
date_deadline d manual_name t write_uid # dpi #
note t journal_name t image t create_uid #
automated # acc_number t pdf t write_uid #
calendar_event_id # manual_post_msg t name t name t
created_at d created_at d created_at d format t
updated_at d updated_at d updated_at d orientation t
deleted_at d deleted_at d deleted_at d default #
header_line #
disable_shrinking #
margin_top #
margin_bottom #
margin_left #
margin_right #
account_invoice discount_coupon pos_category
created_at d
id # id # id # updated_at d
number t code # deleted_at d
ir_act_report_xml
date_invoice d type #
id # partner_id # value #
paperformat_id # currency_id # start_date d
model t invoice_line_ids # end_date d
report_type # state t active #
report_name # move_id # created_at d
report_file # payment_term_id # updated_at d
attachment t journal_id # deleted_at d
print_report_name # company_id #
multi # amount_total #
attachment_use # residual #
created_at d created_at d
updated_at d updated_at d
deleted_at d deleted_at d
rating_line
id #
favorites_groups favorites_categories favorites_companies
name t
rated_object # id # id # id #
rating_scale # favorite_id # name t company_id #
rated_by # group_id # parent_id # user_id #
video_stream hr_employee_category favorites
date d created_at d created_at d created_at d
id # id # id # rating_values # updated_at d updated_at d updated_at d
name t color # name t overall_rating # deleted_at d deleted_at d deleted_at d
description t create_uid # url t created_at d
duration # write_uid # created_at d updated_at d
format t name t updated_at d deleted_at d
size t created_at d deleted_at d
channel_id # updated_at d
pos_make_payment pos_payment pos_payment_method
category_id # deleted_at d
favorites_notifications favorites_tags favorites_items favorites_locations
id # id # id # tag_ids #
config_id # pos_order_id # outstanding_account_id # published_on d id # id # id # id #
payment_method_id # payment_method_id # receivable_account_id # active # favorite_id # name t favorites_items # location_id #
create_uid # session_id # journal_id # created_at d user_id # color t model # user_id #
sale_advance_payment_inv
write_uid # company_id # company_id # updated_at d type t created_at d res_id # created_at d
payment_name t account_move_id # create_uid # deleted_at d id # message t updated_at d url t updated_at d
uom_category seller_rating
amount # create_uid # write_uid # product_id # is_read # deleted_at d created_at d deleted_at d
payment_date # write_uid # use_payment_terminal # id # id # currency_id # created_at d updated_at d
created_at d name t name t create_uid # name t company_id # updated_at d deleted_at d
updated_at d card_type t is_cash_count t write_uid # rating # deposit_account_id # deleted_at d
deleted_at d cardholder_name t split_transactions # name t comment t create_uid #
transaction_id t active # is_pos_groupable # date d write_uid #
payment_status t created_at d created_at d partner_id # advance_payment_method t
favorites_users
ticket t updated_at d updated_at d sale_order_id # fixed_amount #
amount # deleted_at d deleted_at d state # deduct_down_payments # id #
is_change # published # amount # favorite_id #
payment_date d active # created_at d user_id #
created_at d created_at d updated_at d created_at d
updated_at d updated_at d deleted_at d updated_at d
deleted_at d deleted_at d deleted_at d

mail_followers mail_message mail_message_subtype mail_message_schedule

user_id
id # id # id # id #
mail_channel mail_channel_member mail_channel_rtc_session res_users user_id res_bank res_groups_res_users res_groups_id res_groups res_currency_rate res_country_state
res_id # author_guest_id # parent_id # mail_message_id #
partner_id # parent_id # sequence # create_uid # id # id # id # id # id # res_users_id # id # id # id #
res_model t res_id # create_uid # write_uid # message_main_attachment_id # partner_id # channel_member_id # name t state # res_groups_id # name t currency_id # name t
created_at d subtype_id # write_uid # notification_parameters t group_public_id # guest_id # channel_id # login t country # category_id # company_id # code t
updated_at d mail_activity_type_id # relation_field t scheduled_datetime d create_uid # channel_id # create_uid # password t create_uid # color # user_id # country_id #

res_users_id
deleted_at d author_id # res_model t created_at d write_uid # fetched_message_id # write_uid # email t write_uid # create_uid d create_uid # user_id #
mail_server_id # name t updated_at d name t seen_message_id # is_screen_sharing_on # company_id # user_id # write_uid d write_uid # created_at d
create_uid # description t deleted_at d channel_type t rtc_inviting_session_id # is_camera_on # partner_id # name t comment t name t updated_at d
write_uid # internal # default_display_mode t create_uid # is_muted # active # street t share # rate # deleted_at d
subject t default # uuid t write_uid # is_deaf # action_id # street2 t created_at d created_at d
res_partner_delivery_package res_partner_delivery_shipment
model t hidden # description t custom_channel_name t created_at d create_uid # zip t updated_at d updated_at d
record_name t track_recipients # active # fold_state t updated_at d res_partner_id # res_partner_id # write_uid # city t deleted_at d deleted_at d
message_type t created_at d created_at d is_minimized # deleted_at d delivery_package_id # delivery_shipment_id # signature t email t
email_from t updated_at d updated_at d is_pinned # share # phone t

user_id
message_id t deleted_at d deleted_at d last_interest_dt d write_date # bic t
delivery_package_id

res_partner_id

res_partner_id

delivery_shipment_id
reply_to t last_seen_dt d totp_secret t active #
email_layout_xmlid t created_at d notification_type t created_at d
body t updated_at d odoobot_state t updated_at d
res_users_deletion res_users_log
is_internal # deleted_at d odoobot_failed # deleted_at d
reply_to_force_new # sale_team_id # id # id #
user_id

email_add_signature # target_sales_won # user_id # create_uid #

mail_ice_server mail_mail
date # target_sales_done # user_id_int # user_id #
created_at d id # id # karma # create_uid # model t
res_partner delivery_shipment dShipment_id user_id
updated_at d create_uid # mail_message_id # rank_id # write_uid # record_id #
res_partner_delivery_carrier res_partner_id
deleted_at d write_uid # fetchmail_server_id # id # id # next_rank_id # state t action t
server_type t write_uid # res_partner_id # stock_move_res_id # order_id # target_sales_invoiced # created_at d field_name t
uri t create_uid # delivery_carrier_id # user_id # carrier_id # created_at d updated_at d old_value t
username t email_cc t Tracking_id # updated_at d deleted_at d created_at d
credential t state t Return_id # deleted_at d updated_at d
user_id
delivery_carrier_id

stock_move_res_id

created_at d failure_type t shipping_method_id # deleted_at d

mail_notification mail_template mail_template_preview
updated_at d body_html t deliveryPack_id #
mail_wizard_invite
res_partner_id

id # id # id # deleted_at d references t tracking_number t

author_id # model_id # mail_template_id # id # headers t status t
mail_message_id # report_template # create_uid # res_id # email_to t dShipment_id #

user_id
shipmentVolumePack_id chooseDeliveryCarrier_id
mail_mail_id # mail_server_id # write_uid # create_uid # failure_reason t chooseDeliveryCarrier_id #
res_partner_id # ref_ir_act_window # resource_ref t write_uid # is_notification # chooseDeliveryPackage_id #
user_id
notification_type t create_uid # lang t res_model t auto_delete # shipmentVolumePack_id #
res_partner_category res_partner_products_template res_users_settings_volumes res_company
notification_status t write_uid # error_msg t message t to_delete # created_at d
failure_type t template_fs t created_at d send_mail # scheduled_date d id # res_partner_id # updated_at d id # id #
chooseDeliveryPackage_id
failure_reason t lang t updated_at d created_at d created_at d color # products_template_id # deleted_at d user_setting_id # user_id #
is_read # model t deleted_at d updated_at d updated_at d parent_id # user_id #
read_date d email_from t deleted_at d deleted_at d create_uid # partner_id #
products_template_id

deliveryPack_id
Return_id

sms_id # email_to t write_uid # guest_id #

sms_number t partner_to t parent_path t create_uid #
letter_id # email_cc t name t write_uid #
created_at d reply_to t active # volume #
updated_at d scheduled_date t created_at d created_at d
deleted_at d name t updated_at d updated_at d

chooseDeliveryPackage_id
description t deleted_at d deleted_at d
subject t
body_html t
mail_gateway_allowed mail_blacklist mail_blacklist_remove
report_name t

stock_volume_id
res_partner_id

active # id # id # id #
use_default_to # create_uid # message_main_attachment_id # create_uid #
auto_delete # write_uid # create_uid # write_uid #
created_at d email t write_uid # email t
updated_at d email_normalized t email t reason t
res_partner_id deliveryPackage_id res_partner_id
deleted_at d created_at d active # created_at d
stock_shipment_volume_res_partner stock_shipment_volume_order_line order_line_id order_line stock_move stock_Move_id res_partner_stock_move choose_delivery_carrier package_id choose_delivery_package
choose_delivery_package_id res_partner_choose_delivery_package
updated_at d created_at d updated_at d
stock_move_orderLine_id
deleted_at d updated_at d deleted_at d stock_shipment_volume_id # stock_shipment_volume_id # id # id # res_partner_id # id # id # res_partner_id #
deleted_at d res_partner_id # order_line_id # order_id # picking_id # stock_Move_id # order_id # chooseDeliveryPackage_id # choose_delivery_package_id #
product_id # stock_move_id # stock_volume_id # picking_id #
product_uom_qty # product_id # stock_return_id # stock_return_id #
stock_shipment_volume_id

stock_shipment_volume_id

stock_move_orderLine_id # product_qty # deliveryPackage_id # delivery_package_type_id #

mail_tracking_value mail_alias
price_unit # location_id_from # carrier_id # stock_shipment_weight_id #
id # id # discount # location_id_to # choose_id # chooseDpackage_tranking_id #
field # alias_model_id # tax_ids # state t package_id # create_uid #
mail_activity_type mail_guest res_partner_id
old_value_integer # alias_user_id # shipment_ids # picking_type_id # create_uid # write_uid #
res_partner_order_line order_line_id
new_value_integer # alias_force_thread_id # id # id # created_at d shipment_id # chooseDpackage_carrier_id # shipping_weight #
currency_id # alias_parent_model_id # sequence # country_id # res_partner_id # updated_at d created_at d dcarrier_id # created_at d
stock_move_id
mail_message_id # alias_parent_thread_id # create_uid # create_uid # order_line_id # deleted_at d updated_at d stock_shipment_carrier_id # updated_at d
stock_shipment_volume delivery_carrier dcarrier_id delivery_method
tracking_sequence # create_uid # delay_count # name t deleted_at d write_uid # deleted_at d
stock_volume_id stock_volume_id stock_shipment_weight_id
create_uid # write_uid # triggered_next_type_id # access_token t id # id # id # delivery_message t
stock_picking_line_id

shipmentVolume_id
write_uid # alias_name t default_user_id # lang t shipment_id # dcarrier_id # name t delivery_price #
stock_volume_id

dcarrier_id

chooseDpackage_tranking_id

stock_return_id
field_desc t alias_contact t write_uid # timezone t shipmentVolume_id # stock_volume_id # code t display_price #
stock_picking_id

field_type t alias_bounced_content t delay_unit t created_at d stock_shipment_Volume_id # sequence # description t created_at d

old_value_char t alias_defaults t delay_from t updated_at d stock_volume_id # delivery_carrier_id # price # updated_at d
carrier_id stock_return_id
new_value_char t created_at d icon t deleted_at d s_s_volume_id # company_id # carrier_id # deleted_at d

choose_delivery_carrier_id
old_value_text t updated_at d decoration_type t volume # delivery_carrierTrack_id # active #
package_id
new_value_text t deleted_at d res_model t unit t product_ide # created_at d
delivery_package chooseDeliveryPackage_iddelivery_tracking delivery_tracking_history stock_shipment_volume_product_template stock_shipment_volume_id

stock_shipment_carrier_id

chooseDpackage_carrier_id
old_value_datetime d chaining_type t created_at d shipping_insurance # updated_at d
shipmentVolume_id stock_picking stock_picking_line
new_value_datetime d category t id # id # id # stock_shipment_volume_id # updated_at d create_uid # deleted_at d
package_id
old_value_float # name t name t shipment_id # shipment_id # product_template_id # deleted_at d write_uid # id # id #
old_value_monetary # summary t weight # Tracking_id # delivery_tracking_history_id # delivery_type t message_main_attachment_id # picking_id #
new_value_float # default_note t dimensions t stock_volume_id # tracking_id # integration_level t stock_picking_id # product_id #
stock_volume_id
product_template_id

new_value_monetary # active # content t package_tranck_id # tranck_history_id # invoice_policy t backorder_id # location_id #

created_at d created_at d value # stock_move_delivery_id # date d name t group_id # Columna 5 #
stock_volume_id

res_partner_id stock_picking_id
updated_at d updated_at d dPackage_id # status t stock_volume_id # carrier_description t location_id # product_uom_qty #
res_partner_choose_delivery_carrier stock_picking_tracking
deleted_at d deleted_at d package_id # date t status t active # location_dest_id # location_dest_id #
chooseDeliveryPackage_id # location t location t prod_environment # picking_type_id # stock_picking_line_id # res_partner_id # id #
shipmentVolume_id # details t details t debug_logging # partner_id # lot_id # choose_delivery_carrier_id # picking_id #
shipment_id # delivery_tracking_id t created_at d free_over # company_id # serial_number t carrier_id #
tranck_event_id
Tracking_id # created_at d updated_at d return_label_on_delivery # user_id # state # stockShTracking_id #
tranck_history_id stock_volume_id delivery-tracking-event stock_warehouse
created_at d updated_at d deleted_at d get_return_label_from_portal # owner_id # move_id # stock_volume_id #
package_tranck_id delivery_tracking_history_id
updated_at d deleted_at d id # id # margin t create_uid # picking_type_id # stock_picking_tracking_id #
stock_move_delivery_id
deleted_at d shipment_id # name t amount t write_uid # package_id # stock_picking_id #
dPackage_id res_partner_id
delivery_tracking_event_id # code t fixed_price t name t notes t stock_tranking_id #
stock_picking_line_id res_partner_stock_picking_line
Tracking_id

status t partner_id # website_id # origin t created_at d tracking_number t

account_move account_payment account_payment_term_line mail_compose_message mail_resend_message mail_resend_partner
tranck_event_id # company_id # is_published # move_type t updated_at d res_partner_id # created_at d
id # id # id # id # id # id # date d stock_picking_line_id # created_at d state t deleted_at d stock_picking_line_id # updated_at d
stockShTracking_id
message_main_attachment_id # months # template_id # mail_message_id # partner_id # stock_volume_id # stock_tranking_id # updated_at d priority t deleted_at d
move_id # days # parent_id # create_uid # resend_wizard_id # location t active # deleted_at d note t
delivery_carrier_id
partner_bank_id # days_after # author_id # write_uid # create_uid # details t street t has_deadline_issue #

stock_picking_tracking_id
paired_internal_transfer_payment_id # discount_days # res_id # created_at d write_uid # created-at d city t printed #
payment_method_line_id # payment_id # subtype_id # updated_at d message t updated-at d state_id # is_locked #
delivery_zip_prefix
payment_method_id # create_uid # mail_activity_type_id # deleted_at d resend # deleted-at d country_id # immediate_transfer #
delivery_price_rule
currency_id # write_uid # mail_server_id # created_at d id # zip t scheduled_date d
partner_id # value t create_uid # updated_at d id # create_uid # phone t date_deadline d
delivery_tracking_event_id

outstanding_account_id # value_amount # write_uid # deleted_at d sequence # write_uid # fax t date d

destination_account_id # end_month # lang t carrier_id # name t email t date_done d
destination_journal_id # discount_percentage # subject t create_uid # created_at d website t sale_id #
create_uid # created_at d email_layout_xmlid t write_uid # updated_at d warehouse_type t pos_session_id #
mail_shortcode
write_uid # updated_at d email_from t variable t deleted_at d account_picking_id # pos_order_id #
res_partner_id
payment_type t deleted_at d composition_mode t id # operator t account_picking_out_id # website_id #
stock_picking_id res_partner_stock_picking
partner_type t model t create_uid # variable_factor t account_picking_in_id # created_at d
payment_reference t record_name t write_uid # list_base_price # stock_warehouse_id # updated_at d res_partner_id #
amount # message_type t source t list_price # stock_volume_id # deleted_at d stock_picking_id #
amount_company_currency_signed # reply_to t description t max_value # warehouse_id #
is_reconciled # body t substitution t created_at d created_at d
is_matched # active_domain t created_at d updated_at d updated_at d
account_payment_method account_payment_method_line warehouse_id
is_internal_transfer # email_add_signature # updated_at d deleted_at d deleted_at d
stock_picking_line_id

stock_picking_batch_id
payment_transaction_id # id # id # use_active_domain # deleted_at d
product_id

payment_token_id # create_uid # sequence # is_log #

stock_tranking_id

source_payment_id # write_uid # payment_method_id # notify #

stock_volume_id
products-barcode product_id
pos_payment_method_id # code t payment_account_id # reply_to_force_new #
attribute_id
force_outstanding_account_id # payment_type t journal_id # auto_delete # id #
products-attribute product_product product_image
pos_session_id # name t create_uid # auto_delete_message # sequence #
created_at d created_at d write_uid # created_at d attribute_id # id # id # id #
mail_link_preview
updated_at d updated_at d name t updated_at d product_id # sequence # name t name t
product_id

product_id

product_id products_id stock_picking_id stock_picking_line_id stock_picking_id stock_picking_line_id stock_tranking_id

deleted_at d deleted_at d payment_provider_id # deleted_at d id # color # create_uid # default_code t product_tmpl_id #
products product_id products-supplier supplier_id product_supplier_taxes_rel
product_supplier_taxes_rels_id product_supplier_taxes_rel_products stock_shipment_tracking_stock_picking_package stock_shipment_tracking_stock_picking_package_line stock_shipment_weight_stock_picking stock_shipment_weight_stock_picking_type stock_shipment_weight_stock_picking_line stock_shipment_return_stock_picking stock_shipment_return_stock_picking_line stock_shipment_return_stock_picking_package_line stock_picking_note stock_picking_batch
created_at d message_id # create_uid # write_uid # product_tmpl_id # product_id #
updated_at d create_uid # write_uid # product_id # product_id # image t id # id # id # product_supplier_taxes_rels_id # stock_shipment_tracking_id # stock_shipment_tracking_id # stock_shipment_weight_id # stock_shipment_weight_id # stock_shipment_weight_id # stock_shipment_return_id # stock_shipment_return_id # stock_shipment_return_id # id # id #
deleted_at d write_uid # html_color t create_variant t active # sequence # message_main_attachment_id # partner_id # supplier_id # products_id # stock_picking_package_id # stock_picking_package_Line_id # stock_picking_id # stock_picking_type_id # stock_picking_line_id # stock_picking_id # stock_picking_line_id # stock_picking_package_Line_id # picking_id # picking_id #
product_accessory_rel product_taxes_rel
product_taxes_rels_id product_taxes_rel_product products_id stock_shipment_tracking_id stock_picking_package_Line_id
source_url t name t display_type t sale_ok # create_uid # product_tmpl_id # sequence # tax_id # note t stockShBatch_id #
og_type t is_custom # name t purchase_ok # write_uid # id # id # product_taxes_rels_id # create_uid # company_id # created_at d stock_picking_note_id # stock_volume_id #
stock_picking_line_id
stock_picking_package_id

stock_shipment_tracking_id

stock_shipment_weight_id

stock_shipment_weight_id

stock_picking_type_id

stock_shipment_weight_id

stock_shipment_return_id

stock_shipment_return_id

stock_shipment_return_id

stock_picking_package_Line_id
og_title t created_at d created-at d type t created_at d product_tmpl_id # product_id # products_id # write_uid # currency_id # updated_at d stock_volume_id # stock_picking_batch_id #
og_image t updated_at d updated_at d categ_id # updated_at d product_id # tax_id # default_code t product_id # deleted_at d stockShNote_id # stock_tranking_id #
stock_volume_id

product_replenish product_id
og_mimetype t deleted_at d deleted_at d uom_id # deleted_at d created_at d created_at d barcode t product_tmpl_id # stock_tranking_id # name t
image_mimetype t list_price # updated_at d updated_at d id # combination_indices t delay # created_at d date_expected #
product_tmpl_id
og_description t volume t deleted_at d deleted_at d product_id # volume # create_uid # updated_at d location_id #
stock_picking_note_id stock_tranking_id
created_at d weight t quantity # weight # write_uid # deleted_at d state t
stockShNote_id
updated_at d image # date d active # product_name t created_at d
account_payment_register account_payment_term product_id
deleted_at d description # reason t can_image_variant_1024_be_zoomed # product_code t updated_at d

stock_volume_id
stock_carrier_id
product_tmpl_id stock_shipment_tracking stock_trancking_id stock_location stock_location_id stock_shipment_weightstock_shipment_weight_id stock_shipment_weight_product_template stock_shipment_return stock_shipment_return_id stock_shipment_return_product_template
id # id # attribute_value_ids # created_at d created_at d date_start d deleted_at d
products_category_product stockShBa
currency_id # company_id # created_at d updated_at d updated_at d date_end d id # id # id # stock_shipment_weight_id # id # stock_shipment_return_id #
product_accessory_rels_id
journal_id # sequence # products_categorys_id # updated_at d deleted_at d deleted_at d min_qty # shipment_id # name t shipment_id # product_template_id # shipment_id # product_template_id #
product_removal product_accessory_rel_product stock_shipment_return_id
partner_bank_id # create_uid # products_id # deleted_at d price # shipmentTracking_id # stock_location_id # weight t stock_volume_id #
source_currency_id # write_uid # id # product_accessory_rels_id # created_at d stock_shipment_tracking_id # stockLocation_id # shipmentWeight_id # s_s_return_id #
products_id stockcarrier_id
product_template_id

product_template_id
company_id # name t product_id # products_id # updated_at d stock_volume_id # stock_volume_id # stock_volume_id # reason t
stock_shipment_returns_id stock_picking_type stock_tranking_id stock_carrier
products_categorys_id
products_id

partner_id # note t quantity # deleted_at d status t stock_trancking_id # s_s_weight_id # description t

payment_method_line_id # active # date d date d stock_picking_line_id # stock_picking_status_id # date d id # id #
product_id stock_move_id s_s_return_id
supplier_id

writeoff_account_id # display_on_invoice # reason t location t code t unit t stock_shipment_return_id # color # name t

product_id

product_id

account_report_expression stock_shipment_weight_stock_move stock_shipment_weight_id

product_tmpl_id

create_uid # created_at d created_at d details t parent_id # created_at d state t sequence # code t

product_public_category products-category stock_shipment_tracking_product_template stock_shipment_tracking_id shipmentTracking_id stock_move_id
id # write_uid t updated_at d updated_at d created_at d location_type t stock_shipment_weight_id # updated_at d stock_shipment_returns_id # sequence_id # description t
stock_shipment_return_stock_move stock_shipment_return_id
report_line_id # communication t deleted_at d id # id # deleted_at d stock_shipment_tracking_id # updated_at d description t stock_move_id # deleted_at d created_at d default_location_src_id # website t
stock_shipment_weight_id

create_uid # payment_type t website_id # parent_id # product_template_id # deleted_at d active # stock_shipment_return_id # updated_at d default_location_dest_id # stockcarrier_id #
stock_shipment_tracking_id

product_packaging product_supplierinfo
write_uid # partner_type t parent_id # create_uid # created_at # stock_move_id # deleted_at d return_picking_type_id # stock_tranking_id #
product_id

label t payment_difference_handling t sequence # write_uid # id # id # updated_at # warehouse_id # active #

stock_shipment_return_id
product_template_id

engine t writeoff_label t create_uid # name t name t product_id # deleted_at # reservation_days_before # pricelist_id #

stockLocation_id
formula t payment_date t write_uid # complete_name # product_tmpl_id # supplier_id # reservation_days_before_priority # stock_volume_id #
stock_move_id

subformula t amount d website_meta_og_img # parent_path # product_id # price # create_uid # stock_carrier_id #

product_category product_ribbon
date_scope t source_amount # parent_path # removal_strategy_id # height # delay # write_uid # created_at #
figure_type t source_amount_currency # website_meta_title t packaging_reserve_method t id # id # width # min_quantity # sequence_code t updated_at #
carryover_target t group_payment # website_meta_description t created_at d created_at d name t depth # max_quantity # code t deleted_at #
order_line_id res_partner_id
green_on_positive # can_edit_wizard # website_meta_keywords t updated_at d updated_at d product_id # weight # product_code t reservation_method t
stock_shipment_weight_order_line
stock_shipment_weight_id stock_shipment_weight_res_partner
blank_if_zero # can_group_payments # seo_name t deleted_at d deleted_at d color t volume # active # barcode t
stock_shipment_tracking_stock_move order_line_id res_partner_id
auditable # payment_token_id # name t position t create_uid # created_at d order_line_id # stock_shipment_weight_id # create_backorder t

stock_shipment_return_id
stock_shipment_return_order_line
stock_shipment_return_id stock_shipment_return_res_partner
created_at d created_at d website_description t active # write_uid # updated_at d stock_shipment_tracking_id # stock_shipment_weight_id # res_partner_id # name #
updated_at d updated_at d created_at d created_at d created_at d deleted_at d stock_move_id # stock_shipment_return_id # stock_shipment_return_id # show_entire_packs #
deleted_at d deleted_at d updated_at d updated_at d updated_at d order_line_id # res_partner_id # active #
choose_delivery_carrier_id

deleted_at d deleted_at d deleted_at d use_create_lots #

use_existing_lots #
print_label #
show_operations #
show_reserved #
stock_picking_type_id
products_id

auto_show_reception_report #
product_id

product_id

product_id

account_report account_report_line account_report_column stock_shipment_return_stock_picking_type

created_at d
id # id # id # updated_at d stock_shipment_return_id #
stock_shipment_weight_id stock_shipment_weight_id
root_report_id # report_id # sequence # deleted_at # stock_picking_type_id #
product_attribute_id stock_shipment_tracking_order_line stock_shipment_weight_stock_picking_package stock_shipment_weight_stock_picking_package_line
chart_template_id # hierarchy_level # report_id #

stock_shipment_volume_id
product_attribute_value product_alternative_rel
product_alternative_rels_id product_alternatives_rels_products products-template product_template_id product_template_choose_delivery_carrier
country_id # parent_id # custom_audit_action_id # stock_shipment_tracking_id # stock_shipment_weight_id # stock_shipment_weight_id #
stock_shipment_tracking_id

stock_shipment_tracking_id

stock_shipment_tracking_id

load_more_limit # sequence # create_uid # id # id # product_alternative_rels_id # id # product_template_id # order_line_id # stock_picking_package_id # stock_picking_package_line_id #

create_uid # action_id # write_uid # sequence # product_tmpl_id # products_id # create_uid # choose_delivery_carrier_id #
stock_picking_type_id

stock_picking_line_id

write_uid # create_uid # expression_label t attribute_id # product_id # message_main_attachment_id #

stock_picking_package_id

stock_picking_package_line_id
availability_condition t write_uid # figure_type t product_attribute_id # created_at d sequence #
stock_picking_id

product_tmpl_id
default_opening_date_filter t groupby t name t product_tmpl_id # updated_at d stock_move_productsTemplate_id #
filter_multi_company t code t sortable # product_id # deleted_at d categ_id #
stock_rules_report stock_storage_category stock_storage_category_capacity
filter_hierarchy t name t blank_if_zero # color # uom_id #
name t foldable # created_at d create_uid # product_id # id # id # id #
product_tmpl_id stock_tranking_id
only_tax_exigible # print_on_new_page # updated_at d write_uid # uom_po_id # product_id # company_id # storage_category_id #
stock_shipment_volume_id

stock_shipment_volume_id

res_partner_id stock_shipment_tracking_id stock_volume_id stock_picking_status stockShStatus_id

stock_picking_package stock_picking_package_line
stock_picking_package_line_id stock_shipment_volume_stock_picking_package_line
search_bar # hide_if_zero # deleted_at d html_color t company_id # product_tmpl_id # create_uid # product_id #
stock_shipment_tracking_res_partner stock_shipment_tracking_stock_picking stock_shipment_tracking_stock_picking_type stock_shipment_tracking_stock_picking_line
filter_date_range # created_at d name t color # id # id # id # stock_shipment_volume_id # create_uid # write_uid # package_type_id #
stock_picking_type_id

stock_picking_line_id

filter_show_draft # updated_at d is_custom # write_uid # stock_shipment_tracking_id # stock_shipment_tracking_id # stock_shipment_tracking_id # stock_shipment_tracking_id # name t picking_id # picking_id # stock_picking_package_line_id # write_uid # name t create_uid #
filter_unreconciled # deleted_at d created_at d detailed_type t res_partner_id # stock_picking_id # stock_picking_type_id # stock_picking_line_id # code t package_type t package_id # product_has_variants # allow_new_product t write_uid #
stock_move_id

filter_unfold_all # updated_at d type t sequence # weight # product_id # created_at d max_weight # quantity #

filter_period_comparison # deleted_at d default_code t active # volume # product_uom_qty # updated_at d created_at d created_at d
filter_growth_comparison # priority t stock_picking_status_id # barcode t product_uom t deleted_at d updated_at d updated_at d
filter_journals # name t stock_volume_id # tracking_number t product_description t deleted_at d deleted_at d
filter_analytic # description t stockShStatus_id # state t product_barcode t
stock_shipment_volume_id stock_picking_id
filter_account_type # description_purchase t stock_tranking_id # shipment_id # state t
account_report_external_value stock_shipment_volume_stock_move stock_shipment_volume_stock_picking stock_shipment_volume_stock_picking_type stock_shipment_volume_stock_picking_line
filter_partner # description_sale t created_at # created_at d created_at d
stock_picking_package_id

filter_fiscal_position # id # list_price # stock_shipment_volume_id # stock_shipment_volume_id # stock_shipment_volume_id # stock_shipment_volume_id # updated_at # updated_at d updated_at d

stock_shipment_return_id
created_at d target_report_expression_id # volume # stock_move_id # stock_picking_id # stock_picking_type_id # stock_picking_line_id # deleted_at # deleted_at d deleted_at d
products_id stock_picking_status_id
updated_at d company_id # weight #
products_pricelist_product products_pricelists_id
products-princelist
deleted_at d foreign_vat_fiscal_position_id # sale_ok #
stock_shipment_volume_id

carryover_origin_report_line_id # products_pricelists_id # id # purchase_ok #

create_uid # products_id # sequence # active #
write_uid # currency_id # can_image_1024_be_zoomed #
name t company_id # has_configurable_attributes #
carryover_origin_expression_label t create_uid # tracking t
stock_shipment_volume_id stock_picking_package_id
date_date d write_uid # description_pickingin t
stock_shipment_volume_stock_picking_package stock_shipment_return_stock_picking_package
value # discount_policy t description_picking t
choose_delivery_package_id

created_at d name t description_pickingout t stock_shipment_volume_id # stock_shipment_return_id #

updated_at d active # sale_delay t stock_picking_package_id # stock_picking_package_id #
deleted_at d created_at d purchase_method t
updated_at d purchase_line_warn t
deleted_at d purchase_line_warn_msg t
service_type t
sale_line_warn t
expense_policy t
invoice_policy t
sale_line_warn_msg t
product_template_id
service_tracking t
product_template_choose_delivery_package
created_at d
updated_at d product_template_id #
deleted_at d choose_delivery_package_id #
stock_picking_line_id
product_template_id

product_template_id

delivery_package_id delivery_carrier_id
product_template_stock_picking_line product_template_delivery_package product_template_id product_template_delivery_carrier
product_template_id # product_template_id # product_template_id #
stock_picking_line_id # delivery_package_id # delivery_carrier_id #
products_id

product_id
product_product_stock_track_confirmation_rel
product_product_stock_track_confirmation_rels_id product_product_stock_track_confirmation_rel_product product_tag
products_id

pricelist_id

id # product_product_stock_track_confirmation_rels_id # id #
product_id # products_id # name t
stock_track_confirmation_id # color t
product_tags_id product_id
created_at d active #
product_tag_product product_pricelist_item
updated_at d created_at d
deleted_at d updated_at d product_tags_id # id #
product_tmpl_id

deleted_at d products_id # product_id #

pricelist_id #
order_line_id

fixed_price #
percent_price #
price #
discount #
product_label_layout
product_label_layout_id product_label_layout_product_template_rel product_template_id
currency_id #
product_template_order_line
id # id # active #
product_template_id

name t product_label_layout_id # product_template_id # created_at d

template t product_tmpl_id # order_line_id # updated_at d
stock_Move_id
res_Partner_id

create_uid # created_at d deleted_at d

write_uid # updated_at d
product_id # deleted_at d
created_at d
delivery_shipment_id

updated_at d
product_template_id
deleted_at d
product_template_res_partner product_template_stock_move
product_template_id # product_template_id #
res_Partner_id # stock_Move_id #
stock_picking_id

product_template_id
product_template_delivery_shipment
product_template_id #
product_template_id
delivery_shipment_id #
product_template_stock_picking
product_template_id #
stock_picking_id #
Default Layout

Table account_invoice
* Pk id int
number varchar(255)
date_invoice date
partner_id int
currency_id int
invoice_line_ids int
state varchar(255)
move_id int
payment_term_id int
journal_id int
company_id int
amount_total int
residual int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_invoice id

Table account_move
* Pk id int
sequence_number int
message_main_attachment int
_id
journal_id int
company_id int
payment_id int
statement_line_id int
tax_cash_basis_rec_id int
tax_cash_basis_origin_mov int
e_id
auto_post_origin_id int
secure_sequence_number int
invoice_payment_term_id int
partner_id int
commercial_partner_id int
partner_shipping_id int
partner_bank_id int
fiscal_position_id int
currency_id int
reversed_entry_id int
invoice_user_id int
invoice_incoterm_id int
invoice_cash_rounding_id int
create_uid int
write_uid int
sequence_prefix varchar(255)
access_token varchar(255)
name varchar(255)
ref varchar(255)
state varchar(255)
Table account_move
move_type varchar(255)
auto_post varchar(255)
inalterable_hash varchar(255)
payment_reference varchar(255)
qr_code_method varchar(255)
payment_state varchar(255)
invoice_source_email varchar(255)
invoice_partner_display_na varchar(255)
me
invoice_origin varchar(255)
date date
auto_post_until date
invoice_date date
invoice_date_due date
narration text
amount_untaxed int
amount_tax int
amount_total int
amount_residual int
amount_untaxed_signed int
amount_tax_signed int
amount_total_signed int
amount_total_in_currency_s int
igned
amount_residual_signed int
quick_edit_total_amount int
is_storno tinyint
always_tax_exigible tinyint
to_check tinyint
posted_before tinyint
is_move_sent tinyint
edi_state varchar(255)
campaign_id int
source_id int
medium_id int
team_id int
stock_move_id int
website_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_move id

Table account_payment
* Pk id int
message_main_attachment int
_id
move_id int
partner_bank_id int
paired_internal_transfer_pa int
yment_id
payment_method_line_id int
Table account_payment
payment_method_id int
currency_id int
partner_id int
outstanding_account_id int
destination_account_id int
destination_journal_id int
create_uid int
write_uid int
payment_type varchar(255)
partner_type varchar(255)
payment_reference varchar(255)
amount int
amount_company_currency int
_signed
is_reconciled tinyint
is_matched tinyint
is_internal_transfer tinyint
payment_transaction_id int
payment_token_id int
source_payment_id int
pos_payment_method_id int
force_outstanding_account_ int
id
pos_session_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_payment id

Table account_payment_method
* Pk id int
create_uid int
write_uid int
code varchar(255)
payment_type varchar(255)
name varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_payment_meth id
od

Table account_payment_method_line
* Pk id int
sequence int
payment_method_id int
payment_account_id int
journal_id int
create_uid int
write_uid int
Table account_payment_method_line
name varchar(255)
payment_provider_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_payment_meth id
od_line

Table account_payment_register
* Pk id int
currency_id int
journal_id int
partner_bank_id int
source_currency_id int
company_id int
partner_id int
payment_method_line_id int
writeoff_account_id int
create_uid int
write_uid varchar(255)
communication varchar(255)
payment_type varchar(255)
partner_type varchar(255)
payment_difference_handlin varchar(255)
g
writeoff_label varchar(255)
payment_date varchar(255)
amount date
source_amount decimal(20,6)
source_amount_currency decimal(20,6)
group_payment tinyint
can_edit_wizard tinyint
can_group_payments tinyint
payment_token_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_payment_regist id
er

Table account_payment_term
* Pk id int
company_id int
sequence int
create_uid int
write_uid int
name varchar(255)
note varchar(255)
active tinyint
display_on_invoice tinyint
Table account_payment_term
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_payment_term id

Table account_payment_term_line
* Pk id int
months int
days int
days_after int
discount_days int
payment_id int
create_uid int
write_uid int
value varchar(50)
value_amount decimal(20,6)
end_month tinyint
discount_percentage double
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_payment_term_ id
line

Table account_report
* Pk id int
root_report_id int
chart_template_id int
country_id int
load_more_limit int
create_uid int
write_uid int
availability_condition varchar(255)
default_opening_date_filter varchar(255)
filter_multi_company varchar(255)
filter_hierarchy varchar(255)
name varchar(255)
only_tax_exigible tinyint
search_bar tinyint
filter_date_range tinyint
filter_show_draft tinyint
filter_unreconciled tinyint
filter_unfold_all tinyint
filter_period_comparison tinyint
filter_growth_comparison tinyint
filter_journals tinyint
filter_analytic tinyint
filter_account_type tinyint
filter_partner tinyint
filter_fiscal_position tinyint
Table account_report
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_report id

Table account_report_column
* Pk id int
sequence int
report_id int
custom_audit_action_id int
create_uid int
write_uid int
expression_label varchar(255)
figure_type varchar(255)
name varchar(255)
sortable tinyint
blank_if_zero tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_report_column id

Table account_report_expression
* Pk id int
report_line_id int
create_uid int
write_uid int
label varchar(255)
engine varchar(255)
formula varchar(255)
subformula varchar(255)
date_scope varchar(255)
figure_type varchar(255)
carryover_target varchar(255)
green_on_positive tinyint
blank_if_zero tinyint
auditable tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_report_expressi id
on

Table account_report_external_value
* Pk id int
target_report_expression_id int
company_id int
Table account_report_external_value
foreign_vat_fiscal_position_i int
d
carryover_origin_report_line int
_id
create_uid int
write_uid int
name varchar(255)
carryover_origin_expression varchar(255)
_label
date_date date
value double
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_report_external id
_value

Table account_report_line
* Pk id int
report_id int
hierarchy_level int
parent_id int
sequence int
action_id int
create_uid int
write_uid int
groupby varchar(255)
code varchar(255)
name varchar(255)
foldable tinyint
print_on_new_page tinyint
hide_if_zero tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_account_report_line id

Table choose_delivery_carrier
* Pk id int
order_id int
Idx stock_volume_id int
Idx stock_return_id int
Idx deliveryPackage_id int
Idx carrier_id int
Idx choose_id int
Idx package_id int
create_uid int
Idx chooseDpackage_carrier_id int
Idx dcarrier_id int
Idx stock_shipment_carrier_id int
write_uid int
Table choose_delivery_carrier
* delivery_message varchar(255)
delivery_price int
display_price int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_choose_delivery_carrier id
FK_choose_delivery_carrier package_id
_choose_delivery_package
FK_choose_delivery_carrier carrier_id
_delivery_carrier
FK_choose_delivery_carrier deliveryPackage_id
_delivery_package
FK_choose_delivery_carrier dcarrier_id
_order_line
FK_choose_delivery_carrier chooseDpackage_carr
_stock_picking_tracking ier_id
FK_choose_delivery_carrier stock_return_id
_stock_shipment_return
FK_choose_delivery_carrier choose_id
_stock_shipment_tracking
FK_choose_delivery_carrier stock_volume_id
_stock_shipment_volume
FK_choose_delivery_carrier stock_shipment_carrie
_stock_shipment_weight r_id
Foreign Keys
FK_choose_delivery_carrier_choose_delivery_pack
age ( package_id ) ref choose_delivery_package (
id )
FK_choose_delivery_carrier_delivery_carrier (
carrier_id ) ref delivery_carrier ( id )
FK_choose_delivery_carrier_delivery_package (
deliveryPackage_id ) ref delivery_package ( id )
FK_choose_delivery_carrier_order_line ( dcarrier_id
) ref order_line ( id )
FK_choose_delivery_carrier_stock_picking_tracking
( chooseDpackage_carrier_id ) ref
stock_picking_tracking ( id )
FK_choose_delivery_carrier_stock_shipment_return
( stock_return_id ) ref stock_shipment_return ( id )
FK_choose_delivery_carrier_stock_shipment_tracki
ng ( choose_id ) ref stock_shipment_tracking ( id )
FK_choose_delivery_carrier_stock_shipment_volu
me ( stock_volume_id ) ref stock_shipment_volume
( id )
FK_choose_delivery_carrier_stock_shipment_weigh
t ( stock_shipment_carrier_id ) ref
stock_shipment_weight ( id )

Table choose_delivery_package
* Pk id int
* Idx chooseDeliveryPackage_id int
picking_id int
Idx stock_return_id int
delivery_package_type_id int
Idx stock_shipment_weight_id int
Idx chooseDpackage_tranking_i int
d
Table choose_delivery_package
create_uid int
write_uid int
shipping_weight int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_choose_delivery_packag id
e
FK_choose_delivery_packa stock_shipment_weig
ge_choose_delivery_packag ht_id
e
FK_choose_delivery_packa chooseDeliveryPacka
ge_order_line ge_id
FK_choose_delivery_packa chooseDpackage_tran
ge_stock_picking_tracking king_id
FK_choose_delivery_packa stock_return_id
ge_stock_shipment_return
Foreign Keys
FK_choose_delivery_package_choose_delivery_pa
ckage ( stock_shipment_weight_id ) ref
choose_delivery_package ( id )
FK_choose_delivery_package_order_line (
chooseDeliveryPackage_id ) ref order_line ( id )
FK_choose_delivery_package_stock_picking_tracki
ng ( chooseDpackage_tranking_id ) ref
stock_picking_tracking ( id )
FK_choose_delivery_package_stock_shipment_ret
urn ( stock_return_id ) ref stock_shipment_return (
id )

Table delivery-tracking-event
* Pk id int
shipment_id int
Idx delivery_tracking_event_id int
status varchar(255)
Idx tranck_event_id int
date date
Idx stock_volume_id int
location varchar(255)
details varchar(255)
created-at datetime
updated-at datetime
deleted-at datetime
Indexes
Pk pk_delivery-tracking-event id
FK_delivery-tracking- tranck_event_id
event_delivery-tracking-
event
FK_delivery-tracking- stock_volume_id
event_stock_shipment_volu
me
FK_delivery-tracking- delivery_tracking_eve
event_stock_shipment_weig nt_id
ht
Foreign Keys
FK_delivery-tracking-event_delivery-tracking-event (
tranck_event_id ) ref delivery-tracking-event ( id )
Table delivery-tracking-event
FK_delivery-tracking-
event_stock_shipment_volume ( stock_volume_id )
ref stock_shipment_volume ( id )
FK_delivery-tracking-event_stock_shipment_weight
( delivery_tracking_event_id ) ref
stock_shipment_weight ( id )

Table delivery_carrier
* Pk id int
* Idx dcarrier_id int
* Idx stock_volume_id int
sequence int
Idx delivery_carrier_id int
company_id int
Idx delivery_carrierTrack_id int
product_ide int
shipping_insurance int
create_uid int
write_uid int
delivery_type varchar(255)
integration_level varchar(255)
invoice_policy varchar(255)
name varchar(255)
carrier_description varchar(255)
active tinyint
prod_environment tinyint
debug_logging tinyint
free_over tinyint
return_label_on_delivery tinyint
get_return_label_from_porta tinyint
l
margin varchar(255)
amount varchar(255)
fixed_price varchar(255)
website_id int
is_published tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_delivery_carrier id
FK_delivery_carrier_delivery delivery_carrier_id
_carrier
FK_delivery_carrier_order_li dcarrier_id
ne
FK_delivery_carrier_stock_s delivery_carrierTrack_
hipment_tracking id
FK_delivery_carrier_stock_s stock_volume_id
hipment_volume
Foreign Keys
FK_delivery_carrier_delivery_carrier (
delivery_carrier_id ) ref delivery_carrier ( id )
FK_delivery_carrier_order_line ( dcarrier_id ) ref
order_line ( id )
Table delivery_carrier
FK_delivery_carrier_stock_shipment_tracking (
delivery_carrierTrack_id ) ref
stock_shipment_tracking ( id )
FK_delivery_carrier_stock_shipment_volume (
stock_volume_id ) ref stock_shipment_volume ( id )

Table delivery_method
* Pk id int
name varchar(50)
code varchar(50)
description varchar(50)
price float(12,0)
carrier_id int
active int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_delivery_method id

Table delivery_package
* Pk id int
name varchar(255)
weight float(12,0)
dimensions varchar(255)
content varchar(255)
value float(12,0)
Idx dPackage_id int
Idx package_id int
Idx chooseDeliveryPackage_id int
Idx shipmentVolume_id int
shipment_id int
Idx Tracking_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_delivery_package id
FK_delivery_package_choo chooseDeliveryPacka
se_delivery_package ge_id
FK_delivery_package_deliv dPackage_id
ery_package
FK_delivery_package_deliv package_id
ery_package_2
FK_delivery_package_stock Tracking_id
_shipment_tracking
FK_delivery_package_stock shipmentVolume_id
_shipment_volume
Foreign Keys
FK_delivery_package_choose_delivery_package (
chooseDeliveryPackage_id ) ref
choose_delivery_package ( id )
FK_delivery_package_delivery_package (
dPackage_id ) ref delivery_package ( id )
Table delivery_package
FK_delivery_package_delivery_package_2 (
package_id ) ref delivery_package ( id )
FK_delivery_package_stock_shipment_tracking (
Tracking_id ) ref stock_shipment_tracking ( id )
FK_delivery_package_stock_shipment_volume (
shipmentVolume_id ) ref stock_shipment_volume (
id )

Table delivery_price_rule
* Pk id int
sequence int
* carrier_id int
create_uid int
* write_uid int
variable varchar(255)
operator varchar(255)
variable_factor varchar(255)
list_base_price int
list_price int
* max_value int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_delivery_price_rule id

Table delivery_shipment
* Pk id int
order_id int
carrier_id int
Idx Tracking_id int
Idx Return_id int
shipping_method_id int
Idx deliveryPack_id int
tracking_number varchar(255)
status varchar(255)
Idx dShipment_id int
Idx chooseDeliveryCarrier_id int
Idx chooseDeliveryPackage_id int
Idx shipmentVolumePack_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_delivery_shipment id
FK_delivery_shipment_choo chooseDeliveryCarrier
se_delivery_carrier _id
FK_delivery_shipment_choo chooseDeliveryPacka
se_delivery_package ge_id
FK_delivery_shipment_deliv dShipment_id
ery_shipment
FK_delivery_shipment_stoc Return_id
k_shipment_return
Table delivery_shipment
FK_delivery_shipment_stoc Tracking_id
k_shipment_tracking
FK_delivery_shipment_stoc shipmentVolumePack
k_shipment_volume _id
FK_delivery_shipment_stoc deliveryPack_id
k_shipment_weight
Foreign Keys
FK_delivery_shipment_choose_delivery_carrier (
chooseDeliveryCarrier_id ) ref
choose_delivery_carrier ( id )
FK_delivery_shipment_choose_delivery_package (
chooseDeliveryPackage_id ) ref
choose_delivery_package ( id )
FK_delivery_shipment_delivery_shipment (
dShipment_id ) ref delivery_shipment ( id )
FK_delivery_shipment_stock_shipment_return (
Return_id ) ref stock_shipment_return ( id )
FK_delivery_shipment_stock_shipment_tracking (
Tracking_id ) ref stock_shipment_tracking ( id )
FK_delivery_shipment_stock_shipment_volume (
shipmentVolumePack_id ) ref
stock_shipment_volume ( id )
FK_delivery_shipment_stock_shipment_weight (
deliveryPack_id ) ref stock_shipment_weight ( id )

Table delivery_tracking
* Pk id int
shipment_id int
Idx Tracking_id int
Idx stock_volume_id int
Idx package_tranck_id int
Idx stock_move_delivery_id int
status varchar(255)
date varchar(255)
location varchar(255)
details varchar(255)
delivery_tracking_id varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_delivery_tracking id
FK_delivery_tracking_delive stock_move_delivery_
ry_t id
FK_delivery_tracking_delive package_tranck_id
ry_tracking
FK_delivery_tracking_stock Tracking_id
_shipment_tracking
FK_delivery_tracking_stock stock_volume_id
_shipment_volume
Foreign Keys
FK_delivery_tracking_delivery_t (
stock_move_delivery_id ) ref delivery_tracking ( id )
FK_delivery_tracking_delivery_tracking (
package_tranck_id ) ref delivery_tracking ( id )
FK_delivery_tracking_stock_shipment_tracking (
Tracking_id ) ref stock_shipment_tracking ( id )
Table delivery_tracking
FK_delivery_tracking_stock_shipment_volume (
stock_volume_id ) ref stock_shipment_volume ( id )

Table delivery_tracking_history
* Pk id int
shipment_id int
Idx delivery_tracking_history_id int
tracking_id int
Idx tranck_history_id int
date date
Idx stock_volume_id int
status varchar(255)
location varchar(50)
details varchar(50)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_delivery_tracking_history id
FK_delivery_tracking_histor delivery_tracking_hist
y_delivery_tracking_history ory_id
FK_delivery_tracking_histor tranck_history_id
y_delivery_tracking_history_
2
FK_delivery_tracking_histor stock_volume_id
y_stock_shipment_volume
Foreign Keys
FK_delivery_tracking_history_delivery_tracking_hist
ory ( delivery_tracking_history_id ) ref
delivery_tracking_history ( id )
FK_delivery_tracking_history_delivery_tracking_hist
ory_2 ( tranck_history_id ) ref
delivery_tracking_history ( id )
FK_delivery_tracking_history_stock_shipment_volu
me ( stock_volume_id ) ref stock_shipment_volume
( id )

Table delivery_zip_prefix
* Pk id int
create_uid int
write_uid int
name varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_delivery_zip_prefix id

Table discount_coupon
* Pk id int
code int
type int
value int
start_date date
Table discount_coupon
end_date date
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_discount_coupon id

Table discount_coupon_history
* Pk id int
discount_coupon_id int
date date
order_id int
amount_discount int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_discount_coupon_history id

Table discount_coupon_line
* Pk id int
discount_coupon_id int
discount_rule_id int
sequence int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_discount_coupon_line id

Table discount_rule
* Pk id int
name varchar(255)
condition tinyint
amount int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_discount_rule id

Table favorites
* Pk id int
name varchar(255)
url varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Table favorites
Pk pk_favorites id

Table favorites_categories
* Pk id int
name varchar(255)
parent_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_favorites_categories id

Table favorites_companies
* Pk id int
company_id int
user_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_favorites_companies id

Table favorites_groups
* Pk id int
favorite_id int
group_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_favorites_groups id

Table favorites_items
* Pk id int
favorites_items int
model int
res_id int
url varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_favorites_items id

Table favorites_locations
* Pk id int
location_id int
user_id int
created_at datetime
Table favorites_locations
updated_at datetime
deleted_at datetime
Indexes
Pk pk_favorites_locations id

Table favorites_notifications
* Pk id int
favorite_id int
user_id int
type varchar(255)
message varchar(255)
is_read tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_favorites_notifications id

Table favorites_tags
* Pk id int
name varchar(255)
color varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_favorites_tags id

Table favorites_users
* Pk id int
favorite_id int
user_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_favorites_users id

Table hr_employee_category
* Pk id int
color int
create_uid int
write_uid int
name varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_hr_employee_category id
Table ir_act_report_xml
* Pk id int
paperformat_id int
model varchar(255)
report_type int
report_name int
report_file int
attachment varchar(255)
print_report_name int
multi int
attachment_use int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_ir_act_report_xml id

Table mail_activity
* Pk id int
res_model_id int
res_id int
activity_type_id int
user_id int
request_partner_id int
recommended_activity_type int
_id
previous_activity_type_id int
create_uid int
write_uid int
res_model varchar(255)
res_name varchar(255)
summary varchar(255)
date_deadline date
note varchar(255)
automated tinyint
calendar_event_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_activity id

Table mail_activity_type
* Pk id int
sequence int
create_uid int
delay_count int
triggered_next_type_id int
default_user_id int
write_uid int
delay_unit varchar(255)
delay_from varchar(255)
icon varchar(255)
Table mail_activity_type
decoration_type varchar(255)
res_model varchar(255)
chaining_type varchar(255)
category varchar(255)
name varchar(255)
summary varchar(255)
default_note varchar(255)
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_activity_type id

Table mail_alias
* Pk id int
alias_model_id int
alias_user_id int
alias_force_thread_id int
alias_parent_model_id int
alias_parent_thread_id int
create_uid int
write_uid int
alias_name varchar(255)
alias_contact varchar(255)
alias_bounced_content varchar(255)
alias_defaults varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_alias id

Table mail_blacklist
* Pk id int
message_main_attachment int
_id
create_uid int
write_uid int
email varchar(255)
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_blacklist id

Table mail_blacklist_remove
* Pk id int
create_uid int
write_uid int
Table mail_blacklist_remove
email varchar(255)
reason varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_blacklist_remove id

Table mail_channel
* Pk id int
int
message_main_attachment
_id
group_public_id int
create_uid int
write_uid int
name varchar(255)
channel_type varchar(255)
default_display_mode varchar(255)
uuid varchar(255)
description varchar(255)
active int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_channel id

Table mail_channel_member
* Pk id int
partner_id int
guest_id int
channel_id int
fetched_message_id int
seen_message_id int
rtc_inviting_session_id int
create_uid int
write_uid int
custom_channel_name varchar(255)
fold_state varchar(255)
is_minimized tinyint
is_pinned tinyint
last_interest_dt date
last_seen_dt date
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_channel_member id
Table mail_channel_rtc_session
* Pk id int
channel_member_id int
channel_id int
create_uid int
write_uid int
is_screen_sharing_on tinyint
is_camera_on tinyint
is_muted tinyint
is_deaf tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_channel_rtc_sessio id
n

Table mail_compose_message
* Pk id int
template_id int
parent_id int
author_id int
res_id int
subtype_id int
mail_activity_type_id int
mail_server_id int
create_uid int
write_uid int
lang varchar(255)
subject varchar(255)
email_layout_xmlid varchar(255)
email_from varchar(255)
* composition_mode varchar(255)
* model varchar(255)
record_name varchar(255)
message_type varchar(255)
* reply_to varchar(255)
body varchar(255)
active_domain varchar(255)
email_add_signature tinyint
use_active_domain tinyint
is_log tinyint
notify tinyint
reply_to_force_new tinyint
auto_delete tinyint
auto_delete_message tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_compose_message id
Table mail_followers
* Pk id int
res_id int
partner_id int
res_model varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_followers id

Table mail_gateway_allowed
* Pk id int
create_uid int
write_uid int
email varchar(255)
email_normalized varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_gateway_allowed id

Table mail_guest
* Pk id int
country_id int
create_uid int
name varchar(255)
access_token varchar(255)
lang varchar(255)
timezone varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_guest id

Table mail_ice_server
* Pk id int
create_uid int
write_uid int
server_type varchar(255)
uri varchar(255)
username varchar(255)
credential varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_ice_server id
Table mail_link_preview
* Pk id int
message_id int
create_uid int
write_uid int
source_url varchar(255)
og_type varchar(255)
og_title varchar(255)
og_image varchar(255)
og_mimetype varchar(255)
image_mimetype varchar(255)
og_description varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_link_preview id

Table mail_mail
* Pk id int
mail_message_id int
fetchmail_server_id int
write_uid int
create_uid int
email_cc varchar(255)
state varchar(255)
failure_type varchar(255)
body_html varchar(255)
references varchar(255)
headers varchar(255)
email_to varchar(255)
failure_reason varchar(255)
is_notification tinyint
auto_delete tinyint
to_delete tinyint
scheduled_date date
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_mail id

Table mail_message
* Pk id int
author_guest_id int
parent_id int
res_id int
subtype_id int
mail_activity_type_id int
author_id int
mail_server_id int
create_uid int
Table mail_message
write_uid int
subject varchar(255)
model varchar(255)
record_name varchar(255)
message_type varchar(255)
email_from varchar(255)
message_id varchar(255)
reply_to varchar(255)
email_layout_xmlid varchar(255)
body varchar(255)
is_internal int
reply_to_force_new int
email_add_signature int
date int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_message id

Table mail_message_schedule
* Pk id int
mail_message_id int
create_uid int
write_uid int
notification_parameters varchar(255)
scheduled_datetime date
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_message_schedule id

Table mail_message_subtype
* Pk id int
parent_id int
sequence int
create_uid int
write_uid int
* relation_field varchar(255)
* res_model varchar(255)
* name varchar(255)
* description varchar(255)
internal tinyint
default tinyint
hidden tinyint
track_recipients tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Table mail_message_subtype
Pk pk_mail_message_subtype id

Table mail_notification
* Pk id int
author_id int
mail_message_id int
mail_mail_id int
res_partner_id int
notification_type varchar(255)
notification_status varchar(255)
failure_type varchar(255)
failure_reason varchar(255)
is_read tinyint
read_date date
sms_id int
sms_number varchar(255)
letter_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_notification id

Table mail_resend_message
* Pk id int
mail_message_id int
create_uid int
write_uid int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_resend_message id

Table mail_resend_partner
* Pk id int
partner_id int
resend_wizard_id int
create_uid int
write_uid int
message varchar(255)
resend tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_resend_partner id

Table mail_shortcode
* Pk id int
Table mail_shortcode
create_uid int
write_uid int
source varchar(255)
description varchar(255)
substitution varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_shortcode id

Table mail_template
* Pk id int
model_id int
report_template int
mail_server_id int
ref_ir_act_window int
create_uid int
write_uid int
template_fs varchar(255)
lang varchar(255)
model varchar(255)
email_from varchar(255)
email_to varchar(255)
partner_to varchar(255)
email_cc varchar(255)
reply_to varchar(255)
scheduled_date varchar(255)
name varchar(255)
description varchar(255)
subject varchar(255)
body_html varchar(255)
report_name varchar(255)
active tinyint
use_default_to tinyint
auto_delete tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_template id

Table mail_template_preview
* Pk id int
mail_template_id int
create_uid int
write_uid int
resource_ref varchar(255)
lang varchar(255)
error_msg varchar(255)
created_at datetime
Table mail_template_preview
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_template_preview id

Table mail_tracking_value
* Pk id int
field int
old_value_integer int
new_value_integer int
currency_id int
mail_message_id int
tracking_sequence int
create_uid int
write_uid int
field_desc varchar(255)
field_type varchar(255)
old_value_char varchar(255)
new_value_char varchar(255)
old_value_text varchar(255)
new_value_text varchar(255)
old_value_datetime date
new_value_datetime date
old_value_float decimal(20,6)
old_value_monetary decimal(20,6)
new_value_float decimal(20,6)
new_value_monetary decimal(20,6)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_tracking_value id

Table mail_wizard_invite
* Pk id int
res_id int
create_uid int
write_uid int
res_model varchar(255)
message varchar(255)
send_mail tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_mail_wizard_invite id

Table order_line
* Pk id int
order_id int
product_id int
Table order_line
product_uom_qty float(12,0)
Idx stock_move_orderLine_id int
price_unit float(12,0)
discount float(12,0)
tax_ids int
shipment_ids int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_order_line id
FK_order_line_stock_move stock_move_orderLin
e_id
Foreign Keys
FK_order_line_stock_move (
stock_move_orderLine_id ) ref stock_move ( id )

Table payment_icon
* Pk id int
create_uid int
write_uid int
payment_method varchar(255)
paypal_user_type varchar(255)
paypal_email_account varchar(255)
paypal_seller_account varchar(255)
paypal_pdt_token varchar(255)
manual_name varchar(255)
journal_name varchar(255)
acc_number varchar(255)
manual_post_msg varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_payment_icon id

Table payment_link_wizard
* Pk id int
res_id int
currency_id int
partner_id int
create_uid int
write_uid int
res_model varchar(255)
description varchar(255)
payment_provider_selection varchar(255)
amount decimal(20,6)
amount_max decimal(20,6)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Table payment_link_wizard
Pk pk_payment_link_wizard id

Table payment_provider
* Pk id int
sequence int
company_id int
redirect_form_view_id int
inline_form_view_id int
token_inline_form_view_id int
express_checkout_form_vie int
w_id
color int
module_id int
create_uid int
write_uid int
code varchar(255)
state varchar(255)
module_state varchar(255)
name varchar(255)
display_as varchar(255)
pre_msg varchar(255)
pending_msg varchar(255)
auth_msg varchar(255)
done_msg varchar(255)
cancel_msg varchar(255)
maximum_amount decimal(20,6)
is_published tinyint
allow_tokenization tinyint
capture_manually tinyint
allow_express_checkout tinyint
fees_active tinyint
fees_dom_fixed int
fees_dom_var int
fees_int_fixed int
fees_int_var int
so_reference_type varchar(255)
website_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_payment_provider id

Table payment_provider_onboarding_wizard
* Pk id int
create_uid int
write_uid int
payment_method varchar(255)
paypal_user_type varchar(255)
paypal_email_account varchar(255)
paypal_seller_account varchar(255)
paypal_pdt_token varchar(255)
Table payment_provider_onboarding_wizard
manual_name varchar(255)
journal_name varchar(255)
acc_number varchar(255)
manual_post_msg varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_payment_provider_onbo id
arding_wizard

Table payment_refund_wizard
* Pk id int
payment_id int
create_uid int
write_uid int
amount_to_refund decimal(20,6)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_payment_refund_wizard id

Table payment_token
* Pk id int
provider_id int
partner_id int
company_id int
create_uid int
write_uid int
payment_details varchar(255)
provider_ref tinyint
verified tinyint
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_payment_token id

Table payment_transaction
* Pk id int
provider_id int
company_id int
currency_id int
token_id int
source_transaction_id int
callback_model_id int
callback_res_id int
partner_id int
partner_state_id int
Table payment_transaction
partner_country_id int
create_uid int
write_uid int
reference varchar(255)
provider_reference varchar(255)
state varchar(255)
operation varchar(255)
landing_route varchar(255)
callback_method varchar(255)
callback_hash varchar(255)
partner_name varchar(255)
partner_lang varchar(255)
partner_email varchar(255)
partner_address varchar(255)
partner_zip varchar(255)
partner_city varchar(255)
partner_phone varchar(255)
state_message varchar(255)
amount int
fees int
is_post_processed tinyint
tokenize tinyint
callback_is_done tinyint
last_state_change date
payment_id int
is_donation tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_payment_transaction id

Table pos_category
* Pk id int
picking_type_id int
journal_id int
invoice_journal_id int
iface_start_categ_id int
sequence_id int
sequence_line_id int
pricelist_id int
company_id int
group_pos_manager_id int
group_pos_user_id int
tip_product_id int
default_fiscal_position_id int
rounding_method int
warehouse_id int
route_id int
limited_products_amount int
limited_partners_amount int
create_uid int
Table pos_category
write_uid int
name varchar(255)
iface_tax_included varchar(255)
proxy_ip varchar(255)
uuid varchar(255)
picking_policy varchar(255)
receipt_header varchar(255)
receipt_footer varchar(255)
iface_cashdrawer tinyint
iface_electronic_scale tinyint
iface_customer_facing_displ tinyint
ay_via_proxy
iface_customer_facing_displ tinyint
ay_local
iface_print_via_proxy tinyint
iface_scan_via_proxy tinyint
iface_big_scrollbars tinyint
iface_print_auto tinyint
iface_print_skip_screen tinyint
restrict_price_control tinyint
is_margins_costs_accessibl tinyint
e_to_every_user
set_maximum_difference tinyint
active tinyint
iface_tipproduct tinyint
use_pricelist tinyint
tax_regime_selection tinyint
start_category tinyint
limit_categories tinyint
module_pos_restaurant tinyint
module_pos_discount tinyint
module_pos_mercury tinyint
is_posbox tinyint
is_header_or_footer tinyint
module_pos_hr tinyint
other_devices tinyint
cash_rounding tinyint
only_round_cash_method tinyint
manual_discount tinyint
ship_later tinyint
limited_products_loading tinyint
product_load_background tinyint
limited_partners_loading tinyint
partner_load_background tinyint
amount_authorized_diff varchar(50)
epson_printer_ip varchar(50)
crm_team_id int
down_payment_product_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_pos_category id
Table pos_make_payment
* Pk id int
config_id int
payment_method_id int
create_uid int
write_uid int
payment_name varchar(255)
amount int
payment_date int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_pos_make_payment id

Table pos_payment
* Pk id int
pos_order_id int
payment_method_id int
session_id int
company_id int
account_move_id int
create_uid int
write_uid int
name varchar(255)
card_type varchar(255)
cardholder_name varchar(255)
transaction_id varchar(255)
payment_status varchar(255)
ticket varchar(255)
amount decimal(20,6)
is_change tinyint
payment_date date
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_pos_payment id

Table pos_payment_method
* Pk id int
outstanding_account_id int
receivable_account_id int
journal_id int
company_id int
create_uid int
write_uid int
use_payment_terminal int
name varchar(255)
is_cash_count varchar(255)
split_transactions tinyint
active tinyint
Table pos_payment_method
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_pos_payment_method id

Table product_accessory_rel
* Pk id int
Idx product_tmpl_id int
Idx product_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_accessory_rel id
FK_product_accessory_rel_ product_id
products
FK_product_accessory_rel_ product_tmpl_id
products-template
Foreign Keys
FK_product_accessory_rel_products ( product_id )
ref products ( id )
FK_product_accessory_rel_products-template (
product_tmpl_id ) ref products-template ( id )

Table product_accessory_rel_product
Idx product_accessory_rels_id int
Idx products_id int
Indexes
FK__product_accessory_rel product_accessory_rel
s_id
FK__products products_id
Foreign Keys
FK__product_accessory_rel (
product_accessory_rels_id ) ref
product_accessory_rel ( id )
FK__products ( products_id ) ref products ( id )

Table product_alternative_rel
* Pk id int
Idx product_tmpl_id int
Idx product_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_alternative_rel id
FK_product_alternative_rel_ product_id
products
FK_product_alternative_rel_ product_tmpl_id
products-template
Foreign Keys
Table product_alternative_rel
FK_product_alternative_rel_products ( product_id )
ref products ( id )
FK_product_alternative_rel_products-template (
product_tmpl_id ) ref products-template ( id )

Table product_alternatives_rels_products
* Idx product_alternative_rels_id int
* Idx products_id int
Indexes
FK_product_alternatives_rel product_alternative_re
s_products_product_alternat ls_id
ive_rel
FK_product_alternatives_rel products_id
s_products_products
Foreign Keys
FK_product_alternatives_rels_products_product_alt
ernative_rel ( product_alternative_rels_id ) ref
product_alternative_rel ( id )
FK_product_alternatives_rels_products_products (
products_id ) ref products ( id )

Table product_attribute_value
* Pk id int
sequence int
attribute_id int
Idx product_attribute_id int
Idx product_tmpl_id int
Idx product_id int
color int
create_uid int
write_uid int
html_color varchar(255)
name varchar(255)
is_custom tinyint
* created_at datetime
* updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_attribute_value id
FK_product_attribute_value product_id
_products
FK_product_attribute_value product_attribute_id
_products-attribute
FK_product_attribute_value product_tmpl_id
_products-template
Foreign Keys
FK_product_attribute_value_products ( product_id )
ref products ( id )
FK_product_attribute_value_products-attribute (
product_attribute_id ) ref products-attribute ( id )
FK_product_attribute_value_products-template (
product_tmpl_id ) ref products-template ( id )

Table product_category
* Pk id int
Table product_category
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_category id

Table product_image
* Pk id int
name varchar(255)
product_tmpl_id int
Idx product_id int
image varchar(255)
sequence int
create_uid int
* write_uid int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_image id
FK_product_image_product product_id
s
Foreign Keys
FK_product_image_products ( product_id ) ref
products ( id )

Table product_label_layout
* Pk id int
name varchar(255)
template varchar(255)
create_uid int
write_uid int
Idx product_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_label_layout id
FK_product_label_layout_pr product_id
oducts
Foreign Keys
FK_product_label_layout_products ( product_id ) ref
products ( id )

Table product_label_layout_product_template_rel
* Pk id int
Idx product_label_layout_id int
Idx product_tmpl_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Table product_label_layout_product_template_rel
Pk pk_product_label_layout_pr id
oduct_template_rel
FK_product_label_layout_pr product_label_layout_i
oduct_template_rel d
FK_product_template_rel_pr product_tmpl_id
oduct_label_layout
Foreign Keys
FK_product_label_layout_product_template_rel (
product_label_layout_id ) ref product_label_layout (
id )
FK_product_template_rel_product_label_layout (
product_tmpl_id ) ref products-template ( id )

Table product_packaging
* Pk id int
name varchar(255)
product_tmpl_id int
Idx product_id int
height float(12,0)
width float(12,0)
depth float(12,0)
weight float(12,0)
volume float(12,0)
create_uid int
write_uid int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_packaging id
FK_product_packaging_pro product_id
ducts
Foreign Keys
FK_product_packaging_products ( product_id ) ref
products ( id )

Table product_pricelist_item
* Pk id int
Idx product_id int
Idx pricelist_id int
fixed_price float(12,0)
percent_price float(12,0)
price float(12,0)
discount float(12,0)
currency_id int
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_pricelist_item id
FK_product_pricelist_item_p product_id
roducts
Table product_pricelist_item
FK_product_pricelist_item_p pricelist_id
roducts-princelist
Foreign Keys
FK_product_pricelist_item_products ( product_id )
ref products ( id )
FK_product_pricelist_item_products-princelist (
pricelist_id ) ref products-princelist ( id )

Table product_product
* Pk id int
name varchar(255)
default_code varchar(255)
Idx product_tmpl_id int
Idx product_id int
active tinyint
sale_ok tinyint
purchase_ok tinyint
type varchar(255)
categ_id int
uom_id int
list_price float(12,0)
volume varchar(255)
weight varchar(255)
image int
description int
attribute_value_ids int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_product id
FK_product_product_produc product_id
ts
FK_product_product_produc product_tmpl_id
ts-template
Foreign Keys
FK_product_product_products ( product_id ) ref
products ( id )
FK_product_product_products-template (
product_tmpl_id ) ref products-template ( id )

Table product_product_stock_track_confirmation_rel
* Pk id int
Idx product_id int
stock_track_confirmation_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_product_stock_t id
rack_confirmation_rel
FK_product_product_stock_ product_id
track_confirmation_rel_prod
ucts
Table product_product_stock_track_confirmation_rel
Foreign Keys
FK_product_product_stock_track_confirmation_rel_
products ( product_id ) ref products ( id )

Table product_product_stock_track_confirmation_rel_product
* Idx product_product_stock_trac int
k_confirmation_rels_id
* Idx products_id int
Indexes
FK_product_product_stock_ product_product_stoc
track_confirmation_rel_p k_track_confirmation_
rels_id
FK_product_product_stock_ products_id
track_confirmation_rel_prod
uct_products
Foreign Keys
FK_product_product_stock_track_confirmation_rel_
p(
product_product_stock_track_confirmation_rels_id )
ref product_product_stock_track_confirmation_rel (
id )
FK_product_product_stock_track_confirmation_rel_
product_products ( products_id ) ref products ( id )

Table product_public_category
* Pk id int
website_id int
parent_id int
sequence int
* create_uid int
write_uid int
* website_meta_og_img int
* parent_path int
website_meta_title varchar(255)
website_meta_description varchar(255)
website_meta_keywords varchar(255)
seo_name varchar(255)
name varchar(255)
website_description varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_public_category id

Table product_removal
* Pk id int
Idx product_id int
quantity float(12,0)
date date
reason varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Table product_removal
Indexes
Pk pk_product_removal id
FK_product_removal_produ product_id
cts
Foreign Keys
FK_product_removal_products ( product_id ) ref
products ( id )

Table product_replenish
* Pk id int
Idx product_id int
quantity float(12,0)
date date
reason varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_replenish id
FK_product_replenish_prod product_id
ucts
Foreign Keys
FK_product_replenish_products ( product_id ) ref
products ( id )

Table product_ribbon
* Pk id int
name varchar(255)
Idx product_id int
color varchar(255)
position varchar(255)
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_ribbon id
FK_product_ribbon_product product_id
s
Foreign Keys
FK_product_ribbon_products ( product_id ) ref
products ( id )

Table product_supplier_taxes_rel
* Pk id int
Idx supplier_id int
tax_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_supplier_taxes_ id
rel
Table product_supplier_taxes_rel
FK_product_supplier_taxes supplier_id
_rel_products-supplier
Foreign Keys
FK_product_supplier_taxes_rel_products-supplier (
supplier_id ) ref products-supplier ( id )

Table product_supplier_taxes_rel_products
Idx product_supplier_taxes_rels int
_id
Idx products_id int
Indexes
FK_product_supplier_taxes product_supplier_taxe
_rel_products_product s_rels_id
FK_product_supplier_taxes products_id
_rel_products_products
Foreign Keys
FK_product_supplier_taxes_rel_products_product (
product_supplier_taxes_rels_id ) ref
product_supplier_taxes_rel ( id )
FK_product_supplier_taxes_rel_products_products
( products_id ) ref products ( id )

Table product_supplierinfo
* Pk id int
Idx product_id int
Idx supplier_id int
price float(12,0)
delay int
min_quantity float(12,0)
max_quantity float(12,0)
product_code varchar(255)
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_supplierinfo id
FK_product_supplierinfo_pr product_id
oducts
FK_product_supplierinfo_pr supplier_id
oducts-supplier
Foreign Keys
FK_product_supplierinfo_products ( product_id ) ref
products ( id )
FK_product_supplierinfo_products-supplier (
supplier_id ) ref products-supplier ( id )

Table product_tag
* Pk id int
name varchar(255)
color varchar(255)
active tinyint
created_at datetime
updated_at datetime
Table product_tag
deleted_at datetime
Indexes
Pk pk_product_tag id

Table product_tag_product
Idx product_tags_id int
Idx products_id int
Indexes
FK__product_tag product_tags_id
FK_product_tag_product_pr products_id
oducts
Foreign Keys
FK__product_tag ( product_tags_id ) ref
product_tag ( id )
FK_product_tag_product_products ( products_id )
ref products ( id )

Table product_taxes_rel
* Pk id int
Idx product_id int
tax_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_product_taxes_rel id
FK_product_taxes_rel_prod product_id
ucts
Foreign Keys
FK_product_taxes_rel_products ( product_id ) ref
products ( id )

Table product_taxes_rel_product
Idx product_taxes_rels_id int
Idx products_id int
Indexes
FK__product products_id
FK__product_taxes_rel product_taxes_rels_id
Foreign Keys
FK__product_taxes_rel ( product_taxes_rels_id ) ref
product_taxes_rel ( id )
FK__product ( products_id ) ref products ( id )

Table product_template_choose_delivery_carrier
Idx product_template_id int
Idx choose_delivery_carrier_id int
Indexes
FK_product_template_choo choose_delivery_carri
se_delivery_carrier_c_d_car er_id
rier
FK_product_template_choo product_template_id
se_delivery_carrier_product
s-template
Table product_template_choose_delivery_carrier
Foreign Keys
FK_product_template_choose_delivery_carrier_c_d
_carrier ( choose_delivery_carrier_id ) ref
choose_delivery_carrier ( id )
FK_product_template_choose_delivery_carrier_pro
ducts-template ( product_template_id ) ref products-
template ( id )

Table product_template_choose_delivery_package
Idx product_template_id int
Idx choose_delivery_package_i int
d
Indexes
FK__choose_delivery_pack choose_delivery_pack
age age_id
FK__products-template product_template_id
Foreign Keys
FK__choose_delivery_package (
choose_delivery_package_id ) ref
choose_delivery_package ( id )
FK__products-template ( product_template_id ) ref
products-template ( id )

Table product_template_delivery_carrier
Idx product_template_id int
Idx delivery_carrier_id int
Indexes
FK_product_template_deliv delivery_carrier_id
ery_carrier_delivery_carrier
FK_product_template_deliv product_template_id
ery_carrier_products-
template
Foreign Keys
FK_product_template_delivery_carrier_delivery_car
rier ( delivery_carrier_id ) ref delivery_carrier ( id )
FK_product_template_delivery_carrier_products-
template ( product_template_id ) ref products-
template ( id )

Table product_template_delivery_package
Idx product_template_id int
Idx delivery_package_id int
Indexes
FK_product_template_deliv delivery_package_id
ery_package_delivery_pack
age
FK_product_template_deliv product_template_id
ery_package_products-
template
Foreign Keys
FK_product_template_delivery_package_delivery_p
ackage ( delivery_package_id ) ref
delivery_package ( id )
FK_product_template_delivery_package_products-
template ( product_template_id ) ref products-
template ( id )
Table product_template_delivery_shipment
Idx product_template_id int
Idx delivery_shipment_id int
Indexes
FK__delivery_shipment delivery_shipment_id
FK__products_template product_template_id
Foreign Keys
FK__delivery_shipment ( delivery_shipment_id ) ref
delivery_shipment ( id )
FK__products_template ( product_template_id ) ref
products-template ( id )

Table product_template_order_line
Idx product_template_id int
Idx order_line_id int
Indexes
FK_product_template_order order_line_id
_line_order_line
FK_product_template_order product_template_id
_line_products-template
Foreign Keys
FK_product_template_order_line_order_line (
order_line_id ) ref order_line ( id )
FK_product_template_order_line_products-template
( product_template_id ) ref products-template ( id )

Table product_template_res_partner
Idx product_template_id int
Idx res_Partner_id int
Indexes
FK_product_template_res_p product_template_id
artner_products-template
FK_product_template_res_p res_Partner_id
artner_res_partner
Foreign Keys
FK_product_template_res_partner_products-
template ( product_template_id ) ref products-
template ( id )
FK_product_template_res_partner_res_partner (
res_Partner_id ) ref res_partner ( id )

Table product_template_stock_move
Idx product_template_id int
Idx stock_Move_id int
Indexes
FK_product_template_stock product_template_id
_move_products-template
FK_product_template_stock stock_Move_id
_move_stock_move
Foreign Keys
FK_product_template_stock_move_products-
template ( product_template_id ) ref products-
template ( id )
FK_product_template_stock_move_stock_move (
stock_Move_id ) ref stock_move ( id )
Table product_template_stock_picking
Idx product_template_id int
Idx stock_picking_id int
Indexes
FK__products_tempt product_template_id
FK__stock_picking stock_picking_id
Foreign Keys
FK__products_tempt ( product_template_id ) ref
products-template ( id )
FK__stock_picking ( stock_picking_id ) ref
stock_picking ( id )

Table product_template_stock_picking_line
Idx product_template_id int
Idx stock_picking_line_id int
Indexes
FK_product_template_stock product_template_id
_picking_line_products-
template
FK_product_template_stock stock_picking_line_id
_picking_line_stock_picking
_line
Foreign Keys
FK_product_template_stock_picking_line_products-
template ( product_template_id ) ref products-
template ( id )
FK_product_template_stock_picking_line_stock_pic
king_line ( stock_picking_line_id ) ref
stock_picking_line ( id )

Table products
* Pk id int
message_main_attachment int
_id
product_tmpl_id int
create_uid int
write_uid int
default_code varchar(255)
barcode varchar(255)
combination_indices varchar(255)
volume int
weight int
active tinyint
can_image_variant_1024_b tinyint
e_zoomed
* created_at datetime
* updated_at datetime
deleted_at datetime
Indexes
Pk pk_products id

Table products-attribute
* Pk id int
sequence int
create_uid int
Table products-attribute
write_uid int
Idx product_id int
create_variant varchar(255)
display_type varchar(255)
name varchar(255)
* created-at datetime
* updated_at datetime
deleted_at datetime
Indexes
Pk pk_products-attribute id
FK_products- product_id
attribute_products
Foreign Keys
FK_products-attribute_products ( product_id ) ref
products ( id )

Table products-barcode
* Pk id int
sequence int
Idx attribute_id int
Idx product_id int
color int
create_uid int
write_uid int
html_color varchar(255)
name varchar(255)
is_custom tinyint
* created_at datetime
* updated_at datetime
deleted_at datetime
Indexes
Pk pk_products-barcode id
FK_products- product_id
barcode_products
FK_products- attribute_id
barcode_products-attribute
Foreign Keys
FK_products-barcode_products ( product_id ) ref
products ( id )
FK_products-barcode_products-attribute (
attribute_id ) ref products-attribute ( id )

Table products-category
* Pk id int
parent_id int
create_uid int
write_uid int
name varchar(255)
complete_name int
parent_path int
removal_strategy_id int
packaging_reserve_method varchar(255)
created_at datetime
Table products-category
updated_at datetime
deleted_at datetime
Indexes
Pk pk_products-category id

Table products-princelist
* Pk id int
sequence int
currency_id int
company_id int
create_uid int
write_uid int
discount_policy varchar(255)
name varchar(255)
active tinyint
* created_at datetime
* updated_at datetime
deleted_at datetime
Indexes
Pk pk_products-princelist id

Table products-supplier
* Pk id int
partner_id int
sequence int
company_id int
currency_id int
Idx product_id int
Idx product_tmpl_id int
delay int
create_uid int
write_uid int
product_name varchar(255)
product_code varchar(255)
date_start date
date_end date
min_qty decimal(20,6)
price decimal(20,6)
* created_at datetime
* updated_at datetime
deleted_at datetime
Indexes
Pk pk_products-supplier id
FK_products- product_id
supplier_products
FK_products- product_tmpl_id
supplier_products-template
Foreign Keys
FK_products-supplier_products ( product_id ) ref
products ( id )
FK_products-supplier_products-template (
product_tmpl_id ) ref products-template ( id )
Table products-template
* Pk id int
create_uid int
message_main_attachment int
_id
sequence int
Idx stock_move_productsTempl int
ate_id
categ_id int
uom_id int
Idx product_id int
uom_po_id int
company_id int
color int
* write_uid int
detailed_type varchar(255)
type varchar(255)
default_code varchar(255)
priority varchar(255)
name varchar(255)
description varchar(255)
description_purchase varchar(255)
description_sale varchar(255)
list_price decimal(20,6)
volume decimal(20,6)
weight decimal(20,6)
sale_ok tinyint
purchase_ok tinyint
active tinyint
can_image_1024_be_zoom tinyint
ed
has_configurable_attributes tinyint
tracking varchar(255)
description_pickingin varchar(255)
description_picking varchar(255)
description_pickingout varchar(255)
sale_delay varchar(255)
purchase_method varchar(255)
purchase_line_warn varchar(255)
purchase_line_warn_msg varchar(255)
service_type varchar(255)
sale_line_warn varchar(255)
expense_policy varchar(255)
invoice_policy varchar(255)
sale_line_warn_msg varchar(255)
service_tracking varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_products-template id
FK_products- product_id
template_products
FK_products- stock_move_products
template_stock_move Template_id
Foreign Keys
Table products-template
FK_products-template_products ( product_id ) ref
products ( id )
FK_products-template_stock_move (
stock_move_productsTemplate_id ) ref stock_move
( id )

Table products_category_product
Idx products_categorys_id int
Idx products_id int
Indexes
FK_products_category_prod products_id
uct_products
FK_products_category_prod products_categorys_id
uct_products-category
Foreign Keys
FK_products_category_product_products (
products_id ) ref products ( id )
FK_products_category_product_products-category (
products_categorys_id ) ref products-category ( id )

Table products_pricelist_product
Idx products_pricelists_id int
Idx products_id int
Indexes
FK_products_pricelist_prod products_id
uct_products
FK_products_pricelist_prod products_pricelists_id
uct_products-princelist
Foreign Keys
FK_products_pricelist_product_products (
products_id ) ref products ( id )
FK_products_pricelist_product_products-princelist (
products_pricelists_id ) ref products-princelist ( id )

Table rating_line
* Pk id int
name varchar(255)
rated_object int
rating_scale int
rated_by int
date date
rating_values int
overall_rating int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_rating_line id

Table rating_rating
* Pk id int
res_model_id int
res_id int
Table rating_rating
parent_res_model_id int
parent_res_id int
rated_partner_id int
partner_id int
message_id int
create_uid int
write_uid int
res_name varchar(255)
res_model varchar(255)
parent_res_name varchar(255)
parent_res_model varchar(255)
rating_text varchar(255)
access_token varchar(255)
feedback varchar(255)
is_internal tinyint
consumed tinyint
rating int
publisher_id int
publisher_comment varchar(255)
publisher_datetime int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_rating_rating id

Table rating_scale
* Pk id int
name varchar(255)
ratingValues int
sequence int
company varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_rating_scale id

Table rating_vote
* Pk id int
vote_date date
rated_object varchar(255)
rating_scale int
user int
rating_value int
feedback varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_rating_vote id
Table report_layout
* Pk id int
view_id int
sequence int
create_uid int
write_uid int
image varchar(255)
pdf varchar(255)
name varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_report_layout id

Table report_paperformat
* Pk id int
page_height int
page_width int
header_spacing int
dpi int
create_uid int
write_uid int
name varchar(255)
format varchar(255)
orientation varchar(255)
default tinyint
header_line tinyint
disable_shrinking tinyint
margin_top double
margin_bottom double
margin_left double
margin_right double
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_report_paperformat id

Table res_bank
* Pk id int
state int
country int
create_uid int
write_uid int
Idx user_id int
name varchar(255)
street varchar(255)
street2 varchar(255)
zip varchar(255)
city varchar(255)
email varchar(255)
Table res_bank
phone varchar(255)
bic varchar(255)
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_res_bank id
FK_res_bank_res_users user_id
Foreign Keys
FK_res_bank_res_users ( user_id ) ref res_users (
id )

Table res_company
* Pk id int
* name varchar(255)
* partner_id int
* currency_id int
Idx user_id int
sequence int
* create_date date
* parent_id int
paperformat_id int
external_report_layout_id int
create_uid int
write_uid int
* email varchar(255)
* phone varchar(255)
* mobile varchar(255)
base_onboarding_company varchar(255)
_state
font varchar(255)
primary_color varchar(255)
secondary_color varchar(255)
layout_background varchar(255)
report_footer text
report_header text
company_details text
* active tinyint
* write_date date
logo_web varchar(255)
resource_calendar_id int
partner_gid int
* iap_enrich_auto_done tinyint
* snailmail_color tinyint
* snailmail_cover tinyint
* snailmail_duplex tinyint
social_twitter varchar(255)
social_facebook varchar(255)
social_github varchar(255)
social_linkedin varchar(255)
social_youtube varchar(255)
social_instagram varchar(255)
Table res_company
* hr_presence_control_email_ int
amount
* hr_presence_control_ip_list varchar(255)
nomenclature_id int
internal_transit_location_id int
* stock_mail_confirmation_te int
mplate_id
* annual_inventory_day int
annual_inventory_month varchar(255)
* stock_move_email_validatio tinyint
n
stock_sms_confirmation_te int
mplate_id
* stock_move_sms_validation tinyint
* has_received_warning_stoc tinyint
k_sms
payment_provider_onboardi varchar(255)
ng_state
payment_onboarding_paym varchar(255)
ent_method
* message_main_attachment int
_id
fiscalyear_last_day int
transfer_account_id int
chart_template_id int
default_cash_difference_inc int
ome_account_id
default_cash_difference_ex int
pense_account_id
account_journal_suspense_ int
account_id
account_journal_payment_d int
ebit_account_id
account_journal_payment_c int
redit_account_id
account_journal_early_pay_ int
discount_gain_account_id
account_journal_early_pay_ int
discount_loss_account_id
account_sale_tax_id int
account_purchase_tax_id int
currency_exchange_journal int
_id
income_currency_exchange int
_account_id
expense_currency_exchang int
e_account_id
property_stock_account_inp int
ut_categ_id
property_stock_account_out int
put_categ_id
property_stock_valuation_a int
ccount_id
incoterm_id int
account_opening_move_id int
account_default_pos_receiv int
able_account_id
expense_accrual_account_i int
d
Table res_company
revenue_accrual_account_i int
d
automatic_entry_default_jou int
rnal_id
account_fiscal_country_id int
tax_cash_basis_journal_id int
account_cash_basis_base_ int
account_id
fiscalyear_last_month int
bank_account_code_prefix int
cash_account_code_prefix int
early_pay_discount_comput int
ation
transfer_account_code_prefi int
x
tax_calculation_rounding_m int
ethod
account_setup_bank_data_ int
state
account_setup_fy_data_stat int
e
account_setup_coa_state int
account_setup_taxes_state int
account_onboarding_invoic int
e_layout_state
account_onboarding_sale_t int
ax_state
account_invoice_onboardin int
g_state
account_dashboard_onboar int
ding_state
terms_type int
account_setup_bill_state int
quick_edit_mode int
period_lock_date int
fiscalyear_lock_date int
tax_lock_date int
account_opening_date int
invoice_terms int
invoice_terms_html int
expects_chart_of_accounts int
anglo_saxon_accounting int
qr_code int
invoice_is_email int
invoice_is_print int
account_use_credit_limit int
account_onboarding_create int
_invoice_state_flag
tax_exigibility int
account_storno int
po_lock int
po_double_validation int
po_double_validation_amou int
nt
po_lead int
invoice_is_snailmail int
days_to_purchase int
Table res_company
vat_check_vies tinyint
quotation_validity_days int
sale_quotation_onboarding_ varchar(255)
state
sale_onboarding_order_con varchar(255)
firmation_state
sale_onboarding_sample_q varchar(255)
uotation_state
sale_onboarding_payment_ varchar(255)
method
portal_confirmation_sign tinyint
portal_confirmation_pay tinyint
sale_order_template_id int
security_lead int
* created_at datetime
* updated_at datetime
deleted_at datetime
Indexes
Pk pk_res_company id
FK_res_company_res_user user_id
s
Foreign Keys
FK_res_company_res_users ( user_id ) ref
res_users ( id )

Table res_country_state
* Pk id int
name varchar(255)
code varchar(255)
country_id int
Idx user_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_res_country_state id
FK_res_country_state_res_ user_id
users
Foreign Keys
FK_res_country_state_res_users ( user_id ) ref
res_users ( id )

Table res_currency_rate
* Pk id int
currency_id int
company_id int
Idx user_id int
create_uid int
write_uid int
name varchar(50)
rate decimal(20,6)
created_at datetime
updated_at datetime
deleted_at datetime
Table res_currency_rate
Indexes
Pk pk_res_currency_rate id
FK_res_currency_rate_res_ user_id
users
Foreign Keys
FK_res_currency_rate_res_users ( user_id ) ref
res_users ( id )

Table res_groups
* Pk id int
* name varchar(255)
* category_id int
* color int
* create_uid date
* write_uid date
* comment varchar(255)
* share int
* created_at datetime
* updated_at datetime
deleted_at datetime
Indexes
Pk pk_res_groups id

Table res_groups_res_users
Idx res_users_id int
Idx res_groups_id int
Indexes
FK_res_groups_res_users_r res_groups_id
es_groups
FK_res_groups_res_users_r res_users_id
es_users
Foreign Keys
FK_res_groups_res_users_res_groups (
res_groups_id ) ref res_groups ( id )
FK_res_groups_res_users_res_users (
res_users_id ) ref res_users ( id )

Table res_partner
* Pk id int
* name varchar(255)
* company_id int
* Idx stock_move_res_id int
* title varchar(255)
* parent_id int
* Idx user_id int
* state_id int
* country_id int
* industry_id int
* color int
* commercial_partner_id int
* create_uid int
* write_uid int
Table res_partner
* display_name varchar(255)
* ref varchar(255)
* lang varchar(255)
* tz varchar(255)
* vat varchar(255)
* company_registry varchar(255)
* website varchar(255)
* street varchar(255)
* street2 varchar(255)
* zip varchar(255)
* city varchar(255)
* email varchar(255)
* phone varchar(255)
* mobile varchar(255)
* commercial_company_nam varchar(255)
e
* company_name varchar(255)
* date date
* comment text
* partner_latitude decimal(20,6)
* partner_longitude decimal(20,6)
* active tinyint
* employee tinyint
* is_company tinyint
* partner_share tinyint
* write_date datetime
message_main_attachment int
_id
message_bounce int
* email_normalized varchar(255)
* signup_token varchar(255)
* signup_type varchar(255)
* signup_expiration datetime
* calendar_last_notif_ack datetime
* team_id int
* partner_gid int
* additional_info varchar(255)
* phone_sanitized varchar(255)
* picking_warn varchar(255)
* picking_warn_msg text
* supplier_rank int
* customer_rank int
* invoice_warn varchar(255)
* invoice_warn_msg text
* debit_limit decimal(20,6)
* last_time_entries_checked date
* purchase_warn varchar(255)
* purchase_warn_msg tinyint
* sale_warn varchar(255)
* sale_warn_msg text
* created_at datetime
* updated_at datetime
deleted_at datetime
Indexes
Table res_partner
Pk pk_res_partner id
FK_res_partner_res_users user_id
FK_res_partner_stock_m stock_move_res_id
Foreign Keys
FK_res_partner_res_users ( user_id ) ref res_users
( id )
FK_res_partner_stock_move ( stock_move_res_id )
ref stock_move ( id )

Table res_partner_category
* Pk id int
color int
parent_id int
create_uid int
write_uid int
parent_path varchar(255)
name varchar(255)
active int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_res_partner_category id

Table res_partner_choose_delivery_carrier
Idx res_partner_id int
Idx choose_delivery_carrier_id int
Indexes
FK_res_partner_choose_del choose_delivery_carri
ivery_carrier_choose_delive er_id
ry_carrier
FK_res_partner_choose_del res_partner_id
ivery_carrier_res_partner
Foreign Keys
FK_res_partner_choose_delivery_carrier_choose_d
elivery_carrier ( choose_delivery_carrier_id ) ref
choose_delivery_carrier ( id )
FK_res_partner_choose_delivery_carrier_res_partn
er ( res_partner_id ) ref res_partner ( id )

Table res_partner_choose_delivery_package
Idx res_partner_id int
Idx choose_delivery_package_i int
d
Indexes
FK_res_partner_choose_del choose_delivery_pack
ivery_package_choose_deli age_id
very_package
FK_res_partner_choose_del res_partner_id
ivery_package_res_partner
Foreign Keys
FK_res_partner_choose_delivery_package_choose
_delivery_package ( choose_delivery_package_id )
ref choose_delivery_package ( id )
Table res_partner_choose_delivery_package
FK_res_partner_choose_delivery_package_res_par
tner ( res_partner_id ) ref res_partner ( id )

Table res_partner_delivery_carrier
Idx res_partner_id int
Idx delivery_carrier_id int
Indexes
FK_res_partner_delivery_ca delivery_carrier_id
rrier_delivery_carrier
FK_res_partner_delivery_ca res_partner_id
rrier_res_partner
Foreign Keys
FK_res_partner_delivery_carrier_delivery_carrier (
delivery_carrier_id ) ref delivery_carrier ( id )
FK_res_partner_delivery_carrier_res_partner (
res_partner_id ) ref res_partner ( id )

Table res_partner_delivery_package
Idx res_partner_id int
Idx delivery_package_id int
Indexes
FK_res_partner_delivery_pa delivery_package_id
ckage_delivery_package
FK_res_partner_delivery_pa res_partner_id
ckage_res_partner
Foreign Keys
FK_res_partner_delivery_package_delivery_packag
e ( delivery_package_id ) ref delivery_package ( id )
FK_res_partner_delivery_package_res_partner (
res_partner_id ) ref res_partner ( id )

Table res_partner_delivery_shipment
Idx res_partner_id int
Idx delivery_shipment_id int
Indexes
FK_res_partner_delivery_sh delivery_shipment_id
ipment_delivery_shipment
FK_res_partner_delivery_sh res_partner_id
ipment_res_partner
Foreign Keys
FK_res_partner_delivery_shipment_delivery_shipm
ent ( delivery_shipment_id ) ref delivery_shipment (
id )
FK_res_partner_delivery_shipment_res_partner (
res_partner_id ) ref res_partner ( id )

Table res_partner_order_line
Idx res_partner_id int
Idx order_line_id int
Indexes
FK_res_partner_order_line_ order_line_id
order_line
FK_res_partner_order_line_ res_partner_id
res_partner
Table res_partner_order_line
Foreign Keys
FK_res_partner_order_line_order_line (
order_line_id ) ref order_line ( id )
FK_res_partner_order_line_res_partner (
res_partner_id ) ref res_partner ( id )

Table res_partner_products_template
Idx res_partner_id int
Idx products_template_id int
Indexes
FK_res_partner_products_t products_template_id
emplate_products-template
FK_res_partner_products_t res_partner_id
emplate_res_partner
Foreign Keys
FK_res_partner_products_template_products-
template ( products_template_id ) ref products-
template ( id )
FK_res_partner_products_template_res_partner (
res_partner_id ) ref res_partner ( id )

Table res_partner_stock_move
Idx res_partner_id int
Idx stock_Move_id int
Indexes
FK_res_partner_stock_mov res_partner_id
e_res_partner
FK_res_partner_stock_mov stock_Move_id
e_stock_move
Foreign Keys
FK_res_partner_stock_move_res_partner (
res_partner_id ) ref res_partner ( id )
FK_res_partner_stock_move_stock_move (
stock_Move_id ) ref stock_move ( id )

Table res_partner_stock_picking
Idx res_partner_id int
Idx stock_picking_id int
Indexes
FK_res_partner_stock_picki res_partner_id
ng_res_partner
FK_res_partner_stock_picki stock_picking_id
ng_stock_picking
Foreign Keys
FK_res_partner_stock_picking_res_partner (
res_partner_id ) ref res_partner ( id )
FK_res_partner_stock_picking_stock_picking (
stock_picking_id ) ref stock_picking ( id )

Table res_partner_stock_picking_line
Idx res_partner_id int
Idx stock_picking_line_id int
Indexes
Table res_partner_stock_picking_line
FK_res_partner_stock_picki res_partner_id
ng_line_res_partner
FK_res_partner_stock_picki stock_picking_line_id
ng_line_stock_picking_line
Foreign Keys
FK_res_partner_stock_picking_line_res_partner (
res_partner_id ) ref res_partner ( id )
FK_res_partner_stock_picking_line_stock_picking_l
ine ( stock_picking_line_id ) ref stock_picking_line (
id )

Table res_users
* Pk id int
* name varchar(225)
* login varchar(225)
* password varchar(50)
* email varchar(225)
* company_id int
partner_id int
* active tinyint
* action_id int
* create_uid int
* write_uid int
* signature varchar(50)
* share tinyint
* write_date int
* totp_secret varchar(50)
* notification_type varchar(50)
* odoobot_state varchar(50)
* odoobot_failed tinyint
* sale_team_id int
* target_sales_won int
* target_sales_done int
* karma int
* rank_id int
* next_rank_id int
* target_sales_invoiced int
* created_at datetime
* updated_at datetime
deleted_at datetime
Indexes
Pk pk_res_users id

Table res_users_deletion
* Pk id int
Idx user_id int
user_id_int int
create_uid int
write_uid int
state varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Table res_users_deletion
Indexes
Pk pk_res_users_deletion id
FK_res_users_deletion_res user_id
_users
Foreign Keys
FK_res_users_deletion_res_users ( user_id ) ref
res_users ( id )

Table res_users_log
* Pk id int
create_uid int
Idx user_id int
model varchar(255)
record_id int
action varchar(255)
field_name varchar(255)
old_value varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_res_users_log id
FK_res_users_log_res_user user_id
s
Foreign Keys
FK_res_users_log_res_users ( user_id ) ref
res_users ( id )

Table res_users_settings_volumes
* Pk id int
user_setting_id int
Idx user_id int
partner_id int
guest_id int
create_uid int
write_uid int
volume double
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_res_users_settings_volu id
mes
FK_res_users_settings_volu user_id
mes_res_users
Foreign Keys
FK_res_users_settings_volumes_res_users (
user_id ) ref res_users ( id )

Table sale_advance_payment_inv
* Pk id int
product_id int
currency_id int
Table sale_advance_payment_inv
company_id int
deposit_account_id int
create_uid int
write_uid int
advance_payment_method varchar(255)
fixed_amount decimal(20,6)
deduct_down_payments tinyint
amount double
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_advance_payment id
_inv

Table sale_coupon
* Pk id int
name varchar(255)
code int
program_id int
partner_id int
state varchar(255)
discount_type decimal(20,6)
discount_percentage decimal(20,6)
discount_fixed_amount int
discount_apply_on int
minimum_amount int
expiration_date date
usage_limit int
total_used int
order_ids int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_coupon id

Table sale_coupon_program
* Pk id int
name varchar(255)
active tinyint
code int
type int
promo_applicability int
date_start date
date_end date
discount_type int
discount_percentage decimal(20,6)
discount_fixed_amount int
rule_min_amount int
rule_products_domain int
discount_apply_on int
Table sale_coupon_program
minimum_items int
total_used int
coupon_ids int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_coupon_program id

Table sale_coupon_program_line
* Pk id int
program_id int
sequence int
name varchar(255)
product_id int
product_category_id int
product_tmpl_id int
product_variant_ids int
product_uom_id int
price_discount decimal(20,6)
discount_type int
rule_min_quantity int
rule_min_amount int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_coupon_program_li id
ne

Table sale_order
* Pk id int
campaign_id int
source_id int
medium_id int
message_main_attachment int
_id
company_id int
partner_id int
partner_invoice_id int
partner_shipping_id int
fiscal_position_id int
payment_term_id int
pricelist_id int
currency_id int
user_id int
team_id int
analytic_account_id int
create_uid int
write_uid int
access_token varchar(255)
name varchar(255)
Table sale_order
state varchar(255)
client_order_ref varchar(255)
origin varchar(255)
reference varchar(255)
signed_by varchar(255)
invoice_status varchar(255)
validity_date varchar(255)
note varchar(255)
currency_rate int
amount_untaxed int
amount_tax int
amount_total int
require_signature tinyint
require_payment tinyint
commitment_date date
date_order date
signed_on date
sale_order_template_id date
opportunity_id int
incoterm int
warehouse_id int
procurement_group_id int
incoterm_location varchar(255)
picking_policy varchar(255)
delivery_status varchar(255)
effective_date int
amount_unpaid int
website_id int
shop_warning varchar(255)
cart_recovery_email_sent tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_order id

Table sale_order_line
* Pk id int
order_id int
sequence int
company_id int
currency_id int
order_partner_id int
salesman_id int
product_id int
product_uom int
product_packaging_id int
state varchar(255)
display_type varchar(255)
qty_delivered_method varchar(255)
invoice_status varchar(255)
analytic_distribution varchar(255)
Table sale_order_line
name varchar(255)
product_uom_qty int
price_unit int
discount int
price_reduce int
price_subtotal int
price_total int
price_reduce_taxexcl int
price_reduce_taxinc int
qty_delivered int
qty_invoiced int
qty_to_invoice int
untaxed_amount_invoiced int
untaxed_amount_to_invoice int
is_downpayment tinyint
is_expense tinyint
price_tax double
product_packaging_qty double
customer_lead tinyint
route_id int
linked_line_id int
shop_warning varchar(255)
create_uid int
write_uid int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_order_line id

Table sale_payment_provider_onboarding_wizard
* Pk id int
create_uid int
write_uid int
payment_method varchar(255)
paypal_user_type varchar(255)
paypal_email_account varchar(255)
paypal_seller_account varchar(255)
paypal_pdt_token varchar(255)
manual_name varchar(255)
journal_name varchar(255)
acc_number varchar(255)
manual_post_msg varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_payment_provider_ id
onboarding_wizard

Table sale_promotion
* Pk id int
Table sale_promotion
name varchar(255)
active tinyint
date_start date
date_end date
promo_type int
promo_applicability int
minimum_amount int
discount_type int
discount_percentage decimal(20,6)
discount_fixed_amount int
rule_min_amount int
rule_products_domain int
total_used int
coupon_program_ids int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_promotion id

Table sale_promotion_category
* Pk id int
name varchar(255)
sequence int
parent_id int
child_ids int
active tinyint
description varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_promotion_categor id
y

Table sale_promotion_line
* Pk id int
* promotion_id int
name varchar(255)
sequence int
product_id int
product_category_id int
product_tmpl_id int
product_variant_ids int
product_uom_id int
price_discount decimal(20,6)
discount_type int
rule_min_quantity int
rule_min_amount int
created_at datetime
updated_at datetime
deleted_at datetime
Table sale_promotion_line
Indexes
Pk pk_sale_promotion_line id

Table sale_promotion_rule
* Pk id int
name varchar(255)
sequence int
promotion_id int
discount_type int
discount_percentage decimal(20,6)
discount_fixed_amount int
rule_min_quantity int
rule_min_amount int
rule_products_domain int
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_sale_promotion_rule id

Table seller_rating
* Pk id int
name varchar(255)
rating int
comment varchar(255)
date date
partner_id int
sale_order_id int
state tinyint
published int
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_seller_rating id

Table seller_rating_line
* Pk id int
seller_rating_id int
rating int
comment varchar(255)
date date
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_seller_rating_line id
Table seller_rating_settings
* Pk id int
* company_id int
auto_publish int
publish_mode int
rating_min int
rating_max int
allow_guest int
allow_comment varchar(255)
order_confirmation int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_seller_rating_settings id

Table stock_carrier
* Pk id int
name varchar(255)
code varchar(255)
description varchar(255)
website varchar(255)
Idx stockcarrier_id int
Idx stock_tranking_id int
active tinyint
pricelist_id int
Idx stock_volume_id int
Idx stock_carrier_id int
created_at int
updated_at int
deleted_at int
Indexes
Pk pk_stock_carrier id
FK_stock_carrier_stock_car stockcarrier_id
rier
FK_stock_carrier_stock_shi stock_tranking_id
pment_tracking
FK_stock_carrier_stock_shi stock_volume_id
pment_volume
FK_stock_carrier_stock_shi stock_carrier_id
pment_weight
Foreign Keys
FK_stock_carrier_stock_carrier ( stockcarrier_id )
ref stock_carrier ( id )
FK_stock_carrier_stock_shipment_tracking (
stock_tranking_id ) ref stock_shipment_tracking ( id
)
FK_stock_carrier_stock_shipment_volume (
stock_volume_id ) ref stock_shipment_volume ( id )
FK_stock_carrier_stock_shipment_weight (
stock_carrier_id ) ref stock_shipment_weight ( id )

Table stock_location
* Pk id int
name varchar(255)
Table stock_location
Idx stock_location_id int
Idx stockLocation_id int
Idx stock_volume_id int
Idx stock_trancking_id int
Idx stock_picking_line_id int
code varchar(255)
parent_id int
location_type varchar(255)
description varchar(255)
active tinyint
created_at int
updated_at int
deleted_at int
Indexes
Pk pk_stock_location id
FK_stock_location_stock_lo stockLocation_id
cation
FK_stock_location_stock_pi stock_picking_line_id
cking_line
FK_stock_location_stock_sh stock_trancking_id
ipment_tracking
FK_stock_location_stock_sh stock_volume_id
ipment_volume
FK_stock_location_stock_sh stock_location_id
ipment_weight
Foreign Keys
FK_stock_location_stock_location (
stockLocation_id ) ref stock_location ( id )
FK_stock_location_stock_picking_line (
stock_picking_line_id ) ref stock_picking_line ( id )
FK_stock_location_stock_shipment_tracking (
stock_trancking_id ) ref stock_shipment_tracking (
id )
FK_stock_location_stock_shipment_volume (
stock_volume_id ) ref stock_shipment_volume ( id )
FK_stock_location_stock_shipment_weight (
stock_location_id ) ref stock_shipment_weight ( id )

Table stock_move
* Pk id int
picking_id int
Idx stock_move_id int
product_id int
product_qty float(12,0)
location_id_from int
location_id_to int
state varchar(255)
picking_type_id int
shipment_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_move id
FK_stock_move_stock_mov stock_move_id
e
Table stock_move
Foreign Keys
FK_stock_move_stock_move ( stock_move_id ) ref
stock_move ( id )

Table stock_picking
* Pk id int
message_main_attachment int
_id
Idx stock_picking_id int
backorder_id int
group_id int
location_id int
location_dest_id int
picking_type_id int
partner_id int
company_id int
user_id int
owner_id int
create_uid int
write_uid int
name varchar(255)
origin varchar(255)
move_type varchar(255)
state varchar(255)
priority varchar(255)
note varchar(255)
has_deadline_issue tinyint
printed tinyint
is_locked tinyint
immediate_transfer tinyint
scheduled_date date
date_deadline date
date date
date_done date
sale_id int
pos_session_id int
pos_order_id int
website_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_picking id
FK_stock_picking_order_lin stock_picking_id
e
Foreign Keys
FK_stock_picking_order_line ( stock_picking_id ) ref
order_line ( id )

Table stock_picking_batch
* Pk id int
picking_id int
Idx stockShBatch_id int
Table stock_picking_batch
Idx stock_volume_id int
Idx stock_picking_batch_id int
Idx stock_tranking_id int
name varchar(255)
date_expected int
location_id int
state varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_picking_batch id
FK_stock_picking_batch_st stockShBatch_id
ock_picking_batch
FK_stock_picking_batch_st stock_tranking_id
ock_shipment_tracking
FK_stock_picking_batch_st stock_volume_id
ock_shipment_volume
FK_stock_picking_batch_st stock_picking_batch_i
ock_shipment_weight d
Foreign Keys
FK_stock_picking_batch_stock_picking_batch (
stockShBatch_id ) ref stock_picking_batch ( id )
FK_stock_picking_batch_stock_shipment_tracking (
stock_tranking_id ) ref stock_shipment_tracking ( id
)
FK_stock_picking_batch_stock_shipment_volume (
stock_volume_id ) ref stock_shipment_volume ( id )
FK_stock_picking_batch_stock_shipment_weight (
stock_picking_batch_id ) ref stock_shipment_weight
( id )

Table stock_picking_line
* Pk id int
picking_id int
product_id int
location_id int
Columna 5 int
product_uom_qty int
location_dest_id int
Idx stock_picking_line_id int
lot_id int
serial_number varchar(255)
state tinyint
move_id int
picking_type_id int
Idx package_id int
notes varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_picking_line id
FK_stock_picking_line_choo package_id
se_delivery_package
Table stock_picking_line
FK_stock_picking_line_orde stock_picking_line_id
r_line
Foreign Keys
FK_stock_picking_line_choose_delivery_package (
package_id ) ref choose_delivery_package ( id )
FK_stock_picking_line_order_line (
stock_picking_line_id ) ref order_line ( id )

Table stock_picking_note
* Pk id int
picking_id int
note varchar(255)
Idx stock_picking_note_id int
Idx stock_volume_id int
Idx stockShNote_id int
Idx stock_tranking_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_picking_note id
FK_stock_picking_note_sto stock_picking_note_id
ck_picking_note
FK_stock_picking_note_sto stockShNote_id
ck_picking_note_2
FK_stock_picking_note_sto stock_tranking_id
ck_picking_note_3
FK_stock_picking_note_sto stock_volume_id
ck_shipment_volume
Foreign Keys
FK_stock_picking_note_stock_picking_note (
stock_picking_note_id ) ref stock_picking_note ( id )
FK_stock_picking_note_stock_picking_note_2 (
stockShNote_id ) ref stock_picking_note ( id )
FK_stock_picking_note_stock_picking_note_3 (
stock_tranking_id ) ref stock_picking_note ( id )
FK_stock_picking_note_stock_shipment_volume (
stock_volume_id ) ref stock_shipment_volume ( id )

Table stock_picking_package
* Pk id int
picking_id int
package_type varchar(255)
weight float(12,0)
volume float(12,0)
barcode varchar(255)
tracking_number varchar(255)
state varchar(255)
shipment_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_picking_package id
Table stock_picking_package_line
* Pk id int
picking_id int
package_id int
product_id int
product_uom_qty float(12,0)
product_uom varchar(255)
product_description varchar(255)
product_barcode varchar(255)
state varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_picking_package_ id
line

Table stock_picking_status
* Pk id int
name varchar(255)
code varchar(255)
sequence int
active tinyint
Idx stock_picking_status_id int
Idx stock_volume_id int
Idx stockShStatus_id int
Idx stock_tranking_id int
created_at int
updated_at int
deleted_at int
Indexes
Pk pk_stock_picking_status id
FK_stock_picking_status_st stock_picking_status_i
ock_picking_status d
FK_stock_picking_status_st stockShStatus_id
ock_shipment_return
FK_stock_picking_status_st stock_tranking_id
ock_shipment_tracking
FK_stock_picking_status_st stock_volume_id
ock_shipment_volume
Foreign Keys
FK_stock_picking_status_stock_picking_status (
stock_picking_status_id ) ref stock_picking_status (
id )
FK_stock_picking_status_stock_shipment_return (
stockShStatus_id ) ref stock_shipment_return ( id )
FK_stock_picking_status_stock_shipment_tracking
( stock_tranking_id ) ref stock_shipment_tracking (
id )
FK_stock_picking_status_stock_shipment_volume (
stock_volume_id ) ref stock_shipment_volume ( id )

Table stock_picking_tracking
* Pk id int
picking_id int
carrier_id int
Table stock_picking_tracking
Idx stockShTracking_id int
Idx stock_volume_id int
Idx stock_picking_tracking_id int
Idx stock_picking_id int
stock_tranking_id int
tracking_number varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_picking_tracking id
FK_stock_picking_tracking_ stockShTracking_id
stock_picking_tracking
FK_stock_picking_tracking_ stock_picking_id
stock_shipment_tracking
FK_stock_picking_tracking_ stock_volume_id
stock_shipment_volume
FK_stock_picking_tracking_ stock_picking_tracking
stock_shipment_weight _id
Foreign Keys
FK_stock_picking_tracking_order_line (
stock_picking_id ) ref order_line ( id )
FK_stock_picking_tracking_stock_picking_tracking (
stockShTracking_id ) ref stock_picking_tracking ( id
)
FK_stock_picking_tracking_stock_shipment_trackin
g ( stock_picking_id ) ref stock_shipment_tracking (
id )
FK_stock_picking_tracking_stock_shipment_volum
e ( stock_volume_id ) ref stock_shipment_volume (
id )
FK_stock_picking_tracking_stock_shipment_weight
( stock_picking_tracking_id ) ref
stock_shipment_weight ( id )

Table stock_picking_type
* Pk id int
color int
sequence int
sequence_id int
default_location_src_id int
default_location_dest_id int
return_picking_type_id int
warehouse_id int
reservation_days_before int
reservation_days_before_pri int
ority
create_uid int
write_uid int
sequence_code varchar(255)
code varchar(255)
reservation_method varchar(255)
barcode varchar(255)
create_backorder varchar(255)
name int
show_entire_packs int
Table stock_picking_type
active int
use_create_lots int
use_existing_lots int
print_label int
show_operations int
show_reserved int
auto_show_reception_report int
created_at datetime
updated_at datetime
deleted_at int
Indexes
Pk pk_stock_picking_type id

Table stock_rules_report
* Pk id int
product_id int
product_tmpl_id int
create_uid int
write_uid int
product_has_variants tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_rules_report id

Table stock_shipment_return
* Pk id int
shipment_id int
Idx stock_volume_id int
Idx s_s_return_id int
reason varchar(255)
description varchar(255)
date date
Idx stock_shipment_return_id int
state varchar(255)
Idx stock_shipment_returns_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_shipment_return id
FK_stock_shipment_return_ stock_shipment_retur
order_line n_id
FK_stock_shipment_return_ s_s_return_id
stock_shipment_tracking
FK_stock_shipment_return_ stock_volume_id
stock_shipment_volume
FK_stock_shipment_return_ stock_shipment_retur
stock_shipment_weight ns_id
Foreign Keys
FK_stock_shipment_return_order_line (
stock_shipment_return_id ) ref order_line ( id )
Table stock_shipment_return
FK_stock_shipment_return_stock_shipment_trackin
g ( s_s_return_id ) ref stock_shipment_tracking ( id )
FK_stock_shipment_return_stock_shipment_volum
e ( stock_volume_id ) ref stock_shipment_volume (
id )
FK_stock_shipment_return_stock_shipment_weight
( stock_shipment_returns_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_return_order_line
Idx stock_shipment_return_id int
Idx order_line_id int
Indexes
FK_stock_shipment_return_ order_line_id
order_line_order_line
FK_stock_shipment_return_ stock_shipment_retur
order_line_stock_shipment_ n_id
return
Foreign Keys
FK_stock_shipment_return_order_line_order_line (
order_line_id ) ref order_line ( id )
FK_stock_shipment_return_order_line_stock_shipm
ent_return ( stock_shipment_return_id ) ref
stock_shipment_return ( id )

Table stock_shipment_return_product_template
Idx stock_shipment_return_id int
Idx product_template_id int
Indexes
FK__stock_shipment_return stock_shipment_retur
n_id
FK_stock_shipment_return_ product_template_id
product_template'_products-
template
Foreign Keys
FK_stock_shipment_return_product_template'_prod
ucts-template ( product_template_id ) ref products-
template ( id )
FK__stock_shipment_return (
stock_shipment_return_id ) ref
stock_shipment_return ( id )

Table stock_shipment_return_res_partner
Idx stock_shipment_return_id int
Idx res_partner_id int
Indexes
FK_stock_shipment_return_ res_partner_id
res_partner_res_partner
FK_stock_shipment_return_ stock_shipment_retur
res_partner_stock_shipment n_id
_return
Foreign Keys
FK_stock_shipment_return_res_partner_res_partne
r ( res_partner_id ) ref res_partner ( id )
FK_stock_shipment_return_res_partner_stock_ship
ment_return ( stock_shipment_return_id ) ref
stock_shipment_return ( id )
Table stock_shipment_return_stock_move
Idx stock_shipment_return_id int
Idx stock_move_id int
Indexes
FK_stock_shipment_return_ stock_move_id
stock_move_stock_move
FK_stock_shipment_return_ stock_shipment_retur
stock_move_stock_shipmen n_id
t_return
Foreign Keys
FK_stock_shipment_return_stock_move_stock_mo
ve ( stock_move_id ) ref stock_move ( id )
FK_stock_shipment_return_stock_move_stock_ship
ment_return ( stock_shipment_return_id ) ref
stock_shipment_return ( id )

Table stock_shipment_return_stock_picking
Idx stock_shipment_return_id int
Idx stock_picking_id int
Indexes
FK_stock_shipment_return_ stock_picking_id
stock_picking_stock_picking
FK_stock_shipment_return_ stock_shipment_retur
stock_picking_stock_shipme n_id
nt_return
Foreign Keys
FK_stock_shipment_return_stock_picking_stock_pi
cking ( stock_picking_id ) ref stock_picking ( id )
FK_stock_shipment_return_stock_picking_stock_sh
ipment_return ( stock_shipment_return_id ) ref
stock_shipment_return ( id )

Table stock_shipment_return_stock_picking_line
Idx stock_shipment_return_id int
Idx stock_picking_line_id int
Indexes
FK_stock_shipment_return_ stock_picking_line_id
stock_picking_line_stock_pi
cking_line
FK_stock_shipment_return_ stock_shipment_retur
stock_picking_line_stock_sh n_id
ip_return
Foreign Keys
FK_stock_shipment_return_stock_picking_line_stoc
k_picking_line ( stock_picking_line_id ) ref
stock_picking_line ( id )
FK_stock_shipment_return_stock_picking_line_stoc
k_ship_return ( stock_shipment_return_id ) ref
stock_shipment_return ( id )

Table stock_shipment_return_stock_picking_package
Idx stock_shipment_return_id int
Idx stock_picking_package_id int
Indexes
FK_stock_shipment_return_ stock_picking_packag
stock_picking_package_s_p e_id
_p
Table stock_shipment_return_stock_picking_package
FK_stock_shipment_return_ stock_shipment_retur
stock_picking_package_s_s n_id
_r
Foreign Keys
FK_stock_shipment_return_stock_picking_package
_s_p_p ( stock_picking_package_id ) ref
stock_picking_package ( id )
FK_stock_shipment_return_stock_picking_package
_s_s_r ( stock_shipment_return_id ) ref
stock_shipment_return ( id )

Table stock_shipment_return_stock_picking_package_line
Idx stock_shipment_return_id int
Idx stock_picking_package_Lin int
e_id
Indexes
FK_stock_shipment_return_ stock_picking_packag
stock_picking_package_line e_Line_id
_s_p_p_l
FK_stock_shipment_return_ stock_shipment_retur
stock_picking_package_line n_id
_stock_s_r
Foreign Keys
FK_stock_shipment_return_stock_picking_package
_line_s_p_p_l ( stock_picking_package_Line_id )
ref stock_picking_package_line ( id )
FK_stock_shipment_return_stock_picking_package
_line_stock_s_r ( stock_shipment_return_id ) ref
stock_shipment_return ( id )

Table stock_shipment_return_stock_picking_type
Idx stock_shipment_return_id int
Idx stock_picking_type_id int
Indexes
FK_stock_s_return_stock_pi stock_shipment_retur
cking_type_stock_shipment n_id
_return
FK_stock_shipment_return_ stock_picking_type_id
stock_picking_type_s_pickin
g_type
Foreign Keys
FK_stock_shipment_return_stock_picking_type_s_p
icking_type ( stock_picking_type_id ) ref
stock_picking_type ( id )
FK_stock_s_return_stock_picking_type_stock_ship
ment_return ( stock_shipment_return_id ) ref
stock_shipment_return ( id )

Table stock_shipment_tracking
* Pk id int
shipment_id int
Idx shipmentTracking_id int
Idx stock_shipment_tracking_id int
Idx stock_volume_id int
status varchar(255)
date date
location varchar(255)
Table stock_shipment_tracking
details varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_shipment_tracking id
FK_stock_shipment_trackin shipmentTracking_id
g_stock_shipment_tracking
FK_stock_shipment_trackin stock_volume_id
g_stock_shipment_volume
FK_stock_shipment_trackin stock_shipment_tracki
g_stock_shipment_weight ng_id
Foreign Keys
FK_stock_shipment_tracking_stock_shipment_track
ing ( shipmentTracking_id ) ref
stock_shipment_tracking ( id )
FK_stock_shipment_tracking_stock_shipment_volu
me ( stock_volume_id ) ref stock_shipment_volume
( id )
FK_stock_shipment_tracking_stock_shipment_weig
ht ( stock_shipment_tracking_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_tracking_order_line
Idx stock_shipment_tracking_id int
Idx order_line_id int
Indexes
FK__order_l order_line_id
FK__stock_shipment_t stock_shipment_tracki
ng_id

Table stock_shipment_tracking_product_template
Idx stock_shipment_tracking_id int
Idx product_template_id int
Indexes
FK__products-tpte product_template_id
FK__stock_shipment_ting stock_shipment_tracki
ng_id
Foreign Keys
FK__products-tpte ( product_template_id ) ref
products-template ( id )
FK__stock_shipment_ting (
stock_shipment_tracking_id ) ref
stock_shipment_tracking ( id )

Table stock_shipment_tracking_res_partner
Idx stock_shipment_tracking_id int
Idx res_partner_id int
Indexes
FK_stock_shipment_trackin res_partner_id
g_res_partner_res_partner
FK_stock_shipment_trackin stock_shipment_tracki
g_res_partner_stock_shipm ng_id
ent_tracking
Foreign Keys
Table stock_shipment_tracking_res_partner
FK_stock_shipment_tracking_res_partner_res_part
ner ( res_partner_id ) ref res_partner ( id )
FK_stock_shipment_tracking_res_partner_stock_sh
ipment_tracking ( stock_shipment_tracking_id ) ref
stock_shipment_tracking ( id )

Table stock_shipment_tracking_stock_move
Idx stock_shipment_tracking_id int
Idx stock_move_id int
Indexes
FK__stock_m stock_move_id
FK__stock_shipment_tng stock_shipment_tracki
ng_id
Foreign Keys
FK__stock_m ( stock_move_id ) ref stock_move ( id
)
FK__stock_shipment_tng (
stock_shipment_tracking_id ) ref
stock_shipment_tracking ( id )

Table stock_shipment_tracking_stock_picking
Idx stock_shipment_tracking_id int
Idx stock_picking_id int
Indexes
FK__stock_pking stock_picking_id
FK__stock_shipment_tking stock_shipment_tracki
ng_id
Foreign Keys
FK__stock_pking ( stock_picking_id ) ref
stock_picking ( id )
FK__stock_shipment_tking (
stock_shipment_tracking_id ) ref
stock_shipment_tracking ( id )

Table stock_shipment_tracking_stock_picking_line
Idx stock_shipment_tracking_id int
Idx stock_picking_line_id int
Indexes
FK_stock_shipment_trackin stock_shipment_tracki
g_ment_tracking ng_id
FK_stock_shipment_trackin stock_picking_line_id
g_stock_picking_line
Foreign Keys
FK_stock_shipment_tracking_stock_picking_line (
stock_picking_line_id ) ref stock_picking_line ( id )
FK_stock_shipment_tracking_ment_tracking (
stock_shipment_tracking_id ) ref
stock_shipment_tracking ( id )

Table stock_shipment_tracking_stock_picking_package
Idx stock_shipment_tracking_id int
Idx stock_picking_package_id int
Indexes
FK__s_sh_tracking stock_shipment_tracki
ng_id
Table stock_shipment_tracking_stock_picking_package
FK__stock_p_package stock_picking_packag
e_id
Foreign Keys
FK__stock_p_package ( stock_picking_package_id
) ref stock_picking_package ( id )
FK__s_sh_tracking ( stock_shipment_tracking_id )
ref stock_shipment_tracking ( id )

Table stock_shipment_tracking_stock_picking_package_line
Idx stock_shipment_tracking_id int
Idx stock_picking_package_Lin int
e_id
Indexes
FK_stock_shipment_trackin stock_picking_packag
g_stock_picking_package_li e_Line_id
ne_s_p_p_l
FK_stock_shipment_trackin stock_shipment_tracki
g_stock_picking_package_li ng_id
ne_s_s_t
Foreign Keys
FK_stock_shipment_tracking_stock_picking_packa
ge_line_s_p_p_l ( stock_picking_package_Line_id )
ref stock_picking_package_line ( id )
FK_stock_shipment_tracking_stock_picking_packa
ge_line_s_s_t ( stock_shipment_tracking_id ) ref
stock_shipment_tracking ( id )

Table stock_shipment_tracking_stock_picking_type
Idx stock_shipment_tracking_id int
Idx stock_picking_type_id int
Indexes
FK__stock_picking_t stock_picking_type_id
FK__stock_shipment_t stock_shipment_tracki
ng_id
Foreign Keys
FK__stock_picking_t ( stock_picking_type_id ) ref
stock_picking_type ( id )
FK__stock_shipment_t (
stock_shipment_tracking_id ) ref
stock_shipment_tracking ( id )

Table stock_shipment_volume
* Pk id int
shipment_id int
Idx shipmentVolume_id int
Idx stock_shipment_Volume_id int
Idx stock_volume_id int
Idx s_s_volume_id int
volume float(12,0)
unit varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_shipment_volume id
Table stock_shipment_volume
FK_stock_shipment_volume s_s_volume_id
_stock_shipment_tracking
FK_stock_shipment_volume stock_volume_id
_stock_shipment_volume
FK_stock_shipment_volume shipmentVolume_id
_stock_shipment_volume_2
FK_stock_shipment_volume stock_shipment_Volu
_stock_shipment_weight me_id
Foreign Keys
FK_stock_shipment_volume_stock_shipment_tracki
ng ( s_s_volume_id ) ref stock_shipment_tracking (
id )
FK_stock_shipment_volume_stock_shipment_volu
me ( stock_volume_id ) ref stock_shipment_volume
( id )
FK_stock_shipment_volume_stock_shipment_volu
me_2 ( shipmentVolume_id ) ref
stock_shipment_volume ( id )
FK_stock_shipment_volume_stock_shipment_weig
ht ( stock_shipment_Volume_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_volume_order_line
Idx stock_shipment_volume_id int
Idx order_line_id int
Indexes
FK__order_line order_line_id
FK__stock_shipment_volum stock_shipment_volu
e me_id
Foreign Keys
FK__order_line ( order_line_id ) ref order_line ( id )
FK__stock_shipment_volume (
stock_shipment_volume_id ) ref
stock_shipment_volume ( id )

Table stock_shipment_volume_product_template
Idx stock_shipment_volume_id int
Idx product_template_id int
Indexes
FK__stock_shipment_volum stock_shipment_volu
e_volume me_id
FK_product_template_produ product_template_id
ctsT
Foreign Keys
FK_product_template_productsT (
product_template_id ) ref products-template ( id )
FK__stock_shipment_volume_volume (
stock_shipment_volume_id ) ref
stock_shipment_volume ( id )

Table stock_shipment_volume_res_partner
Idx stock_shipment_volume_id int
Idx res_partner_id int
Indexes
FK_stock_shipment_volume res_partner_id
_res_partner_res_partner
Table stock_shipment_volume_res_partner
FK_stock_shipment_volume stock_shipment_volu
_res_partner_stock_shipme me_id
nt_volume
Foreign Keys
FK_stock_shipment_volume_res_partner_res_partn
er ( res_partner_id ) ref res_partner ( id )
FK_stock_shipment_volume_res_partner_stock_shi
pment_volume ( stock_shipment_volume_id ) ref
stock_shipment_volume ( id )

Table stock_shipment_volume_stock_move
Idx stock_shipment_volume_id int
Idx stock_move_id int
Indexes
FK_stock_shipment_volume stock_shipment_volu
_stock_move_ssv me_id
FK_stock_shipment_volume stock_move_id
_stock_move_stock_move
Foreign Keys
FK_stock_shipment_volume_stock_move_stock_m
ove ( stock_move_id ) ref stock_move ( id )
FK_stock_shipment_volume_stock_move_ssv (
stock_shipment_volume_id ) ref
stock_shipment_volume ( id )

Table stock_shipment_volume_stock_picking
Idx stock_shipment_volume_id int
Idx stock_picking_id int
Indexes
FK__ssvolume stock_shipment_volu
me_id
FK_stock_shipment_volume stock_picking_id
_stock_picking_sp
Foreign Keys
FK_stock_shipment_volume_stock_picking_sp (
stock_picking_id ) ref stock_picking ( id )
FK__ssvolume ( stock_shipment_volume_id ) ref
stock_shipment_volume ( id )

Table stock_shipment_volume_stock_picking_line
Idx stock_shipment_volume_id int
Idx stock_picking_line_id int
Indexes
FK_stock_shipment_volume stock_picking_line_id
_stock_picking_line_s_p_lin
e
FK_stock_shipment_volume stock_shipment_volu
_stock_picking_line_st_volu me_id
me
Foreign Keys
FK_stock_shipment_volume_stock_picking_line_s_
p_line ( stock_picking_line_id ) ref
stock_picking_line ( id )
FK_stock_shipment_volume_stock_picking_line_st_
volume ( stock_shipment_volume_id ) ref
stock_shipment_volume ( id )
Table stock_shipment_volume_stock_picking_package
Idx stock_shipment_volume_id int
Idx stock_picking_package_id int
Indexes
FK__stock_s_volume stock_shipment_volu
me_id
FK_s_ship stock_picking_packag
e_id
Foreign Keys
FK_s_ship ( stock_picking_package_id ) ref
stock_picking_package ( id )
FK__stock_s_volume ( stock_shipment_volume_id )
ref stock_shipment_volume ( id )

Table stock_shipment_volume_stock_picking_package_line
Idx stock_shipment_volume_id int
Idx stock_picking_package_line int
_id
Indexes
FK_s_shipment_volume_sto stock_picking_packag
ck_picking_package_line_s e_line_id
_picking_p_line
FK_stock_shipment_volume stock_shipment_volu
_stock_picking_package_lin me_id
e_ss_volume
Foreign Keys
FK_s_shipment_volume_stock_picking_package_li
ne_s_picking_p_line (
stock_picking_package_line_id ) ref
stock_picking_package_line ( id )
FK_stock_shipment_volume_stock_picking_packag
e_line_ss_volume ( stock_shipment_volume_id ) ref
stock_shipment_volume ( id )

Table stock_shipment_volume_stock_picking_type
Idx stock_shipment_volume_id int
Idx stock_picking_type_id int
Indexes
FK_stock_shipment_volume stock_picking_type_id
_stock_picking_type_s_p_t
FK_stock_shipment_volume stock_shipment_volu
_stock_picking_type_ssv me_id
Foreign Keys
FK_stock_shipment_volume_stock_picking_type_s
_p_t ( stock_picking_type_id ) ref
stock_picking_type ( id )
FK_stock_shipment_volume_stock_picking_type_ss
v ( stock_shipment_volume_id ) ref
stock_shipment_volume ( id )

Table stock_shipment_weight
* Pk id int
shipment_id int
weight varchar(255)
Idx shipmentWeight_id int
Idx stock_volume_id int
Idx s_s_weight_id int
Table stock_shipment_weight
stock_picking_status_id int
unit varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_shipment_weight id
FK_stock_shipment_weight s_s_weight_id
_stock_shipment_tracking
FK_stock_shipment_weight shipmentWeight_id
_stock_shipment_tracking_2
FK_stock_shipment_weight stock_volume_id
_stock_shipment_volume
Foreign Keys
FK_stock_shipment_weight_stock_shipment_tracki
ng ( s_s_weight_id ) ref stock_shipment_tracking (
id )
FK_stock_shipment_weight_stock_shipment_tracki
ng_2 ( shipmentWeight_id ) ref
stock_shipment_tracking ( id )
FK_stock_shipment_weight_stock_shipment_volum
e ( stock_volume_id ) ref stock_shipment_volume (
id )

Table stock_shipment_weight_order_line
Idx order_line_id int
Idx stock_shipment_weight_id int
Indexes
FK_stock_shipment_weight order_line_id
_order_line_order_line
FK_stock_shipment_weight stock_shipment_weig
_order_line_stock_shipment ht_id
_weight
Foreign Keys
FK_stock_shipment_weight_order_line_order_line (
order_line_id ) ref order_line ( id )
FK_stock_shipment_weight_order_line_stock_ship
ment_weight ( stock_shipment_weight_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_weight_product_template
Idx stock_shipment_weight_id int
Idx product_template_id int
Indexes
FK__stock_shipment_weigh stock_shipment_weig
t ht_id
FK_stock_shipment_weight product_template_id
_product_template_products
-template
Foreign Keys
FK_stock_shipment_weight_product_template_prod
ucts-template ( product_template_id ) ref products-
template ( id )
FK__stock_shipment_weight (
stock_shipment_weight_id ) ref
stock_shipment_weight ( id )
Table stock_shipment_weight_res_partner
* Idx stock_shipment_weight_id int
* Idx res_partner_id int
Indexes
FK_stock_shipment_weight res_partner_id
_res_partner_res_partner
FK_stock_shipment_weight stock_shipment_weig
_res_partner_stock_shipme ht_id
nt_weight
Foreign Keys
FK_stock_shipment_weight_res_partner_res_partn
er ( res_partner_id ) ref res_partner ( id )
FK_stock_shipment_weight_res_partner_stock_shi
pment_weight ( stock_shipment_weight_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_weight_stock_move
Idx stock_shipment_weight_id int
Idx stock_move_id int
Indexes
FK__stock_move stock_move_id
FK_s_shipment_weight_sto stock_shipment_weig
ck_move_s_shipment_weig ht_id
ht
Foreign Keys
FK__stock_move ( stock_move_id ) ref stock_move
( id )
FK_s_shipment_weight_stock_move_s_shipment_
weight ( stock_shipment_weight_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_weight_stock_picking
Idx stock_shipment_weight_id int
Idx stock_picking_id int
Indexes
FK_s_shipment_weight_sto stock_shipment_weig
ck_picking_s_shipment_wei ht_id
ght
FK_stock_shipment_weight stock_picking_id
_stock_picking_stock_pickin
g
Foreign Keys
FK_stock_shipment_weight_stock_picking_stock_pi
cking ( stock_picking_id ) ref stock_picking ( id )
FK_s_shipment_weight_stock_picking_s_shipment
_weight ( stock_shipment_weight_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_weight_stock_picking_line
* Idx stock_shipment_weight_id int
* Idx stock_picking_line_id int
Indexes
FK_s_shipment_weight_s_p stock_picking_line_id
icking_line_stock_picking_li
ne
FK_s_shipment_weight_s_p stock_shipment_weig
icking_line_stock_shipment ht_id
_weight
Table stock_shipment_weight_stock_picking_line
Foreign Keys
FK_s_shipment_weight_s_picking_line_stock_picki
ng_line ( stock_picking_line_id ) ref
stock_picking_line ( id )
FK_s_shipment_weight_s_picking_line_stock_ship
ment_weight ( stock_shipment_weight_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_weight_stock_picking_package
Idx stock_shipment_weight_id int
Idx stock_picking_package_id int
Indexes
FK__s_shipment_weight_s_ stock_shipment_weig
picking_package ht_id
FK__stock_picking_packag stock_picking_packag
e e_id
Foreign Keys
FK__stock_picking_package (
stock_picking_package_id ) ref
stock_picking_package ( id )
FK__s_shipment_weight_s_picking_package (
stock_shipment_weight_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_weight_stock_picking_package_line
Idx stock_shipment_weight_id int
Idx stock_picking_package_line int
_id
Indexes
FK_s_shipment_weight_s_p stock_picking_packag
icking_package_line e_line_id
FK_stock_shipment_weight stock_shipment_weig
_stock_picking_package_lin ht_id
e
Foreign Keys
FK_s_shipment_weight_s_picking_package_line (
stock_picking_package_line_id ) ref
stock_picking_package_line ( id )
FK_stock_shipment_weight_stock_picking_package
_line ( stock_shipment_weight_id ) ref
stock_shipment_weight ( id )

Table stock_shipment_weight_stock_picking_type
Idx stock_shipment_weight_id int
Idx stock_picking_type_id int
Indexes
FK__stock_picking_type stock_picking_type_id
FK_s_shipment_weight_s_s stock_shipment_weig
hipment_weight ht_id
Foreign Keys
FK__stock_picking_type ( stock_picking_type_id )
ref stock_picking_type ( id )
FK_s_shipment_weight_s_shipment_weight (
stock_shipment_weight_id ) ref
stock_shipment_weight ( id )
Table stock_storage_category
* Pk id int
company_id int
create_uid int
write_uid int
name varchar(255)
allow_new_product varchar(255)
max_weight decimal(20,6)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_storage_category id

Table stock_storage_category_capacity
* Pk id int
storage_category_id int
product_id int
package_type_id int
create_uid int
write_uid int
quantity int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_storage_category id
_capacity

Table stock_warehouse
* Pk id int
name varchar(50)
code varchar(50)
partner_id int
company_id int
Idx stock_picking_line_id int
Idx stock_tranking_id int
active tinyint
street varchar(255)
city varchar(255)
state_id int
country_id int
zip varchar(255)
phone varchar(255)
fax varchar(255)
email varchar(255)
website varchar(255)
warehouse_type varchar(255)
account_picking_id int
account_picking_out_id int
account_picking_in_id int
Idx stock_warehouse_id int
Idx stock_volume_id int
Table stock_warehouse
Idx warehouse_id int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_stock_warehouse id
FK_stock_warehouse_stock stock_picking_line_id
_picking_line
FK_stock_warehouse_stock stock_tranking_id
_shipment_tracking
FK_stock_warehouse_stock stock_volume_id
_shipment_volume
FK_stock_warehouse_stock stock_warehouse_id
_shipment_weight
FK_stock_warehouse_stock warehouse_id
_warehouse
Foreign Keys
FK_stock_warehouse_stock_picking_line (
stock_picking_line_id ) ref stock_picking_line ( id )
FK_stock_warehouse_stock_shipment_tracking (
stock_tranking_id ) ref stock_shipment_tracking ( id
)
FK_stock_warehouse_stock_shipment_volume (
stock_volume_id ) ref stock_shipment_volume ( id )
FK_stock_warehouse_stock_shipment_weight (
stock_warehouse_id ) ref stock_shipment_weight (
id )
FK_stock_warehouse_stock_warehouse (
warehouse_id ) ref stock_warehouse ( id )

Table uom_category
* Pk id int
create_uid int
write_uid int
name varchar(255)
is_pos_groupable tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_uom_category id

Table video_stream
* Pk id int
name varchar(255)
description varchar(255)
duration float(12,0)
format varchar(255)
size varchar(255)
channel_id int
category_id int
tag_ids int
published_on date
active tinyint
created_at datetime
Table video_stream
updated_at datetime
deleted_at datetime
Indexes
Pk pk_video_stream id

Table video_stream_category
* Pk id int
name varchar(255)
description varchar(255)
active tinyint
icon varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_video_stream_category id

Table video_stream_channel
* Pk id int
name varchar(255)
description varchar(255)
owner_id int
category_id int
tag_ids int
published_on date
active tinyint
icon varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_video_stream_channel id

Table video_stream_playlist
* Pk id int
name varchar(255)
description varchar(255)
video_stream_ids float(12,0)
active tinyint
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_video_stream_playlist id

Table video_stream_tag
* Pk id int
name varchar(255)
description varchar(255)
active int
Table video_stream_tag
color varchar(255)
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_video_stream_tag id

Table video_stream_view
* Pk id int
video_stream_id int
user_id int
view_date date
view_duration int
created_at datetime
updated_at datetime
deleted_at datetime
Indexes
Pk pk_video_stream_view id