create table SYS_SEQ
(
	ID NUMBER(19) not null
		constraint PK_SYS_SEQ_ID
			primary key,
	NAME NVARCHAR2(100) not null,
	CODE NVARCHAR2(100) not null
		constraint UK_SYS_SEQ_CODE
			unique,
	START_WITH NUMBER(10) not null,
	CURRENT_VALUE NUMBER(10) not null,
	INCREMENT_BY NUMBER(10) not null,
	REMARK NVARCHAR2(500)
)
/

comment on table SYS_SEQ is '系统序列'
/

comment on column SYS_SEQ.ID is '序列主键'
/

comment on column SYS_SEQ.NAME is '序列名称'
/

comment on column SYS_SEQ.CODE is '序列编码'
/

comment on column SYS_SEQ.START_WITH is '开始值'
/

comment on column SYS_SEQ.CURRENT_VALUE is '当前值'
/

comment on column SYS_SEQ.INCREMENT_BY is '步长'
/

comment on column SYS_SEQ.REMARK is '备注'
/

create table SYS_FILE
(
	ID NUMBER(19) not null
		constraint PK_SYS_FILE_ID
			primary key,
	NAME NVARCHAR2(100) not null,
	URL NVARCHAR2(200),
	FILE_SIZE NUMBER(19) not null,
	RECORD_ID NUMBER(19) not null,
	CONTENT_TYPE NVARCHAR2(100),
	MD5 NVARCHAR2(100),
	OPERATE_USER_ID NUMBER(19),
	OPERATE_USER_NAME NVARCHAR2(100),
	OPERATE_DATE_TIME DATE
)
/

comment on table SYS_FILE is '系统文件'
/

comment on column SYS_FILE.ID is '文件主键'
/

comment on column SYS_FILE.NAME is '文件名称'
/

comment on column SYS_FILE.URL is '文件路径'
/

comment on column SYS_FILE.FILE_SIZE is '文件大小'
/

comment on column SYS_FILE.RECORD_ID is '记录主键'
/

comment on column SYS_FILE.CONTENT_TYPE is '文档类型'
/

comment on column SYS_FILE.MD5 is '文件指纹'
/

comment on column SYS_FILE.OPERATE_USER_ID is '操作人主键'
/

comment on column SYS_FILE.OPERATE_USER_NAME is '操作人姓名'
/

comment on column SYS_FILE.OPERATE_DATE_TIME is '操作时间'
/

create index IX_SYS_FILE_RECORD_ID
	on SYS_FILE (RECORD_ID)
/

create table SYS_DIC_CATEGORY
(
	ID NUMBER(19) not null
		constraint PK_SYS_DIC_CATEGORY_ID
			primary key,
	CODE NVARCHAR2(100) not null
		constraint UK_SYS_DIC_CATEGORY_CODE
			unique,
	NAME NVARCHAR2(100) not null
)
/

comment on table SYS_DIC_CATEGORY is '系统字典类型'
/

comment on column SYS_DIC_CATEGORY.ID is '字典类型主键'
/

comment on column SYS_DIC_CATEGORY.CODE is '字典类型编码'
/

comment on column SYS_DIC_CATEGORY.NAME is '字典类型名称'
/

create table SYS_ROLE_MAP
(
	USER_ID NUMBER(19) not null,
	ROLE_ID NUMBER(19) not null
)
/

comment on table SYS_ROLE_MAP is '系统用户角色关联'
/

comment on column SYS_ROLE_MAP.USER_ID is '用户主键'
/

comment on column SYS_ROLE_MAP.ROLE_ID is '角色主键'
/

create index IX_SYS_URMAP_U_R_ID
	on SYS_ROLE_MAP (USER_ID, ROLE_ID)
/

create table SYS_MODULE_MAP
(
	OBJECT_ID NUMBER(19) not null,
	MODULE_ID NUMBER(19) not null
)
/

comment on table SYS_MODULE_MAP is '系统对象模块关联'
/

comment on column SYS_MODULE_MAP.OBJECT_ID is '对象主键'
/

comment on column SYS_MODULE_MAP.MODULE_ID is '模块主键'
/

create index IX_SYS_OMMAP_O_M_ID
	on SYS_MODULE_MAP (OBJECT_ID, MODULE_ID)
/

create table SYS_ROLE
(
	ID NUMBER(19) not null
		constraint PK_SYS_ROLE_ID
			primary key,
	NAME NVARCHAR2(100) not null,
	CODE NVARCHAR2(100) not null
		constraint UK_SYS_ROLE_CODE
			unique,
	SPELL NVARCHAR2(100),
	DEPT_ID NUMBER(19) not null,
	DEPT_NAME NVARCHAR2(100) not null,
	STATUS NUMBER(3) not null,
	REMARK NVARCHAR2(500),
	constraint UK_SYS_ROLE_NAME
		unique (NAME, DEPT_ID)
)
/

comment on table SYS_ROLE is '系统角色'
/

comment on column SYS_ROLE.ID is '角色主键'
/

comment on column SYS_ROLE.NAME is '角色名称'
/

comment on column SYS_ROLE.CODE is '角色编码'
/

comment on column SYS_ROLE.SPELL is '角色名称简拼'
/

comment on column SYS_ROLE.DEPT_ID is '机构主键'
/

comment on column SYS_ROLE.DEPT_NAME is '机构名称'
/

comment on column SYS_ROLE.STATUS is '状态(0:禁用;1:启用)'
/

comment on column SYS_ROLE.REMARK is '备注'
/

create unique index UK_SYS_ROLE_DID_NAME
	on SYS_ROLE (DEPT_ID, NAME)
/

create table SYS_USER
(
	ID NUMBER(19) not null
		constraint PK_SYS_USER_ID
			primary key,
	NAME NVARCHAR2(100) not null,
	SPELL NVARCHAR2(100),
	ACCOUNT NVARCHAR2(100) not null
		constraint UK_SYS_USER_ACCOUNT
			unique,
	PASSWORD NVARCHAR2(100) not null,
	SALT NVARCHAR2(100) not null,
	MOBILE NVARCHAR2(100),
	EMAIL NVARCHAR2(100),
	DEPT_ID NUMBER(19) not null,
	DEPT_NAME NVARCHAR2(100) not null,
	LOGIN_NUMBER NUMBER(10) not null,
	ADMIN NUMBER(3) not null,
	FIRST_VISIT_TIME DATE,
	LAST_VISIT_TIME DATE,
	ALLOW_START_TIME DATE,
	ALLOW_END_TIME DATE,
	STATUS NUMBER(3) not null,
	REMARK NVARCHAR2(500)
)
/

comment on table SYS_USER is '系统用户'
/

comment on column SYS_USER.ID is '用户主键'
/

comment on column SYS_USER.NAME is '用户姓名'
/

comment on column SYS_USER.SPELL is '用户姓名简拼'
/

comment on column SYS_USER.ACCOUNT is '账号'
/

comment on column SYS_USER.PASSWORD is '密码'
/

comment on column SYS_USER.SALT is '密码盐'
/

comment on column SYS_USER.MOBILE is '手机号码'
/

comment on column SYS_USER.EMAIL is '电子邮件'
/

comment on column SYS_USER.DEPT_ID is '机构主键'
/

comment on column SYS_USER.DEPT_NAME is '机构名称'
/

comment on column SYS_USER.LOGIN_NUMBER is '登录次数'
/

comment on column SYS_USER.ADMIN is '管理员(0:否;1:是)'
/

comment on column SYS_USER.FIRST_VISIT_TIME is '首次登录时间'
/

comment on column SYS_USER.LAST_VISIT_TIME is '最后登录时间'
/

comment on column SYS_USER.ALLOW_START_TIME is '有效期开始时间'
/

comment on column SYS_USER.ALLOW_END_TIME is '有效期结束时间'
/

comment on column SYS_USER.STATUS is '状态(0:禁用;1:启用)'
/

comment on column SYS_USER.REMARK is '备注'
/

create table SYS_DIC
(
	ID NUMBER(19) not null
		constraint PK_SYS_DIC_ID
			primary key,
	CODE NVARCHAR2(100) not null,
	NAME NVARCHAR2(100) not null,
	VALUE NVARCHAR2(500) not null,
	SPELL NVARCHAR2(100),
	PATH NUMBER(10),
	STATUS NUMBER(3) not null,
	REMARK NVARCHAR2(500)
)
/

comment on table SYS_DIC is '系统字典'
/

comment on column SYS_DIC.ID is '字典主键'
/

comment on column SYS_DIC.CODE is '字典类型编码'
/

comment on column SYS_DIC.NAME is '字典名称'
/

comment on column SYS_DIC.VALUE is '字典值'
/

comment on column SYS_DIC.SPELL is '字典名称简拼'
/

comment on column SYS_DIC.PATH is '排序行号'
/

comment on column SYS_DIC.STATUS is '状态(0:禁用;1:启用)'
/

comment on column SYS_DIC.REMARK is '备注'
/

create index IX_SYS_DIC_CATEGORY_CODE
	on SYS_DIC (CODE)
/

create table SYS_DEPT
(
	ID NUMBER(19) not null
		constraint PK_SYS_DEPT_ID
			primary key,
	PARENT_ID NUMBER(19) not null,
	NAME NVARCHAR2(100) not null,
	CODE NVARCHAR2(100) not null
		constraint UK_SYS_DEPT_CODE
			unique,
	SPELL NVARCHAR2(100),
	PATH NVARCHAR2(100),
	STATUS NUMBER(3) not null,
	REMARK NVARCHAR2(500),
	constraint UK_SYS_DEPT_NAME
		unique (PARENT_ID, NAME)
)
/

comment on table SYS_DEPT is '系统机构'
/

comment on column SYS_DEPT.ID is '机构主键'
/

comment on column SYS_DEPT.PARENT_ID is '机构上级主键'
/

comment on column SYS_DEPT.NAME is '机构名称'
/

comment on column SYS_DEPT.CODE is '机构编码'
/

comment on column SYS_DEPT.SPELL is '机构名称简拼'
/

comment on column SYS_DEPT.PATH is '排序路径'
/

comment on column SYS_DEPT.STATUS is '状态(0:禁用;1:启用)'
/

comment on column SYS_DEPT.REMARK is '备注'
/

create table SYS_APP
(
	ID NUMBER(19) not null
		constraint PK_SYS_APP_ID
			primary key,
	NAME NVARCHAR2(100) not null
		constraint UK_SYS_APP_NAME
			unique,
	SECRET NVARCHAR2(100) not null,
	STATUS NUMBER(3) not null,
	REMARK NVARCHAR2(500)
)
/

comment on table SYS_APP is '系统应用程序'
/

comment on column SYS_APP.ID is '应用主键'
/

comment on column SYS_APP.NAME is '应用名称'
/

comment on column SYS_APP.SECRET is '密钥'
/

comment on column SYS_APP.STATUS is '状态(0:禁用;1:启用)'
/

comment on column SYS_APP.REMARK is '备注'
/

create table SYS_HISTORY
(
	ID NUMBER(19) not null
		constraint PK_SYS_HISTORY_ID
			primary key,
	OPERATE_TYPE NUMBER(3) not null,
	TABLE_NAME NVARCHAR2(100) not null,
	PRIMARY_KEY NVARCHAR2(100) not null,
	BEFORE_DATA NCLOB,
	AFTER_DATA NCLOB,
	MESSAGE NCLOB,
	OPERATE_USER_ID NUMBER(19),
	OPERATE_USER_NAME NVARCHAR2(100),
	OPERATE_DATE_TIME DATE
)
/

comment on table SYS_HISTORY is '系统历史记录'
/

comment on column SYS_HISTORY.ID is '历史记录主键'
/

comment on column SYS_HISTORY.OPERATE_TYPE is '操作类型(1:新增;2:修改;3:删除)'
/

comment on column SYS_HISTORY.TABLE_NAME is '表名'
/

comment on column SYS_HISTORY.PRIMARY_KEY is '主键'
/

comment on column SYS_HISTORY.BEFORE_DATA is '操作前数据'
/

comment on column SYS_HISTORY.AFTER_DATA is '操作后数据'
/

comment on column SYS_HISTORY.MESSAGE is '消息'
/

comment on column SYS_HISTORY.OPERATE_USER_ID is '操作人主键'
/

comment on column SYS_HISTORY.OPERATE_USER_NAME is '操作人姓名'
/

comment on column SYS_HISTORY.OPERATE_DATE_TIME is '操作时间'
/

create index IX_SYS_HISTORY_PRIMARY_KEY
	on SYS_HISTORY (PRIMARY_KEY)
/

create table SYS_LOG
(
	ID NUMBER(19) not null
		constraint PK_SYS_LOG_ID
			primary key,
	APP_ID NVARCHAR2(100) not null,
	OPERATE_TYPE NUMBER(3) not null,
	MODULE NVARCHAR2(100),
	METHOD NVARCHAR2(200),
	PARAM_DATA NCLOB,
	IP NVARCHAR2(100),
	BROWSER NVARCHAR2(100),
	URL NVARCHAR2(500),
	COST_TIME NUMBER(10),
	RESULT NUMBER(5) not null,
	MESSAGE NCLOB,
	DETAILS NCLOB,
	OPERATE_USER_ID NUMBER(19),
	OPERATE_USER_NAME NVARCHAR2(100),
	OPERATE_DATE_TIME DATE
)
/

comment on table SYS_LOG is '系统日志'
/

comment on column SYS_LOG.ID is '日志主键'
/

comment on column SYS_LOG.APP_ID is '应用标识'
/

comment on column SYS_LOG.OPERATE_TYPE is '操作类型(1:操作;2:登录;3:异常)'
/

comment on column SYS_LOG.MODULE is '模块'
/

comment on column SYS_LOG.METHOD is '方法'
/

comment on column SYS_LOG.PARAM_DATA is '参数'
/

comment on column SYS_LOG.IP is 'IP地址'
/

comment on column SYS_LOG.BROWSER is '浏览器'
/

comment on column SYS_LOG.URL is '请求地址'
/

comment on column SYS_LOG.COST_TIME is '耗时'
/

comment on column SYS_LOG.RESULT is '执行结果(0:失败;1:成功)'
/

comment on column SYS_LOG.MESSAGE is '信息'
/

comment on column SYS_LOG.DETAILS is '详细信息'
/

comment on column SYS_LOG.OPERATE_USER_ID is '操作人主键'
/

comment on column SYS_LOG.OPERATE_USER_NAME is '操作人姓名'
/

comment on column SYS_LOG.OPERATE_DATE_TIME is '操作时间'
/

create table SYS_PARAM
(
	ID NUMBER(19) not null
		constraint PK_SYS_PARAM_ID
			primary key,
	NAME NVARCHAR2(100) not null,
	CODE NVARCHAR2(100) not null
		constraint UK_SYS_PARAM_CODE
			unique,
	VALUE NVARCHAR2(2000) not null,
	SPELL NVARCHAR2(100),
	REMARK NVARCHAR2(500)
)
/

comment on table SYS_PARAM is '系统参数'
/

comment on column SYS_PARAM.ID is '参数主键'
/

comment on column SYS_PARAM.NAME is '参数名称'
/

comment on column SYS_PARAM.CODE is '参数编码'
/

comment on column SYS_PARAM.VALUE is '参数值'
/

comment on column SYS_PARAM.SPELL is '参数名称简拼'
/

comment on column SYS_PARAM.REMARK is '备注'
/

create table SYS_REPORT
(
	ID NUMBER(19) not null
		constraint PK_SYS_REPORT_ID
			primary key,
	CODE NVARCHAR2(100) not null
		constraint UK_SYS_REPORT_CODE
			unique,
	NAME NVARCHAR2(100) not null,
	URL NVARCHAR2(200),
	PATH NVARCHAR2(500),
	MD5 NVARCHAR2(100),
	REMARK NVARCHAR2(500)
)
/

comment on table SYS_REPORT is '系统报表'
/

comment on column SYS_REPORT.ID is '报表主键'
/

comment on column SYS_REPORT.CODE is '报表编码'
/

comment on column SYS_REPORT.NAME is '报表名称'
/

comment on column SYS_REPORT.URL is '接口地址'
/

comment on column SYS_REPORT.PATH is '报表文件路径'
/

comment on column SYS_REPORT.MD5 is '文件指纹'
/

comment on column SYS_REPORT.REMARK is '备注'
/

create table SYS_DATA_MAP
(
	OBJECT_NAME NVARCHAR2(100) not null,
	OBJECT_ID NUMBER(19) not null,
	TARGET_NAME NVARCHAR2(100) not null,
	TARGET_ID NUMBER(19) not null
)
/

comment on table SYS_DATA_MAP is '系统对象数据关联'
/

comment on column SYS_DATA_MAP.OBJECT_NAME is '对象名称'
/

comment on column SYS_DATA_MAP.OBJECT_ID is '对象主键'
/

comment on column SYS_DATA_MAP.TARGET_NAME is '目标名称'
/

comment on column SYS_DATA_MAP.TARGET_ID is '目标主键'
/

create index IX_SYS_DATA_MAP_OBJECT
	on SYS_DATA_MAP (OBJECT_NAME, OBJECT_ID, TARGET_NAME, TARGET_ID)
/

create table SYS_MODULE
(
	ID NUMBER(19) not null
		constraint PK_SYS_MODULE_ID
			primary key,
	PARENT_ID NUMBER(19) not null,
	NAME NVARCHAR2(100) not null,
	CODE NVARCHAR2(100) not null
		constraint UK_SYS_MODULE_CODE
			unique,
	SPELL NVARCHAR2(100),
	PARAM_DATA NVARCHAR2(1000),
	WEB_URL NVARCHAR2(200),
	WEB_CLS NVARCHAR2(100),
	WIN_PROVIDER NVARCHAR2(200),
	WIN_LARGE_ICON NVARCHAR2(100),
	WIN_SMALL_ICON NVARCHAR2(100),
	WEB_FLAG NUMBER(3) not null,
	WIN_FLAG NUMBER(3) not null,
	EXPAND_FLAG NUMBER(3) not null,
	PUBLIC_FLAG NUMBER(3) not null,
	MENU_FLAG NUMBER(3) not null,
	DIALOG_FLAG NUMBER(3) not null,
	PRELOADING_FLAG NUMBER(3) default (0) not null,
	VECTOR_GRAPH_FLAG NUMBER(3) default (0) not null,
	PATH NVARCHAR2(100),
	STATUS NUMBER(3) not null,
	REMARK NVARCHAR2(500)
)
/

comment on table SYS_MODULE is '系统模块'
/

comment on column SYS_MODULE.ID is '模块主键'
/

comment on column SYS_MODULE.PARENT_ID is '模块上级主键'
/

comment on column SYS_MODULE.NAME is '模块名称'
/

comment on column SYS_MODULE.CODE is '模块编码'
/

comment on column SYS_MODULE.SPELL is '模块名称简拼'
/

comment on column SYS_MODULE.PARAM_DATA is '模块参数'
/

comment on column SYS_MODULE.WEB_URL is 'Web地址'
/

comment on column SYS_MODULE.WEB_CLS is 'Web图标'
/

comment on column SYS_MODULE.WIN_PROVIDER is 'WinFrom窗口类'
/

comment on column SYS_MODULE.WIN_LARGE_ICON is 'WinFrom大图标'
/

comment on column SYS_MODULE.WIN_SMALL_ICON is 'WinFrom小图标'
/

comment on column SYS_MODULE.WEB_FLAG is '是否Web菜单'
/

comment on column SYS_MODULE.WIN_FLAG is '是否WinForm菜单'
/

comment on column SYS_MODULE.EXPAND_FLAG is '是否展开'
/

comment on column SYS_MODULE.PUBLIC_FLAG is '是否公开'
/

comment on column SYS_MODULE.MENU_FLAG is '是否菜单'
/

comment on column SYS_MODULE.DIALOG_FLAG is '是否显示为对话框'
/

comment on column SYS_MODULE.PRELOADING_FLAG is '是否预加载'
/

comment on column SYS_MODULE.VECTOR_GRAPH_FLAG is '是否矢量图'
/

comment on column SYS_MODULE.PATH is '排序路径'
/

comment on column SYS_MODULE.STATUS is '状态(0:禁用;1:启用)'
/

comment on column SYS_MODULE.REMARK is '备注'
/