学步园

-- Table: "xx_attr_chooseType"

-- DROP TABLE "xx_attr_chooseType";

CREATE TABLE "xx_attr_chooseType"( 

 id serial NOT NULL, 

 name character varying(50) NOT NULL,

  CONSTRAINT "xx_attr_chooseType_pkey" PRIMARY KEY (id))

WITH (  OIDS=FALSE);ALTER TABLE "xx_attr_chooseType"  OWNER TO postgres;

uiType，表示该属性（针对于自定义输入）的ui类型，可以为url，普通字符串，日期等等。

-- Table: "xx_attr_uiType"
-- DROP TABLE "xx_attr_uiType";
CREATE TABLE "xx_attr_uiType"( 
 id serial NOT NULL,
  name character varying(50) NOT NULL, 
 CONSTRAINT "xx_attr_uiType_pkey" PRIMARY KEY (id))
WITH (  OIDS=FALSE);
ALTER TABLE "xx_attr_uiType"  OWNER TO postgres;

type，表示该属性的类型，通常分为sku属性及普通展示属性。

-- Table: xx_attr_type-- 
DROP TABLE xx_attr_type;
CREATE TABLE xx_attr_type( 
 id serial NOT NULL,
  name character varying(50) NOT NULL, 
 CONSTRAINT xx_attr_type_pkey PRIMARY KEY (id))
WITH (  OIDS=FALSE);
ALTER TABLE xx_attr_type  OWNER TO postgres;

name表，表示该属性的名称表，

    id:0,//数据库的id  
moduleid:0,//数据库对应的模型id。 
 name:"",//属性名称，中文名称。
 attrName:"",//属性的英文名称，用于方便提交表单时候进行相关操作。请注意，同一个模型里面不能有相同的属性名称。 
 tips:"",//属性填写提示。   
 chooseType:1,//选择类型，1：单选，2：多选，3：手写输入   
 attrType:1,//属性类型，1、sku属性，2、普通展示属性。    isRequired:true,//是否必须填写或选择。 usedInSearch:true,//是否在搜索里面使用。  
enabled:true,//该属性是否启用。 
 isMain:false,//是否主要的sku属性。只有在单选及手写情况下，才可能是sku。还有，手写时候，没办法设置为搜索属性。 
orders:0,//该属性的排位。
  /*single 单选系列参数*/   
single_isColor:false,  
single_imgAllowed:false, 
   /*单选参数结束*/   /*多选系列参数*/  
muti_maxSelected:0,  /*多选参数结束*/   /*手动输入系列参数*/  
 input_uiType:0,  
/*手动输入参数结束*/  
/*共用，选择类型的option*/  
options:[] //里面的item为：{id:0,name:"",orders:"",color:"",enabled:false}    /*option结束*/

-- Table: xx_attr_val
-- DROP TABLE xx_attr_val;
CREATE TABLE xx_attr_val(  id serial NOT NULL,  nameid integer NOT NULL,  name character varying(200) NOT NULL,  orders integer DEFAULT 0,  color character varying(20) DEFAULT ''::character varying,  enabled boolean NOT NULL DEFAULT true,  CONSTRAINT xx_attr_val_pkey PRIMARY KEY (id),  CONSTRAINT xx_attr_val_nameid_fkey FOREIGN KEY (nameid)      REFERENCES xx_attr_name (id) MATCH SIMPLE      ON UPDATE NO ACTION ON DELETE NO ACTION)WITH (  OIDS=FALSE);ALTER TABLE xx_attr_val  OWNER TO postgres;

-- Table: xx_attr_va
l-- DROP TABLE xx_attr_val;
CREATE TABLE xx_attr_val(  id serial NOT NULL,  nameid integer NOT NULL,  name character varying(200) NOT NULL,  orders integer DEFAULT 0,  color character varying(20) DEFAULT ''::character varying,  enabled boolean NOT NULL DEFAULT true,  CONSTRAINT xx_attr_val_pkey PRIMARY KEY (id),  CONSTRAINT xx_attr_val_nameid_fkey FOREIGN KEY (nameid)      REFERENCES xx_attr_name (id) MATCH SIMPLE      ON UPDATE NO ACTION ON DELETE NO ACTION)WITH (  OIDS=FALSE);ALTER TABLE xx_attr_val  OWNER TO postgres;

module模型表

-- Table: xx_module-- DROP TABLE xx_module;CREATE TABLE xx_module(  id serial NOT NULL,  name character varying(50) NOT NULL,  logo character varying(200) DEFAULT ''::character varying,  memo character varying(200) DEFAULT ''::character varying,  orders smallint DEFAULT 0,  enabled boolean DEFAULT true,  CONSTRAINT xx_module_pkey PRIMARY KEY (id))WITH (  OIDS=FALSE);ALTER TABLE xx_module  OWNER TO postgres;

[{"id":0,"moduleid":0,"name":"颜色","attrName":"color","tips":"机身颜色","chooseType":1,"attrType":1,"isRequired":true,"usedInSearch":true,"enabled":true,"isMain":false,"orders":0,"single_isColor":true,"single_imgAllowed":true,"muti_maxSelected":0,"input_uiType":0,"options":[{"id":0,"name":"白色","color":"#000000","orders":0,"enabled":true},{"id":0,"name":"黑色","color":"#ffffff","orders":1,"enabled":true}]},{"id":0,"moduleid":0,"name":"版本","attrName":"version","tips":"","chooseType":3,"attrType":1,"isRequired":true,"usedInSearch":false,"enabled":true,"isMain":false,"orders":0,"single_isColor":false,"single_imgAllowed":false,"muti_maxSelected":0,"input_uiType":1,"options":[]},{"id":0,"moduleid":0,"name":"网络制式","attrName":"web","tips":"","chooseType":2,"attrType":2,"isRequired":true,"usedInSearch":false,"enabled":true,"isMain":false,"orders":0,"single_isColor":false,"single_imgAllowed":false,"muti_maxSelected":4,"input_uiType":0,"options":[{"id":0,"name":"GSM/WCDMA/LTE","color":"","orders":0,"enabled":true},{"id":0,"name":"WCDMA/CDMA2000/TD-SCDMA","color":"","orders":0,"enabled":true},{"id":0,"name":"GSM/WCDMA/CDMA/CDMA2000","color":"","orders":1,"enabled":true},{"id":0,"name":"双模(GSM/CDMA)","color":"","orders":3,"enabled":true}]},{"id":0,"moduleid":0,"name":"机身内存","attrName":"neicun","tips":"","chooseType":1,"attrType":1,"isRequired":true,"usedInSearch":false,"enabled":true,"isMain":false,"orders":3,"single_isColor":false,"single_imgAllowed":false,"muti_maxSelected":0,"input_uiType":0,"options":[{"id":0,"name":"256MB","color":"","orders":0,"enabled":true},{"id":0,"name":"512MB","color":"","orders":2,"enabled":true},{"id":0,"name":"1G","color":"","orders":3,"enabled":true},{"id":0,"name":"4g","color":"","orders":8,"enabled":true},{"id":0,"name":"2g","color":"","orders":8,"enabled":true},{"id":0,"name":"8g","color":"","orders":10,"enabled":true},{"id":0,"name":"16G","color":"","orders":12,"enabled":true},{"id":0,"name":"32G","color":"","orders":16,"enabled":true}]}]