/*
|
Navicat SQLite Data Transfer
|
|
Source Server : aibatis_test_db
|
Source Server Version : 30714
|
Source Host : :0
|
|
Target Server Type : SQLite
|
Target Server Version : 30714
|
File Encoding : 65001
|
|
Date: 2017-07-20 12:34:55
|
*/
|
|
PRAGMA foreign_keys = OFF;
|
|
-- ----------------------------
|
-- Table structure for offline_visitor_register
|
-- ----------------------------
|
DROP TABLE IF EXISTS "main"."offline_visitor_register";
|
CREATE TABLE "offline_visitor_register" (
|
"visitor_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
"username" TEXT,
|
"mobile_phone" TEXT,
|
"gender_id" TEXT,
|
"identity_type_id" TEXT,
|
"country_id" TEXT,
|
"visitor_type_id" TEXT,
|
"identify_num" TEXT,
|
"company_id" TEXT,
|
"birthday" TEXT,
|
"remark" TEXT,
|
"raw_surveillance_photo_path" TEXT,
|
"raw_surveillance_photo_width" TEXT,
|
"raw_surveillance_photo_height" TEXT,
|
"surveillance_photo_path" TEXT,
|
"upload_custom_photo_path" TEXT,
|
"id_card_photo_path" TEXT,
|
"create_time" TEXT
|
);
|
