建表语句:
create table rental(
...
primary key (rental_id),
unique key rental_date(rental_date,inventory_id,customer_id),
key idx_fk_inventory_id(inventory_id),
key idx_fk_customer_id(costmer_id),
...
)
建表语句:
create table rental(
...
primary key (rental_id),
unique key rental_date(rental_date,inventory_id,customer_id),
key idx_fk_inventory_id(inventory_id),
key idx_fk_customer_id(costmer_id),
...
)