store

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
store_id TINYINT UNSIGNED 3 √ null
customer.store_id fk_customer_storeR
inventory.store_id fk_inventory_storeR
staff.store_id fk_staff_storeR
manager_staff_id TINYINT UNSIGNED 3 null
staff.staff_id fk_store_staffR
address_id SMALLINT UNSIGNED 5 null
address.address_id fk_store_addressR
last_update TIMESTAMP 26 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc store_id
idx_fk_address_id Performance Asc address_id
idx_unique_manager Must be unique Asc manager_staff_id

Relationships

Close relationships within degrees of separation