/*
 Navicat Premium Data Transfer

 Source Server         : saiyi
 Source Server Type    : SQLite
 Source Server Version : 3021000
 Source Schema         : main

 Target Server Type    : SQLite
 Target Server Version : 3021000
 File Encoding         : 65001

 Date: 24/08/2020 15:12:55
*/

PRAGMA foreign_keys = false;

-- ----------------------------
-- Table structure for summary
-- ----------------------------
DROP TABLE IF EXISTS "summary";
CREATE TABLE "summary" (
  "id" INTEGER NOT NULL,
  "sum_time" TEXT, -- 汇总时间
  "name" TEXT,  -- 姓名
  "other_expenses" real, -- 其他业务费
  "overdraft" real, -- 历史欠款
  "remark" TEXT, -- 备注
  PRIMARY KEY ("id")
);

PRAGMA foreign_keys = true;
