组织管理模块页面设计.docx

1、组织分类定义OrganizationClassify1.1查询页面 1.2 新增页面- Create tablecreate table ORGAN_TYPE( organ_type_id NUMBER not null, organ_type_no VARCHAR2(50), organ_type_name VARCHAR2(50), repeat_flag CHAR(1), creator VARCHAR2(50), create_date DATE, lastupdator VARCHAR2(50), lastupdate_date DATE, remark VARCHAR2(200)tablespace TS_DAT_HQ pctfree 10 initrans 1 maxtrans 255;- Add comments to the table comment on table ORGAN_TYPE is 组织类型;- Add comments to the columns comment on column ORGAN_TYPE.organ_type_id is 序号;comment on column ORGAN_TYPE.organ_type_no is 组织分类编码;comment on column ORGAN_TYPE.organ_type_name is 组织分类名称;comment on column ORGAN_TYPE.repeat_flag is 是否允许重复;comment on column ORGAN_TYPE.creator is 创建人;comment on column ORGAN_TYPE.create_date is 创建时间;comment on column ORGAN_TYPE.lastupdator is 最后更新人;comment on column ORGAN_TYPE.lastupdate_date is 最后更新时间;comment on column ORGAN_TYPE.remark is 备注;- Create/Recreate primary, unique and foreign key constraints alter table ORGAN_TYPE add constraint PK_ORGAN_TYPE primary key (ORGAN_TYPE_ID) using index tablespace TS_DAT_HQ pctfree 10 initrans 2 maxtrans 255;2、组织属性定义2.1 查询页面- Create tablecreate table ORGAN_PROP( organ_prop_id NUMBER not null, organ_prop_name VARCHAR2(50), remark VARCHAR2(200), creator VARCHAR2(50), create_date DATE, lastupdator VARCHAR2(50), lastupdate_date DATE)tablespace TS_DAT_HQ pctfree 10 initrans 1 maxtrans 255;- Add comments to the table comment on table ORGAN_PROP is 组织属性;- Add comments to the columns comment on column ORGAN_PROP.organ_prop_id is 序号;comment on column ORGAN_PROP.organ_prop_name is 组织属性ID;comment on column ORGAN_PROP.remark is 备注;comment on column ORGAN_PROP.creator is 创建人;comment on column ORGAN_PROP.create_date is 创建时间;comment on column ORGAN_PROP.lastupdator is 最后更新人;comment on column ORGAN_PROP.lastupdate_date is 最后更新时间;- Create/Recreate primary, unique and foreign key constraints alter table ORGAN_PROP add constraint PK_ORGAN_PROP primary key (ORGAN_PROP_ID) using index tablespace TS_DAT_HQ pctfree 10 initrans 2 maxtrans 255;3、组织关系维护3.1树形查询页面3.2 新增页面各位： 组织结构管理表重新整理了下，新建 组织属性表 ORGAN_PROP （对应序列SEQ_ORGAN_PROP ），组织类型表ORGAN_T