sk_property_images.md

sk_property_images

Description

物件画像

Table Definition

CREATE TABLE `sk_property_images` (
  `id` bigint(21) unsigned NOT NULL AUTO_INCREMENT COMMENT '物件画像ID',
  `property_id` int(11) unsigned NOT NULL COMMENT '物件ID',
  `image` varchar(1000) NOT NULL DEFAULT '' COMMENT '画像パス',
  `sort_order` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT 'ソート順',
  PRIMARY KEY (`id`),
  KEY `sk_relation_property_images_and_properties` (`property_id`),
  CONSTRAINT `sk_relation_property_images_and_properties` FOREIGN KEY (`property_id`) REFERENCES `sk_properties` (`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	bigint(21) unsigned		false	auto_increment			物件画像ID
property_id	int(11) unsigned		false			sk_properties	物件ID
image	varchar(1000)		false				画像パス
sort_order	smallint(6) unsigned	0	false				ソート順

Constraints

Name	Type	Definition
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)
sk_relation_property_images_and_properties	FOREIGN KEY	FOREIGN KEY (property_id) REFERENCES sk_properties (id)

Indexes

Name	Definition
sk_relation_property_images_and_properties	KEY sk_relation_property_images_and_properties (property_id) USING BTREE
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

---

Generated by tbls