查看表格结构内容，包含注释

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60

mysql> desc tf_insurance_order; +------------------------+-----------------+------+-----+---------+----------------+ | Field                  | Type            | Null | Key | Default | Extra          | +------------------------+-----------------+------+-----+---------+----------------+ | id                     | int(8)          | NO   | PRI | NULL    | auto_increment | | order_num              | varchar(100)    | NO   |     | NULL    |                | | uid                    | int(8)          | NO   |     | NULL    |                | | insurance_id           | int(8)          | NO   |     | NULL    |                | | name                   | varchar(100)    | NO   |     | NULL    |                | | age_range              | varchar(100)    | NO   |     | NULL    |                | | security_object        | varchar(100)    | NO   |     | NULL    |                | | guarantee_range        | varchar(100)    | NO   |     | NULL    |                | | guarantee_period       | varchar(100)    | NO   |     | NULL    |                | | people_num             | int(6) unsigned | NO   |     | NULL    |                | | scheme_name            | varchar(100)    | NO   |     | NULL    |                | | scheme_price           | int(11)         | NO   |     | NULL    |                | | price_id               | int(8)          | NO   |     | NULL    |                | | total_fee              | int(11)         | NO   |     | NULL    |                | | payed_fee              | int(11)         | NO   |     | NULL    |                | | pay_type               | tinyint(1)      | NO   |     | NULL    |                | | pay_credential         | varchar(200)    | NO   |     | NULL    |                | | pay_credential_addtime | int(11)         | NO   |     | NULL    |                | | status                 | tinyint(1)      | NO   |     | NULL    |                | | paytime                | int(11)         | NO   |     | 0       |                | | is_pay                 | tinyint(1)      | NO   |     | 0       |                | | addtime                | int(11)         | NO   |     | NULL    |                | +------------------------+-----------------+------+-----+---------+----------------+ 22 rows in set (0.00 sec)   mysql> show create table tf_insurance_order; +--------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table              | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     | +--------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | tf_insurance_order | CREATE TABLE `tf_insurance_order` (   `id` int(8) NOT NULL AUTO_INCREMENT,   `order_num` varchar(100) NOT NULL COMMENT '订单号',   `uid` int(8) NOT NULL COMMENT '生成订单的uid',   `insurance_id` int(8) NOT NULL COMMENT '购买哪个保险产品',   `name` varchar(100) NOT NULL,   `age_range` varchar(100) NOT NULL COMMENT '投保年龄',   `security_object` varchar(100) NOT NULL COMMENT '保障对象',   `guarantee_range` varchar(100) NOT NULL COMMENT '承包范围',   `guarantee_period` varchar(100) NOT NULL COMMENT '保险期限',   `people_num` int(6) unsigned NOT NULL COMMENT '投保人数',   `scheme_name` varchar(100) NOT NULL COMMENT '投保方案',   `scheme_price` int(11) NOT NULL COMMENT '投保方案的价格',   `price_id` int(8) NOT NULL COMMENT '方案价格id',   `total_fee` int(11) NOT NULL COMMENT '保单总费用',   `payed_fee` int(11) NOT NULL COMMENT '实际支付的费用',   `pay_type` tinyint(1) NOT NULL COMMENT '1.微信;2.对公账户',   `pay_credential` varchar(200) NOT NULL COMMENT '打款凭据',   `pay_credential_addtime` int(11) NOT NULL COMMENT '打款凭据上传时间',   `status` tinyint(1) NOT NULL,   `paytime` int(11) NOT NULL DEFAULT '0' COMMENT '支付时间',   `is_pay` tinyint(1) NOT NULL DEFAULT '0',   `addtime` int(11) NOT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='保险订单' | +--------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)