賬戶相關 · Niushop單商戶V3數據字典

```[sql] CREATE TABLE ns_account ( account_id INT(10) NOT NULL AUTO_INCREMENT COMMENT '賬戶ID', account_profit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平臺的總營業額', account_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平臺資金總余額', account_return DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平臺利潤總額', account_deposit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '保證金總額', account_order DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商城訂單總額', account_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商城提現總額', account_shop DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪總余額', account_shop_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪總提現', PRIMARY KEY (account_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '商城資金統計'; CREATE TABLE ns_account_assistant_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水號', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '對應金額', account_type TINYINT(1) NOT NULL COMMENT '賬戶類型', type_alis_id INT(11) NOT NULL COMMENT '關聯ID', remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '簡介', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '招商員支付記錄'; CREATE TABLE ns_account_order_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水號', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '對應金額', account_type TINYINT(1) NOT NULL COMMENT '賬戶類型', type_alis_id INT(11) NOT NULL COMMENT '關聯ID', remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '簡介', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 8192 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '金額賬戶記錄'; CREATE TABLE ns_account_period ( period_id INT(10) NOT NULL AUTO_INCREMENT COMMENT '賬戶ID', period_year INT(10) NOT NULL COMMENT '賬期年份', period_month INT(10) NOT NULL COMMENT '賬期月份', account_profit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '賬期總營業額', account_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '賬期總發生余額', account_return DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '賬期利潤總額', account_deposit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '賬期保證金總額', account_order DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '賬期訂單總額', account_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '賬期店鋪提現總額', account_shop DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '賬期店鋪總發生額', account_shop_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '賬期店鋪總提現額', start_time INT(11) DEFAULT 0 COMMENT '開始時間', end_time INT(11) DEFAULT 0 COMMENT '結束時間', PRIMARY KEY (period_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 16384 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '商城賬期結算表'; CREATE TABLE ns_account_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '對應金額', account_type TINYINT(1) NOT NULL COMMENT '賬戶類型', type_alis_id INT(11) NOT NULL COMMENT '關聯ID', is_display TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否顯示', is_calculate TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否參與計算', remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '簡介', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1092 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '金額賬戶記錄'; CREATE TABLE ns_account_return_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '金額', return_type INT(11) NOT NULL DEFAULT 0 COMMENT '提成類型', type_alis_id INT(11) NOT NULL DEFAULT 0 COMMENT '關聯id', is_display INT(11) NOT NULL DEFAULT 0 COMMENT '是否顯示', is_calculate INT(11) NOT NULL DEFAULT 0 COMMENT '是否計算', remark VARCHAR(255) NOT NULL DEFAULT '0' COMMENT '備注', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 910 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '平臺的利潤的記錄'; CREATE TABLE ns_account_withdraw_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水號', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '對應金額', account_type TINYINT(1) NOT NULL COMMENT '賬戶類型', type_alis_id INT(11) NOT NULL COMMENT '關聯ID', remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '簡介', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '金額賬戶記錄'; CREATE TABLE ns_account_withdraw_user_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主鍵', serial_no VARCHAR(50) NOT NULL DEFAULT '' COMMENT '流水號', shop_id INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪id', money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '對應金額', account_type TINYINT(1) NOT NULL COMMENT '賬戶類型', type_alis_id INT(11) NOT NULL COMMENT '關聯ID', remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '簡介', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '會員提現記錄表'; -- -- Definition for table ns_shop -- DROP TABLE IF EXISTS ns_shop; CREATE TABLE ns_shop ( shop_id INT(11) NOT NULL COMMENT '店鋪索引id', shop_name VARCHAR(50) NOT NULL COMMENT '店鋪名稱', shop_type INT(11) NOT NULL COMMENT '店鋪類型等級', uid INT(11) NOT NULL COMMENT '會員id', shop_group_id INT(11) NOT NULL COMMENT '店鋪分類', shop_company_name VARCHAR(50) DEFAULT NULL COMMENT '店鋪公司名稱', province_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店鋪所在省份ID', city_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店鋪所在市ID', shop_address VARCHAR(100) NOT NULL DEFAULT '' COMMENT '詳細地區', shop_zip VARCHAR(10) NOT NULL DEFAULT '' COMMENT '郵政編碼', shop_state TINYINT(1) NOT NULL DEFAULT 1 COMMENT '店鋪狀態，0關閉，1開啟，2審核中', shop_close_info VARCHAR(255) DEFAULT NULL COMMENT '店鋪關閉原因', shop_sort INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪排序', shop_logo VARCHAR(255) DEFAULT NULL COMMENT '店鋪logo', shop_banner VARCHAR(255) DEFAULT NULL COMMENT '店鋪橫幅', shop_avatar VARCHAR(150) DEFAULT NULL COMMENT '店鋪頭像', shop_keywords VARCHAR(255) NOT NULL DEFAULT '' COMMENT '店鋪seo關鍵字', shop_description VARCHAR(255) NOT NULL DEFAULT '' COMMENT '店鋪seo描述', shop_qq VARCHAR(50) DEFAULT NULL COMMENT 'QQ', shop_ww VARCHAR(50) DEFAULT NULL COMMENT '阿里旺旺', shop_phone VARCHAR(20) DEFAULT NULL COMMENT '商家電話', shop_domain VARCHAR(50) DEFAULT NULL COMMENT '店鋪二級域名', shop_domain_times TINYINT(1) UNSIGNED DEFAULT 0 COMMENT '二級域名修改次數', shop_recommend TINYINT(1) NOT NULL DEFAULT 0 COMMENT '推薦，0為否，1為是，默認為0', shop_credit INT(10) NOT NULL DEFAULT 0 COMMENT '店鋪信用', shop_desccredit FLOAT NOT NULL DEFAULT 0 COMMENT '描述相符度分數', shop_servicecredit FLOAT NOT NULL DEFAULT 0 COMMENT '服務態度分數', shop_deliverycredit FLOAT NOT NULL DEFAULT 0 COMMENT '發貨速度分數', shop_collect INT(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '店鋪收藏數量', shop_stamp VARCHAR(200) DEFAULT NULL COMMENT '店鋪印章', shop_printdesc VARCHAR(500) DEFAULT NULL COMMENT '打印訂單頁面下方說明文字', shop_sales DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪銷售額（不計算退款）', shop_account DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪賬戶余額', shop_cash DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪可提現金額', shop_workingtime VARCHAR(100) DEFAULT NULL COMMENT '工作時間', live_store_name VARCHAR(255) DEFAULT NULL COMMENT '商鋪名稱', live_store_address VARCHAR(255) DEFAULT NULL COMMENT '商家地址', live_store_tel VARCHAR(255) DEFAULT NULL COMMENT '商鋪電話', live_store_bus VARCHAR(255) DEFAULT NULL COMMENT '公交線路', shop_vrcode_prefix CHAR(3) DEFAULT NULL COMMENT '商家兌換碼前綴', store_qtian TINYINT(1) DEFAULT 0 COMMENT '7天退換', shop_zhping TINYINT(1) DEFAULT 0 COMMENT '正品保障', shop_erxiaoshi TINYINT(1) DEFAULT 0 COMMENT '兩小時發貨', shop_tuihuo TINYINT(1) DEFAULT 0 COMMENT '退貨承諾', shop_shiyong TINYINT(1) DEFAULT 0 COMMENT '試用中心', shop_shiti TINYINT(1) DEFAULT 0 COMMENT '實體驗證', shop_xiaoxie TINYINT(1) DEFAULT 0 COMMENT '消協保證', shop_huodaofk TINYINT(1) DEFAULT 0 COMMENT '貨到付款', shop_free_time VARCHAR(10) DEFAULT NULL COMMENT '商家配送時間', shop_region VARCHAR(50) DEFAULT NULL COMMENT '店鋪默認配送區域', recommend_uid INT(11) NOT NULL DEFAULT 0 COMMENT '推薦招商員用戶id', shop_qrcode VARCHAR(255) NOT NULL DEFAULT '' COMMENT '店鋪公眾號', shop_create_time INT(11) DEFAULT 0 COMMENT '店鋪時間', shop_end_time INT(11) DEFAULT 0 COMMENT '店鋪關閉時間', PRIMARY KEY (shop_id) ) ENGINE = INNODB AVG_ROW_LENGTH = 16384 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '店鋪數據表'; -- -- Definition for table ns_shop_account -- DROP TABLE IF EXISTS ns_shop_account; CREATE TABLE ns_shop_account ( shop_id INT(11) NOT NULL, shop_profit DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪總營業額', shop_total_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪入賬總額', shop_proceeds DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪收益總額', shop_platform_commission DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平臺抽取店鋪利潤總額', shop_withdraw DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪提現總額', shop_point INT(11) NOT NULL DEFAULT 0 COMMENT '店鋪發放的積分總額', shop_point_use INT(11) NOT NULL DEFAULT 0 COMMENT '會員已使用多少積分', PRIMARY KEY (shop_id) ) ENGINE = INNODB AVG_ROW_LENGTH = 2340 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '店鋪賬戶表'; -- -- Definition for table ns_shop_ad -- DROP TABLE IF EXISTS ns_shop_ad; CREATE TABLE ns_shop_ad ( id INT(11) NOT NULL AUTO_INCREMENT, shop_id INT(11) NOT NULL, ad_image VARCHAR(255) NOT NULL DEFAULT '' COMMENT '廣告圖片', link_url VARCHAR(255) NOT NULL DEFAULT '' COMMENT '鏈接地址', sort INT(11) NOT NULL DEFAULT 0 COMMENT '排序', type INT(1) NOT NULL DEFAULT 0 COMMENT '類型 0 -- pc端 1-- 手機端 ', background VARCHAR(255) NOT NULL DEFAULT '#FFFFFF' COMMENT '背景色', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 5461 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '店鋪廣告設置'; -- -- Definition for table ns_shop_coin_records -- DROP TABLE IF EXISTS ns_shop_coin_records; CREATE TABLE ns_shop_coin_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, shop_id INT(11) NOT NULL COMMENT '店鋪ID', num DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '購物幣數量', account_type INT(11) NOT NULL DEFAULT 1 COMMENT '增加或減少類型', type_alis_id INT(11) NOT NULL DEFAULT 0 COMMENT '關聯ID', is_display TINYINT(1) NOT NULL DEFAULT 1 COMMENT '是否顯示', text VARCHAR(255) NOT NULL DEFAULT '' COMMENT '簡介', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '店鋪購物幣記錄'; -- -- Definition for table ns_shop_express_address -- DROP TABLE IF EXISTS ns_shop_express_address; CREATE TABLE ns_shop_express_address ( express_address_id INT(11) NOT NULL AUTO_INCREMENT COMMENT '物流地址id', shop_id INT(11) NOT NULL COMMENT '商鋪id', contact VARCHAR(100) NOT NULL DEFAULT '' COMMENT '聯系人', mobile VARCHAR(50) NOT NULL DEFAULT '' COMMENT '手機', phone VARCHAR(50) NOT NULL DEFAULT '' COMMENT '電話', company_name VARCHAR(100) NOT NULL DEFAULT '' COMMENT '公司名稱', province SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '所在地省', city SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '所在地市', district SMALLINT(6) NOT NULL DEFAULT 0 COMMENT '所在地區縣', zipcode VARCHAR(6) NOT NULL DEFAULT '' COMMENT '郵編', address VARCHAR(100) NOT NULL DEFAULT '' COMMENT '詳細地址', is_consigner TINYINT(2) NOT NULL DEFAULT 0 COMMENT '發貨地址標記', is_receiver TINYINT(2) NOT NULL DEFAULT 0 COMMENT '收貨地址標記', create_date INT(11) DEFAULT 0 COMMENT '創建日期', modify_date INT(11) DEFAULT 0 COMMENT '修改日期', PRIMARY KEY (express_address_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 1092 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '物流地址'; -- -- Definition for table ns_shop_group -- DROP TABLE IF EXISTS ns_shop_group; CREATE TABLE ns_shop_group ( shop_group_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '分組ID', group_name VARCHAR(50) NOT NULL DEFAULT '' COMMENT '分組名稱', group_sort INT(11) NOT NULL DEFAULT 1 COMMENT '分組排序號', create_time INT(11) DEFAULT 0 COMMENT '創建時間', modify_time INT(11) DEFAULT 0 COMMENT '修改時間', PRIMARY KEY (shop_group_id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 2730 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '店鋪分組表'; -- -- Definition for table ns_shop_order_account_records -- DROP TABLE IF EXISTS ns_shop_order_account_records; CREATE TABLE ns_shop_order_account_records ( id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, shop_id INT(11) NOT NULL COMMENT '店鋪ID', order_id INT(11) NOT NULL COMMENT '訂單ID', order_no VARCHAR(255) NOT NULL DEFAULT '' COMMENT '訂單編號', order_goods_id INT(11) NOT NULL COMMENT '訂單項ID', goods_pay_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '訂單項實際支付金額', rate DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '商品平臺傭金比率', shop_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪獲取金額', platform_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平臺獲取金額', is_refund TINYINT(1) NOT NULL DEFAULT 0 COMMENT '是否產生退款', refund_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '實際退款金額', shop_refund_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '店鋪扣減余額', platform_refund_money DECIMAL(10, 2) NOT NULL DEFAULT 0.00 COMMENT '平臺扣減余額', is_issue TINYINT(4) NOT NULL DEFAULT 0 COMMENT '是否已經結算', remark VARCHAR(255) NOT NULL DEFAULT '' COMMENT '備注', create_time INT(11) DEFAULT 0 COMMENT '創建時間', PRIMARY KEY (id) ) ENGINE = INNODB AUTO_INCREMENT = 1 AVG_ROW_LENGTH = 655 CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = '店鋪針對訂單的金額分配'; ```