68 行
3.6 KiB
SQL
68 行
3.6 KiB
SQL
-- 运营公司财务结算模块
|
|
-- 执行前请将 fa_ 替换为实际表前缀
|
|
|
|
CREATE TABLE IF NOT EXISTS `fa_shopro_operating_company` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(100) NOT NULL COMMENT '运营公司名称',
|
|
`contact_name` varchar(50) DEFAULT NULL COMMENT '联系人',
|
|
`contact_mobile` varchar(20) DEFAULT NULL COMMENT '联系电话',
|
|
`bank_name` varchar(100) DEFAULT NULL COMMENT '开户行',
|
|
`bank_account` varchar(50) DEFAULT NULL COMMENT '银行账号',
|
|
`account_name` varchar(50) DEFAULT NULL COMMENT '户名',
|
|
`status` enum('normal','forbidden') NOT NULL DEFAULT 'normal' COMMENT '状态',
|
|
`createtime` int(10) NOT NULL COMMENT '创建时间',
|
|
`updatetime` int(10) NOT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `name` (`name`) USING BTREE,
|
|
KEY `status` (`status`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运营公司';
|
|
|
|
CREATE TABLE IF NOT EXISTS `fa_shopro_operating_company_settlement` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`settlement_sn` varchar(32) NOT NULL COMMENT '结算单号',
|
|
`company_id` int(11) NOT NULL COMMENT '运营公司ID',
|
|
`company_name` varchar(100) NOT NULL COMMENT '运营公司名称',
|
|
`amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '结算金额',
|
|
`period_start` date NOT NULL COMMENT '结算周期起',
|
|
`period_end` date NOT NULL COMMENT '结算周期止',
|
|
`audit_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '审核:0=草稿,1=待审核,2=已通过,3=已驳回',
|
|
`pay_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '打款:0=未打款,1=已打款,2=打款失败',
|
|
`audit_remark` varchar(255) DEFAULT NULL COMMENT '审核备注',
|
|
`pay_remark` varchar(255) DEFAULT NULL COMMENT '打款备注',
|
|
`pay_time` int(10) DEFAULT NULL COMMENT '打款时间',
|
|
`admin_id` int(11) NOT NULL DEFAULT 0 COMMENT '创建人',
|
|
`audit_admin_id` int(11) NOT NULL DEFAULT 0 COMMENT '审核人',
|
|
`source` enum('manual','import') NOT NULL DEFAULT 'manual' COMMENT '来源',
|
|
`import_batch` varchar(32) DEFAULT NULL COMMENT '导入批次',
|
|
`createtime` int(10) NOT NULL COMMENT '创建时间',
|
|
`updatetime` int(10) NOT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
UNIQUE KEY `settlement_sn` (`settlement_sn`) USING BTREE,
|
|
KEY `company_id` (`company_id`) USING BTREE,
|
|
KEY `audit_status` (`audit_status`) USING BTREE,
|
|
KEY `pay_status` (`pay_status`) USING BTREE,
|
|
KEY `period_start` (`period_start`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运营公司结算单';
|
|
|
|
CREATE TABLE IF NOT EXISTS `fa_shopro_operating_company_settlement_item` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`settlement_id` int(11) NOT NULL COMMENT '结算单ID',
|
|
`order_sn` varchar(50) DEFAULT NULL COMMENT '订单号',
|
|
`item_name` varchar(100) DEFAULT NULL COMMENT '分成项目',
|
|
`amount` decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '明细金额',
|
|
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `settlement_id` (`settlement_id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运营公司结算明细';
|
|
|
|
CREATE TABLE IF NOT EXISTS `fa_shopro_operating_company_settlement_log` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`settlement_id` int(11) NOT NULL COMMENT '结算单ID',
|
|
`action` varchar(30) NOT NULL COMMENT '操作',
|
|
`admin_id` int(11) NOT NULL DEFAULT 0 COMMENT '操作人',
|
|
`content` text COMMENT '内容',
|
|
`createtime` int(10) NOT NULL COMMENT '创建时间',
|
|
PRIMARY KEY (`id`) USING BTREE,
|
|
KEY `settlement_id` (`settlement_id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='运营公司结算日志';
|