Company

Tables (13)

authorization_role (12)

  • rolde_id (Key) — Primary key — NOT NULL
  • parent_id (Field)
  • tree_level (Field2)
  • role_type (Field3)
  • user_id (Field4)
  • user_type (Field5)
  • role-name (Field6)
  • role_scope (Field7)

company_customer (10)

  • customer_entity_id (Key4) — Foreign key → customer_entity.entity_id — NOT NULL
  • company_entity_id (Key) — Foreign key → company_entity.entity_id — NOT NULL
  • rolde_id (Key3) — Foreign key → authorization_role.rolde_id — NOT NULL

company_eav_attribte (2)

  • attribute_id (Key2) — Foreign key → eav_attribute.attribute_id — NOT NULL
  • is_visible (Field)
  • is_used_in_grid (Field2)
  • is_visible_in_grid (Field3)
  • validate_rules (Field4)

company_entity (11)

  • entity_id (Key) — Primary key — NOT NULL
  • website_id (Field)
  • created_at (Field2)
  • updated_at (Field3)

company_entity_datetime (7)

  • value_id (Key) — Primary key — NOT NULL
  • attribute_id (Key4) — Foreign key → eav_attribute.attribute_id — NOT NULL
  • entity_id (Key3) — Foreign key → company_entity.entity_id — NOT NULL
  • value (Field3)

company_entity_decimal (8)

  • value_id (Key) — Primary key — NOT NULL
  • attribute_id (Key4) — Foreign key → eav_attribute.attribute_id — NOT NULL
  • entity_id (Key3) — Foreign key → company_entity.entity_id — NOT NULL
  • value (Field3)

company_entity_int (6)

  • value_id (Key) — Primary key — NOT NULL
  • attribute_id (Key4) — Foreign key → eav_attribute.attribute_id — NOT NULL
  • entity_id (Key3) — Foreign key → company_entity.entity_id — NOT NULL
  • value (Field3)

company_entity_text (4)

  • value_id (Key) — Primary key — NOT NULL
  • attribute_id (Key4) — Foreign key → eav_attribute.attribute_id — NOT NULL
  • entity_id (Key3) — Foreign key → company_entity.entity_id — NOT NULL
  • value (Field3)

company_entity_varchar (5)

  • value_id (Key) — Primary key — NOT NULL
  • attribute_id (Key4) — Foreign key → eav_attribute.attribute_id — NOT NULL
  • entity_id (Key3) — Foreign key → company_entity.entity_id — NOT NULL
  • value (Field3)

customer_address_entity (13)

  • entity_id (Key) — Primary key — NOT NULL
  • company_entity_id (Key2) — Foreign key → company_entity.entity_id — NOT NULL
  • parent_id (Field)
  • country_id (Field2)
  • fax (Field3)
  • post_code (Field4)
  • street (Field5)

customer_entity (9)

  • entity_id (Key) — Primary key — NOT NULL
  • email (Field)
  • group_id (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • middle_name (Field5)

eav_attribute (3)

  • attribute_id (Key) — Primary key — NOT NULL
  • entity_type_id (Key2) — Foreign key → eav_entity_type.entity_type_id — NOT NULL
  • attribute_code (Field2)

eav_entity_type (1)

  • entity_type_id (Key) — Primary key — NOT NULL
  • entity_type_code (Field)
  • entity_model (Field2)
  • attribute_model (Field3)
  • entity_table (Field4)