Answer the question
In order to leave comments, you need to log in
Is the database normalized?
Good day. Experts prompt the DB is how much normalized. What do you think could be changed?
CREATE TABLE `site_catalog_items` (
`id` INT(30) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'уникальный номер ',
`thumbnail` VARCHAR(255) NOT NULL DEFAULT '/content/images/default_thumb.png' COMMENT 'миниатюра',
`image` VARCHAR(255) NOT NULL DEFAULT '/content/images/ .png' COMMENT 'фото',
`category` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'категория',
`material` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'материал',
`region` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'район',
`district` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'населенный пункт',
`town` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'город',
`digging` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'раскоп',
`layer` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'слой',
`square` VARCHAR(10) NOT NULL DEFAULT '' COMMENT 'квадрат',
`fieldNumber` VARCHAR(30) NOT NULL DEFAULT '' COMMENT 'полевой номер',
`area` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'участок',
`homestead` VARCHAR(20) NULL DEFAULT '' COMMENT 'усадьба',
`gps` VARCHAR(30) NULL DEFAULT '' COMMENT 'координаты позитирования',
`year` YEAR NOT NULL DEFAULT '2013' COMMENT 'год',
`title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'наименование ',
`description` MEDIUMTEXT NULL COMMENT 'описание ',
`dating` VARCHAR(20) NULL DEFAULT '' COMMENT 'датировка',
`storagePlace` VARCHAR(20) NOT NULL DEFAULT '' COMMENT 'место хранения',
`notes` MEDIUMTEXT NULL COMMENT 'блокнот',
PRIMARY KEY (`id`),
INDEX `cost` (`title`),
INDEX `category_realm` (`category`, `material`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=8;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question