| |id | +-> |product_id | |
| |price | | |attribute_key_id | o---------------1:n---------------+
| |quantity | | |attribute_value |
| |... | | +--------------------------+
+-o|category_id | |
|attr_group_id| <--1:n--o
+-------------+
+--------------------------------------------------+
| product_attribute_key |
+--------------------------------------------------+
| 1 | color | list | red,green,blue |
| 2 | sex | bool | Female,Male |
| 3 | qty | input| '' |
+--------------------------------------------------+
国际化语言表
+-----------+ +---------------+
| category | .---+ | category_lang |
|-----------| / | +---------------+
+-->|id | <---+ +--o |category_id |
| |title | | |language_id | o---+
| |description| 1:n |name | | +-------------+
| |status | | +---------------+ . | language |
| |parent_id | o---+ \ +-------------+
| +-----------+ >--> |id |
1:n / |lang |
| +------------+ ' |status |
| | product | | +-------------+
| +------------+ +--------------+ |
| |id | <---+ | product_lang | |
| |price | | +--------------+ |
| |quantity | +---o |product_id | |
| |... | |language_id | o-----+
+-o |category_id | |name |
+------------+ +--------------+
Workflow
+------------+ +---------------+ +-----------+
| user | | role_has_user | | role |
+------------+ +---------------+ +-----------+
|id |o-+ |id | +->|id |<-+
|node_id | +->|user_id | | |name | |
|up_id | |role_id |o-+ |description| |
+------------+ +---------------+ +-----------+ |
|
+----------------+ +------------+ |
| workflow | | job | |
+----------------+ +------------+ |
+->|id | +->|id | |
| |job_id |o-+ |name | |
+-o|up_id | |role_id |o------------------+
| | |description |
+----------------+ +------------+
内容版本控制
主表
CREATE TABLE `article` (
`article_id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`cat_id` SMALLINT(5) NOT NULL DEFAULT '0',
`title` VARCHAR(150) NOT NULL DEFAULT '',
`content` LONGTEXT NOT NULL,
`author` VARCHAR(30) NOT NULL DEFAULT '',
`keywords` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`article_id`),
INDEX `cat_id` (`cat_id`)
)
ENGINE=MyISAM
ROW_FORM