sk_room_charge_early_days.md

sk_room_charge_early_days

Description

直前の日の部屋利用料金

Table Definition

CREATE TABLE `sk_room_charge_early_days` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `room_id` int(11) unsigned NOT NULL,
  `early_day` smallint(6) NOT NULL DEFAULT '0' COMMENT '何日前か　0:当日、1:1日前、..',
  `price` int(11) NOT NULL DEFAULT '0' COMMENT '値段',
  PRIMARY KEY (`id`),
  KEY `sk_relation_room_charge_early_days_and_rooms` (`room_id`),
  CONSTRAINT `sk_relation_room_charge_early_days_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
early_day	smallint(6)	0	false				何日前か　0:当日、1:1日前、..
price	int(11)	0	false				値段

Constraints

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

Indexes

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

Relations

---

Generated by tbls