EPT_BUSINESS_SCOPE.sql
2.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
/*
Navicat Oracle Data Transfer
Oracle Client Version : 12.2.0.1.0
Source Server : orcl
Source Server Version : 110200
Source Host : 127.0.0.1:1521
Source Schema : EPORT
Target Server Type : ORACLE
Target Server Version : 110200
File Encoding : 65001
Date: 2017-09-15 15:57:24
*/
-- ----------------------------
-- Table structure for EPT_BUSINESS_SCOPE
-- ----------------------------
DROP TABLE "EPORT"."EPT_BUSINESS_SCOPE";
CREATE TABLE "EPORT"."EPT_BUSINESS_SCOPE" (
"ID" NUMBER(11) NOT NULL ,
"CODE" NVARCHAR2(8) NULL ,
"NAME" NVARCHAR2(30) NULL ,
"SEQ_NO" NVARCHAR2(20) NULL ,
"CONT_CUSTOM" NVARCHAR2(50) NULL ,
"ECI_EMS_NO" NVARCHAR2(36) NULL ,
"CREATE_ID" NUMBER(11) NULL ,
"CREATE_DATE" DATE NULL ,
"UPDATE_ID" NUMBER(11) NULL ,
"UPDATE_DATE" DATE NULL ,
"IS_DELETE" NUMBER(11) NULL ,
"BOOK_ID" NUMBER(11) NULL ,
"NOTE" NVARCHAR2(255) NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;
COMMENT ON COLUMN "EPORT"."EPT_BUSINESS_SCOPE"."CODE" IS '类别编码';
COMMENT ON COLUMN "EPORT"."EPT_BUSINESS_SCOPE"."NAME" IS '类别名称';
COMMENT ON COLUMN "EPORT"."EPT_BUSINESS_SCOPE"."SEQ_NO" IS '企业内部编号';
COMMENT ON COLUMN "EPORT"."EPT_BUSINESS_SCOPE"."CONT_CUSTOM" IS '签约客户';
COMMENT ON COLUMN "EPORT"."EPT_BUSINESS_SCOPE"."ECI_EMS_NO" IS '账册编号';
COMMENT ON COLUMN "EPORT"."EPT_BUSINESS_SCOPE"."BOOK_ID" IS '账册ID';
COMMENT ON COLUMN "EPORT"."EPT_BUSINESS_SCOPE"."NOTE" IS '备注';
-- ----------------------------
-- Records of EPT_BUSINESS_SCOPE
-- ----------------------------
INSERT INTO "EPORT"."EPT_BUSINESS_SCOPE" VALUES ('1', '8501', '发动机及发电机', 'ZG2017051200015', null, '11111', '1', TO_DATE('2017-09-15 15:28:20', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-09-15 15:28:20', 'YYYY-MM-DD HH24:MI:SS'), '0', '1', null);
INSERT INTO "EPORT"."EPT_BUSINESS_SCOPE" VALUES ('2', '2710', '润滑油，不含生物柴油', 'ZG2017051200015', null, '11111', '1', TO_DATE('2017-09-15 15:29:39', 'YYYY-MM-DD HH24:MI:SS'), '1', TO_DATE('2017-09-15 15:29:39', 'YYYY-MM-DD HH24:MI:SS'), '0', '1', null);
-- ----------------------------
-- Indexes structure for table EPT_BUSINESS_SCOPE
-- ----------------------------
-- ----------------------------
-- Checks structure for table EPT_BUSINESS_SCOPE
-- ----------------------------
ALTER TABLE "EPORT"."EPT_BUSINESS_SCOPE" ADD CHECK ("ID" IS NOT NULL);
-- ----------------------------
-- Primary Key structure for table EPT_BUSINESS_SCOPE
-- ----------------------------
ALTER TABLE "EPORT"."EPT_BUSINESS_SCOPE" ADD PRIMARY KEY ("ID");