# generator

**Repository Path**: BDong/generator

## Basic Information

- **Project Name**: generator
- **Description**: No description available
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2019-03-28
- **Last Updated**: 2020-12-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 搭建过程
## 数据库语句
### 生成器表配置
```roomsql
CREATE TABLE GENERATOR_TABLE_CONFIG (
	ID NUMBER(11) NOT NULL,
	TABLE_NAME VARCHAR2(100) NOT NULL,
	DOMAIN_OBJECT_NAME VARCHAR2(100) NOT NULL,
	REMARKS VARCHAR2(200) DEFAULT NULL,
	APP_CONFIG_ID NUMBER(11) NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;

COMMENT ON TABLE GENERATOR_TABLE_CONFIG IS '生成器-表配置';
COMMENT ON COLUMN GENERATOR_TABLE_CONFIG.TABLE_NAME IS '表名';
COMMENT ON COLUMN GENERATOR_TABLE_CONFIG.DOMAIN_OBJECT_NAME IS '实体名';
COMMENT ON COLUMN GENERATOR_TABLE_CONFIG.REMARKS IS '备注';
COMMENT ON COLUMN GENERATOR_TABLE_CONFIG.APP_CONFIG_ID IS '应用配置ID';

-- ----------------------------
-- Primary Key structure for table ACC_ENT_CER
-- ----------------------------
ALTER TABLE GENERATOR_TABLE_CONFIG ADD PRIMARY KEY (ID);
```
### 生成器字段属性配置
```roomsql
CREATE TABLE GENERATOR_COLUMN_CONFIG (
	ID NUMBER(11) NOT NULL,
	ACTUAL_COLUMN_NAME VARCHAR2(100) NOT NULL,
	JDBC_TYPE VARCHAR2(100) NOT NULL,
	IS_PRIMARY_KEY CHAR(1) NOT NULL,
	IS_NOT_NULL CHAR(1) NOT NULL,
	COLUMN_LENGTH VARCHAR2(20) NOT NULL,
	JAVA_PROPERTY_NAME VARCHAR2(100) NOT NULL,
	JAVA_SHORT_TYPE VARCHAR2(100) NOT NULL,
	JAVA_FULL_TYPE VARCHAR2(200) NOT NULL,
	REMARKS VARCHAR2(200) DEFAULT NULL,
	TABLE_CONFIG_ID NUMBER(11) NOT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;

COMMENT ON TABLE GENERATOR_COLUMN_CONFIG IS '生成器-表列配置';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.ACTUAL_COLUMN_NAME IS '表列名';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.JDBC_TYPE IS 'JDBC类型';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.IS_PRIMARY_KEY IS '是否主键';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.IS_NOT_NULL IS '是否为空';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.COLUMN_LENGTH IS '列长度';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.JAVA_PROPERTY_NAME IS '对象属性名';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.JAVA_FULL_TYPE IS '对象短属性类型';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.JAVA_SHORT_TYPE IS '对象长属性类型';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.REMARKS IS '备注';
COMMENT ON COLUMN GENERATOR_COLUMN_CONFIG.TABLE_CONFIG_ID IS '表配置ID';

ALTER TABLE GENERATOR_COLUMN_CONFIG ADD PRIMARY KEY (ID);

```
### 生成器应用配置
```roomsql
CREATE TABLE GENERATOR_APP_CONFIG (
	ID NUMBER(11) NOT NULL,
	APP_NAME VARCHAR2(100) NOT NULL,
	ARTIFACT_ID VARCHAR2(100) NOT NULL,
	GROUP_ID VARCHAR2(100) NOT NULL,
	REMARKS VARCHAR2(200) DEFAULT NULL
)
LOGGING
NOCOMPRESS
NOCACHE
;

COMMENT ON TABLE GENERATOR_APP_CONFIG IS '生成器-应用配置';
COMMENT ON COLUMN GENERATOR_APP_CONFIG.APP_NAME IS '应用名';
COMMENT ON COLUMN GENERATOR_APP_CONFIG.REMARKS IS '备注';
COMMENT ON COLUMN GENERATOR_APP_CONFIG.ARTIFACT_ID IS ' maven artifactId';
COMMENT ON COLUMN GENERATOR_APP_CONFIG.GROUP_ID IS 'maven groupId';
-- ----------------------------
-- Primary Key structure for table ACC_ENT_CER
-- ----------------------------
ALTER TABLE GENERATOR_APP_CONFIG ADD PRIMARY KEY (ID);
```
```roomsql
CREATE SEQUENCE GENERATOR_APP_CONFIG_ID_SEQ MINVALUE 1 MAXVALUE 99999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE;
```