/*
 Navicat Premium Data Transfer

 Source Server         : 214_edw
 Source Server Type    : Oracle
 Source Server Version : 110200
 Source Host           : 192.168.0.214:1521
 Source Schema         : INMON

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

 Date: 03/12/2021 15:21:13
*/


-- ----------------------------
-- Table structure for TZ_W_PER_TEST
-- ----------------------------
DROP TABLE "INMON"."TZ_W_PER_TEST";
CREATE TABLE "INMON"."TZ_W_PER_TEST" (
  "ID" NUMBER(18) NOT NULL ,
  "DIAGNOSIS_NO" VARCHAR2(20 BYTE) ,
  "PERSONAL_NAME" VARCHAR2(50 BYTE) ,
  "SEX" NUMBER(18) ,
  "AGE" NUMBER(5) ,
  "AGE_UNITS" VARCHAR2(10 BYTE) ,
  "BIRTHDAY" DATE ,
  "BLOOD_TYPE" NUMBER(18) ,
  "RH_BLOOD_TYPE" NUMBER(18) ,
  "IDENTITYCARD" VARCHAR2(40 BYTE) ,
  "METIER" NUMBER(18) ,
  "NATION" NUMBER(18) ,
  "NATIONALITY" VARCHAR2(20 BYTE) ,
  "DIPLOMA" NUMBER(18) ,
  "MARITAL_STATUS" NUMBER(18) ,
  "HOMEPLACE_PROVINCE" VARCHAR2(100 BYTE) ,
  "HOMEPLACE_CITY" VARCHAR2(100 BYTE) ,
  "HOMEPLACE_COUNTY" VARCHAR2(100 BYTE) ,
  "NATIVE_PLACE_PROVINCE" VARCHAR2(100 BYTE) ,
  "NATIVE_PLACE_CITY" VARCHAR2(100 BYTE) ,
  "NATIVE_PLACE_COUNTY" VARCHAR2(100 BYTE) ,
  "CURRENT_ADDRESS_PROVINCE" VARCHAR2(100 BYTE) ,
  "CURRENT_ADDRESS_CITY" VARCHAR2(100 BYTE) ,
  "CURRENT_ADDRESS_COUNTY" VARCHAR2(100 BYTE) ,
  "CURRENT_ADDRESS_PHONE" VARCHAR2(40 BYTE) ,
  "CURRENT_ADDRESS_POSTCODE" VARCHAR2(40 BYTE) ,
  "HOUSEHOLD_PROVINCE" VARCHAR2(100 BYTE) ,
  "HOUSEHOLD_CITY" VARCHAR2(100 BYTE) ,
  "HOUSEHOLD_COUNTY" VARCHAR2(100 BYTE) ,
  "HOUSEHOLD_POSTCODE" VARCHAR2(40 BYTE) ,
  "WORK_COMPANY" VARCHAR2(100 BYTE) ,
  "COMPANY_ADDRESS" VARCHAR2(100 BYTE) ,
  "COMPANY_PHONE" VARCHAR2(40 BYTE) ,
  "COMPANY_POSTCODE" VARCHAR2(40 BYTE) ,
  "LINKMAN" VARCHAR2(50 BYTE) ,
  "LINKMAN_RELATION" NUMBER(18) ,
  "LINKMAN_ADDRESS" VARCHAR2(100 BYTE) ,
  "LINKMAN_PHONE" VARCHAR2(40 BYTE) ,
  "HEALTH_NUMBER" VARCHAR2(40 BYTE) ,
  "TREATMENT_CARD" VARCHAR2(40 BYTE) ,
  "CARD_VALIDATE" VARCHAR2(80 BYTE) ,
  "MEDICARE_TYPE" NUMBER(18) ,
  "MEDICARE_NUMBER" VARCHAR2(40 BYTE) ,
  "REGISTER_TIME" TIMESTAMP(6) ,
  "UPDATE_TIME" TIMESTAMP(6) ,
  "RECORD_STATE" NUMBER(1) ,
  "IDENTITY_TYPE" NUMBER(18) ,
  "CARD_TYPE" NUMBER(18) 
)
TABLESPACE "SPACE_BASE"
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of "TZ_W_PER_TEST"
-- ----------------------------
INSERT INTO "INMON"."TZ_W_PER_TEST" VALUES ('101248', '7987', 'jack', '2', '43', NULL, TO_DATE('1986-05-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, '450122198605043104', '27', '1', NULL, NULL, NULL, '123456789', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '12', NULL, '530600', NULL, '13', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, TO_TIMESTAMP('2016-07-20 11:31:09.000000', 'SYYYY-MM-DD HH24:MI:SS:FF6'), NULL, NULL, NULL, NULL);

-- ----------------------------
-- Checks structure for table TZ_W_PER_TEST
-- ----------------------------
ALTER TABLE "INMON"."TZ_W_PER_TEST" ADD CONSTRAINT "SYS_C0058844" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
