應用（小票打印） · Niushop單商戶V5開發手冊

```[sql] -- ---------------------------- -- Table structure for ns_printer -- ---------------------------- DROP TABLE IF EXISTS `ns_printer`; CREATE TABLE `ns_printer` ( `printer_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `brand` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '小票打印機品牌（365 飛鶴易聯云）', `printer_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '打印機名稱', `printer_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '打印機編號', `printer_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '打印機秘鑰', `open_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '開發者id', `apikey` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '開發者密鑰', `print_num` tinyint(3) NOT NULL DEFAULT 1 COMMENT '打印張數', `order_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '打印的訂單類型', `template_id` int(11) NOT NULL DEFAULT 0 COMMENT '模板id', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`printer_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '小票打印機' ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for ns_printer_template -- ---------------------------- DROP TABLE IF EXISTS `ns_printer_template`; CREATE TABLE `ns_printer_template` ( `template_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` int(11) NOT NULL DEFAULT 0 COMMENT '站點id', `site_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '站點名', `template_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板類型（預留字段）', `template_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板名稱', `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '小票名稱', `head` tinyint(1) NOT NULL DEFAULT 0 COMMENT '頭部內容', `buy_notes` tinyint(1) NOT NULL DEFAULT 0 COMMENT '買家留言（0否 1是）', `seller_notes` tinyint(1) NOT NULL DEFAULT 0 COMMENT '賣家留言（0否 1是）', `buy_name` tinyint(1) NOT NULL DEFAULT 0 COMMENT '買家姓名', `buy_mobile` tinyint(1) NOT NULL DEFAULT 0 COMMENT '買家聯系電話', `buy_address` tinyint(1) NOT NULL DEFAULT 0 COMMENT '買家地址', `shop_mobile` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商家聯系電話', `shop_address` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商家地址', `shop_qrcode` tinyint(1) NOT NULL DEFAULT 0 COMMENT '商家二維碼', `qrcode_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '二維碼鏈接', `bottom` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '底部內容', `create_time` int(11) NOT NULL DEFAULT 0, `update_time` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`template_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 AVG_ROW_LENGTH = 8192 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '打印機模板' ROW_FORMAT = Compact;