Compalex

Database schema compare tool

tables views procedures functions indexes triggers  all changed

compalex_dev

localhost/compalex_dev

compalex_prod

localhost/compalex_prod

actor [PRIMARY] 1

  • actor_id (1)

actor [PRIMARY] 1

  • actor_id (1)

actor [idx_actor_last_name] 1

  • last_name (1)

actor [idx_actor_last_name] 1

  • last_name (1)

address [PRIMARY] 1

  • address_id (1)

address [PRIMARY] 1

  • address_id (1)

address [idx_fk_city_id] 1

  • city_id (1)

address [idx_fk_city_id] 1

  • city_id (1)

category [PRIMARY] 1

  • category_id (1)

category [PRIMARY] 1

  • category_id (1)

city [PRIMARY] 1

  • city_id (1)

city [PRIMARY] 1

  • city_id (1)

city [idx_fk_country_id] 1

  • country_id (1)

city [idx_fk_country_id] 1

  • country_id (1)

country [PRIMARY] 1

  • country_id (1)

country [PRIMARY] 1

  • country_id (1)

customer [PRIMARY] 1

  • customer_id (1)

customer [PRIMARY] 1

  • customer_id (1)

customer [idx_fk_address_id] 0

customer [idx_fk_address_id] 1

  • address_id (1)

customer [idx_fk_store_id] 1

  • store_id (1)

customer [idx_fk_store_id] 1

  • store_id (1)

customer [idx_last_name] 0

customer [idx_last_name] 1

  • last_name (1)

film [PRIMARY] 1

  • film_id (1)

film [PRIMARY] 1

  • film_id (1)

film [idx_fk_language_id] 1

  • language_id (1)

film [idx_fk_language_id] 1

  • language_id (1)

film [idx_fk_original_language_id] 1

  • original_language_id (1)

film [idx_fk_original_language_id] 1

  • original_language_id (1)

film [idx_title] 1

  • title (1)

film [idx_title] 1

  • title (1)

film_actor [PRIMARY] 2

  • actor_id (1)
  • film_id (2)

film_actor [PRIMARY] 2

  • actor_id (1)
  • film_id (2)

film_actor [idx_fk_film_id] 1

  • film_id (1)

film_actor [idx_fk_film_id] 1

  • film_id (1)

film_category [PRIMARY] 2

  • film_id (1)
  • category_id (2)

film_category [PRIMARY] 2

  • film_id (1)
  • category_id (2)

film_category [fk_film_category_category] 1

  • category_id (1)

film_category [fk_film_category_category] 1

  • category_id (1)

film_text [PRIMARY] 1

  • film_id (1)

film_text [PRIMARY] 0

film_text [idx_title_description] 2

  • title (1)
  • description (2)

film_text [idx_title_description] 0

inventory [PRIMARY] 1

  • inventory_id (1)

inventory [PRIMARY] 1

  • inventory_id (1)

inventory [idx_fk_film_id] 1

  • film_id (1)

inventory [idx_fk_film_id] 1

  • film_id (1)

inventory [idx_store_id_film_id] 2

  • store_id (1)
  • film_id (2)

inventory [idx_store_id_film_id] 2

  • store_id (1)
  • film_id (2)

language [PRIMARY] 1

  • language_id (1)

language [PRIMARY] 1

  • language_id (1)

payment [PRIMARY] 1

  • payment_id (1)

payment [PRIMARY] 1

  • payment_id (1)

payment [fk_payment_rental] 1

  • rental_id (1)

payment [fk_payment_rental] 1

  • rental_id (1)

payment [idx_fk_customer_id] 1

  • customer_id (1)

payment [idx_fk_customer_id] 0

payment [idx_fk_staff_id] 1

  • staff_id (1)

payment [idx_fk_staff_id] 1

  • staff_id (1)

rental [PRIMARY] 1

  • rental_id (1)

rental [PRIMARY] 1

  • rental_id (1)

rental [idx_fk_customer_id] 1

  • customer_id (1)

rental [idx_fk_customer_id] 1

  • customer_id (1)

rental [idx_fk_inventory_id] 1

  • inventory_id (1)

rental [idx_fk_inventory_id] 1

  • inventory_id (1)

rental [idx_fk_staff_id] 1

  • staff_id (1)

rental [idx_fk_staff_id] 1

  • staff_id (1)

rental [rental_date] 3

  • rental_date (1)
  • inventory_id (2)
  • customer_id (3)

rental [rental_date] 3

  • rental_date (1)
  • inventory_id (2)
  • customer_id (3)

staff [PRIMARY] 1

  • staff_id (1)

staff [PRIMARY] 1

  • staff_id (1)

staff [idx_fk_address_id] 1

  • address_id (1)

staff [idx_fk_address_id] 1

  • address_id (1)

staff [idx_fk_store_id] 1

  • store_id (1)

staff [idx_fk_store_id] 1

  • store_id (1)

store [PRIMARY] 1

  • store_id (1)

store [PRIMARY] 1

  • store_id (1)

store [idx_fk_address_id] 1

  • address_id (1)

store [idx_fk_address_id] 1

  • address_id (1)

store [idx_unique_manager] 1

  • manager_staff_id (1)

store [idx_unique_manager] 1

  • manager_staff_id (1)