/*
Navicat Oracle Data Transfer
Oracle Client Version : 10.2.0.5.0

Source Server         : 192.168.0.129_1521_ORCL
Source Server Version : 110200
Source Host           : 192.168.0.129:1521
Source Schema         : SYSTEM

Target Server Type    : ORACLE
Target Server Version : 110200
File Encoding         : 65001

Date: 2017-04-15 00:15:46
*/


-- ----------------------------
-- Table structure for REGION
-- ----------------------------
DROP TABLE "SYSTEM"."REGION";
CREATE TABLE "SYSTEM"."REGION" (
"ID" VARCHAR2(255 BYTE) NOT NULL ,
"NAME" VARCHAR2(255 BYTE) NULL ,
"DESC" VARCHAR2(255 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON TABLE "SYSTEM"."REGION" IS '区域表';
COMMENT ON COLUMN "SYSTEM"."REGION"."DESC" IS '描述';

-- ----------------------------
-- Table structure for SITES
-- ----------------------------
DROP TABLE "SYSTEM"."SITES";
CREATE TABLE "SYSTEM"."SITES" (
"ID" VARCHAR2(255 BYTE) NOT NULL ,
"LOCATION" VARCHAR2(255 BYTE) NULL ,
"CREATE_TIME" DATE NULL ,
"UPDATE_TIME" DATE NULL ,
"PARENT_ID" VARCHAR2(255 BYTE) NULL ,
"REGION_ID" VARCHAR2(255 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON TABLE "SYSTEM"."SITES" IS '站点表';
COMMENT ON COLUMN "SYSTEM"."SITES"."LOCATION" IS '地理位置';
COMMENT ON COLUMN "SYSTEM"."SITES"."PARENT_ID" IS '父级站点ID';
COMMENT ON COLUMN "SYSTEM"."SITES"."REGION_ID" IS '区域ID';

-- ----------------------------
-- Table structure for USERS
-- ----------------------------
DROP TABLE "SYSTEM"."USERS";
CREATE TABLE "SYSTEM"."USERS" (
"ID" VARCHAR2(255 BYTE) NOT NULL ,
"USERNAME" VARCHAR2(255 BYTE) NULL ,
"NAME" VARCHAR2(255 BYTE) NULL ,
"PASSWORD" VARCHAR2(255 BYTE) NULL ,
"TYPE" VARCHAR2(255 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON TABLE "SYSTEM"."USERS" IS '用户表';
COMMENT ON COLUMN "SYSTEM"."USERS"."TYPE" IS '员工类型，揽收、分拣、封发、转运、投送、信息录入、查询、市场开发、疑难快件处理';

-- ----------------------------
-- Table structure for WAYBILL
-- ----------------------------
DROP TABLE "SYSTEM"."WAYBILL";
CREATE TABLE "SYSTEM"."WAYBILL" (
"ID" VARCHAR2(255 BYTE) NOT NULL ,
"FROM" VARCHAR2(255 BYTE) NULL ,
"DEPARTURE" VARCHAR2(255 BYTE) NULL ,
"COMPANY_NAME" VARCHAR2(255 BYTE) NULL ,
"ADDRESS" VARCHAR2(255 BYTE) NULL ,
"PHONE" VARCHAR2(255 BYTE) NULL ,
"POSTAL_CODE" VARCHAR2(255 BYTE) NULL ,
"TO" VARCHAR2(255 BYTE) NULL ,
"TO_PHONE" VARCHAR2(255 BYTE) NULL ,
"TO_COMPANY_NAME" VARCHAR2(255 BYTE) NULL ,
"TO_ADDRESS" VARCHAR2(255 BYTE) NULL ,
"TO_POSTAL_CODE" VARCHAR2(255 BYTE) NULL ,
"CREATE_TIME" DATE NULL ,
"UPDATE_TIME" DATE NULL ,
"USER_ID" VARCHAR2(255 BYTE) NULL ,
"STATUS" VARCHAR2(255 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON TABLE "SYSTEM"."WAYBILL" IS '快递单';
COMMENT ON COLUMN "SYSTEM"."WAYBILL"."FROM" IS '寄件人姓名';
COMMENT ON COLUMN "SYSTEM"."WAYBILL"."DEPARTURE" IS '始发地';
COMMENT ON COLUMN "SYSTEM"."WAYBILL"."COMPANY_NAME" IS '单位名称';
COMMENT ON COLUMN "SYSTEM"."WAYBILL"."ADDRESS" IS '寄件地址';
COMMENT ON COLUMN "SYSTEM"."WAYBILL"."PHONE" IS '联系电话';
COMMENT ON COLUMN "SYSTEM"."WAYBILL"."TO" IS '收件人';
COMMENT ON COLUMN "SYSTEM"."WAYBILL"."STATUS" IS '待发货，已揽件，已签收';

-- ----------------------------
-- Table structure for WAYBILL_STATUS
-- ----------------------------
DROP TABLE "SYSTEM"."WAYBILL_STATUS";
CREATE TABLE "SYSTEM"."WAYBILL_STATUS" (
"ID" VARCHAR2(255 BYTE) NOT NULL ,
"WAYBILL_ID" VARCHAR2(255 BYTE) NULL ,
"CREATE_TIME" DATE NULL ,
"USER_ID" VARCHAR2(255 BYTE) NULL ,
"DESC" VARCHAR2(255 BYTE) NULL ,
"LOCATION" VARCHAR2(255 BYTE) NULL 
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON TABLE "SYSTEM"."WAYBILL_STATUS" IS '快递单物流信息表';
COMMENT ON COLUMN "SYSTEM"."WAYBILL_STATUS"."WAYBILL_ID" IS '快递单ID';
COMMENT ON COLUMN "SYSTEM"."WAYBILL_STATUS"."CREATE_TIME" IS '时间';
COMMENT ON COLUMN "SYSTEM"."WAYBILL_STATUS"."USER_ID" IS '负责人';
COMMENT ON COLUMN "SYSTEM"."WAYBILL_STATUS"."DESC" IS '备注';
COMMENT ON COLUMN "SYSTEM"."WAYBILL_STATUS"."LOCATION" IS '包裹所在位置';

-- ----------------------------
-- Indexes structure for table REGION
-- ----------------------------

-- ----------------------------
-- Checks structure for table REGION
-- ----------------------------
ALTER TABLE "SYSTEM"."REGION" ADD CHECK ("ID" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table REGION
-- ----------------------------
ALTER TABLE "SYSTEM"."REGION" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table SITES
-- ----------------------------

-- ----------------------------
-- Checks structure for table SITES
-- ----------------------------
ALTER TABLE "SYSTEM"."SITES" ADD CHECK ("ID" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table SITES
-- ----------------------------
ALTER TABLE "SYSTEM"."SITES" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table USERS
-- ----------------------------

-- ----------------------------
-- Checks structure for table USERS
-- ----------------------------
ALTER TABLE "SYSTEM"."USERS" ADD CHECK ("ID" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table USERS
-- ----------------------------
ALTER TABLE "SYSTEM"."USERS" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table WAYBILL
-- ----------------------------

-- ----------------------------
-- Checks structure for table WAYBILL
-- ----------------------------
ALTER TABLE "SYSTEM"."WAYBILL" ADD CHECK ("ID" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table WAYBILL
-- ----------------------------
ALTER TABLE "SYSTEM"."WAYBILL" ADD PRIMARY KEY ("ID");

-- ----------------------------
-- Indexes structure for table WAYBILL_STATUS
-- ----------------------------

-- ----------------------------
-- Checks structure for table WAYBILL_STATUS
-- ----------------------------
ALTER TABLE "SYSTEM"."WAYBILL_STATUS" ADD CHECK ("ID" IS NOT NULL);

-- ----------------------------
-- Primary Key structure for table WAYBILL_STATUS
-- ----------------------------
ALTER TABLE "SYSTEM"."WAYBILL_STATUS" ADD PRIMARY KEY ("ID");