2020test/document/sys_bag.sql

/*
Navicat PGSQL Data Transfer

Source Server         : 本地测试pos库
Source Server Version : 90617
Source Host           : localhost:5432
Source Database       : pf
Source Schema         : public

Target Server Type    : PGSQL
Target Server Version : 90617
File Encoding         : 65001

Date: 2020-04-25 23:34:46
*/

CREATE SEQUENCE sys_id_seq;

-- ----------------------------
-- Table structure for sys_bag
-- ----------------------------
DROP TABLE IF EXISTS "public"."sys_bag";
CREATE TABLE "public"."sys_bag" (
"id" int2 DEFAULT nextval('sys_id_seq'::regclass) NOT NULL,
"type" varchar(255) COLLATE "default",
"texture" varchar(255) COLLATE "default",
"gsprice" varchar(128) COLLATE "default",
"bagprice" varchar(128) COLLATE "default",
"gs" varchar(255) COLLATE "default",
"kc" varchar(255) COLLATE "default",
"kcyj" varchar(255) COLLATE "default",
"startdate" date,
"enddate" date
)
WITH (OIDS=FALSE)

;

-- ----------------------------
-- Records of sys_bag
-- ----------------------------
INSERT INTO "public"."sys_bag" VALUES ('11', 'dd', '硬塑', '700', '670', 'CA', '77', '5', '2020-05-11', '2020-05-03');
INSERT INTO "public"."sys_bag" VALUES ('12', '美的', '硬塑', '40.58', '30.33', 'CZ', '70', '15', '2019-12-30', '2020-04-28');
INSERT INTO "public"."sys_bag" VALUES ('13', '1', '1', '1', '1', 'MU', '1', '1', '2020-03-30', '2020-04-30');
INSERT INTO "public"."sys_bag" VALUES ('15', '66', '66', '22', '2', 'ZA', '2', '2', '2020-03-30', '2020-05-03');
INSERT INTO "public"."sys_bag" VALUES ('16', '66', '66', '1', '5', 'CA', '5', '5', '2020-03-30', '2020-05-02');
INSERT INTO "public"."sys_bag" VALUES ('17', '99', '99', '3', '3', 'CA', '3', '1', '2020-03-30', '2020-05-01');
INSERT INTO "public"."sys_bag" VALUES ('18', '11', '66', '88', '7', 'CA', '8', '8', '2020-03-30', '2020-03-29');
INSERT INTO "public"."sys_bag" VALUES ('19', '66', '1', '2', '3', '5', '5', '5', '2020-03-30', '2020-04-16');
INSERT INTO "public"."sys_bag" VALUES ('20', '66', '99', '55', '5', 'NH', '5', '5', '2020-03-30', '2020-04-30');
INSERT INTO "public"."sys_bag" VALUES ('21', 'w', 'w', '4', '4', '4', '5', '5', '2020-03-30', '2020-04-30');
INSERT INTO "public"."sys_bag" VALUES ('22', '皮', '软壳', '300', '200', ' CA', '50', '9', '2019-12-30', '2020-05-14');

-- ----------------------------
-- Alter Sequences Owned By 
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table sys_bag
-- ----------------------------
ALTER TABLE "public"."sys_bag" ADD PRIMARY KEY ("id");