· 7 years ago · Jan 07, 2019, 09:38 AM
1DROP TABLE IF EXISTS `t_bid_item_argument`;
2CREATE TABLE `t_bid_item_argument` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `bid_item_id` varchar(36) NOT NULL DEFAULT '' COMMENT 'ç«žä»·æ¡ç›® id',
5 `product_property_id` int(11) NOT NULL DEFAULT '0' COMMENT '属性 id',
6 `property_value_id` int(11) NOT NULL DEFAULT '0' COMMENT '属性值 id',
7 `value_desc` varchar(36) NOT NULL DEFAULT '' COMMENT '属性值æè¿° (自定义的值)',
8 `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
9 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
10 `is_deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是å¦è¢«åˆ 除',
11 PRIMARY KEY (`id`) USING BTREE,
12 KEY `idx_bid_item_id` (`bid_item_id`)
13) ENGINE=InnoDB AUTO_INCREMENT=457 DEFAULT CHARSET=utf8;
14
15DROP TABLE IF EXISTS `t_bid_item_property`;
16CREATE TABLE `t_bid_item_property` (
17 `id` int(11) NOT NULL AUTO_INCREMENT,
18 `name` varchar(36) NOT NULL DEFAULT '' COMMENT '属性å',
19 `content_type` int(11) NOT NULL DEFAULT '0' COMMENT '属性类型',
20 `group_id` int(11) NOT NULL DEFAULT '0' COMMENT '属性分组',
21 `required` bit(1) NOT NULL DEFAULT b'0' COMMENT '是å¦å¿…å¡«',
22 `order` int(11) NOT NULL DEFAULT '0' COMMENT 'å±žæ€§æŽ’åº è¶Šå°è¶Šå‰é¢',
23 `description` varchar(50) NOT NULL DEFAULT '' COMMENT '属性æè¿°',
24 `enable` bit(1) NOT NULL DEFAULT b'0' COMMENT '是å¦å¯ç”¨',
25 `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
26 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
27 PRIMARY KEY (`id`) USING BTREE,
28 KEY `idx_group_id` (`group_id`)
29) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
30
31DROP TABLE IF EXISTS `t_bid_item_property_value`;
32CREATE TABLE `t_bid_item_property_value` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `property_id` int(11) NOT NULL DEFAULT 0 COMMENT '属性id',
35 `name` varchar(50) NOT NULL DEFAULT 0 COMMENT '属性å',
36 `custom` bit(1) NOT NULL DEFAULT '' COMMENT '是å¦æ˜¯è‡ªå®šä¹‰',
37 `custom_name` varchar(50) NOT NULL DEFAULT '' COMMENT '自定义值',
38 `order` int(11) NOT NULL DEFAULT 0 COMMENT 'å±žæ€§æŽ’åº è¶Šå°è¶Šå‰é¢',
39 `text` bit(1) NOT NULL DEFAULT b'0' COMMENT '是å¦å¡«ç©º',
40 `enable` bit(1) NOT NULL DEFAULT b'0' COMMENT '是å¦å¯ç”¨',
41 `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
42 `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
43 PRIMARY KEY (`id`) USING BTREE,
44 KEY `idx_property_id` (`property_id`)
45) ENGINE=InnoDB DEFAULT CHARSET = utf8;
46
47INSERT INTO `t_bid_item_property` (`id`, `name`, `content_type`, `group_id`, `required`, `order`, `description`, `enable`, `creation_time`, `update_time`)
48VALUES
49 (2, 'æœåŠ¡èŒƒå›´', 3, 1, 1, 0, '', 1, '2018-12-05 17:48:56', '2018-12-07 10:10:09'),
50 (3, '物ç§', 3, 1, 0, 0, '请选择测åº/分æžç‰©ç§æ¥æº', 1, '2018-12-05 17:48:56', '2018-12-07 16:47:59'),
51 (4, 'æ ·å“类型', 2, 1, 0, 0, '', 1, '2018-12-05 17:48:56', '2018-12-05 17:48:56'),
52 (5, '是å¦éœ€è¦ææ ·', 1, 1, 1, 0, '', 1, '2018-12-05 17:48:56', '2018-12-07 10:10:13'),
53 (6, '测åºç–ç•¥', 2, 1, 1, 0, '请选择测åº/分æžæ‰€æµ‹çš„长度', 1, '2018-12-05 17:48:56', '2018-12-07 16:48:18'),
54 (7, '测åºå¹³å°', 2, 1, 0, 0, '', 1, '2018-12-05 17:48:56', '2018-12-05 17:48:56'),
55 (8, 'æ•°æ®äº¤ä»˜ç±»åž‹', 1, 1, 1, 0, '', 1, '2018-12-05 17:48:56', '2018-12-07 10:11:00'),
56 (9, '需求周期', 2, 1, 1, 0, '', 1, '2018-12-05 17:48:56', '2018-12-07 10:11:01'),
57 (10, 'æ ·å“æ•°é‡', 4, 1, 1, 0, '', 1, '2018-12-05 17:48:56', '2018-12-07 10:11:04'),
58 (11, 'æ•°æ®é‡', 4, 1, 0, 0, '', 1, '2018-12-05 17:48:56', '2018-12-05 17:48:56'),
59 (12, '项目信æ¯éœ€æ±‚', 6, 1, 0, 0, '', 1, '2018-12-07 16:04:55', '2018-12-07 16:06:37');
60
61
62INSERT INTO `t_bid_item_property_value` (`id`, `property_id`, `name`, `text`, `order`, `enable`, `creation_time`, `update_time`)
63VALUES
64 (1, 2, '建库测åº', 0, 0, 0, '2018-12-05 17:55:06', '2018-12-05 17:55:06'),
65 (2, 2, '建库测åº', 0, 1, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
66 (3, 2, 'æ•°æ®åˆ†æž', 0, 2, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
67 (4, 3, '动物', 0, 1, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
68 (5, 3, 'æ¤ç‰©', 0, 2, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
69 (6, 3, '微生物', 0, 3, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
70 (7, 4, 'DNA', 0, 1, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
71 (8, 4, 'RNA', 0, 2, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
72 (9, 4, '蛋白质', 0, 3, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
73 (10, 4, '其他', 1, 4, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
74 (11, 5, '是', 0, 1, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
75 (12, 5, 'å¦', 0, 1, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
76 (13, 6, 'PE-150', 0, 1, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
77 (14, 6, 'SE-50', 0, 2, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
78 (15, 6, 'SE-250', 0, 3, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
79 (16, 6, 'SE-300', 0, 4, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
80 (17, 6, '其他', 1, 5, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
81 (18, 7, 'Hiseq X Ten', 0, 1, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
82 (19, 7, 'Hiseq 4000', 0, 2, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
83 (20, 7, 'PacBio', 0, 3, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
84 (21, 7, '其他', 1, 4, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
85 (22, 8, 'raw data', 0, 1, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
86 (23, 8, 'clean data', 0, 2, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
87 (24, 9, '20天-30天', 0, 1, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
88 (25, 9, '30天-50天', 0, 2, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
89 (26, 9, '50天以上', 0, 3, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
90 (27, 9, '自定义', 1, 4, 1, '2018-12-05 18:12:05', '2018-12-05 18:12:05'),
91 (28, 10, '个', 1, 1, 1, '2018-12-05 18:12:05', '2018-12-17 15:51:53'),
92 (29, 11, 'G', 1, 1, 1, '2018-12-05 18:12:05', '2018-12-17 15:51:57'),
93 (31, 12, 'æä¾›èƒ½å¤Ÿæ”¯æ’‘æ–‡ç« å‘表的所有信æ¯åˆ†æžæœåŠ¡ï¼Œç›´è‡³æ–‡ç« å‘表', 0, 2, 1, '2018-12-07 16:10:20', '2018-12-07 16:12:56'),
94 (32, 12, '为课题组æˆå‘˜æä¾›å…费的信æ¯åˆ†æžåŸ¹è®', 0, 4, 1, '2018-12-07 16:10:20', '2018-12-07 16:12:56'),
95 (33, 12, 'æä¾›åˆé€‚çš„æå–æ ·å“方法或指导', 0, 5, 1, '2018-12-07 16:10:20', '2018-12-07 16:12:56'),
96 (34, 12, 'è¿ç”¨è‡ªå·±çš„测åºå¹³å°ï¼Œä¸å¾—转包第三方', 0, 3, 1, '2018-12-07 16:10:20', '2018-12-07 16:12:56'),
97 (35, 12, 'æ供相似案例作为å‚考', 0, 6, 1, '2018-12-07 16:10:20', '2018-12-07 16:12:56'),
98 (36, 12, '其他', 0, 7, 1, '2018-12-07 16:10:20', '2018-12-07 16:12:56'),
99 (37, 12, '技术团队定期汇报项目进展', 0, 1, 1, '2018-12-07 16:10:20', '2018-12-07 16:12:56');