数据字典
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 | /* Navicat Oracle Data Transfer Oracle Client Version : 12.2.0.1.0 Source Server : FO2.0开发库 Source Server Version : 110200 Source Host : Source Schema : Target Server Type : ORACLE Target Server Version : 110200 File Encoding : 65001 Date: 2018-07-04 08:49:07 */ -- ---------------------------- -- Table structure for T_DICTIONARY_TYPE -- ---------------------------- DROP TABLE "YCGCE" . "T_DICTIONARY_TYPE" ; CREATE TABLE "YCGCE" . "T_DICTIONARY_TYPE" ( "ID" VARCHAR2( 50 BYTE) NOT NULL , "TYPE_NAME" VARCHAR2( 50 BYTE) NULL , "ACTIVE" CHAR( 1 BYTE) NULL , "CREATE_TIME" DATE NULL , "MODIFY_TIME" DATE NULL , "CREATE_USER_CODE" VARCHAR2( 50 BYTE) NULL , "MODIFY_USER_CODE" VARCHAR2( 50 BYTE) NULL , "PARENT_CODE" VARCHAR2( 50 BYTE) NULL , "TYPE_ALIAS" VARCHAR2( 50 BYTE) NULL , "IS_LEAF" CHAR( 1 BYTE) NULL ) LOGGING NOCOMPRESS NOCACHE ; COMMENT ON TABLE "YCGCE" . "T_DICTIONARY_TYPE" IS '数据字典分类表' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "ID" IS 'ID' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "TYPE_NAME" IS '分类名称' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "ACTIVE" IS '是否启用' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "CREATE_TIME" IS '创建时间' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "MODIFY_TIME" IS '更新时间' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "CREATE_USER_CODE" IS '创建人' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "MODIFY_USER_CODE" IS '更新人' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "PARENT_CODE" IS '上级分类编码' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "TYPE_ALIAS" IS '分类别名' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_TYPE" . "IS_LEAF" IS '是否为子分类' ; -- ---------------------------- -- Indexes structure for table T_DICTIONARY_TYPE -- ---------------------------- -- ---------------------------- -- Checks structure for table T_DICTIONARY_TYPE -- ---------------------------- ALTER TABLE "YCGCE" . "T_DICTIONARY_TYPE" ADD CHECK ( "ID" IS NOT NULL); -- ---------------------------- -- Primary Key structure for table T_DICTIONARY_TYPE -- ---------------------------- ALTER TABLE "YCGCE" . "T_DICTIONARY_TYPE" ADD PRIMARY KEY ( "ID" ); INSERT INTO "YCGCE" . "T_DICTIONARY_TYPE" ( "ID" , "TYPE_NAME" , "ACTIVE" , "CREATE_TIME" , "MODIFY_TIME" , "CREATE_USER_CODE" , "MODIFY_USER_CODE" , "PARENT_CODE" , "TYPE_ALIAS" , "IS_LEAF" ) VALUES ( '38fd8195b1b04c668fab3d44e19d9c12' , '账户交易明细' , 'Y' , TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), TO_DATE( '2017-03-10 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), '1' , '1' , '000000' , 'T_FIN_ACCOUNT_OPER_INFO' , 'N' ); INSERT INTO "YCGCE" . "T_DICTIONARY_TYPE" ( "ID" , "TYPE_NAME" , "ACTIVE" , "CREATE_TIME" , "MODIFY_TIME" , "CREATE_USER_CODE" , "MODIFY_USER_CODE" , "PARENT_CODE" , "TYPE_ALIAS" , "IS_LEAF" ) VALUES ( '38c3da2671d0448380ad1dceed1b61b1' , '费用状态' , 'Y' , TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), '1' , '1' , '38fd8195b1b04c668fab3d44e19d9c12' , 'FIN_ACCOUNT_OPER_INFO_FEE_STATUS' , 'Y' ); |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | -- ---------------------------- -- Table structure for T_DICTIONARY_DATA -- ---------------------------- DROP TABLE "YCGCE" . "T_DICTIONARY_DATA" ; CREATE TABLE "YCGCE" . "T_DICTIONARY_DATA" ( "ID" VARCHAR2( 50 BYTE) NOT NULL , "DICT_TYPE" VARCHAR2( 50 BYTE) NULL , "VALUE_ORDER" NUMBER( 9 ) NULL , "VALUE_NAME" VARCHAR2( 50 BYTE) NULL , "VALUE_CODE" VARCHAR2( 50 BYTE) NULL , "LANGUAGE" VARCHAR2( 10 BYTE) NULL , "ACTIVE" CHAR( 1 BYTE) NULL , "CREATE_TIME" DATE NULL , "MODIFY_TIME" DATE NULL , "CREATE_USER_CODE" VARCHAR2( 50 BYTE) NULL , "MODIFY_USER_CODE" VARCHAR2( 50 BYTE) NULL , "NOTE_INFO" VARCHAR2( 250 BYTE) NULL , "VERSION_NO" NUMBER( 18 ) DEFAULT 0 NULL ) LOGGING NOCOMPRESS NOCACHE ; COMMENT ON TABLE "YCGCE" . "T_DICTIONARY_DATA" IS '数据字典基础数据表' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "ID" IS 'ID' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "DICT_TYPE" IS '数据字典分类' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "VALUE_ORDER" IS '序号' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "VALUE_NAME" IS '值名称' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "VALUE_CODE" IS '值代码' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "LANGUAGE" IS '语言' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "ACTIVE" IS '是否启用' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "CREATE_TIME" IS '创建时间' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "MODIFY_TIME" IS '更新时间' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "CREATE_USER_CODE" IS '创建人' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "MODIFY_USER_CODE" IS '更新人' ; COMMENT ON COLUMN "YCGCE" . "T_DICTIONARY_DATA" . "NOTE_INFO" IS '备注信息' ; -- ---------------------------- -- Indexes structure for table T_DICTIONARY_DATA -- ---------------------------- -- ---------------------------- -- Checks structure for table T_DICTIONARY_DATA -- ---------------------------- ALTER TABLE "YCGCE" . "T_DICTIONARY_DATA" ADD CHECK ( "ID" IS NOT NULL); -- ---------------------------- -- Primary Key structure for table T_DICTIONARY_DATA -- ---------------------------- ALTER TABLE "YCGCE" . "T_DICTIONARY_DATA" ADD PRIMARY KEY ( "ID" ); INSERT INTO "YCGCE" . "T_DICTIONARY_DATA" ( "ID" , "DICT_TYPE" , "VALUE_ORDER" , "VALUE_NAME" , "VALUE_CODE" , "LANGUAGE" , "ACTIVE" , "CREATE_TIME" , "MODIFY_TIME" , "CREATE_USER_CODE" , "MODIFY_USER_CODE" , "NOTE_INFO" , "VERSION_NO" ) VALUES ( 'd51e7af5fa5b43089862112a362f2c1f' , '38c3da2671d0448380ad1dceed1b61b1' , '1' , '无效结算' , '-2' , 'zh_CN' , 'Y' , TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), '1' , '1' , NULL, '1470646470889' ); INSERT INTO "YCGCE" . "T_DICTIONARY_DATA" ( "ID" , "DICT_TYPE" , "VALUE_ORDER" , "VALUE_NAME" , "VALUE_CODE" , "LANGUAGE" , "ACTIVE" , "CREATE_TIME" , "MODIFY_TIME" , "CREATE_USER_CODE" , "MODIFY_USER_CODE" , "NOTE_INFO" , "VERSION_NO" ) VALUES ( '49ed4a68ec1c450e85c508c207d10da6' , '38c3da2671d0448380ad1dceed1b61b1' , '2' , '未开户' , '-1' , 'zh_CN' , 'Y' , TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), '1' , '1' , NULL, '1470646485078' ); INSERT INTO "YCGCE" . "T_DICTIONARY_DATA" ( "ID" , "DICT_TYPE" , "VALUE_ORDER" , "VALUE_NAME" , "VALUE_CODE" , "LANGUAGE" , "ACTIVE" , "CREATE_TIME" , "MODIFY_TIME" , "CREATE_USER_CODE" , "MODIFY_USER_CODE" , "NOTE_INFO" , "VERSION_NO" ) VALUES ( '54215af17309482889ddbea9ec6833b4' , '38c3da2671d0448380ad1dceed1b61b1' , '3' , '等待结算' , '0' , 'zh_CN' , 'Y' , TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), '1' , '1' , NULL, '1470646500489' ); INSERT INTO "YCGCE" . "T_DICTIONARY_DATA" ( "ID" , "DICT_TYPE" , "VALUE_ORDER" , "VALUE_NAME" , "VALUE_CODE" , "LANGUAGE" , "ACTIVE" , "CREATE_TIME" , "MODIFY_TIME" , "CREATE_USER_CODE" , "MODIFY_USER_CODE" , "NOTE_INFO" , "VERSION_NO" ) VALUES ( 'cd561e238598499ebae98902a1b604a9' , '38c3da2671d0448380ad1dceed1b61b1' , '4' , '已结算' , '1' , 'zh_CN' , 'Y' , TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), '1' , '1' , NULL, '1470646517022' ); INSERT INTO "YCGCE" . "T_DICTIONARY_DATA" ( "ID" , "DICT_TYPE" , "VALUE_ORDER" , "VALUE_NAME" , "VALUE_CODE" , "LANGUAGE" , "ACTIVE" , "CREATE_TIME" , "MODIFY_TIME" , "CREATE_USER_CODE" , "MODIFY_USER_CODE" , "NOTE_INFO" , "VERSION_NO" ) VALUES ( '732f4872a1e0463f9f484c0a32901e08' , '38c3da2671d0448380ad1dceed1b61b1' , '5' , '已退回结算' , '2' , 'zh_CN' , 'Y' , TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), '1' , '1' , NULL, '1470646528091' ); INSERT INTO "YCGCE" . "T_DICTIONARY_DATA" ( "ID" , "DICT_TYPE" , "VALUE_ORDER" , "VALUE_NAME" , "VALUE_CODE" , "LANGUAGE" , "ACTIVE" , "CREATE_TIME" , "MODIFY_TIME" , "CREATE_USER_CODE" , "MODIFY_USER_CODE" , "NOTE_INFO" , "VERSION_NO" ) VALUES ( 'bf2ac090503c4204adf226a535378d3d' , 'de7a062b32b6442f84a42d8a898d2a3a' , '1' , '中心结算明细' , '1' , 'zh_CN' , 'Y' , TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), '1' , '1' , NULL, '1481123140325' ); INSERT INTO "YCGCE" . "T_DICTIONARY_DATA" ( "ID" , "DICT_TYPE" , "VALUE_ORDER" , "VALUE_NAME" , "VALUE_CODE" , "LANGUAGE" , "ACTIVE" , "CREATE_TIME" , "MODIFY_TIME" , "CREATE_USER_CODE" , "MODIFY_USER_CODE" , "NOTE_INFO" , "VERSION_NO" ) VALUES ( 'a2c6b6504ea140debb2cd894425feded' , 'de7a062b32b6442f84a42d8a898d2a3a' , '2' , '加盟调账' , '2' , 'zh_CN' , 'Y' , TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), TO_DATE( '2016-08-08 00:00:00' , 'SYYYY-MM-DD HH24:MI:SS' ), '1' , '1' , NULL, '1481123161733' ); |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 深入理解 Mybatis 分库分表执行原理
· 如何打造一个高并发系统?
· .NET Core GC压缩(compact_phase)底层原理浅谈
· 现代计算机视觉入门之:什么是图片特征编码
· .NET 9 new features-C#13新的锁类型和语义
· 《HelloGitHub》第 106 期
· Spring AI + Ollama 实现 deepseek-r1 的API服务和调用
· 数据库服务器 SQL Server 版本升级公告
· 深入理解Mybatis分库分表执行原理
· 使用 Dify + LLM 构建精确任务处理应用