cas/ddl/postgresql/v0.2.11/2_table.sql

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 '记录修改时间';