ddl(ecif)

63 阅读 0 评论 42 点赞

我是靠谱客的博主端庄爆米花，最近开发中收集的这篇文章主要介绍ddl(ecif)，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

VIP层级表

CREATE TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER"

( "ECIF_PARTYNO" VARCHAR2(20) CONSTRAINT "NN_A_PTY_TM_VIP_TIER_ECIF_NO" NOT NULL ENABLE,

"VIP_SRC" VARCHAR2(20) NOT NULL ENABLE,

"VIP_SEQ" NUMBER NOT NULL ENABLE,

"VIP_TIER" VARCHAR2(20) NOT NULL ENABLE,

"ENABLE" VARCHAR2(20) NOT NULL ENABLE,

"VIP_START" DATE NOT NULL ENABLE,

"VIP_END" DATE NOT NULL ENABLE,

"IS_HONOUR" VARCHAR2(20) NOT NULL ENABLE,

"VIP_CHANGE_DESC" VARCHAR2(500),

"VIP_CHANGE_FLAG" VARCHAR2(20),

"CREATED_BY" VARCHAR2(50) NOT NULL ENABLE,

"CREATED_DT" DATE NOT NULL ENABLE,

"UPDATED_BY" VARCHAR2(50) NOT NULL ENABLE,

"UPDATED_DT" DATE NOT NULL ENABLE,

"SRC_SYS_NAME" VARCHAR2(10) NOT NULL ENABLE,

"ETL_UPDATE_TIME" DATE NOT NULL ENABLE,

CONSTRAINT "PK_A_PTY_TM_VIP_TIER" PRIMARY KEY ("ECIF_PARTYNO", "VIP_SRC", "VIP_SEQ")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE UNIQUE INDEX "ATO_DATA"."PK_A_PTY_TM_VIP_TIER" ON "ATO_DATA"."A_PTY_TM_VIP_TIER" ("ECIF_PARTYNO", "VIP_SRC", "VIP_SEQ")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("ECIF_PARTYNO" CONSTRAINT "NN_A_PTY_TM_VIP_TIER_ECIF_NO" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("VIP_SRC" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("VIP_SEQ" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("VIP_TIER" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("ENABLE" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("VIP_START" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("VIP_END" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("IS_HONOUR" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("CREATED_BY" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("CREATED_DT" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("UPDATED_BY" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("UPDATED_DT" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("SRC_SYS_NAME" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" MODIFY ("ETL_UPDATE_TIME" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" ADD CONSTRAINT "PK_A_PTY_TM_VIP_TIER" PRIMARY KEY ("ECIF_PARTYNO", "VIP_SRC", "VIP_SEQ")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE;

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."ECIF_PARTYNO" IS 'ECIF客户号,引用TM_PERSON_BASE_INFO.ECIF_PARTYNO';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."VIP_SRC" IS 'VIP来源';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."VIP_SEQ" IS 'VIP序号';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."VIP_TIER" IS 'VIP层级（0-普通客户；1-银卡客户；2-金卡客户；3-钻石卡客户；）';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."ENABLE" IS 'VIP当前层级标志（Y/N）';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."VIP_START" IS 'VIP开始时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."VIP_END" IS 'VIP结束时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."IS_HONOUR" IS '荣誉VIP标志(Y/N)';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."VIP_CHANGE_DESC" IS 'VIP层级变更原因';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."VIP_CHANGE_FLAG" IS '升降级标志(0-不变，1-升级，2-降级)';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."CREATED_BY" IS '创建者';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."CREATED_DT" IS '创建时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."UPDATED_BY" IS '更新者';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."UPDATED_DT" IS '更新时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."SRC_SYS_NAME" IS '源系统名';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_VIP_TIER"."ETL_UPDATE_TIME" IS '数据加载时间';

COMMENT ON TABLE "ATO_DATA"."A_PTY_TM_VIP_TIER" IS 'VIP层级表';

GRANT DELETE ON "ATO_DATA"."A_PTY_TM_VIP_TIER" TO "DW_CODE" WITH GRANT OPTION;

GRANT INSERT ON "ATO_DATA"."A_PTY_TM_VIP_TIER" TO "DW_CODE" WITH GRANT OPTION;

GRANT SELECT ON "ATO_DATA"."A_PTY_TM_VIP_TIER" TO "DW_CODE" WITH GRANT OPTION;

GRANT UPDATE ON "ATO_DATA"."A_PTY_TM_VIP_TIER" TO "DW_CODE" WITH GRANT OPTION;

来源客户信息表

CREATE TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"

( "SRC_SYS_ID" VARCHAR2(20) CONSTRAINT "NN_SRC_SYS_ID" NOT NULL ENABLE,

"SRC_PARTYNO" VARCHAR2(100) NOT NULL ENABLE,

"ECIF_PARTYNO" VARCHAR2(20),

"BE_MERGER_TO" VARCHAR2(20),

"MERGER_RULE_ID" VARCHAR2(20),

"NAME" VARCHAR2(500),

"SEX" VARCHAR2(20),

"BIRTHDAY" DATE,

"CREATED_BY" VARCHAR2(50) NOT NULL ENABLE,

"CREATED_DT" DATE NOT NULL ENABLE,

"UPDATED_BY" VARCHAR2(50) NOT NULL ENABLE,

"UPDATED_DT" DATE NOT NULL ENABLE,

"SRC_SYS_NAME" VARCHAR2(10) NOT NULL ENABLE,

"ETL_UPDATE_TIME" DATE NOT NULL ENABLE,

CONSTRAINT "PK_A_PTY_TM_SRC_PSN_BASE_INFO" PRIMARY KEY ("SRC_SYS_ID", "SRC_PARTYNO")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE UNIQUE INDEX "ATO_DATA"."PK_A_PTY_TM_SRC_PSN_BASE_INFO" ON "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" ("SRC_SYS_ID", "SRC_PARTYNO")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

ALTER TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" MODIFY ("SRC_SYS_ID" CONSTRAINT "NN_SRC_SYS_ID" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" MODIFY ("SRC_PARTYNO" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" MODIFY ("CREATED_BY" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" MODIFY ("CREATED_DT" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" MODIFY ("UPDATED_BY" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" MODIFY ("UPDATED_DT" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" MODIFY ("SRC_SYS_NAME" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" MODIFY ("ETL_UPDATE_TIME" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" ADD CONSTRAINT "PK_A_PTY_TM_SRC_PSN_BASE_INFO" PRIMARY KEY ("SRC_SYS_ID", "SRC_PARTYNO")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE;

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."SRC_SYS_ID" IS '源系统ID,引用TC_SRC_SYS_ID.SRC_SYS_ID';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."SRC_PARTYNO" IS '源系统客户号';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."NAME" IS '姓名';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."SEX" IS '性别';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."BIRTHDAY" IS '生日';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."CREATED_BY" IS '创建者';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."CREATED_DT" IS '创建时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."UPDATED_BY" IS '更新者';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."UPDATED_DT" IS '更新时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."SRC_SYS_NAME" IS '源系统名';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO"."ETL_UPDATE_TIME" IS '数据加载时间';

COMMENT ON TABLE "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" IS '来源客户信息表';

GRANT DELETE ON "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" TO "DW_CODE" WITH GRANT OPTION;

GRANT INSERT ON "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" TO "DW_CODE" WITH GRANT OPTION;

GRANT SELECT ON "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" TO "DW_CODE" WITH GRANT OPTION;

GRANT UPDATE ON "ATO_DATA"."A_PTY_TM_SRC_PERSON_BASE_INFO" TO "DW_CODE" WITH GRANT OPTION;

黑名单个人信息

CREATE TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"

( "SID" VARCHAR2(32),

"PARTY_ID" NUMBER(12,0),

"PARTY_TYPE" VARCHAR2(10),

"SRC_SYS_ID" VARCHAR2(10),

"SRC_PARTY_ID" NUMBER(10,0),

"BLACK_LIST_CATEGORY_1" VARCHAR2(10),

"BLACK_LIST_CATEGORY_2" VARCHAR2(10),

"BLACK_LIST_CATEGORY_3" VARCHAR2(10),

"RISK_LEVEL" VARCHAR2(6),

"FULL_NAME" VARCHAR2(200),

"GENDER" CHAR(1) DEFAULT 'N',

"BIRTHDAY" DATE,

"NATIONALITY" VARCHAR2(3),

"NATION_CODE" VARCHAR2(2),

"JOB_CATE_ID" VARCHAR2(6),

"JOB_COMPANY" VARCHAR2(60),

"RESIDENCE_PLACE" VARCHAR2(100),

"EDUCATION_ID" VARCHAR2(2),

"RISK_CAUSE" VARCHAR2(4000),

"OTHER" VARCHAR2(4000),

"PHOTO_URL" VARCHAR2(300),

"REVIEW_STATE" VARCHAR2(6),

"REVIEW_PERSON" VARCHAR2(50),

"CREATED_BY" VARCHAR2(50),

"CREATED_DATE" DATE,

"UPDATED_BY" VARCHAR2(50),

"UPDATED_DATE" DATE,

"DEL_FLAG" CHAR(1) DEFAULT 'N',

"JOB_NAME" VARCHAR2(200),

"SRC_SYS_NAME" VARCHAR2(10),

"ETL_UPDATE_TIME" DATE DEFAULT SYSDATE,

CONSTRAINT "PK_A_PTY_TM_BLACK_LIST_PERSON" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE INDEX "ATO_DATA"."IDX_A_PTY_TM_BLACK_LIST_PERSON" ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON" ("ETL_UPDATE_TIME")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE UNIQUE INDEX "ATO_DATA"."PK_A_PTY_TM_BLACK_LIST_PERSON" ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON" ("SID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

ALTER TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON" ADD CONSTRAINT "PK_A_PTY_TM_BLACK_LIST_PERSON" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE;

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."SID" IS '记录唯一值';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."PARTY_ID" IS '客户唯一编号';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."PARTY_TYPE" IS '参与方类型';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."SRC_SYS_ID" IS '外部系统';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."SRC_PARTY_ID" IS '源系统客户号';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."BLACK_LIST_CATEGORY_1" IS '黑名单一级分类';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."BLACK_LIST_CATEGORY_2" IS '黑名单二级分类';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."BLACK_LIST_CATEGORY_3" IS '黑名单三级分类';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."RISK_LEVEL" IS '风险等级';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."FULL_NAME" IS '姓名';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."GENDER" IS '性别';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."BIRTHDAY" IS '出生日期';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."NATIONALITY" IS '国籍';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."NATION_CODE" IS '民族代码';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."JOB_CATE_ID" IS '当前职业ID';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."JOB_COMPANY" IS '工作单位';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."RESIDENCE_PLACE" IS '住所地';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."EDUCATION_ID" IS '文化程度ID';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."RISK_CAUSE" IS '风险原因';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."OTHER" IS '其他';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."PHOTO_URL" IS '照片路径';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."REVIEW_STATE" IS '复核状态1-待复核，2-复核通过，3-复核不通过';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."REVIEW_PERSON" IS '复核人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."CREATED_BY" IS '创建人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."CREATED_DATE" IS '创建时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."UPDATED_BY" IS '修改人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."UPDATED_DATE" IS '更新时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."DEL_FLAG" IS '删除标记，Y,N';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."JOB_NAME" IS '当前职业';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."SRC_SYS_NAME" IS '源系统名';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON"."ETL_UPDATE_TIME" IS '数据加载时间';

COMMENT ON TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON" IS '黑名单个人信息';

GRANT DELETE ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON" TO "DW_CODE" WITH GRANT OPTION;

GRANT INSERT ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON" TO "DW_CODE" WITH GRANT OPTION;

GRANT SELECT ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON" TO "DW_CODE" WITH GRANT OPTION;

GRANT UPDATE ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_PERSON" TO "DW_CODE" WITH GRANT OPTION;

黑名单别名

CREATE TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"

( "SID" VARCHAR2(32),

"ALIAS_TYPE" CHAR(1),

"ALIAS_CONTENT" VARCHAR2(200),

"BLACK_SID" VARCHAR2(32),

"CREATED_BY" VARCHAR2(50),

"CREATED_DATE" DATE,

"UPDATED_BY" VARCHAR2(50),

"UPDATED_DATE" DATE,

"SRC_SYS_NAME" VARCHAR2(10),

"ETL_UPDATE_TIME" DATE DEFAULT SYSDATE,

CONSTRAINT "PK_A_PTY_TM_BLACK_LIST_ALIAS" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE INDEX "ATO_DATA"."IDX_A_PTY_TM_BLACK_LIST_ALIAS" ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS" ("ETL_UPDATE_TIME")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE UNIQUE INDEX "ATO_DATA"."PK_A_PTY_TM_BLACK_LIST_ALIAS" ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS" ("SID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

ALTER TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS" ADD CONSTRAINT "PK_A_PTY_TM_BLACK_LIST_ALIAS" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE;

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."SID" IS '记录唯一值';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."ALIAS_TYPE" IS '类型';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."ALIAS_CONTENT" IS '别名化名';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."BLACK_SID" IS '黑名单客户SID';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."CREATED_BY" IS '创建人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."CREATED_DATE" IS '创建时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."UPDATED_BY" IS '修改人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."UPDATED_DATE" IS '更新时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."SRC_SYS_NAME" IS '源系统名';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS"."ETL_UPDATE_TIME" IS '数据加载时间';

COMMENT ON TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS" IS '黑名单别名';

GRANT DELETE ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS" TO "DW_CODE" WITH GRANT OPTION;

GRANT INSERT ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS" TO "DW_CODE" WITH GRANT OPTION;

GRANT SELECT ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS" TO "DW_CODE" WITH GRANT OPTION;

GRANT UPDATE ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ALIAS" TO "DW_CODE" WITH GRANT OPTION;

黑名单证件

CREATE TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"

( "SID" VARCHAR2(32),

"CERTI_TYPE" VARCHAR2(2),

"CERTI_CODE" VARCHAR2(50),

"BLACK_SID" VARCHAR2(32),

"CREATED_BY" VARCHAR2(50),

"CREATED_DATE" DATE,

"UPDATED_BY" VARCHAR2(50),

"UPDATED_DATE" DATE,

"SRC_SYS_NAME" VARCHAR2(10),

"ETL_UPDATE_TIME" DATE DEFAULT SYSDATE,

CONSTRAINT "PK_A_PTY_TM_BLACK_LIST_CERTI" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE INDEX "ATO_DATA"."IDX_A_PTY_TM_BLACK_LIST_CERTI" ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI" ("ETL_UPDATE_TIME")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE UNIQUE INDEX "ATO_DATA"."PK_A_PTY_TM_BLACK_LIST_CERTI" ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI" ("SID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

ALTER TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI" ADD CONSTRAINT "PK_A_PTY_TM_BLACK_LIST_CERTI" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE;

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."SID" IS '记录唯一值';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."CERTI_TYPE" IS '证件类型';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."CERTI_CODE" IS '证件号码';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."BLACK_SID" IS '黑名单客户SID';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."CREATED_BY" IS '创建人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."CREATED_DATE" IS '创建时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."UPDATED_BY" IS '修改人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."UPDATED_DATE" IS '更新时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."SRC_SYS_NAME" IS '源系统名';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI"."ETL_UPDATE_TIME" IS '数据加载时间';

COMMENT ON TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI" IS '黑名单证件';

GRANT DELETE ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI" TO "DW_CODE" WITH GRANT OPTION;

GRANT INSERT ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI" TO "DW_CODE" WITH GRANT OPTION;

GRANT SELECT ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI" TO "DW_CODE" WITH GRANT OPTION;

GRANT UPDATE ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_CERTI" TO "DW_CODE" WITH GRANT OPTION;

黑名单分类

CREATE TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY"

( "SID" VARCHAR2(32),

"BLACK_LIST_CATEGORY" CHAR(1),

"BLACK_LIST_CATEGORY_DESC" VARCHAR2(100),

"PARENT_SID" VARCHAR2(32),

"SRC_SYS_NAME" VARCHAR2(10),

"ETL_UPDATE_TIME" DATE DEFAULT SYSDATE,

CONSTRAINT "PK_A_COD_TM_BLACK_LIST_CATE" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE INDEX "ATO_DATA"."IDX_A_COD_TM_BLACK_LIST_CATE" ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY" ("ETL_UPDATE_TIME")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE UNIQUE INDEX "ATO_DATA"."PK_A_COD_TM_BLACK_LIST_CATE" ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY" ("SID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

ALTER TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY" ADD CONSTRAINT "PK_A_COD_TM_BLACK_LIST_CATE" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE;

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY"."SID" IS '记录唯一值';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY"."BLACK_LIST_CATEGORY" IS '黑名单分类';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY"."BLACK_LIST_CATEGORY_DESC" IS '黑名单分类描述';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY"."PARENT_SID" IS '父类型SID';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY"."SRC_SYS_NAME" IS '源系统名';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY"."ETL_UPDATE_TIME" IS '数据加载时间';

COMMENT ON TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY" IS '黑名单分类';

GRANT DELETE ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY" TO "DW_CODE" WITH GRANT OPTION;

GRANT INSERT ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY" TO "DW_CODE" WITH GRANT OPTION;

GRANT SELECT ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY" TO "DW_CODE" WITH GRANT OPTION;

GRANT UPDATE ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CATEGORY" TO "DW_CODE" WITH GRANT OPTION;

黑名单代码定义表

CREATE TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE"

( "TYPEID" VARCHAR2(8),

"TARGET_CODE_VALUE" VARCHAR2(20),

"LABEL_TEXT" VARCHAR2(120),

"CODE_SCHEME_ID" VARCHAR2(50),

"CODE_DESCRIPTION" VARCHAR2(120),

"SRC_SYS_NAME" VARCHAR2(10),

"ETL_UPDATE_TIME" DATE DEFAULT SYSDATE,

CONSTRAINT "PK_A_COD_TM_BLACK_LIST_CODE" PRIMARY KEY ("TARGET_CODE_VALUE", "CODE_SCHEME_ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE INDEX "ATO_DATA"."IDX_A_COD_TM_BLACK_LIST_CODE" ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE" ("ETL_UPDATE_TIME")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE UNIQUE INDEX "ATO_DATA"."PK_A_COD_TM_BLACK_LIST_CODE" ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE" ("TARGET_CODE_VALUE", "CODE_SCHEME_ID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

ALTER TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE" ADD CONSTRAINT "PK_A_COD_TM_BLACK_LIST_CODE" PRIMARY KEY ("TARGET_CODE_VALUE", "CODE_SCHEME_ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE;

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE"."TYPEID" IS '类型ID';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE"."TARGET_CODE_VALUE" IS '代码值';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE"."LABEL_TEXT" IS '代码描述';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE"."CODE_SCHEME_ID" IS '代码类型ID';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE"."CODE_DESCRIPTION" IS '代码详细描述';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE"."SRC_SYS_NAME" IS '源系统名';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE"."ETL_UPDATE_TIME" IS '数据加载时间';

COMMENT ON TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE" IS '黑名单代码定义表';

GRANT DELETE ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE" TO "DW_CODE" WITH GRANT OPTION;

GRANT INSERT ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE" TO "DW_CODE" WITH GRANT OPTION;

GRANT SELECT ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE" TO "DW_CODE" WITH GRANT OPTION;

GRANT UPDATE ON "ATO_DATA"."A_COD_TM_BLACK_LIST_CODE" TO "DW_CODE" WITH GRANT OPTION;

黑名单职业分类

CREATE TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"

( "ORGAN_ID" VARCHAR2(10),

"JOB_CATE_ID" VARCHAR2(10),

"JOB_CODE" VARCHAR2(20) NOT NULL ENABLE,

"CLASS_1" VARCHAR2(150),

"CLASS_2" VARCHAR2(100),

"CLASS_3" VARCHAR2(200),

"SRC_SYS_ID" VARCHAR2(10),

"SRC_SYS_NAME" VARCHAR2(10),

"ETL_UPDATE_TIME" DATE DEFAULT SYSDATE,

CONSTRAINT "PK_A_COD_TM_BLACK_LIST_JOB_C" PRIMARY KEY ("JOB_CATE_ID", "JOB_CODE", "SRC_SYS_ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE INDEX "ATO_DATA"."IDX_A_COD_TM_BLACK_LIST_JOB_C" ON "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE" ("ETL_UPDATE_TIME")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE UNIQUE INDEX "ATO_DATA"."PK_A_COD_TM_BLACK_LIST_JOB_C" ON "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE" ("JOB_CATE_ID", "JOB_CODE", "SRC_SYS_ID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

ALTER TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE" MODIFY ("JOB_CODE" NOT NULL ENABLE);

ALTER TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE" ADD CONSTRAINT "PK_A_COD_TM_BLACK_LIST_JOB_C" PRIMARY KEY ("JOB_CATE_ID", "JOB_CODE", "SRC_SYS_ID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE;

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"."ORGAN_ID" IS 'ORGAN ID';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"."JOB_CATE_ID" IS 'JOD CATEGORY ID';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"."JOB_CODE" IS 'INTERNAL JOB CODE';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"."CLASS_1" IS 'FIRST CLASS';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"."CLASS_2" IS 'SECOND CLASS';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"."CLASS_3" IS 'THIRD CLASS';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"."SRC_SYS_ID" IS '外部系统【注：01：个险系统；02：团险系统】';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"."SRC_SYS_NAME" IS '源系统名';

COMMENT ON COLUMN "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE"."ETL_UPDATE_TIME" IS '数据加载时间';

COMMENT ON TABLE "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE" IS '黑名单职业分类';

GRANT DELETE ON "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE" TO "DW_CODE" WITH GRANT OPTION;

GRANT INSERT ON "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE" TO "DW_CODE" WITH GRANT OPTION;

GRANT SELECT ON "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE" TO "DW_CODE" WITH GRANT OPTION;

GRANT UPDATE ON "ATO_DATA"."A_COD_TM_BLACK_LIST_JOB_CATE" TO "DW_CODE" WITH GRANT OPTION;

黑名单团体信息

CREATE TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"

( "SID" VARCHAR2(32),

"PARTY_ID" NUMBER(12,0),

"PARTY_TYPE" VARCHAR2(10),

"SRC_SYS_ID" VARCHAR2(10),

"SRC_PARTY_ID" NUMBER(10,0),

"BLACK_LIST_CATEGORY_1" VARCHAR2(10),

"BLACK_LIST_CATEGORY_2" VARCHAR2(10),

"BLACK_LIST_CATEGORY_3" VARCHAR2(10),

"RISK_LEVEL" VARCHAR2(6),

"COMPANY_NAME" VARCHAR2(150),

"ADDRESS" VARCHAR2(100),

"REGISTER_CAPITAL" NUMBER(10,0),

"OPERATION_RANGE" VARCHAR2(200),

"ORGAN_CODE" VARCHAR2(20),

"BUSINESS_LISENCE_CODE" VARCHAR2(100),

"TAX_REGISTRATION_CODE" VARCHAR2(100),

"CONTROLLING_SHAREHOLDER" VARCHAR2(50),

"LEADER_NAME" VARCHAR2(50),

"COMP_REG_CODE" VARCHAR2(40),

"RISK_CAUSE" VARCHAR2(4000),

"OTHER" VARCHAR2(4000),

"PHOTO_URL" VARCHAR2(300),

"REVIEW_STATE" VARCHAR2(6),

"REVIEW_PERSON" VARCHAR2(50),

"CREATED_BY" VARCHAR2(50),

"CREATED_DATE" DATE,

"UPDATED_BY" VARCHAR2(50),

"UPDATED_DATE" DATE,

"DEL_FLAG" CHAR(1) DEFAULT 'N',

"SRC_SYS_NAME" VARCHAR2(10),

"ETL_UPDATE_TIME" DATE DEFAULT SYSDATE,

CONSTRAINT "PK_A_PTY_TM_BLACK_LIST_ORG" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE

) SEGMENT CREATION IMMEDIATE

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

NOCOMPRESS LOGGING

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE INDEX "ATO_DATA"."IDX_A_PTY_TM_BLACK_LIST_ORG" ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG" ("ETL_UPDATE_TIME")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

CREATE UNIQUE INDEX "ATO_DATA"."PK_A_PTY_TM_BLACK_LIST_ORG" ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG" ("SID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ;

ALTER TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG" ADD CONSTRAINT "PK_A_PTY_TM_BLACK_LIST_ORG" PRIMARY KEY ("SID")

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1

BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)

TABLESPACE "ATO_DATA" ENABLE;

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."SID" IS '记录唯一值';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."PARTY_ID" IS '客户唯一编号';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."PARTY_TYPE" IS '参与方类型';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."SRC_SYS_ID" IS '外部系统';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."SRC_PARTY_ID" IS '源系统客户号';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."BLACK_LIST_CATEGORY_1" IS '黑名单一级分类';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."BLACK_LIST_CATEGORY_2" IS '黑名单二级分类';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."BLACK_LIST_CATEGORY_3" IS '黑名单三级分类';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."RISK_LEVEL" IS '风险等级';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."COMPANY_NAME" IS '机构名称';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."ADDRESS" IS '公司地址';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."REGISTER_CAPITAL" IS '注册资本金（元）';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."OPERATION_RANGE" IS '经营范围';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."ORGAN_CODE" IS '组织机构代码';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."BUSINESS_LISENCE_CODE" IS '营业执照号码';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."TAX_REGISTRATION_CODE" IS '税务登记证号码';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."CONTROLLING_SHAREHOLDER" IS '控股股东';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."LEADER_NAME" IS '机构法人代表或领导ID';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."COMP_REG_CODE" IS '企业法人代码';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."RISK_CAUSE" IS '风险原因';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."OTHER" IS '其他';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."PHOTO_URL" IS '照片路径';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."REVIEW_STATE" IS '复核状态1-待复核，2-复核通过，3-复核不通过';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."REVIEW_PERSON" IS '复核人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."CREATED_BY" IS '创建人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."CREATED_DATE" IS '创建时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."UPDATED_BY" IS '修改人';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."UPDATED_DATE" IS '更新时间';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."DEL_FLAG" IS '删除标记，Y,N';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."SRC_SYS_NAME" IS '源系统名';

COMMENT ON COLUMN "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG"."ETL_UPDATE_TIME" IS '数据加载时间';

COMMENT ON TABLE "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG" IS '黑名单团体信息';

GRANT DELETE ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG" TO "DW_CODE" WITH GRANT OPTION;

GRANT INSERT ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG" TO "DW_CODE" WITH GRANT OPTION;

GRANT SELECT ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG" TO "DW_CODE" WITH GRANT OPTION;

GRANT UPDATE ON "ATO_DATA"."A_PTY_TM_BLACK_LIST_ORG" TO "DW_CODE" WITH GRANT OPTION;

最后

以上就是端庄爆米花为你收集整理的ddl(ecif)的全部内容，希望文章能够帮你解决ddl(ecif)所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。

本图文内容来源于网友提供，作为学习参考使用，或来自网络收集整理，版权属于原作者所有。

本文分类：Other
浏览次数：63 次浏览
发布日期：2023-10-06 11:45:32
本文链接：https://www.kaopuke.com/article/k-p-k_14_uzogf5_13_z_26_y.html

ddl(ecif)

概述

最后

评论列表共有 0 条评论

发表评论取消回复

ddl(ecif)

概述

最后

相关文章

评论列表共有 0 条评论

发表评论 取消回复

发表评论取消回复