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)