Compalex.net

Profits [PRIMARY]

Profits [PRIMARY] ¹

• id (1)

abilities [PRIMARY] ¹

• id (1)

abilities [PRIMARY]

abilities [abilities_scope_index] ¹

• scope (1)

abilities [abilities_scope_index]

accountpayables [PRIMARY]

accountpayables [PRIMARY] ¹

• id (1)

accountreceivable [PRIMARY]

accountreceivable [PRIMARY] ¹

• id (1)

assigned_roles [PRIMARY] ¹

• id (1)

assigned_roles [PRIMARY]

assigned_roles [assigned_roles_entity_index] ³

• entity_id (1)
• entity_type (2)
• scope (3)

assigned_roles [assigned_roles_entity_index]

assigned_roles [assigned_roles_role_id_index] ¹

• role_id (1)

assigned_roles [assigned_roles_role_id_index]

assigned_roles [assigned_roles_scope_index] ¹

• scope (1)

assigned_roles [assigned_roles_scope_index]

bank [PRIMARY]

bank [PRIMARY] ¹

• id (1)

classification [PRIMARY] ¹

• id (1)

classification [PRIMARY] ¹

• id (1)

clients [PRIMARY] ¹

• id (1)

clients [PRIMARY] ¹

• id (1)

combos [PRIMARY] ¹

• id (1)

combos [PRIMARY] ¹

• id (1)

combosdetails [PRIMARY] ¹

• id (1)

combosdetails [PRIMARY] ¹

• id (1)

condiciones_pagos [PRIMARY] ¹

• id (1)

condiciones_pagos [PRIMARY] ¹

• id (1)

costlists [PRIMARY] ¹

• id (1)

costlists [PRIMARY] ¹

• id (1)

costlistsdetails [PRIMARY] ¹

• id (1)

costlistsdetails [PRIMARY] ¹

• id (1)

departments [PRIMARY] ¹

• id (1)

departments [PRIMARY] ¹

• id (1)

estatus_comprobantes [PRIMARY] ¹

• id (1)

estatus_comprobantes [PRIMARY] ¹

• id (1)

estatus_egresos [PRIMARY] ¹

• id (1)

estatus_egresos [PRIMARY] ¹

• id (1)

expenses [PRIMARY] ¹

• id (1)

expenses [PRIMARY] ¹

• id (1)

failed_jobs [PRIMARY]

failed_jobs [PRIMARY] ¹

• id (1)

inbounds [PRIMARY]

inbounds [PRIMARY] ¹

• id (1)

inboundsdetails [PRIMARY]

inboundsdetails [PRIMARY] ¹

• id (1)

inboundtypes [PRIMARY]

inboundtypes [PRIMARY] ¹

• id (1)

inventory [PRIMARY] ¹

• id (1)

inventory [PRIMARY] ¹

• id (1)

inventory [product_id_warehouse_id] ²

• product_id (1)
• warehouse_id (2)

inventory [product_id_warehouse_id]

inventorykardex [PRIMARY] ¹

• id (1)

inventorykardex [PRIMARY] ¹

• id (1)

migrations [PRIMARY] ¹

• id (1)

migrations [PRIMARY] ¹

• id (1)

model_has_permissions [PRIMARY]

model_has_permissions [PRIMARY] ³

• permission_id (1)
• model_id (2)
• model_type (3)

model_has_permissions [model_has_permissions_model_id_model_type_index]

model_has_permissions [model_has_permissions_model_id_model_type_index] ²

• model_id (1)
• model_type (2)

model_has_roles [PRIMARY]

model_has_roles [PRIMARY] ³

• role_id (1)
• model_id (2)
• model_type (3)

model_has_roles [model_has_roles_model_id_model_type_index]

model_has_roles [model_has_roles_model_id_model_type_index] ²

• model_id (1)
• model_type (2)

order_invoice [PRIMARY] ¹

• id (1)

order_invoice [PRIMARY] ¹

• id (1)

order_phase [PRIMARY] ¹

• id (1)

order_phase [PRIMARY] ¹

• id (1)

order_remision [PRIMARY] ¹

• id (1)

order_remision [PRIMARY] ¹

• id (1)

ordercomments [PRIMARY] ¹

• id (1)

ordercomments [PRIMARY] ¹

• id (1)

orderdetails [PRIMARY] ¹

• id (1)

orderdetails [PRIMARY] ¹

• id (1)

orders [PRIMARY] ¹

• id (1)

orders [PRIMARY] ¹

• id (1)

orderstatus [PRIMARY] ¹

• id (1)

orderstatus [PRIMARY] ¹

• id (1)

outbounddestinations [PRIMARY]

outbounddestinations [PRIMARY] ¹

• id (1)

outbounds [PRIMARY]

outbounds [PRIMARY] ¹

• id (1)

outboundsdetails [PRIMARY]

outboundsdetails [PRIMARY] ¹

• id (1)

outboundtypes [PRIMARY]

outboundtypes [PRIMARY] ¹

• id (1)

password_resets [password_resets_email_index] ¹

• email (1)

password_resets [password_resets_email_index] ¹

• email (1)

permissions [PRIMARY] ¹

• id (1)

permissions [PRIMARY] ¹

• id (1)

permissions [permissions_ability_id_index] ¹

• ability_id (1)

permissions [permissions_ability_id_index]

permissions [permissions_entity_index] ³

• entity_id (1)
• entity_type (2)
• scope (3)

permissions [permissions_entity_index]

permissions [permissions_name_guard_name_unique]

permissions [permissions_name_guard_name_unique] ²

• name (1)
• guard_name (2)

permissions [permissions_scope_index] ¹

• scope (1)

permissions [permissions_scope_index]

pricelistdetails [PRIMARY] ¹

• id (1)

pricelistdetails [PRIMARY] ¹

• id (1)

pricelists [PRIMARY] ¹

• id (1)

pricelists [PRIMARY] ¹

• id (1)

prod_cat [PRIMARY] ¹

• Id (1)

prod_cat [PRIMARY] ¹

• Id (1)

productbrands [PRIMARY]

productbrands [PRIMARY] ¹

• id (1)

productcategories [PRIMARY]

productcategories [PRIMARY] ¹

• id (1)

productclassifications [PRIMARY]

productclassifications [PRIMARY] ¹

• id (1)

productlines [PRIMARY] ¹

• id (1)

productlines [PRIMARY] ¹

• id (1)

products [PRIMARY] ¹

• id (1)

products [PRIMARY] ¹

• id (1)

products [code] ¹

• code (1)

products [code]

productsubcategories [PRIMARY]

productsubcategories [PRIMARY] ¹

• id (1)

profits [PRIMARY]

profits [PRIMARY] ¹

• id (1)

purchaseorders [PRIMARY] ¹

• id (1)

purchaseorders [PRIMARY] ¹

• id (1)

purchaseordersdetails [PRIMARY] ¹

• id (1)

purchaseordersdetails [PRIMARY] ¹

• id (1)

returns [PRIMARY] ¹

• id (1)

returns [PRIMARY] ¹

• id (1)

returnsdetails [PRIMARY] ¹

• id (1)

returnsdetails [PRIMARY] ¹

• id (1)

returntypes [PRIMARY] ¹

• id (1)

returntypes [PRIMARY] ¹

• id (1)

role_has_permissions [PRIMARY]

role_has_permissions [PRIMARY] ²

• permission_id (1)
• role_id (2)

role_has_permissions [role_has_permissions_role_id_foreign]

role_has_permissions [role_has_permissions_role_id_foreign] ¹

• role_id (1)

roles [PRIMARY] ¹

• id (1)

roles [PRIMARY] ¹

• id (1)

roles [roles_name_guard_name_unique]

roles [roles_name_guard_name_unique] ²

• name (1)
• guard_name (2)

roles [roles_name_unique] ²

• name (1)
• scope (2)

roles [roles_name_unique]

roles [roles_scope_index] ¹

• scope (1)

roles [roles_scope_index]

suppliers [PRIMARY] ¹

• id (1)

suppliers [PRIMARY] ¹

• id (1)

units [PRIMARY] ¹

• id (1)

units [PRIMARY] ¹

• id (1)

users [PRIMARY] ¹

• id (1)

users [PRIMARY] ¹

• id (1)

users [api_token] ¹

• api_token (1)

users [api_token]

users [users_api_token_unique]

users [users_api_token_unique] ¹

• api_token (1)

users [users_email_unique] ¹

• email (1)

users [users_email_unique] ¹

• email (1)

warehouses [PRIMARY] ¹

• id (1)

warehouses [PRIMARY] ¹

• id (1)

workflow_phase [PRIMARY] ¹

• id (1)

workflow_phase [PRIMARY] ¹

• id (1)