mysql多个主键约束_具有多个主键复合约束的mysql表

有两种看待这种方式的方法......你提到的独特约束是否相互排斥？意思是，一个人可以不存在吗？

逻辑规定，无论客户如何，房间都可以一次预订一天。除非多个客户可以共享同一个房间。所以我会给你两个选择。

# If room can be booked to multiple clients

CREATE TABLE `reservation` (

`id` int(11) unsigned not null auto_increment,

`day` varchar(25) not null,

`room` int(5) unsigned not null,

`id_client` int(11) unsigned not null,

PRIMARY KEY (`id`),

UNIQUE KEY (`room`, `day`),

UNIQUE KEY (`room`, `id_client`),

)ENGINE=InnoDB DEFAULT CHARSET=utf8;

# Room can only be booked to one client for a given day

CREATE TABLE `reservation` (

`id` int(11) unsigned not null auto_increment,

`day` varchar(25) not null,

`room` int(5) unsigned not null,

`id_client` int(11) unsigned not null,

PRIMARY KEY (`id`),

UNIQUE KEY (`room`, `day`)

)ENGINE=InnoDB DEFAULT CHARSET=utf8;此外，我会使用单独的主键列，否则您的更新将更复杂，例如：

UPDATE `reservation` SET `other_stuff` = 'some value' WHERE `day` = 'Friday' AND `room` = 123;

# Vs

UPDATE `reservation` SET `other_stuff` = 'some value' WHERE `id` = 1;