【免费】平台库

### 数据库表概览

| 表名 | 说明 |
| --- | --- |
| [magic_api_file](#h4-) |  |
| [magic_api_file_backup](#h4-) |  |
| [qrtz_blob_triggers](#h4-) |  |
| [qrtz_calendars](#h4-) |  |
| [qrtz_cron_triggers](#h4-) |  |
| [qrtz_fired_triggers](#h4-) |  |
| [qrtz_job_details](#h4-) |  |
| [qrtz_locks](#h4-) |  |
| [qrtz_paused_trigger_grps](#h4-) |  |
| [qrtz_scheduler_state](#h4-) |  |
| [qrtz_simple_triggers](#h4-) |  |
| [qrtz_simprop_triggers](#h4-) |  |
| [qrtz_triggers](#h4-) |  |
| [sys_module](#h4-系统模块) | 系统模块 |
| [sys_module_tenant](#h4-租户和系统模块关系表) | 租户和系统模块关系表 |
| [sys_open_domain](#h4-开放域) | 开放域 |
| [tenant](#h4-租户) | 租户 |

### 数据库表结构

####

**magic_api_file**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| file_path | varchar(512) | NO | PRI |  |
| file_content | mediumtext | YES |  |  |

####

**magic_api_file_backup**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| id | varchar(32) | NO | PRI | 原对象ID |
| create_date | bigint(13) | NO | PRI | 备份时间 |
| tag | varchar(32) | YES |  | 标签 |
| type | varchar(32) | YES |  | 类型 |
| name | varchar(64) | YES |  | 原名称 |
| content | blob | YES |  | 备份内容 |
| create_by | varchar(64) | YES |  | 操作人 |

####

**qrtz_blob_triggers**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| TRIGGER_NAME | varchar(190) | NO | PRI |  |
| TRIGGER_GROUP | varchar(190) | NO | PRI |  |
| BLOB_DATA | blob | YES |  |  |

####

**qrtz_calendars**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| CALENDAR_NAME | varchar(190) | NO | PRI |  |
| CALENDAR | blob | NO |  |  |

####

**qrtz_cron_triggers**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| TRIGGER_NAME | varchar(190) | NO | PRI |  |
| TRIGGER_GROUP | varchar(190) | NO | PRI |  |
| CRON_EXPRESSION | varchar(120) | NO |  |  |
| TIME_ZONE_ID | varchar(80) | YES |  |  |

####

**qrtz_fired_triggers**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| ENTRY_ID | varchar(95) | NO | PRI |  |
| TRIGGER_NAME | varchar(190) | NO |  |  |
| TRIGGER_GROUP | varchar(190) | NO |  |  |
| INSTANCE_NAME | varchar(190) | NO |  |  |
| FIRED_TIME | bigint(13) | NO |  |  |
| SCHED_TIME | bigint(13) | NO |  |  |
| PRIORITY | int(11) | NO |  |  |
| STATE | varchar(16) | NO |  |  |
| JOB_NAME | varchar(190) | YES |  |  |
| JOB_GROUP | varchar(190) | YES |  |  |
| IS_NONCONCURRENT | varchar(1) | YES |  |  |
| REQUESTS_RECOVERY | varchar(1) | YES |  |  |

####

**qrtz_job_details**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| JOB_NAME | varchar(190) | NO | PRI |  |
| JOB_GROUP | varchar(190) | NO | PRI |  |
| DESCRIPTION | varchar(250) | YES |  |  |
| JOB_CLASS_NAME | varchar(250) | NO |  |  |
| IS_DURABLE | varchar(1) | NO |  |  |
| IS_NONCONCURRENT | varchar(1) | NO |  |  |
| IS_UPDATE_DATA | varchar(1) | NO |  |  |
| REQUESTS_RECOVERY | varchar(1) | NO |  |  |
| JOB_DATA | blob | YES |  |  |

####

**qrtz_locks**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| LOCK_NAME | varchar(40) | NO | PRI |  |

####

**qrtz_paused_trigger_grps**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| TRIGGER_GROUP | varchar(190) | NO | PRI |  |

####

**qrtz_scheduler_state**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| INSTANCE_NAME | varchar(190) | NO | PRI |  |
| LAST_CHECKIN_TIME | bigint(13) | NO |  |  |
| CHECKIN_INTERVAL | bigint(13) | NO |  |  |

####

**qrtz_simple_triggers**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| TRIGGER_NAME | varchar(190) | NO | PRI |  |
| TRIGGER_GROUP | varchar(190) | NO | PRI |  |
| REPEAT_COUNT | bigint(7) | NO |  |  |
| REPEAT_INTERVAL | bigint(12) | NO |  |  |
| TIMES_TRIGGERED | bigint(10) | NO |  |  |

####

**qrtz_simprop_triggers**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| TRIGGER_NAME | varchar(190) | NO | PRI |  |
| TRIGGER_GROUP | varchar(190) | NO | PRI |  |
| STR_PROP_1 | varchar(512) | YES |  |  |
| STR_PROP_2 | varchar(512) | YES |  |  |
| STR_PROP_3 | varchar(512) | YES |  |  |
| INT_PROP_1 | int(11) | YES |  |  |
| INT_PROP_2 | int(11) | YES |  |  |
| LONG_PROP_1 | bigint(20) | YES |  |  |
| LONG_PROP_2 | bigint(20) | YES |  |  |
| DEC_PROP_1 | decimal(13,4) | YES |  |  |
| DEC_PROP_2 | decimal(13,4) | YES |  |  |
| BOOL_PROP_1 | varchar(1) | YES |  |  |
| BOOL_PROP_2 | varchar(1) | YES |  |  |

####

**qrtz_triggers**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| SCHED_NAME | varchar(120) | NO | PRI |  |
| TRIGGER_NAME | varchar(190) | NO | PRI |  |
| TRIGGER_GROUP | varchar(190) | NO | PRI |  |
| JOB_NAME | varchar(190) | NO |  |  |
| JOB_GROUP | varchar(190) | NO |  |  |
| DESCRIPTION | varchar(250) | YES |  |  |
| NEXT_FIRE_TIME | bigint(13) | YES |  |  |
| PREV_FIRE_TIME | bigint(13) | YES |  |  |
| PRIORITY | int(11) | YES |  |  |
| TRIGGER_STATE | varchar(16) | NO |  |  |
| TRIGGER_TYPE | varchar(8) | NO |  |  |
| START_TIME | bigint(13) | NO |  |  |
| END_TIME | bigint(13) | YES |  |  |
| CALENDAR_NAME | varchar(190) | YES |  |  |
| MISFIRE_INSTR | smallint(2) | YES |  |  |
| JOB_DATA | blob | YES |  |  |

#### 系统模块

**sys_module**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| id | int(11) | NO | PRI | ID |
| name | varchar(20) | NO |  | 名称 |
| description | varchar(200) | NO |  | 备注 |
| create_by | varchar(32) | NO |  | 创建人 |
| create_by_id | varchar(32) | NO |  | 创建人ID |
| create_time | datetime | NO |  | 创建时间 |
| update_by | varchar(32) | NO |  | 修改人 |
| update_by_id | varchar(32) | NO |  | 修改人ID |
| update_time | datetime | NO |  | 修改时间 |

#### 租户和系统模块关系表

**sys_module_tenant**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| id | varchar(32) | NO | PRI | ID |
| module_id | int(11) | NO |  | 模块ID |
| tenant_id | int(11) | NO | MUL | 租户ID |
| expire_time | datetime | NO |  | 过期时间 |

#### 开放域

**sys_open_domain**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| id | int(11) | NO | PRI | ID |
| name | varchar(20) | NO | UNI | 名称 |
| api_secret | varchar(100) | NO |  | API秘钥 |
| available | tinyint(1) | NO |  | 状态 |
| description | varchar(200) | NO |  | 备注 |
| tenant_id | int(11) | YES |  | 租户ID |
| create_by | varchar(32) | NO |  | 创建人 |
| create_by_id | varchar(32) | NO |  | 创建人ID |
| create_time | datetime | NO |  | 创建时间 |
| update_by | varchar(32) | NO |  | 修改人 |
| update_by_id | varchar(32) | NO |  | 修改人ID |
| update_time | datetime | NO |  | 修改时间 |

#### 租户

**tenant**
| Field | Type | Null | Key | Comment |
| --- | --- | --- | --- | --- |
| id | int(11) | NO | PRI | ID |
| name | varchar(200) | NO |  | 名称 |
| jdbc_url | varchar(400) | NO |  | JDBC连接地址 |
| jdbc_username | varchar(200) | NO |  | JDBC用户名 |
| jdbc_password | varchar(200) | NO |  | JDBC密码 |
| available | tinyint(1) | NO |  | 状态 |
| create_time | datetime | NO |  | 创建时间 |
| update_time | datetime | NO |  | 修改时间 |