/* Drop Tables */ DROP TABLE gen_scheme; DROP TABLE gen_table_column; DROP TABLE gen_table; DROP TABLE gen_template; /* Create Tables */ CREATE TABLE gen_scheme ( id varchar2(64) NOT NULL, name nvarchar2(200), category varchar2(2000), package_name varchar2(500), module_name varchar2(30), sub_module_name varchar2(30), function_name nvarchar2(500), function_name_simple nvarchar2(100), function_author nvarchar2(100), gen_table_id varchar2(200), create_by varchar2(64), create_date timestamp, update_by varchar2(64), update_date timestamp, remarks nvarchar2(255), del_flag char(1) DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); CREATE TABLE gen_table ( id varchar2(64) NOT NULL, name nvarchar2(200), comments nvarchar2(500), class_name varchar2(100), parent_table varchar2(200), parent_table_fk varchar2(100), create_by varchar2(64), create_date timestamp, update_by varchar2(64), update_date timestamp, remarks nvarchar2(255), del_flag char(1) DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); CREATE TABLE gen_table_column ( id varchar2(64) NOT NULL, gen_table_id varchar2(64), name nvarchar2(200), comments nvarchar2(500), jdbc_type varchar2(100), java_type varchar2(500), java_field varchar2(200), is_pk char(1), is_null char(1), is_insert char(1), is_edit char(1), is_list char(1), is_query char(1), query_type varchar2(200), show_type varchar2(200), dict_type varchar2(200), settings nvarchar2(2000), sort number, create_by varchar2(64), create_date timestamp, update_by varchar2(64), update_date timestamp, remarks nvarchar2(255), del_flag char(1) DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); CREATE TABLE gen_template ( id varchar2(64) NOT NULL, name nvarchar2(200), category varchar2(2000), file_path varchar2(500), file_name varchar2(200), content clob, create_by varchar2(64), create_date timestamp, update_by varchar2(64), update_date timestamp, remarks nvarchar2(255), del_flag char(1) DEFAULT '0' NOT NULL, PRIMARY KEY (id) ); /* Create Indexes */ CREATE INDEX gen_scheme_del_flag ON gen_scheme (del_flag); CREATE INDEX gen_table_name ON gen_table (name); CREATE INDEX gen_table_del_flag ON gen_table (del_flag); CREATE INDEX gen_table_column_table_id ON gen_table_column (gen_table_id); CREATE INDEX gen_table_column_name ON gen_table_column (name); CREATE INDEX gen_table_column_sort ON gen_table_column (sort); CREATE INDEX gen_table_column_del_flag ON gen_table_column (del_flag); CREATE INDEX gen_template_del_falg ON gen_template (del_flag); /* Comments */ COMMENT ON TABLE gen_scheme IS '生成方案'; COMMENT ON COLUMN gen_scheme.id IS '编号'; COMMENT ON COLUMN gen_scheme.name IS '名称'; COMMENT ON COLUMN gen_scheme.category IS '分类'; COMMENT ON COLUMN gen_scheme.package_name IS '生成包路径'; COMMENT ON COLUMN gen_scheme.module_name IS '生成模块名'; COMMENT ON COLUMN gen_scheme.sub_module_name IS '生成子模块名'; COMMENT ON COLUMN gen_scheme.function_name IS '生成功能名'; COMMENT ON COLUMN gen_scheme.function_name_simple IS '生成功能名（简写）'; COMMENT ON COLUMN gen_scheme.function_author IS '生成功能作者'; COMMENT ON COLUMN gen_scheme.gen_table_id IS '生成表编号'; COMMENT ON COLUMN gen_scheme.create_by IS '创建者'; COMMENT ON COLUMN gen_scheme.create_date IS '创建时间'; COMMENT ON COLUMN gen_scheme.update_by IS '更新者'; COMMENT ON COLUMN gen_scheme.update_date IS '更新时间'; COMMENT ON COLUMN gen_scheme.remarks IS '备注信息'; COMMENT ON COLUMN gen_scheme.del_flag IS '删除标记（0：正常；1：删除）'; COMMENT ON TABLE gen_table IS '业务表'; COMMENT ON COLUMN gen_table.id IS '编号'; COMMENT ON COLUMN gen_table.name IS '名称'; COMMENT ON COLUMN gen_table.comments IS '描述'; COMMENT ON COLUMN gen_table.class_name IS '实体类名称'; COMMENT ON COLUMN gen_table.parent_table IS '关联父表'; COMMENT ON COLUMN gen_table.parent_table_fk IS '关联父表外键'; COMMENT ON COLUMN gen_table.create_by IS '创建者'; COMMENT ON COLUMN gen_table.create_date IS '创建时间'; COMMENT ON COLUMN gen_table.update_by IS '更新者'; COMMENT ON COLUMN gen_table.update_date IS '更新时间'; COMMENT ON COLUMN gen_table.remarks IS '备注信息'; COMMENT ON COLUMN gen_table.del_flag IS '删除标记（0：正常；1：删除）'; COMMENT ON TABLE gen_table_column IS '业务表字段'; COMMENT ON COLUMN gen_table_column.id IS '编号'; COMMENT ON COLUMN gen_table_column.gen_table_id IS '归属表编号'; COMMENT ON COLUMN gen_table_column.name IS '名称'; COMMENT ON COLUMN gen_table_column.comments IS '描述'; COMMENT ON COLUMN gen_table_column.jdbc_type IS '列的数据类型的字节长度'; COMMENT ON COLUMN gen_table_column.java_type IS 'JAVA类型'; COMMENT ON COLUMN gen_table_column.java_field IS 'JAVA字段名'; COMMENT ON COLUMN gen_table_column.is_pk IS '是否主键'; COMMENT ON COLUMN gen_table_column.is_null IS '是否可为空'; COMMENT ON COLUMN gen_table_column.is_insert IS '是否为插入字段'; COMMENT ON COLUMN gen_table_column.is_edit IS '是否编辑字段'; COMMENT ON COLUMN gen_table_column.is_list IS '是否列表字段'; COMMENT ON COLUMN gen_table_column.is_query IS '是否查询字段'; COMMENT ON COLUMN gen_table_column.query_type IS '查询方式（等于、不等于、大于、小于、范围、左LIKE、右LIKE、左右LIKE）'; COMMENT ON COLUMN gen_table_column.show_type IS '字段生成方案（文本框、文本域、下拉框、复选框、单选框、字典选择、人员选择、部门选择、区域选择）'; COMMENT ON COLUMN gen_table_column.dict_type IS '字典类型'; COMMENT ON COLUMN gen_table_column.settings IS '其它设置（扩展字段JSON）'; COMMENT ON COLUMN gen_table_column.sort IS '排序（升序）'; COMMENT ON COLUMN gen_table_column.create_by IS '创建者'; COMMENT ON COLUMN gen_table_column.create_date IS '创建时间'; COMMENT ON COLUMN gen_table_column.update_by IS '更新者'; COMMENT ON COLUMN gen_table_column.update_date IS '更新时间'; COMMENT ON COLUMN gen_table_column.remarks IS '备注信息'; COMMENT ON COLUMN gen_table_column.del_flag IS '删除标记（0：正常；1：删除）'; COMMENT ON TABLE gen_template IS '代码模板表'; COMMENT ON COLUMN gen_template.id IS '编号'; COMMENT ON COLUMN gen_template.name IS '名称'; COMMENT ON COLUMN gen_template.category IS '分类'; COMMENT ON COLUMN gen_template.file_path IS '生成文件路径'; COMMENT ON COLUMN gen_template.file_name IS '生成文件名'; COMMENT ON COLUMN gen_template.content IS '内容'; COMMENT ON COLUMN gen_template.create_by IS '创建者'; COMMENT ON COLUMN gen_template.create_date IS '创建时间'; COMMENT ON COLUMN gen_template.update_by IS '更新者'; COMMENT ON COLUMN gen_template.update_date IS '更新时间'; COMMENT ON COLUMN gen_template.remarks IS '备注信息'; COMMENT ON COLUMN gen_template.del_flag IS '删除标记（0：正常；1：删除）';