sk_room_charge_hours.md

sk_room_charge_hours

Description

時刻毎の部屋利用料金

Table Definition

CREATE TABLE `sk_room_charge_hours` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `room_id` int(11) unsigned NOT NULL,
  `hour` time NOT NULL DEFAULT '00:00:00' COMMENT '時刻',
  `price` int(11) NOT NULL DEFAULT '0' COMMENT '値段',
  PRIMARY KEY (`id`),
  KEY `sk_relation_room_charge_hours_and_rooms` (`room_id`),
  CONSTRAINT `sk_relation_room_charge_hours_and_rooms` FOREIGN KEY (`room_id`) REFERENCES `sk_rooms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=[Redacted by tbls] DEFAULT CHARSET=utf8 COMMENT='時刻毎の部屋利用料金'

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
id	int(11) unsigned		false	auto_increment			id
room_id	int(11) unsigned		false			sk_rooms
hour	time	00:00:00	false				時刻
price	int(11)	0	false				値段

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)
sk_relation_room_charge_hours_and_rooms	FOREIGN KEY	FOREIGN KEY (room_id) REFERENCES sk_rooms (id)

Indexes

Name	Definition
sk_relation_room_charge_hours_and_rooms	KEY sk_relation_room_charge_hours_and_rooms (room_id) USING BTREE
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

---

Generated by tbls