From 7685bd0a9f4d87503b992f8ef3c425d46b2e5a59 Mon Sep 17 00:00:00 2001
From: dupengyue <dupengyue@454eff88-639b-444f-9e54-f578c98de674>
Date: 星期五, 03 三月 2017 16:30:53 +0800
Subject: [PATCH] 建表SQL

---
 VisitFace/script/导出的face_discern.sql |  310 ++++++++++++++++++++++++++++++++++++++++++++
 VisitFace/script/face_discern.sql    |   81 +++++------
 2 files changed, 349 insertions(+), 42 deletions(-)

diff --git a/VisitFace/script/face_discern.sql b/VisitFace/script/face_discern.sql
index b12c953..e56f0ee 100644
--- a/VisitFace/script/face_discern.sql
+++ b/VisitFace/script/face_discern.sql
@@ -2,33 +2,33 @@
 #-----------------------------鎴戞槸鍒嗗壊绾�-------------------------------------------
 
 CREATE TABLE t_company(
-ID VARCHAR(32) PRIMARY KEY COMMENT '鍏徃涓婚敭',
+ID INT(10) PRIMARY KEY COMMENT '鍏徃涓婚敭',
 NAME VARCHAR(255) COMMENT '鍏徃鍚嶇О'
 )
 
 
 CREATE TABLE t_place(
-ID VARCHAR(32) PRIMARY KEY COMMENT '璁惧涓婚敭',
-companyID VARCHAR(32) COMMENT '鍏徃涓婚敭',
+ID INT(10) PRIMARY KEY COMMENT '璁惧涓婚敭',
+companyID INT(10) COMMENT '鍏徃涓婚敭',
 label VARCHAR(40) COMMENT '璁惧鍦扮偣',
 authorizationID VARCHAR(40) COMMENT '璁惧鎺堟潈鐮�',
 CONSTRAINT con_place_companyID FOREIGN KEY(companyID) REFERENCES t_company(ID)
 )
 
 CREATE TABLE t_department(
-ID VARCHAR(32) PRIMARY KEY COMMENT '閮ㄩ棬涓婚敭',
+ID INT(10) PRIMARY KEY COMMENT '閮ㄩ棬涓婚敭',
 label VARCHAR(40) COMMENT '閮ㄩ棬鍚嶇О',
 labelSpell CHAR(2) COMMENT '閮ㄩ棬棣栧瓧姣�'
 )
 
 
 CREATE TABLE t_post(
-ID VARCHAR(32) PRIMARY KEY COMMENT '鑱屼綅涓婚敭',
+ID INT(10) PRIMARY KEY COMMENT '鑱屼綅涓婚敭',
 label VARCHAR(40) COMMENT '鑱屼綅鍚嶇О'
 )
 
 CREATE TABLE t_person(
-ID VARCHAR(32) PRIMARY KEY COMMENT '浜哄憳涓婚敭',
+ID INT(10) PRIMARY KEY COMMENT '浜哄憳涓婚敭',
 NAME VARCHAR(40) COMMENT '浜哄憳鍚嶅瓧',
 nameSpell CHAR(2) COMMENT '浜哄憳鍚嶉瀛楁瘝',
 gender TINYINT(1) COMMENT '鎬у埆',
@@ -38,9 +38,9 @@
 mobilePhone CHAR(15) COMMENT '绉诲姩鐢佃瘽',
 identityType CHAR(40) COMMENT '璇佷欢绫诲瀷',
 identify VARCHAR(255) COMMENT '璇佷欢缂栧彿',
-companyID VARCHAR(32) COMMENT '鍏徃涓婚敭',
-departmentID VARCHAR(32) COMMENT '閮ㄩ棬涓婚敭',
-postID VARCHAR(32) COMMENT '鑱屽姟涓婚敭',
+companyID INT(10) COMMENT '鍏徃涓婚敭',
+departmentID INT(10) COMMENT '閮ㄩ棬涓婚敭',
+postID INT(10) COMMENT '鑱屽姟涓婚敭',
 remark VARCHAR(255) COMMENT '浜哄憳澶囨敞娑堟伅',
 warning VARCHAR(255) COMMENT '鍗遍櫓浜哄憳璀﹀憡娑堟伅',
 CONSTRAINT con_person_companyID FOREIGN KEY(companyID) REFERENCES t_company(ID),
@@ -50,81 +50,79 @@
 
 
 CREATE TABLE t_image(
-personID VARCHAR(32) COMMENT '浜哄憳涓婚敭',
+personID INT(10) COMMENT '浜哄憳涓婚敭',
 imageTye VARCHAR(32) COMMENT '鍥剧墖绫诲瀷',
 imagePath VARCHAR(255) COMMENT '鍥剧墖鍦板潃',
 CONSTRAINT con_image_personID FOREIGN KEY(personID) REFERENCES t_person(ID)
 )
 
 CREATE TABLE t_visitFace(
-ID VARCHAR(32) PRIMARY KEY COMMENT '璁垮鍥剧墖涓婚敭',
-personID VARCHAR(32) COMMENT '浜哄憳涓婚敭',
+ID INT(10) PRIMARY KEY COMMENT '璁垮鍥剧墖涓婚敭',
+personID INT(32) COMMENT '浜哄憳涓婚敭',
 imagePath VARCHAR(255) COMMENT '鍥剧墖鍦板潃',
 CONSTRAINT con_visitFace_personID FOREIGN KEY(personID) REFERENCES t_person(ID)
 )
 
 
-DROP TABLE t_employeeFace
 
 CREATE TABLE t_employeeFace(
-ID VARCHAR(32) PRIMARY KEY COMMENT '鍛樺伐鍥剧墖涓婚敭',
-registerCompanyID VARCHAR(32) COMMENT '娉ㄥ唽鍏徃涓婚敭',
-personID VARCHAR(32) COMMENT '浜哄憳涓婚敭',
+ID INT(32) PRIMARY KEY COMMENT '鍛樺伐鍥剧墖涓婚敭',
+registerCompanyID INT(32) COMMENT '娉ㄥ唽鍏徃涓婚敭',
+personID INT(32) COMMENT '浜哄憳涓婚敭',
 imagePath VARCHAR(255) COMMENT '鍥剧墖鍦板潃',
 CONSTRAINT con_employeeFace_personID FOREIGN KEY(personID) REFERENCES t_person(ID),
 CONSTRAINT con_employeeFace_registerCompanyID FOREIGN KEY(registerCompanyID) REFERENCES t_company(ID)
 )
 
-DROP TABLE t_visitorType
 
 CREATE TABLE t_visitorType(
-ID VARCHAR(32) PRIMARY KEY COMMENT '璁垮绫诲瀷涓婚敭',
+ID INT(32) PRIMARY KEY COMMENT '璁垮绫诲瀷涓婚敭',
 label VARCHAR(32) COMMENT '璁垮绫诲瀷',
-registerCompanyID VARCHAR(32) COMMENT '娉ㄥ唽鍏徃涓婚敭',
-personID VARCHAR(32) COMMENT '浜哄憳涓婚敭',
+registerCompanyID INT(32) COMMENT '娉ㄥ唽鍏徃涓婚敭',
+personID INT(32) COMMENT '浜哄憳涓婚敭',
 CONSTRAINT con_visitorType_personID FOREIGN KEY(personID) REFERENCES t_person(ID),
 CONSTRAINT con_visitorType_registerCompanyID FOREIGN KEY(registerCompanyID) REFERENCES t_company(ID)
 )
 
 CREATE TABLE t_visitStat(
-personID VARCHAR(32) COMMENT '浜哄憳涓婚敭',
-registerCompanyID VARCHAR(32) COMMENT '娉ㄥ唽鍏徃涓婚敭',
+personID INT(32) COMMENT '浜哄憳涓婚敭',
+registerCompanyID INT(32) COMMENT '娉ㄥ唽鍏徃涓婚敭',
 totalCount INTEGER(20) COMMENT '鏉ヨ鍏徃娆℃暟',
 CONSTRAINT con_visitStat_personID FOREIGN KEY(personID) REFERENCES t_person(ID),
 CONSTRAINT con_visitStat_registerCompanyID FOREIGN KEY(registerCompanyID) REFERENCES t_company(ID)
 )
 
 CREATE TABLE t_checkingCompany(
-personID VARCHAR(32) COMMENT '浜哄憳涓婚敭',
-companyID VARCHAR(32) COMMENT '鍏徃涓婚敭',
+personID INT(32) COMMENT '浜哄憳涓婚敭',
+companyID INT(32) COMMENT '鍏徃涓婚敭',
 CONSTRAINT con_checkingCompany_personID FOREIGN KEY(personID) REFERENCES t_person(ID),
 CONSTRAINT con_checkingCompany_registerCompanyID FOREIGN KEY(companyID) REFERENCES t_company(ID)
 )
 
 
 CREATE TABLE t_personExt(
-personID VARCHAR(32) COMMENT '浜哄憳涓婚敭',
+personID INT(32) COMMENT '浜哄憳涓婚敭',
 CONSTRAINT con_personExt_personID FOREIGN KEY(personID) REFERENCES t_person(ID)
 )
 
 
 
 CREATE TABLE t_checking(
-ID VARCHAR(32) PRIMARY KEY COMMENT '绛惧埌浜嬩欢涓婚敭',
-statusID INTEGER(2) COMMENT '绛惧埌鐘舵��',
+ID INT(32) PRIMARY KEY COMMENT '绛惧埌浜嬩欢涓婚敭',
+statusID TINYINT(2) COMMENT '绛惧埌鐘舵��',
 statusDT DATETIME COMMENT '绛惧埌鏃堕棿',
-personID VARCHAR(32) COMMENT '浜哄憳涓婚敭',
-placeID VARCHAR(32) COMMENT '绛惧埌浣嶇疆',
+personID INT(32) COMMENT '浜哄憳涓婚敭',
+placeID INT(32) COMMENT '绛惧埌浣嶇疆',
 CONSTRAINT con_checking_personID FOREIGN KEY(personID) REFERENCES t_person(ID),
 CONSTRAINT con_checking_placeID FOREIGN KEY(placeID) REFERENCES t_place(ID)
 )
 
 
 CREATE TABLE t_calling(
-ID VARCHAR(32) PRIMARY KEY COMMENT '绛惧埌浜嬩欢涓婚敭',
+ID INT(32) PRIMARY KEY COMMENT '绛惧埌浜嬩欢涓婚敭',
 callDT DATETIME COMMENT '鍛煎彨鏃堕棿',
-callerPersonID VARCHAR(32) COMMENT '鍛煎彨浜哄憳涓婚敭',
-calleePersonID VARCHAR(32) COMMENT '琚懠鍙汉鍛樹富閿�',
+callerPersonID INT(32) COMMENT '鍛煎彨浜哄憳涓婚敭',
+calleePersonID INT(32) COMMENT '琚懠鍙汉鍛樹富閿�',
 CONSTRAINT con_calling_callerPersonID FOREIGN KEY(callerPersonID) REFERENCES t_person(ID),
 CONSTRAINT con_calling_calleePersonID FOREIGN KEY(calleePersonID) REFERENCES t_person(ID)
 )
@@ -135,8 +133,8 @@
 
 
 CREATE TABLE t_visitMatter(
-ID VARCHAR(32) PRIMARY KEY COMMENT '璁块棶浜嬬敱涓婚敭',
-companyID VARCHAR(32) COMMENT '鍏徃涓婚敭',
+ID INT(32) PRIMARY KEY COMMENT '璁块棶浜嬬敱涓婚敭',
+companyID INT(32) COMMENT '鍏徃涓婚敭',
 label VARCHAR(40) COMMENT '璁块棶浜嬬敱',
 available TINYINT(1) COMMENT '鏄惁鏄�氱敤浜嬬敱',
 CONSTRAINT con_visitMatter_companyID FOREIGN KEY(companyID) REFERENCES t_company(ID)
@@ -145,10 +143,10 @@
 
 
 CREATE TABLE t_visit(
-ID VARCHAR(32) PRIMARY KEY COMMENT '璁块棶浜嬩欢涓婚敭',
-visitorPersonID VARCHAR(32) COMMENT '璁块棶浜哄憳涓婚敭',
-visiteePersonID VARCHAR(32) COMMENT '琚闂汉鍛樹富閿�',
-matterID VARCHAR(32) COMMENT '璁块棶浜嬬敱涓婚敭',
+ID INT(32) PRIMARY KEY COMMENT '璁块棶浜嬩欢涓婚敭',
+visitorPersonID INT(32) COMMENT '璁块棶浜哄憳涓婚敭',
+visiteePersonID INT(32) COMMENT '琚闂汉鍛樹富閿�',
+matterID INT(32) COMMENT '璁块棶浜嬬敱涓婚敭',
 remark VARCHAR(255) COMMENT '璁块棶澶囨敞',
 lastStatus INTEGER(40) COMMENT '鏈�鏂扮殑璁块棶鐘舵��',
 startTime DATETIME COMMENT '鏉ヨ鏃堕棿',
@@ -163,12 +161,11 @@
 
 
 CREATE TABLE t_visiting(
-ID VARCHAR(32) PRIMARY KEY COMMENT '璁块棶浜嬩欢娴佹按ID',
-visitID INTEGER(2) COMMENT '璁块棶浜嬩欢ID',
+ID INT(32) PRIMARY KEY COMMENT '璁块棶浜嬩欢娴佹按ID',
+visitID INT(32) COMMENT '璁块棶浜嬩欢ID',
 statusID DATETIME COMMENT '褰撳墠璁块棶鐘舵��',
 statusDT DATETIME COMMENT '鏇存柊鐘舵�佹椂闂�',
-placeID VARCHAR(32) COMMENT '璁惧浣嶇疆涓婚敭',
-CONSTRAINT con_visiting_personID FOREIGN KEY(personID) REFERENCES t_person(ID),
+placeID INT(32) COMMENT '璁惧浣嶇疆涓婚敭',
 CONSTRAINT con_visiting_placeID FOREIGN KEY(placeID) REFERENCES t_place(ID)
 )
 
diff --git "a/VisitFace/script/\345\257\274\345\207\272\347\232\204face_discern.sql" "b/VisitFace/script/\345\257\274\345\207\272\347\232\204face_discern.sql"
new file mode 100644
index 0000000..27843b6
--- /dev/null
+++ "b/VisitFace/script/\345\257\274\345\207\272\347\232\204face_discern.sql"
@@ -0,0 +1,310 @@
+/*
+SQLyog Ultimate v12.09 (64 bit)
+MySQL - 5.7.17 : Database - face_discern
+*********************************************************************
+*/

+
+/*!40101 SET NAMES utf8 */;
+
+/*!40101 SET SQL_MODE=''*/;
+
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+CREATE DATABASE /*!32312 IF NOT EXISTS*/`face_discern` /*!40100 DEFAULT CHARACTER SET utf8 */;
+
+USE `face_discern`;
+
+/*Table structure for table `t_calling` */
+
+DROP TABLE IF EXISTS `t_calling`;
+
+CREATE TABLE `t_calling` (
+  `ID` int(32) NOT NULL COMMENT '绛惧埌浜嬩欢涓婚敭',
+  `callDT` datetime DEFAULT NULL COMMENT '鍛煎彨鏃堕棿',
+  `callerPersonID` int(32) DEFAULT NULL COMMENT '鍛煎彨浜哄憳涓婚敭',
+  `calleePersonID` int(32) DEFAULT NULL COMMENT '琚懠鍙汉鍛樹富閿�',
+  PRIMARY KEY (`ID`),
+  KEY `con_calling_callerPersonID` (`callerPersonID`),
+  KEY `con_calling_calleePersonID` (`calleePersonID`),
+  CONSTRAINT `con_calling_calleePersonID` FOREIGN KEY (`calleePersonID`) REFERENCES `t_person` (`ID`),
+  CONSTRAINT `con_calling_callerPersonID` FOREIGN KEY (`callerPersonID`) REFERENCES `t_person` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_calling` */
+
+/*Table structure for table `t_checking` */
+
+DROP TABLE IF EXISTS `t_checking`;
+
+CREATE TABLE `t_checking` (
+  `ID` int(32) NOT NULL COMMENT '绛惧埌浜嬩欢涓婚敭',
+  `statusID` tinyint(2) DEFAULT NULL COMMENT '绛惧埌鐘舵��',
+  `statusDT` datetime DEFAULT NULL COMMENT '绛惧埌鏃堕棿',
+  `personID` int(32) DEFAULT NULL COMMENT '浜哄憳涓婚敭',
+  `placeID` int(32) DEFAULT NULL COMMENT '绛惧埌浣嶇疆',
+  PRIMARY KEY (`ID`),
+  KEY `con_checking_personID` (`personID`),
+  KEY `con_checking_placeID` (`placeID`),
+  CONSTRAINT `con_checking_personID` FOREIGN KEY (`personID`) REFERENCES `t_person` (`ID`),
+  CONSTRAINT `con_checking_placeID` FOREIGN KEY (`placeID`) REFERENCES `t_place` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_checking` */
+
+/*Table structure for table `t_checkingcompany` */
+
+DROP TABLE IF EXISTS `t_checkingcompany`;
+
+CREATE TABLE `t_checkingcompany` (
+  `personID` int(32) DEFAULT NULL COMMENT '浜哄憳涓婚敭',
+  `companyID` int(32) DEFAULT NULL COMMENT '鍏徃涓婚敭',
+  KEY `con_checkingCompany_personID` (`personID`),
+  KEY `con_checkingCompany_registerCompanyID` (`companyID`),
+  CONSTRAINT `con_checkingCompany_personID` FOREIGN KEY (`personID`) REFERENCES `t_person` (`ID`),
+  CONSTRAINT `con_checkingCompany_registerCompanyID` FOREIGN KEY (`companyID`) REFERENCES `t_company` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_checkingcompany` */
+
+/*Table structure for table `t_company` */
+
+DROP TABLE IF EXISTS `t_company`;
+
+CREATE TABLE `t_company` (
+  `ID` int(10) NOT NULL COMMENT '鍏徃涓婚敭',
+  `NAME` varchar(255) DEFAULT NULL COMMENT '鍏徃鍚嶇О',
+  PRIMARY KEY (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_company` */
+
+/*Table structure for table `t_department` */
+
+DROP TABLE IF EXISTS `t_department`;
+
+CREATE TABLE `t_department` (
+  `ID` int(10) NOT NULL COMMENT '閮ㄩ棬涓婚敭',
+  `label` varchar(40) DEFAULT NULL COMMENT '閮ㄩ棬鍚嶇О',
+  `labelSpell` char(2) DEFAULT NULL COMMENT '閮ㄩ棬棣栧瓧姣�',
+  PRIMARY KEY (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_department` */
+
+/*Table structure for table `t_employeeface` */
+
+DROP TABLE IF EXISTS `t_employeeface`;
+
+CREATE TABLE `t_employeeface` (
+  `ID` int(32) NOT NULL COMMENT '鍛樺伐鍥剧墖涓婚敭',
+  `registerCompanyID` int(32) DEFAULT NULL COMMENT '娉ㄥ唽鍏徃涓婚敭',
+  `personID` int(32) DEFAULT NULL COMMENT '浜哄憳涓婚敭',
+  `imagePath` varchar(255) DEFAULT NULL COMMENT '鍥剧墖鍦板潃',
+  PRIMARY KEY (`ID`),
+  KEY `con_employeeFace_personID` (`personID`),
+  KEY `con_employeeFace_registerCompanyID` (`registerCompanyID`),
+  CONSTRAINT `con_employeeFace_personID` FOREIGN KEY (`personID`) REFERENCES `t_person` (`ID`),
+  CONSTRAINT `con_employeeFace_registerCompanyID` FOREIGN KEY (`registerCompanyID`) REFERENCES `t_company` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_employeeface` */
+
+/*Table structure for table `t_image` */
+
+DROP TABLE IF EXISTS `t_image`;
+
+CREATE TABLE `t_image` (
+  `personID` int(10) DEFAULT NULL COMMENT '浜哄憳涓婚敭',
+  `imageTye` varchar(32) DEFAULT NULL COMMENT '鍥剧墖绫诲瀷',
+  `imagePath` varchar(255) DEFAULT NULL COMMENT '鍥剧墖鍦板潃',
+  KEY `con_image_personID` (`personID`),
+  CONSTRAINT `con_image_personID` FOREIGN KEY (`personID`) REFERENCES `t_person` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_image` */
+
+/*Table structure for table `t_person` */
+
+DROP TABLE IF EXISTS `t_person`;
+
+CREATE TABLE `t_person` (
+  `ID` int(10) NOT NULL COMMENT '浜哄憳涓婚敭',
+  `NAME` varchar(40) DEFAULT NULL COMMENT '浜哄憳鍚嶅瓧',
+  `nameSpell` char(2) DEFAULT NULL COMMENT '浜哄憳鍚嶉瀛楁瘝',
+  `gender` tinyint(1) DEFAULT NULL COMMENT '鎬у埆',
+  `country` char(20) DEFAULT NULL COMMENT '鍥界睄',
+  `birthday` date DEFAULT NULL COMMENT '鍑虹敓鏃ユ湡',
+  `phone` char(12) DEFAULT NULL COMMENT '搴ф満鐢佃瘽',
+  `mobilePhone` char(15) DEFAULT NULL COMMENT '绉诲姩鐢佃瘽',
+  `identityType` char(40) DEFAULT NULL COMMENT '璇佷欢绫诲瀷',
+  `identify` varchar(255) DEFAULT NULL COMMENT '璇佷欢缂栧彿',
+  `companyID` int(10) DEFAULT NULL COMMENT '鍏徃涓婚敭',
+  `departmentID` int(10) DEFAULT NULL COMMENT '閮ㄩ棬涓婚敭',
+  `postID` int(10) DEFAULT NULL COMMENT '鑱屽姟涓婚敭',
+  `remark` varchar(255) DEFAULT NULL COMMENT '浜哄憳澶囨敞娑堟伅',
+  `warning` varchar(255) DEFAULT NULL COMMENT '鍗遍櫓浜哄憳璀﹀憡娑堟伅',
+  PRIMARY KEY (`ID`),
+  KEY `con_person_companyID` (`companyID`),
+  KEY `con_person_departmentID` (`departmentID`),
+  KEY `con_person_postID` (`postID`),
+  CONSTRAINT `con_person_companyID` FOREIGN KEY (`companyID`) REFERENCES `t_company` (`ID`),
+  CONSTRAINT `con_person_departmentID` FOREIGN KEY (`departmentID`) REFERENCES `t_department` (`ID`),
+  CONSTRAINT `con_person_postID` FOREIGN KEY (`postID`) REFERENCES `t_post` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_person` */
+
+/*Table structure for table `t_personext` */
+
+DROP TABLE IF EXISTS `t_personext`;
+
+CREATE TABLE `t_personext` (
+  `personID` int(32) DEFAULT NULL COMMENT '浜哄憳涓婚敭',
+  KEY `con_personExt_personID` (`personID`),
+  CONSTRAINT `con_personExt_personID` FOREIGN KEY (`personID`) REFERENCES `t_person` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_personext` */
+
+/*Table structure for table `t_place` */
+
+DROP TABLE IF EXISTS `t_place`;
+
+CREATE TABLE `t_place` (
+  `ID` int(10) NOT NULL COMMENT '璁惧涓婚敭',
+  `companyID` int(10) DEFAULT NULL COMMENT '鍏徃涓婚敭',
+  `label` varchar(40) DEFAULT NULL COMMENT '璁惧鍦扮偣',
+  `authorizationID` varchar(40) DEFAULT NULL COMMENT '璁惧鎺堟潈鐮�',
+  PRIMARY KEY (`ID`),
+  KEY `con_place_companyID` (`companyID`),
+  CONSTRAINT `con_place_companyID` FOREIGN KEY (`companyID`) REFERENCES `t_company` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_place` */
+
+/*Table structure for table `t_post` */
+
+DROP TABLE IF EXISTS `t_post`;
+
+CREATE TABLE `t_post` (
+  `ID` int(10) NOT NULL COMMENT '鑱屼綅涓婚敭',
+  `label` varchar(40) DEFAULT NULL COMMENT '鑱屼綅鍚嶇О',
+  PRIMARY KEY (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_post` */
+
+/*Table structure for table `t_visit` */
+
+DROP TABLE IF EXISTS `t_visit`;
+
+CREATE TABLE `t_visit` (
+  `ID` int(32) NOT NULL COMMENT '璁块棶浜嬩欢涓婚敭',
+  `visitorPersonID` int(32) DEFAULT NULL COMMENT '璁块棶浜哄憳涓婚敭',
+  `visiteePersonID` int(32) DEFAULT NULL COMMENT '琚闂汉鍛樹富閿�',
+  `matterID` int(32) DEFAULT NULL COMMENT '璁块棶浜嬬敱涓婚敭',
+  `remark` varchar(255) DEFAULT NULL COMMENT '璁块棶澶囨敞',
+  `lastStatus` int(40) DEFAULT NULL COMMENT '鏈�鏂扮殑璁块棶鐘舵��',
+  `startTime` datetime DEFAULT NULL COMMENT '鏉ヨ鏃堕棿',
+  `lastTime` datetime DEFAULT NULL COMMENT '绛剧鏃堕棿',
+  `visitorTypeLabel` varchar(32) DEFAULT NULL COMMENT '璁垮绫诲瀷',
+  `warning` varchar(255) DEFAULT NULL COMMENT '褰撳墠璁块棶鐨勮鍛婄姸鎬�',
+  PRIMARY KEY (`ID`),
+  KEY `con_visit_visitorPersonID` (`visitorPersonID`),
+  KEY `con_visit_visiteePersonID` (`visiteePersonID`),
+  KEY `con_visit_matterID` (`matterID`),
+  CONSTRAINT `con_visit_matterID` FOREIGN KEY (`matterID`) REFERENCES `t_visitmatter` (`ID`),
+  CONSTRAINT `con_visit_visiteePersonID` FOREIGN KEY (`visiteePersonID`) REFERENCES `t_person` (`ID`),
+  CONSTRAINT `con_visit_visitorPersonID` FOREIGN KEY (`visitorPersonID`) REFERENCES `t_person` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_visit` */
+
+/*Table structure for table `t_visitface` */
+
+DROP TABLE IF EXISTS `t_visitface`;
+
+CREATE TABLE `t_visitface` (
+  `ID` int(10) NOT NULL COMMENT '璁垮鍥剧墖涓婚敭',
+  `personID` int(32) DEFAULT NULL COMMENT '浜哄憳涓婚敭',
+  `imagePath` varchar(255) DEFAULT NULL COMMENT '鍥剧墖鍦板潃',
+  PRIMARY KEY (`ID`),
+  KEY `con_visitFace_personID` (`personID`),
+  CONSTRAINT `con_visitFace_personID` FOREIGN KEY (`personID`) REFERENCES `t_person` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_visitface` */
+
+/*Table structure for table `t_visiting` */
+
+DROP TABLE IF EXISTS `t_visiting`;
+
+CREATE TABLE `t_visiting` (
+  `ID` int(32) NOT NULL COMMENT '璁块棶浜嬩欢娴佹按ID',
+  `visitID` int(32) DEFAULT NULL COMMENT '璁块棶浜嬩欢ID',
+  `statusID` datetime DEFAULT NULL COMMENT '褰撳墠璁块棶鐘舵��',
+  `statusDT` datetime DEFAULT NULL COMMENT '鏇存柊鐘舵�佹椂闂�',
+  `placeID` int(32) DEFAULT NULL COMMENT '璁惧浣嶇疆涓婚敭',
+  PRIMARY KEY (`ID`),
+  KEY `con_visiting_placeID` (`placeID`),
+  CONSTRAINT `con_visiting_placeID` FOREIGN KEY (`placeID`) REFERENCES `t_place` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_visiting` */
+
+/*Table structure for table `t_visitmatter` */
+
+DROP TABLE IF EXISTS `t_visitmatter`;
+
+CREATE TABLE `t_visitmatter` (
+  `ID` int(32) NOT NULL COMMENT '璁块棶浜嬬敱涓婚敭',
+  `companyID` int(32) DEFAULT NULL COMMENT '鍏徃涓婚敭',
+  `label` varchar(40) DEFAULT NULL COMMENT '璁块棶浜嬬敱',
+  `available` tinyint(1) DEFAULT NULL COMMENT '鏄惁鏄�氱敤浜嬬敱',
+  PRIMARY KEY (`ID`),
+  KEY `con_visitMatter_companyID` (`companyID`),
+  CONSTRAINT `con_visitMatter_companyID` FOREIGN KEY (`companyID`) REFERENCES `t_company` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_visitmatter` */
+
+/*Table structure for table `t_visitortype` */
+
+DROP TABLE IF EXISTS `t_visitortype`;
+
+CREATE TABLE `t_visitortype` (
+  `ID` int(32) NOT NULL COMMENT '璁垮绫诲瀷涓婚敭',
+  `label` varchar(32) DEFAULT NULL COMMENT '璁垮绫诲瀷',
+  `registerCompanyID` int(32) DEFAULT NULL COMMENT '娉ㄥ唽鍏徃涓婚敭',
+  `personID` int(32) DEFAULT NULL COMMENT '浜哄憳涓婚敭',
+  PRIMARY KEY (`ID`),
+  KEY `con_visitorType_personID` (`personID`),
+  KEY `con_visitorType_registerCompanyID` (`registerCompanyID`),
+  CONSTRAINT `con_visitorType_personID` FOREIGN KEY (`personID`) REFERENCES `t_person` (`ID`),
+  CONSTRAINT `con_visitorType_registerCompanyID` FOREIGN KEY (`registerCompanyID`) REFERENCES `t_company` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_visitortype` */
+
+/*Table structure for table `t_visitstat` */
+
+DROP TABLE IF EXISTS `t_visitstat`;
+
+CREATE TABLE `t_visitstat` (
+  `personID` int(32) DEFAULT NULL COMMENT '浜哄憳涓婚敭',
+  `registerCompanyID` int(32) DEFAULT NULL COMMENT '娉ㄥ唽鍏徃涓婚敭',
+  `totalCount` int(20) DEFAULT NULL COMMENT '鏉ヨ鍏徃娆℃暟',
+  KEY `con_visitStat_personID` (`personID`),
+  KEY `con_visitStat_registerCompanyID` (`registerCompanyID`),
+  CONSTRAINT `con_visitStat_personID` FOREIGN KEY (`personID`) REFERENCES `t_person` (`ID`),
+  CONSTRAINT `con_visitStat_registerCompanyID` FOREIGN KEY (`registerCompanyID`) REFERENCES `t_company` (`ID`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+/*Data for the table `t_visitstat` */
+
+/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
+/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
+/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

--
Gitblit v1.8.0