CREATE TABLE cas_branch_info ( id integer NOT NULL DEFAULT nextval('seq_cas_branch_info'::regclass), name character varying NOT NULL, cas_branch_type integer, remark character varying, seq integer, delete_flag integer NOT NULL DEFAULT 0, aid integer, atime timestamp without time zone NOT NULL DEFAULT now(), mid integer, mtime timestamp without time zone DEFAULT now(), CONSTRAINT pkey_cas_branch_info PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE cas_branch_info OWNER TO postgres; COMMENT ON TABLE cas_branch_info IS '学会信息表'; COMMENT ON COLUMN cas_branch_info.id IS 'pk'; COMMENT ON COLUMN cas_branch_info.name IS '学会名称'; COMMENT ON COLUMN cas_branch_info.cas_branch_type IS '学会类型'; COMMENT ON COLUMN cas_branch_info.remark IS '描述'; COMMENT ON COLUMN cas_branch_info.seq IS '排序'; COMMENT ON COLUMN cas_branch_info.delete_flag IS '删除标记'; COMMENT ON COLUMN cas_branch_info.aid IS '记录新增人员ID'; COMMENT ON COLUMN cas_branch_info.atime IS '记录新增时间'; COMMENT ON COLUMN cas_branch_info.mid IS '记录修改人员ID'; COMMENT ON COLUMN cas_branch_info.mtime IS '记录修改时间'; CREATE TABLE cas_branch_user_relation ( id integer NOT NULL DEFAULT nextval('seq_cas_branch_user_relation'::regclass), lsp_user_id integer NOT NULL, branch_id integer NOT NULL, aid integer, atime timestamp without time zone NOT NULL DEFAULT now(), mid integer, mtime timestamp without time zone DEFAULT now(), CONSTRAINT pkey_cas_branch_user_relation PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE cas_branch_user_relation OWNER TO postgres; COMMENT ON TABLE cas_branch_user_relation IS '学会用户关联表'; COMMENT ON COLUMN cas_branch_user_relation.id IS 'pk'; COMMENT ON COLUMN cas_branch_user_relation.lsp_user_id IS '姓名'; COMMENT ON COLUMN cas_branch_user_relation.branch_id IS '性别'; COMMENT ON COLUMN cas_branch_user_relation.aid IS '记录新增人员ID'; COMMENT ON COLUMN cas_branch_user_relation.atime IS '记录新增时间'; COMMENT ON COLUMN cas_branch_user_relation.mid IS '记录修改人员ID'; COMMENT ON COLUMN cas_branch_user_relation.mtime IS '记录修改时间'; CREATE TABLE cas_user_info ( id integer NOT NULL DEFAULT nextval('seq_cas_user_info'::regclass), lsp_user_id integer, name character varying NOT NULL, sex integer, birthday timestamp without time zone DEFAULT now(), id_no character varying, portrait_id integer, unit character varying, cas_unit_status integer, branch_id integer, address character varying, postal_code character varying, duty character varying, office_tel character varying, phone character varying, email character varying, success_case character varying, apply_cause character varying, cas_user_type integer, cas_service_require character varying, apply_time timestamp without time zone DEFAULT now(), cas_user_approval_status integer, approval_lsp_user_id integer, approval_time timestamp without time zone DEFAULT now(), advice character varying, cas_user_approval_status_manage integer, approval_lsp_user_id_manage integer, approval_time_manage timestamp without time zone DEFAULT now(), advice_manage character varying, education integer, evaluation character varying, delete_flag integer DEFAULT 0, nation_type integer, work_time timestamp without time zone DEFAULT now(), political_type integer, work_title character varying, cas_expert_group integer, research_direction character varying, fax character varying, honor character varying, join_active character varying, aid integer, atime timestamp without time zone NOT NULL DEFAULT now(), mid integer, mtime timestamp without time zone DEFAULT now(), CONSTRAINT pkey_cas_user_info PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE cas_user_info OWNER TO postgres; COMMENT ON TABLE cas_user_info IS '会员基本信息'; COMMENT ON COLUMN cas_user_info.id IS 'pk'; COMMENT ON COLUMN cas_user_info.name IS '姓名'; COMMENT ON COLUMN cas_user_info.sex IS '性别'; COMMENT ON COLUMN cas_user_info.birthday IS '生日'; COMMENT ON COLUMN cas_user_info.id_no IS '身份证号'; COMMENT ON COLUMN cas_user_info.portrait_id IS '证件照'; COMMENT ON COLUMN cas_user_info.unit IS '单位'; COMMENT ON COLUMN cas_user_info.cas_unit_status IS '单位性质'; COMMENT ON COLUMN cas_user_info.branch_id IS '学会id'; COMMENT ON COLUMN cas_user_info.address IS '通讯地址'; COMMENT ON COLUMN cas_user_info.postal_code IS '邮政编码'; COMMENT ON COLUMN cas_user_info.duty IS '职务'; COMMENT ON COLUMN cas_user_info.office_tel IS '办公电话'; COMMENT ON COLUMN cas_user_info.phone IS '手机号'; COMMENT ON COLUMN cas_user_info.email IS '邮箱'; COMMENT ON COLUMN cas_user_info.success_case IS '业内成果'; COMMENT ON COLUMN cas_user_info.apply_cause IS '申请原因'; COMMENT ON COLUMN cas_user_info.cas_user_type IS '用户类型'; COMMENT ON COLUMN cas_user_info.cas_service_require IS '服务需求'; COMMENT ON COLUMN cas_user_info.apply_time IS '申请时间'; COMMENT ON COLUMN cas_user_info.cas_user_approval_status IS '审核状态'; COMMENT ON COLUMN cas_user_info.approval_lsp_user_id IS '审核人'; COMMENT ON COLUMN cas_user_info.approval_time IS '审核时间'; COMMENT ON COLUMN cas_user_info.advice IS '审核建议'; COMMENT ON COLUMN cas_user_info.cas_user_approval_status_manage IS '总会审核状态'; COMMENT ON COLUMN cas_user_info.approval_lsp_user_id_manage IS '总会审核人'; COMMENT ON COLUMN cas_user_info.approval_time_manage IS '总会审核时间'; COMMENT ON COLUMN cas_user_info.advice_manage IS '总会审核建议'; COMMENT ON COLUMN cas_user_info.education IS '学历'; COMMENT ON COLUMN cas_user_info.evaluation IS '自我评价'; COMMENT ON COLUMN cas_user_info.delete_flag IS '删除标记'; COMMENT ON COLUMN cas_user_info.nation_type IS '民族'; COMMENT ON COLUMN cas_user_info.work_time IS '工作时间'; COMMENT ON COLUMN cas_user_info.political_type IS '政治面貌'; COMMENT ON COLUMN cas_user_info.work_title IS '职称'; COMMENT ON COLUMN cas_user_info.cas_expert_group IS '专家组别'; COMMENT ON COLUMN cas_user_info.research_direction IS '研究方向'; COMMENT ON COLUMN cas_user_info.fax IS '传真'; COMMENT ON COLUMN cas_user_info.honor IS '曾获荣誉'; COMMENT ON COLUMN cas_user_info.join_active IS '参加活动'; COMMENT ON COLUMN cas_user_info.aid IS '记录新增人员ID'; COMMENT ON COLUMN cas_user_info.atime IS '记录新增时间'; COMMENT ON COLUMN cas_user_info.mid IS '记录修改人员ID'; COMMENT ON COLUMN cas_user_info.mtime IS '记录修改时间'; CREATE TABLE cas_approval_history ( id integer NOT NULL DEFAULT nextval('seq_cas_approval_history'::regclass), user_id integer, advice character varying, cas_user_approval_status integer, approval_lsp_user_id integer, apply_time timestamp without time zone NOT NULL DEFAULT now(), aid integer, atime timestamp without time zone NOT NULL DEFAULT now(), CONSTRAINT pkey_cas_approval_history PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE cas_approval_history OWNER TO postgres; COMMENT ON TABLE cas_approval_history IS '会员审核履历'; COMMENT ON COLUMN cas_approval_history.id IS 'pk'; COMMENT ON COLUMN cas_approval_history.user_id IS '姓名'; COMMENT ON COLUMN cas_approval_history.advice IS '性别'; COMMENT ON COLUMN cas_approval_history.cas_user_approval_status IS '审核状态'; COMMENT ON COLUMN cas_approval_history.approval_lsp_user_id IS '审核人'; COMMENT ON COLUMN cas_approval_history.apply_time IS '申请时间'; COMMENT ON COLUMN cas_approval_history.aid IS '记录新增人员ID'; COMMENT ON COLUMN cas_approval_history.atime IS '记录新增时间'; CREATE TABLE cas_unit_info ( id integer NOT NULL DEFAULT nextval('seq_cas_unit_info'::regclass), user_id integer, name character varying, cas_unit_status integer, organ_no character varying, unit_people_num integer, register_money character varying, company_user character varying, company_sex integer, company_birthday timestamp without time zone DEFAULT now(), company_education character varying, company_title character varying, company_duty character varying, company_server_thing character varying, company_phone character varying, company_team character varying, unit_remake character varying, technological_personnel integer, technological_high integer, technological_module integer, technological_other integer, company_work character varying, technological_work_remake character varying, fax character varying, delete_flag integer, aid integer, atime timestamp without time zone NOT NULL DEFAULT now(), mid integer, mtime timestamp without time zone DEFAULT now(), CONSTRAINT pkey_cas_unit_info PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE cas_unit_info OWNER TO postgres; COMMENT ON TABLE cas_unit_info IS '单位详细信息'; COMMENT ON COLUMN cas_unit_info.id IS 'pk'; COMMENT ON COLUMN cas_unit_info.user_id IS '用户id'; COMMENT ON COLUMN cas_unit_info.name IS '单位名称'; COMMENT ON COLUMN cas_unit_info.cas_unit_status IS '单位性质'; COMMENT ON COLUMN cas_unit_info.organ_no IS '组织机构代码'; COMMENT ON COLUMN cas_unit_info.unit_people_num IS '单位人数'; COMMENT ON COLUMN cas_unit_info.register_money IS '注册资金'; COMMENT ON COLUMN cas_unit_info.company_user IS '法人姓名'; COMMENT ON COLUMN cas_unit_info.company_sex IS '法人性别'; COMMENT ON COLUMN cas_unit_info.company_birthday IS '法人生日'; COMMENT ON COLUMN cas_unit_info.company_education IS '法人学历'; COMMENT ON COLUMN cas_unit_info.company_title IS '法人职称'; COMMENT ON COLUMN cas_unit_info.company_duty IS '法人职务'; COMMENT ON COLUMN cas_unit_info.company_server_thing IS '法人主管业务'; COMMENT ON COLUMN cas_unit_info.company_phone IS '法人电话'; COMMENT ON COLUMN cas_unit_info.company_team IS '法人社会任职情况'; COMMENT ON COLUMN cas_unit_info.unit_remake IS '公司简介'; COMMENT ON COLUMN cas_unit_info.technological_personnel IS '科技人员总数'; COMMENT ON COLUMN cas_unit_info.technological_high IS '高级技术人员总数'; COMMENT ON COLUMN cas_unit_info.technological_module IS '劳动模范人数'; COMMENT ON COLUMN cas_unit_info.technological_other IS '行业标兵人员你总数'; COMMENT ON COLUMN cas_unit_info.company_work IS '业务返回主要成果'; COMMENT ON COLUMN cas_unit_info.technological_work_remake IS '科技工作简介'; COMMENT ON COLUMN cas_unit_info.fax IS '传真'; COMMENT ON COLUMN cas_unit_info.delete_flag IS '删除标记'; COMMENT ON COLUMN cas_unit_info.aid IS '记录新增人员ID'; COMMENT ON COLUMN cas_unit_info.atime IS '记录新增时间'; COMMENT ON COLUMN cas_unit_info.mid IS '记录修改人员ID'; COMMENT ON COLUMN cas_unit_info.mtime IS '记录修改时间'; CREATE TABLE cas_work_record_info ( id integer NOT NULL DEFAULT nextval('seq_cas_work_record_info'::regclass), user_id integer, unit character varying, work_type character varying, duty character varying, begin_time timestamp without time zone DEFAULT now(), end_time timestamp without time zone DEFAULT now(), remake character varying, img_id character varying, delete_flag integer, aid integer, atime timestamp without time zone NOT NULL DEFAULT now(), mid integer, mtime timestamp without time zone DEFAULT now(), CONSTRAINT pkey_cas_work_record_info PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE cas_work_record_info OWNER TO postgres; COMMENT ON TABLE cas_work_record_info IS '工作履历'; COMMENT ON COLUMN cas_work_record_info.id IS 'pk'; COMMENT ON COLUMN cas_work_record_info.user_id IS '用户id'; COMMENT ON COLUMN cas_work_record_info.unit IS '工作单位'; COMMENT ON COLUMN cas_work_record_info.work_type IS '从事工作'; COMMENT ON COLUMN cas_work_record_info.duty IS '职务'; COMMENT ON COLUMN cas_work_record_info.begin_time IS '开始时间'; COMMENT ON COLUMN cas_work_record_info.end_time IS '结束时间'; COMMENT ON COLUMN cas_work_record_info.remake IS '描述'; COMMENT ON COLUMN cas_work_record_info.img_id IS '图片id'; COMMENT ON COLUMN cas_unit_info.delete_flag IS '删除标记'; COMMENT ON COLUMN cas_work_record_info.aid IS '记录新增人员ID'; COMMENT ON COLUMN cas_work_record_info.atime IS '记录新增时间'; COMMENT ON COLUMN cas_work_record_info.mid IS '记录修改人员ID'; COMMENT ON COLUMN cas_work_record_info.mtime IS '记录修改时间'; CREATE TABLE cas_case_info ( id integer NOT NULL DEFAULT nextval('seq_cas_case_info'::regclass), user_id integer, name character varying, role_position character varying, reward character varying, begin_time timestamp without time zone DEFAULT now(), end_time timestamp without time zone DEFAULT now(), remake character varying, img_id character varying, delete_flag integer, aid integer, atime timestamp without time zone NOT NULL DEFAULT now(), mid integer, mtime timestamp without time zone DEFAULT now(), CONSTRAINT pkey_cas_case_info PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE cas_case_info OWNER TO postgres; COMMENT ON TABLE cas_case_info IS '工作业绩表'; COMMENT ON COLUMN cas_case_info.id IS 'pk'; COMMENT ON COLUMN cas_case_info.user_id IS '用户id'; COMMENT ON COLUMN cas_case_info.name IS '项目课题名称'; COMMENT ON COLUMN cas_case_info.role_position IS '担任角色'; COMMENT ON COLUMN cas_case_info.reward IS '奖励'; COMMENT ON COLUMN cas_case_info.begin_time IS '开始时间'; COMMENT ON COLUMN cas_case_info.end_time IS '结束时间'; COMMENT ON COLUMN cas_case_info.remake IS '描述'; COMMENT ON COLUMN cas_case_info.img_id IS '图片id'; COMMENT ON COLUMN cas_unit_info.delete_flag IS '删除标记'; COMMENT ON COLUMN cas_case_info.aid IS '记录新增人员ID'; COMMENT ON COLUMN cas_case_info.atime IS '记录新增时间'; COMMENT ON COLUMN cas_case_info.mid IS '记录修改人员ID'; COMMENT ON COLUMN cas_case_info.mtime IS '记录修改时间'; CREATE TABLE cas_article_info ( id integer NOT NULL DEFAULT nextval('seq_cas_article_info'::regclass), user_id integer, title character varying, publish_time timestamp without time zone DEFAULT now(), author character varying, publish_type character varying, ranking character varying, certificate character varying, award_time timestamp without time zone DEFAULT now(), img_id character varying, remake character varying, delete_flag integer, aid integer, atime timestamp without time zone NOT NULL DEFAULT now(), mid integer, mtime timestamp without time zone DEFAULT now(), CONSTRAINT pkey_cas_article_info PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); ALTER TABLE cas_article_info OWNER TO postgres; COMMENT ON TABLE cas_article_info IS '工作业绩表'; COMMENT ON COLUMN cas_article_info.id IS 'pk'; COMMENT ON COLUMN cas_article_info.user_id IS '用户id'; COMMENT ON COLUMN cas_article_info.title IS '标题'; COMMENT ON COLUMN cas_article_info.publish_time IS '出版时间'; COMMENT ON COLUMN cas_article_info.author IS '作者'; COMMENT ON COLUMN cas_article_info.publish_type IS '发表情况'; COMMENT ON COLUMN cas_article_info.ranking IS '排名'; COMMENT ON COLUMN cas_article_info.certificate IS '证书（获奖情况）'; COMMENT ON COLUMN cas_article_info.award_time IS '获奖时间'; COMMENT ON COLUMN cas_article_info.img_id IS '图片id'; COMMENT ON COLUMN cas_article_info.remake IS '描述'; COMMENT ON COLUMN cas_unit_info.delete_flag IS '删除标记'; COMMENT ON COLUMN cas_article_info.aid IS '记录新增人员ID'; COMMENT ON COLUMN cas_article_info.atime IS '记录新增时间'; COMMENT ON COLUMN cas_article_info.mid IS '记录修改人员ID'; COMMENT ON COLUMN cas_article_info.mtime IS '记录修改时间';