mt_objectscore

機能

調査中


CreateTable

CREATE TABLE `mt_objectscore` (
	`objectscore_id` INT(11) NOT NULL AUTO_INCREMENT,
	`objectscore_author_id` INT(11) NULL DEFAULT '0',
	`objectscore_created_by` INT(11) NULL DEFAULT NULL,
	`objectscore_created_on` DATETIME NULL DEFAULT NULL,
	`objectscore_ip` VARCHAR(50) NULL DEFAULT NULL,
	`objectscore_modified_by` INT(11) NULL DEFAULT NULL,
	`objectscore_modified_on` DATETIME NULL DEFAULT NULL,
	`objectscore_namespace` VARCHAR(100) NOT NULL,
	`objectscore_object_ds` VARCHAR(50) NOT NULL,
	`objectscore_object_id` INT(11) NULL DEFAULT '0',
	`objectscore_score` FLOAT NULL DEFAULT NULL,
	PRIMARY KEY (`objectscore_id`),
	INDEX `mt_objectscore_ns_ip_ds_obj` (`objectscore_namespace`, `objectscore_ip`, `objectscore_object_ds`, `objectscore_object_id`),
	INDEX `mt_objectscore_ds_obj` (`objectscore_object_ds`, `objectscore_object_id`),
	INDEX `mt_objectscore_ns_user_ds_obj` (`objectscore_namespace`, `objectscore_author_id`, `objectscore_object_ds`, `objectscore_object_id`),
	INDEX `mt_objectscore_user_ns` (`objectscore_author_id`, `objectscore_namespace`)
)
 
 

一覧

調査中


関連テーブル

調査中



最終更新:2012年01月28日 05:35