车辆管理系统更新和维护的字段
2016-01-22 10:38:23 访问(1183) 赞(0) 踩(0)
--删除用不到的表
drop table base_interfacemanage;
drop table base_interfacemanagedetails;
drop table bpms_appendproperty;
drop table BPMS_IPBLACKLIST;
drop table bpms_shortcut;
drop table bpms_tablecolumns;
drop table bpms_employee;
drop table bpms_interfaceaccess;
----以下为表的字段注解
--表 BPMS_DATAPERMISSION
-- Add comments to the table
comment on table BPMS_DATAPERMISSION
is '数据权限表';
-- Add comments to the columns
comment on column BPMS_DATAPERMISSION.datapermissionid
is '主键';
comment on column BPMS_DATAPERMISSION.roleid
is '权限ID';
comment on column BPMS_DATAPERMISSION.code
is '权限编码';
comment on column BPMS_DATAPERMISSION.resourceid
is '资源ID';
comment on column BPMS_DATAPERMISSION.objectid
is '权限内容';
comment on column BPMS_DATAPERMISSION.createdate
is '创建时间';
comment on column BPMS_DATAPERMISSION.createuserid
is '创建人';
comment on column BPMS_DATAPERMISSION.createusername
is '创建人名(冗余)';
--表BPMS_ITEMDETAILS
-- Add comments to the table
comment on table BPMS_ITEMDETAILS
is '字典项表';
-- Add comments to the columns
comment on column BPMS_ITEMDETAILS.itemdetailsid
is '主键';
comment on column BPMS_ITEMDETAILS.itemsid
is '字典ID';
comment on column BPMS_ITEMDETAILS.parentid
is '父级ID';
comment on column BPMS_ITEMDETAILS.itemname
is '字典项名称';
comment on column BPMS_ITEMDETAILS.itemcode
is '字典项编码';
comment on column BPMS_ITEMDETAILS.description
is '描述';
comment on column BPMS_ITEMDETAILS.allowedit
is '是否允许编辑：0否，1是';
comment on column BPMS_ITEMDETAILS.allowdelete
is '是否允许删除：0否，1是';
comment on column BPMS_ITEMDETAILS.enabled
is '是否启用：0否，1是';
comment on column BPMS_ITEMDETAILS.sortcode
is '排序，按升序';
comment on column BPMS_ITEMDETAILS.deletemark
is '删除标识：0否，1是';
comment on column BPMS_ITEMDETAILS.createdate
is '创建时间';
comment on column BPMS_ITEMDETAILS.createuserid
is '创建人';
comment on column BPMS_ITEMDETAILS.createusername
is '创建人名（冗余）';
comment on column BPMS_ITEMDETAILS.modifydate
is '更新时间';
comment on column BPMS_ITEMDETAILS.modifyuserid
is '更新人';
comment on column BPMS_ITEMDETAILS.modifyusername
is '更新人名（冗余）';
--表BPMS_ITEMS
-- Add comments to the table
comment on table BPMS_ITEMS
is '字典表';
-- Add comments to the columns
comment on column BPMS_ITEMS.itemsid
is '主键';
comment on column BPMS_ITEMS.parentid
is '父级ID';
comment on column BPMS_ITEMS.code
is '编码';
comment on column BPMS_ITEMS.fullname
is '名称';
comment on column BPMS_ITEMS.category
is '类别';
comment on column BPMS_ITEMS.istree
is '是否树形，0否，1是';
comment on column BPMS_ITEMS.allowedit
is '是否允许编辑：0否，1是';
comment on column BPMS_ITEMS.allowdelete
is '是否允许删除：0否，1是';
comment on column BPMS_ITEMS.enabled
is '是否启用：0否，1是';
comment on column BPMS_ITEMS.sortcode
is '排序，按升序';
comment on column BPMS_ITEMS.deletemark
is '删除标识：0否，1是';
comment on column BPMS_ITEMS.createdate
is '创建时间';
comment on column BPMS_ITEMS.createuserid
is '创建人';
comment on column BPMS_ITEMS.createusername
is '创建人名（冗余）';
comment on column BPMS_ITEMS.modifydate
is '更新时间';
comment on column BPMS_ITEMS.modifyuserid
is '更新人';
comment on column BPMS_ITEMS.modifyusername
is '更新人名（冗余）';
--表BPMS_ORGANIZATION
-- Add comments to the table
comment on table BPMS_ORGANIZATION
is '组织机构表';
-- Add comments to the columns
comment on column BPMS_ORGANIZATION.organizationid
is '主键';
comment on column BPMS_ORGANIZATION.parentid
is '父级ID';
comment on column BPMS_ORGANIZATION.code
is '编码';
comment on column BPMS_ORGANIZATION.shortname
is '简称';
comment on column BPMS_ORGANIZATION.fullname
is '全称';
comment on column BPMS_ORGANIZATION.category
is '类型';
comment on column BPMS_ORGANIZATION.isinnerorganize
is '是否内部组织机构';
comment on column BPMS_ORGANIZATION.manager
is '经理';
comment on column BPMS_ORGANIZATION.assistantmanager
is '助理';
comment on column BPMS_ORGANIZATION.outerphone
is '内部通讯电话';
comment on column BPMS_ORGANIZATION.innerphone
is '外部联系电话';
comment on column BPMS_ORGANIZATION.fax
is '传真';
comment on column BPMS_ORGANIZATION.postalcode
is '邮编';
comment on column BPMS_ORGANIZATION.address
is '地址';
comment on column BPMS_ORGANIZATION.web
is '网站';
comment on column BPMS_ORGANIZATION.description
is '描述';
comment on column BPMS_ORGANIZATION.enabled
is '是否启用';
comment on column BPMS_ORGANIZATION.sortcode
is '排序';
comment on column BPMS_ORGANIZATION.deletemark
is '删除标识';
--表BPMS_ROLEMENU
-- Add comments to the table
comment on table BPMS_ROLEMENU
is '权限菜单表';
-- Add comments to the columns
comment on column BPMS_ROLEMENU.rolemenuid
is '主键';
comment on column BPMS_ROLEMENU.roleid
is '权限ID';
comment on column BPMS_ROLEMENU.menuid
is '菜单ID';
--表BPMS_ROLEMENU
-- Add comments to the table
comment on table BPMS_ROLEMENUBUTTON
is '角色按钮表';
-- Add comments to the columns
comment on column BPMS_ROLEMENUBUTTON.rolemenubuttonid
is '主键';
comment on column BPMS_ROLEMENUBUTTON.roleid
is '角色ID';
comment on column BPMS_ROLEMENUBUTTON.menuid
is '菜单ID';
comment on column BPMS_ROLEMENUBUTTON.buttonid
is '按钮ID';
--BPMS_ROLES
-- Add comments to the table
comment on table BPMS_ROLES
is '角色表';
-- Add comments to the columns
comment on column BPMS_ROLES.roleid
is '主键';
comment on column BPMS_ROLES.organizationid
is '机构ID';
comment on column BPMS_ROLES.parentid
is '父级ID';
comment on column BPMS_ROLES.code
is '编码';
comment on column BPMS_ROLES.fullname
is '名称';
comment on column BPMS_ROLES.category
is '类型';
comment on column BPMS_ROLES.description
is '描述';
comment on column BPMS_ROLES.allowedit
is '允许编辑标识';
comment on column BPMS_ROLES.allowdelete
is '允许删除标识';
comment on column BPMS_ROLES.enabled
is '是否启用';
comment on column BPMS_ROLES.sortcode
is '排序';
comment on column BPMS_ROLES.deletemark
is '删除标识';
--表BPMS_SYSLOGDETAILS
-- Add comments to the table
comment on table BPMS_SYSLOGDETAILS
is '操作日志详细表';
-- Add comments to the columns
comment on column BPMS_SYSLOGDETAILS.syslogdetailsid
is '主键';
comment on column BPMS_SYSLOGDETAILS.syslogsid
is '日志ID';
comment on column BPMS_SYSLOGDETAILS.fieldname
is '操作字段名';
comment on column BPMS_SYSLOGDETAILS.fieldtext
is '操作字段内容';
comment on column BPMS_SYSLOGDETAILS.newvalue
is '操作字段变更内容';
comment on column BPMS_SYSLOGDETAILS.oldvalue
is '操作字段原内容';
comment on column BPMS_SYSLOGDETAILS.remark
is '操作内容详细';
--BPMS_SYSLOGINLOG
-- Add comments to the table
comment on table BPMS_SYSLOGINLOG
is '登录日志表';
-- Add comments to the columns
comment on column BPMS_SYSLOGINLOG.sysloginlogid
is '主键';
comment on column BPMS_SYSLOGINLOG.createdate
is '登录时间';
comment on column BPMS_SYSLOGINLOG.account
is '登录账号';
comment on column BPMS_SYSLOGINLOG.status
is '状态';
comment on column BPMS_SYSLOGINLOG.ipaddress
is 'IP地址';
comment on column BPMS_SYSLOGINLOG.ipaddressname
is '网络名';
--BPMS_SYSMENU
-- Add comments to the table
comment on table BPMS_SYSMENU
is '系统菜单表';
-- Add comments to the columns
comment on column BPMS_SYSMENU.menuid
is '主键';
comment on column BPMS_SYSMENU.parentid
is '父级ID';
comment on column BPMS_SYSMENU.code
is '编码';
comment on column BPMS_SYSMENU.fullname
is '菜单名';
comment on column BPMS_SYSMENU.description
is '描述';
comment on column BPMS_SYSMENU.img
is '图片标识';
comment on column BPMS_SYSMENU.category
is '类别';
comment on column BPMS_SYSMENU.navigateurl
is '菜单URL';
comment on column BPMS_SYSMENU.formname
is '表单名';
comment on column BPMS_SYSMENU.target
is '打开目标';
comment on column BPMS_SYSMENU.isunfold
is '是否打开下级菜单';
comment on column BPMS_SYSMENU.allowedit
is '允许编辑标识';
comment on column BPMS_SYSMENU.allowdelete
is '允许删除标识';
comment on column BPMS_SYSMENU.enabled
is '是否启用';
comment on column BPMS_SYSMENU.sortcode
is '排序';
comment on column BPMS_SYSMENU.deletemark
is '删除标识';
-- Add comments to the table
comment on table BPMS_SYSMENUBUTTON
is '菜单按钮表';
-- Add comments to the columns
comment on column BPMS_SYSMENUBUTTON.sysmenubuttonid
is '主键';
comment on column BPMS_SYSMENUBUTTON.menuid
is '菜单ID';
comment on column BPMS_SYSMENUBUTTON.buttonid
is '按钮ID';
comment on column BPMS_SYSMENUBUTTON.sortcode
is '排序';
-- Add comments to the columns
comment on column BPMS_USER.userid
is '主键';
comment on column BPMS_USER.account
is '账号';
comment on column BPMS_USER.password
is '密码';
comment on column BPMS_USER.secretkey
is '密钥';
comment on column BPMS_USER.realname
is '姓名';
comment on column BPMS_USER.roleid
is '默认角色ID';
comment on column BPMS_USER.email
is '电子邮件';
comment on column BPMS_USER.h_phone
is '家庭电话';
comment on column BPMS_USER.dutyid
is '职位ID';
comment on column BPMS_USER.departmentid
is '所属部门';
comment on column BPMS_USER.description
is '描述';
comment on column BPMS_USER.ipaddress
is '最后登录IP';
comment on column BPMS_USER.macaddress
is 'MAC地址';
comment on column BPMS_USER.logoncount
is '登录次数';
comment on column BPMS_USER.firstvisit
is '第一次登录时间';
comment on column BPMS_USER.previousvisit
is '上次登录时间';
comment on column BPMS_USER.lastvisit
is '最后登录时间';
comment on column BPMS_USER.enabled
is '是否启用';
comment on column BPMS_USER.sortcode
is '排序';
comment on column BPMS_USER.deletemark
is '删除标识';
-- Add comments to the table
comment on table BPMS_USERMENU
is '用户菜单表';
-- Add comments to the columns
comment on column BPMS_USERMENU.usermenuid
is '主键';
comment on column BPMS_USERMENU.userid
is '用户ID';
comment on column BPMS_USERMENU.menuid
is '菜单ID';
-- Add comments to the table
comment on table BPMS_USERMENUBUTTON
is '用户按钮表';
-- Add comments to the columns
comment on column BPMS_USERMENUBUTTON.usermenubuttonid
is '主键';
comment on column BPMS_USERMENUBUTTON.userid
is '用户ID';
comment on column BPMS_USERMENUBUTTON.menuid
is '菜单ID';
comment on column BPMS_USERMENUBUTTON.buttonid
is '按钮ID';
-- Add comments to the table
comment on table BPMS_USERROLE
is '用户角色表';
-- Add comments to the columns
comment on column BPMS_USERROLE.userroleid
is '主键';
comment on column BPMS_USERROLE.userid
is '用户Id';
comment on column BPMS_USERROLE.roleid
is '角色ID';
标签：
车辆管理系统更新和维护的字段 
上一条：
下一条：
相关评论
发表评论