2637 lines
87 KiB
SQL
2637 lines
87 KiB
SQL
create table "ks_db3"."app_notice"
|
||
(
|
||
"notice_id" int not null,
|
||
"notice_title" varchar(50) not null,
|
||
"notice_type" char(1) not null,
|
||
"notice_content" text null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(255) null
|
||
);
|
||
create table "ks_db3"."app_review_job"
|
||
(
|
||
"id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"job_id" bigint not null,
|
||
"review_date" timestamp(6) not null,
|
||
"del_flag" char(1) not null,
|
||
"create_by" varchar(100) null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(100) null,
|
||
"remark" varchar(100) null,
|
||
"update_time" timestamp(0) null
|
||
);
|
||
create table "ks_db3"."app_user"
|
||
(
|
||
"user_id" bigint not null,
|
||
"name" varchar(50) null,
|
||
"age" varchar(10) null,
|
||
"sex" char(1) default '0'
|
||
null,
|
||
"birth_date" timestamp(0) null,
|
||
"education" char(1) null,
|
||
"political_affiliation" varchar(100) null,
|
||
"phone" varchar(11) default ''
|
||
null,
|
||
"avatar" varchar(100) default ''
|
||
null,
|
||
"salary_min" varchar(10) null,
|
||
"salary_max" varchar(10) null,
|
||
"area" char(1) null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"login_ip" varchar(128) default ''
|
||
null,
|
||
"login_date" timestamp(0) null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"job_title_id" text null,
|
||
"experience" varchar(100) null,
|
||
"is_recommend" char(1) default 1
|
||
not null,
|
||
"password" text null
|
||
);
|
||
create table "ks_db3"."app_user_work"
|
||
(
|
||
"id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"work_type_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"name" varchar(100) null
|
||
);
|
||
create table "ks_db3"."bussiness_dict_data"
|
||
(
|
||
"dict_code" bigint not null,
|
||
"dict_sort" int default 0
|
||
null,
|
||
"dict_label" varchar(100) default ''
|
||
null,
|
||
"dict_value" varchar(100) default ''
|
||
null,
|
||
"dict_type" varchar(100) default ''
|
||
null,
|
||
"css_class" varchar(100) null,
|
||
"list_class" varchar(100) null,
|
||
"is_default" char(1) default 'n'
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."bussiness_dict_type"
|
||
(
|
||
"dict_id" bigint not null,
|
||
"dict_name" varchar(100) default ''
|
||
null,
|
||
"dict_type" varchar(100) default ''
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."bussiness_oper_log"
|
||
(
|
||
"oper_id" bigint not null,
|
||
"title" varchar(50) default ''
|
||
null,
|
||
"business_type" int default 0
|
||
null,
|
||
"method" varchar(200) default ''
|
||
null,
|
||
"request_method" varchar(10) default ''
|
||
null,
|
||
"operator_type" int default 0
|
||
null,
|
||
"oper_name" varchar(50) default ''
|
||
null,
|
||
"dept_name" varchar(50) default ''
|
||
null,
|
||
"oper_url" varchar(255) default ''
|
||
null,
|
||
"oper_ip" varchar(128) default ''
|
||
null,
|
||
"oper_location" varchar(255) default ''
|
||
null,
|
||
"oper_param" varchar(2000) default ''
|
||
null,
|
||
"json_result" varchar(2000) default ''
|
||
null,
|
||
"status" int default 0
|
||
null,
|
||
"error_msg" varchar(2000) default ''
|
||
null,
|
||
"oper_time" timestamp(0) null,
|
||
"cost_time" bigint default 0
|
||
null
|
||
);
|
||
create table "ks_db3"."commercial_area"
|
||
(
|
||
"commercial_area_id" bigint not null,
|
||
"commercial_area_name" varchar(255) not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"latitude" decimal(10,7) null,
|
||
"longitude" decimal(10,7) null,
|
||
"address" varchar(100) null
|
||
);
|
||
create table "ks_db3"."company"
|
||
(
|
||
"company_id" bigint not null,
|
||
"name" varchar(255) not null,
|
||
"location" varchar(255) null,
|
||
"industry" varchar(100) null,
|
||
"scale" varchar(100) null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"code" varchar(100) null,
|
||
"description" text null,
|
||
"nature" varchar(100) null,
|
||
"total_recruitment" int null
|
||
);
|
||
create table "ks_db3"."company_card"
|
||
(
|
||
"company_card_id" bigint not null,
|
||
"name" varchar(255) not null,
|
||
"targ" text null,
|
||
"backgroud_color" varchar(100) null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"status" char(1) null,
|
||
"company_nature" text null,
|
||
"card_order" char(1) null,
|
||
"description" text null
|
||
);
|
||
create table "ks_db3"."company_card_collection"
|
||
(
|
||
"company_card_collection_id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"company_card_id" bigint not null
|
||
);
|
||
create table "ks_db3"."company_collection"
|
||
(
|
||
"id" bigint not null,
|
||
"company_id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."company_label"
|
||
(
|
||
"id" bigint not null,
|
||
"dict_value" varchar(19) not null,
|
||
"company_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(6) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(6) null,
|
||
"remark" varchar(100) null
|
||
);
|
||
alter table "ks_db3"."app_notice" add primary key("notice_id") ;
|
||
|
||
alter table "ks_db3"."app_review_job" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."app_user" add primary key("user_id") ;
|
||
|
||
alter table "ks_db3"."app_user_work" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."bussiness_dict_data" add primary key("dict_code") ;
|
||
|
||
alter table "ks_db3"."bussiness_dict_type" add primary key("dict_id") ;
|
||
|
||
alter table "ks_db3"."bussiness_oper_log" add primary key("oper_id") ;
|
||
|
||
alter table "ks_db3"."commercial_area" add primary key("commercial_area_id") ;
|
||
|
||
alter table "ks_db3"."company" add primary key("company_id") ;
|
||
|
||
alter table "ks_db3"."company_card" add primary key("company_card_id") ;
|
||
|
||
alter table "ks_db3"."company_card_collection" add primary key("company_card_collection_id") ;
|
||
|
||
alter table "ks_db3"."company_collection" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."company_label" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."bussiness_dict_type" add constraint "dict_type" unique("dict_type") ;
|
||
|
||
comment on table "ks_db3"."app_notice" is 'app通知公告表';
|
||
|
||
comment on column "ks_db3"."app_notice"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."app_notice"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."app_notice"."notice_content" is '公告内容';
|
||
|
||
comment on column "ks_db3"."app_notice"."notice_id" is '公告id';
|
||
|
||
comment on column "ks_db3"."app_notice"."notice_title" is '公告标题';
|
||
|
||
comment on column "ks_db3"."app_notice"."notice_type" is '公告类型（1通知 2公告）';
|
||
|
||
comment on column "ks_db3"."app_notice"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."app_notice"."status" is '公告状态（0正常 1关闭）';
|
||
|
||
comment on column "ks_db3"."app_notice"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."app_notice"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."app_review_job" is '用户岗位浏览记录';
|
||
|
||
comment on column "ks_db3"."app_review_job"."review_date" is '浏览日期';
|
||
|
||
comment on table "ks_db3"."app_user" is 'app用户表';
|
||
|
||
comment on column "ks_db3"."app_user"."age" is '年龄段 对应字典age';
|
||
|
||
comment on column "ks_db3"."app_user"."area" is '期望工作地 对应字典area';
|
||
|
||
comment on column "ks_db3"."app_user"."avatar" is '头像地址';
|
||
|
||
comment on column "ks_db3"."app_user"."birth_date" is '生日';
|
||
|
||
comment on column "ks_db3"."app_user"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."app_user"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."app_user"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."app_user"."education" is '学历 对应字典education';
|
||
|
||
comment on column "ks_db3"."app_user"."is_recommend" is '是否开启推荐（0不推荐 1推荐）';
|
||
|
||
comment on column "ks_db3"."app_user"."job_title_id" is '期望岗位,逗号分隔';
|
||
|
||
comment on column "ks_db3"."app_user"."login_date" is '最后登录时间';
|
||
|
||
comment on column "ks_db3"."app_user"."login_ip" is '最后登录ip';
|
||
|
||
comment on column "ks_db3"."app_user"."name" is '用户名称';
|
||
|
||
comment on column "ks_db3"."app_user"."phone" is '手机号码';
|
||
|
||
comment on column "ks_db3"."app_user"."political_affiliation" is '政治面貌';
|
||
|
||
comment on column "ks_db3"."app_user"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."app_user"."salary_max" is '最高工资';
|
||
|
||
comment on column "ks_db3"."app_user"."salary_min" is '最低工资';
|
||
|
||
comment on column "ks_db3"."app_user"."sex" is '用户性别（0男 1女）对应字典sex';
|
||
|
||
comment on column "ks_db3"."app_user"."status" is '帐号状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."app_user"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."app_user"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."app_user"."user_id" is '用户id';
|
||
|
||
comment on table "ks_db3"."app_user_work" is '用户职业关联表';
|
||
|
||
comment on column "ks_db3"."app_user_work"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."app_user_work"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."app_user_work"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."app_user_work"."id" is 'id';
|
||
|
||
comment on column "ks_db3"."app_user_work"."name" is '行业类型名称';
|
||
|
||
comment on column "ks_db3"."app_user_work"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."app_user_work"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."app_user_work"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."app_user_work"."user_id" is 'app_user 的id';
|
||
|
||
comment on column "ks_db3"."app_user_work"."work_type_id" is 'work_type的id';
|
||
|
||
comment on table "ks_db3"."bussiness_dict_data" is '业务字典数据表';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."css_class" is '样式属性（其他样式扩展）';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."dict_code" is '字典编码';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."dict_label" is '字典标签';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."dict_sort" is '字典排序';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."dict_type" is '字典类型';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."dict_value" is '字典键值';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."is_default" is '是否默认（y是 n否）';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."list_class" is '表格回显样式';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."status" is '状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_data"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."bussiness_dict_type" is '业务字典类型表';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_type"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_type"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_type"."dict_id" is '字典主键';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_type"."dict_name" is '字典名称';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_type"."dict_type" is '字典类型';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_type"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_type"."status" is '状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_type"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."bussiness_dict_type"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."bussiness_oper_log" is 'app操作日志记录';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."business_type" is '业务类型（0其它 1新增 2修改 3删除）';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."cost_time" is '消耗时间';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."dept_name" is '部门名称';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."error_msg" is '错误消息';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."json_result" is '返回参数';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."method" is '方法名称';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."operator_type" is '操作类别（0其它 1后台用户 2手机端用户）';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."oper_id" is '日志主键';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."oper_ip" is '主机地址';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."oper_location" is '操作地点';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."oper_name" is '操作人员';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."oper_param" is '请求参数';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."oper_time" is '操作时间';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."oper_url" is '请求url';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."request_method" is '请求方式';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."status" is '操作状态（0正常 1异常）';
|
||
|
||
comment on column "ks_db3"."bussiness_oper_log"."title" is '模块标题';
|
||
|
||
comment on table "ks_db3"."commercial_area" is '商圈';
|
||
|
||
comment on column "ks_db3"."commercial_area"."commercial_area_id" is 'id';
|
||
|
||
comment on column "ks_db3"."commercial_area"."commercial_area_name" is '商圈名称';
|
||
|
||
comment on column "ks_db3"."commercial_area"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."commercial_area"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."commercial_area"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."commercial_area"."latitude" is '纬度';
|
||
|
||
comment on column "ks_db3"."commercial_area"."longitude" is '经度';
|
||
|
||
comment on column "ks_db3"."commercial_area"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."commercial_area"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."commercial_area"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."company" is '公司表';
|
||
|
||
comment on column "ks_db3"."company"."code" is '信用代码';
|
||
|
||
comment on column "ks_db3"."company"."company_id" is '公司id';
|
||
|
||
comment on column "ks_db3"."company"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."company"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."company"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."company"."description" is '单位介绍';
|
||
|
||
comment on column "ks_db3"."company"."industry" is '主要行业';
|
||
|
||
comment on column "ks_db3"."company"."location" is '单位地点';
|
||
|
||
comment on column "ks_db3"."company"."name" is '单位名称';
|
||
|
||
comment on column "ks_db3"."company"."nature" is '企业性质';
|
||
|
||
comment on column "ks_db3"."company"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."company"."scale" is '单位规模 对应字典scale';
|
||
|
||
comment on column "ks_db3"."company"."total_recruitment" is '招聘数量';
|
||
|
||
comment on column "ks_db3"."company"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."company"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."company_card" is '公司卡片表';
|
||
|
||
comment on column "ks_db3"."company_card"."backgroud_color" is '背景色';
|
||
|
||
comment on column "ks_db3"."company_card"."card_order" is '排序';
|
||
|
||
comment on column "ks_db3"."company_card"."company_card_id" is '公司id';
|
||
|
||
comment on column "ks_db3"."company_card"."company_nature" is '企业性质 逗号分开';
|
||
|
||
comment on column "ks_db3"."company_card"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."company_card"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."company_card"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."company_card"."description" is '描述';
|
||
|
||
comment on column "ks_db3"."company_card"."name" is '卡片名称';
|
||
|
||
comment on column "ks_db3"."company_card"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."company_card"."status" is '0代表未启用 1代表启用';
|
||
|
||
comment on column "ks_db3"."company_card"."targ" is '标签，逗号分开';
|
||
|
||
comment on column "ks_db3"."company_card"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."company_card"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."company_card_collection" is '公司卡片收藏表';
|
||
|
||
comment on column "ks_db3"."company_card_collection"."company_card_collection_id" is '公司id';
|
||
|
||
comment on column "ks_db3"."company_card_collection"."company_card_id" is '公司id';
|
||
|
||
comment on column "ks_db3"."company_card_collection"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."company_card_collection"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."company_card_collection"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."company_card_collection"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."company_card_collection"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."company_card_collection"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."company_card_collection"."user_id" is '用户id';
|
||
|
||
comment on table "ks_db3"."company_collection" is '用户公司收藏表';
|
||
|
||
comment on column "ks_db3"."company_collection"."company_id" is '公司id';
|
||
|
||
comment on column "ks_db3"."company_collection"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."company_collection"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."company_collection"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."company_collection"."id" is 'id';
|
||
|
||
comment on column "ks_db3"."company_collection"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."company_collection"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."company_collection"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."company_collection"."user_id" is 'app用户id';
|
||
|
||
comment on table "ks_db3"."company_label" is '公司标签';
|
||
|
||
create table "ks_db3"."fair_collection"
|
||
(
|
||
"id" bigint not null,
|
||
"fair_id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(6) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(6) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."fair_company"
|
||
(
|
||
"id" bigint not null,
|
||
"company_id" bigint not null,
|
||
"job_fair_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."file"
|
||
(
|
||
"id" bigint not null,
|
||
"file_url" text not null,
|
||
"bussinessid" bigint null,
|
||
"del_flag" char(1) null,
|
||
"create_by" varchar(64) null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) null,
|
||
"update_time" timestamp(0) null
|
||
);
|
||
create table "ks_db3"."gen_table"
|
||
(
|
||
"table_id" bigint not null,
|
||
"table_name" varchar(200) default ''
|
||
null,
|
||
"table_comment" varchar(500) default ''
|
||
null,
|
||
"sub_table_name" varchar(64) null,
|
||
"sub_table_fk_name" varchar(64) null,
|
||
"class_name" varchar(100) default ''
|
||
null,
|
||
"tpl_category" varchar(200) default 'crud'
|
||
null,
|
||
"tpl_web_type" varchar(30) default ''
|
||
null,
|
||
"package_name" varchar(100) null,
|
||
"module_name" varchar(30) null,
|
||
"business_name" varchar(30) null,
|
||
"function_name" varchar(50) null,
|
||
"function_author" varchar(50) null,
|
||
"gen_type" char(1) default '0'
|
||
null,
|
||
"gen_path" varchar(200) default '/'
|
||
null,
|
||
"options" varchar(1000) null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."gen_table_column"
|
||
(
|
||
"column_id" bigint not null,
|
||
"table_id" bigint null,
|
||
"column_name" varchar(200) null,
|
||
"column_comment" varchar(500) null,
|
||
"column_type" varchar(100) null,
|
||
"java_type" varchar(500) null,
|
||
"java_field" varchar(200) null,
|
||
"is_pk" char(1) null,
|
||
"is_increment" char(1) null,
|
||
"is_required" char(1) null,
|
||
"is_insert" char(1) null,
|
||
"is_edit" char(1) null,
|
||
"is_list" char(1) null,
|
||
"is_query" char(1) null,
|
||
"query_type" varchar(200) default 'eq'
|
||
null,
|
||
"html_type" varchar(200) null,
|
||
"dict_type" varchar(200) default ''
|
||
null,
|
||
"sort" int null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null
|
||
);
|
||
create table "ks_db3"."industr"
|
||
(
|
||
"industry_id" bigint not null,
|
||
"parent_id" bigint default 0
|
||
null,
|
||
"ancestors" varchar(50) default ''
|
||
null,
|
||
"industry_name" varchar(200) default ''
|
||
null,
|
||
"order_num" int default 0
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(6) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(6) null,
|
||
"remark" varchar(100) null
|
||
);
|
||
create table "ks_db3"."industry"
|
||
(
|
||
"industry_id" bigint not null,
|
||
"parent_id" bigint default 0
|
||
null,
|
||
"ancestors" varchar(50) default ''
|
||
null,
|
||
"industry_name" varchar(200) default ''
|
||
null,
|
||
"order_num" int default 0
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(100) null
|
||
);
|
||
create table "ks_db3"."job"
|
||
(
|
||
"job_id" bigint not null,
|
||
"job_title" varchar(255) not null,
|
||
"min_salary" int null,
|
||
"max_salary" int null,
|
||
"education" varchar(2) null,
|
||
"experience" varchar(2) null,
|
||
"company_name" varchar(255) null,
|
||
"job_location" varchar(255) null,
|
||
"posting_date" timestamp(0) null,
|
||
"vacancies" int null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"latitude" decimal(10,7) null,
|
||
"longitude" decimal(10,7) null,
|
||
"view" bigint default 0
|
||
null,
|
||
"company_id" bigint null,
|
||
"is_hot" char(1) null,
|
||
"apply_num" char(1) null,
|
||
"job_location_area_code" varchar(100) null,
|
||
"description" text null,
|
||
"is_publish" char(1) null,
|
||
"data_source" varchar(100) null,
|
||
"job_url" text null,
|
||
"row_id" bigint null,
|
||
"job_category" varchar(100) null,
|
||
"is_explain" int null,
|
||
"explain_url" text null,
|
||
"cover" text null
|
||
);
|
||
create table "ks_db3"."job_apply"
|
||
(
|
||
"id" bigint not null,
|
||
"job_id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"matching_degree" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."job_bak"
|
||
(
|
||
"job_id" bigint not null,
|
||
"job_title" varchar(255) not null,
|
||
"min_salary" int null,
|
||
"max_salary" int null,
|
||
"education" varchar(2) null,
|
||
"experience" varchar(2) null,
|
||
"company_name" varchar(255) null,
|
||
"job_location" varchar(255) null,
|
||
"posting_date" timestamp(0) null,
|
||
"vacancies" int null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"latitude" decimal(10,7) null,
|
||
"longitude" decimal(10,7) null,
|
||
"view" bigint default 0
|
||
not null,
|
||
"company_id" bigint null,
|
||
"is_hot" char(1) null,
|
||
"apply_num" char(1) null,
|
||
"job_location_area_code" varchar(100) null,
|
||
"description" text null,
|
||
"is_publish" char(1) null,
|
||
"data_source" varchar(100) null,
|
||
"job_url" text null,
|
||
"row_id" bigint null,
|
||
"job_category" varchar(100) null
|
||
);
|
||
create table "ks_db3"."job_candidates"
|
||
(
|
||
"id" bigint not null,
|
||
"job_id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"score" bigint null
|
||
);
|
||
create table "ks_db3"."job_collection"
|
||
(
|
||
"id" bigint not null,
|
||
"job_id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."job_fair"
|
||
(
|
||
"job_fair_id" bigint not null,
|
||
"name" varchar(255) not null,
|
||
"job_fair_type" char(1) default '0'
|
||
not null,
|
||
"location" varchar(255) not null,
|
||
"latitude" decimal(10,7) null,
|
||
"longitude" decimal(10,7) null,
|
||
"start_time" timestamp(0) not null,
|
||
"end_time" timestamp(0) not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"description" text null,
|
||
"address" varchar(100) null
|
||
);
|
||
create table "ks_db3"."job_recommend"
|
||
(
|
||
"id" bigint not null,
|
||
"job_id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(6) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(6) null,
|
||
"remark" varchar(500) null,
|
||
"is_read" char(1) null
|
||
);
|
||
create table "ks_db3"."job_title"
|
||
(
|
||
"job_id" bigint not null,
|
||
"parent_id" bigint default 0
|
||
null,
|
||
"job_name" varchar(200) default ''
|
||
null,
|
||
"order_num" int default 0
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(6) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(6) null,
|
||
"remark" varchar(100) null
|
||
);
|
||
create table "ks_db3"."notice"
|
||
(
|
||
"notice_id" int not null,
|
||
"title" text null,
|
||
"notice_type" char(1) not null,
|
||
"notice_content" text null,
|
||
"is_read" char(1) not null,
|
||
"user_id" int not null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(6) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(6) null,
|
||
"remark" varchar(255) null,
|
||
"del_flag" varchar(100) null,
|
||
"sub_title" text null,
|
||
"not_read_count" char(1) null,
|
||
"date" timestamp(6) null,
|
||
"bussiness_id" bigint null
|
||
);
|
||
create table "ks_db3"."qrtz_blob_triggers"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"trigger_name" varchar(200) not null,
|
||
"trigger_group" varchar(200) not null,
|
||
"blob_data" text null
|
||
);
|
||
create table "ks_db3"."qrtz_calendars"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"calendar_name" varchar(200) not null,
|
||
"calendar" text not null
|
||
);
|
||
create table "ks_db3"."qrtz_cron_triggers"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"trigger_name" varchar(200) not null,
|
||
"trigger_group" varchar(200) not null,
|
||
"cron_expression" varchar(200) not null,
|
||
"time_zone_id" varchar(80) null
|
||
);
|
||
create table "ks_db3"."qrtz_fired_triggers"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"entry_id" varchar(95) not null,
|
||
"trigger_name" varchar(200) not null,
|
||
"trigger_group" varchar(200) not null,
|
||
"instance_name" varchar(200) not null,
|
||
"fired_time" bigint not null,
|
||
"sched_time" bigint not null,
|
||
"priority" int not null,
|
||
"state" varchar(16) not null,
|
||
"job_name" varchar(200) null,
|
||
"job_group" varchar(200) null,
|
||
"is_nonconcurrent" varchar(1) null,
|
||
"requests_recovery" varchar(1) null
|
||
);
|
||
create table "ks_db3"."qrtz_job_details"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"job_name" varchar(200) not null,
|
||
"job_group" varchar(200) not null,
|
||
"description" varchar(250) null,
|
||
"job_class_name" varchar(250) not null,
|
||
"is_durable" varchar(1) not null,
|
||
"is_nonconcurrent" varchar(1) not null,
|
||
"is_update_data" varchar(1) not null,
|
||
"requests_recovery" varchar(1) not null,
|
||
"job_data" text null
|
||
);
|
||
create table "ks_db3"."qrtz_locks"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"lock_name" varchar(40) not null
|
||
);
|
||
create table "ks_db3"."qrtz_paused_trigger_grps"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"trigger_group" varchar(200) not null
|
||
);
|
||
create table "ks_db3"."qrtz_scheduler_state"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"instance_name" varchar(200) not null,
|
||
"last_checkin_time" bigint not null,
|
||
"checkin_interval" bigint not null
|
||
);
|
||
create table "ks_db3"."qrtz_simple_triggers"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"trigger_name" varchar(200) not null,
|
||
"trigger_group" varchar(200) not null,
|
||
"repeat_count" bigint not null,
|
||
"repeat_interval" bigint not null,
|
||
"times_triggered" bigint not null
|
||
);
|
||
create table "ks_db3"."qrtz_simprop_triggers"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"trigger_name" varchar(200) not null,
|
||
"trigger_group" varchar(200) not null,
|
||
"str_prop_1" varchar(512) null,
|
||
"str_prop_2" varchar(512) null,
|
||
"str_prop_3" varchar(512) null,
|
||
"int_prop_1" int null,
|
||
"int_prop_2" int null,
|
||
"long_prop_1" bigint null,
|
||
"long_prop_2" bigint null,
|
||
"dec_prop_1" decimal(13,4) null,
|
||
"dec_prop_2" decimal(13,4) null,
|
||
"bool_prop_1" varchar(1) null,
|
||
"bool_prop_2" varchar(1) null
|
||
);
|
||
create table "ks_db3"."qrtz_triggers"
|
||
(
|
||
"sched_name" varchar(120) not null,
|
||
"trigger_name" varchar(200) not null,
|
||
"trigger_group" varchar(200) not null,
|
||
"job_name" varchar(200) not null,
|
||
"job_group" varchar(200) not null,
|
||
"description" varchar(250) null,
|
||
"next_fire_time" bigint null,
|
||
"prev_fire_time" bigint null,
|
||
"priority" int null,
|
||
"trigger_state" varchar(16) not null,
|
||
"trigger_type" varchar(8) not null,
|
||
"start_time" bigint not null,
|
||
"end_time" bigint null,
|
||
"calendar_name" varchar(200) null,
|
||
"misfire_instr" smallint null,
|
||
"job_data" text null
|
||
);
|
||
create table "ks_db3"."resume"
|
||
(
|
||
"id" bigint not null,
|
||
"user_id" bigint not null,
|
||
"full_name" varchar(100) null,
|
||
"email" varchar(100) null,
|
||
"phone" varchar(20) null,
|
||
"education" varchar(100) null,
|
||
"experience" text null,
|
||
"skills" text null,
|
||
"created_at" timestamp(0) default
|
||
null,
|
||
"updated_at" timestamp(0) default
|
||
null
|
||
);
|
||
create table "ks_db3"."row_work"
|
||
(
|
||
"id" bigint not null,
|
||
"taskid" varchar(100) null,
|
||
"taskname" varchar(100) null,
|
||
"std_class" varchar(100) null,
|
||
"sf" varchar(100) null,
|
||
"zcmc" varchar(100) null,
|
||
"aca112" text null,
|
||
"acb22a" text null,
|
||
"aac011" text null,
|
||
"acb240" text null,
|
||
"recruit_num" varchar(100) null,
|
||
"acb202" text null,
|
||
"aab302" text null,
|
||
"acb241" text null,
|
||
"salary" varchar(100) null,
|
||
"salarylow" varchar(100) null,
|
||
"salaryhight" varchar(100) null,
|
||
"aae397" date null,
|
||
"aab004" text null,
|
||
"aab022" text null,
|
||
"aab019" text null,
|
||
"aae006" text null,
|
||
"aab092" text null,
|
||
"org" text null,
|
||
"ace760" text null,
|
||
"aae004" text null,
|
||
"aae005" text null,
|
||
"num_employers" text null,
|
||
"experience" text null,
|
||
"highlight" text null,
|
||
"minimum_age" text null,
|
||
"maximum_age" text null,
|
||
"sex" text null,
|
||
"industrytype" text null,
|
||
"industrysub" text null,
|
||
"aab019_ok" varchar(100) null,
|
||
"aac011_ok" varchar(100) null,
|
||
"experience_ok" varchar(100) null,
|
||
"num_ok" varchar(100) null,
|
||
"collect_time" date null,
|
||
"clearflag" varchar(100) null,
|
||
"province" varchar(100) null,
|
||
"city" varchar(100) null,
|
||
"county" varchar(100) null,
|
||
"importdate" varchar(100) null,
|
||
"yearmonth" varchar(100) null,
|
||
"isrepeat" varchar(100) null,
|
||
"latitude" varchar(65) null,
|
||
"longitude" varchar(65) null,
|
||
"metro_line" varchar(50) null,
|
||
"district" varchar(50) null,
|
||
"station_name" varchar(50) null
|
||
);
|
||
create table "ks_db3"."row_work_tmp"
|
||
(
|
||
"id" bigint not null,
|
||
"taskid" varchar(100) null,
|
||
"taskname" varchar(100) null,
|
||
"std_class" varchar(100) null,
|
||
"sf" varchar(100) null,
|
||
"zcmc" varchar(100) null,
|
||
"aca112" text null,
|
||
"acb22a" text null,
|
||
"aac011" text null,
|
||
"acb240" text null,
|
||
"recruit_num" varchar(100) null,
|
||
"acb202" text null,
|
||
"aab302" text null,
|
||
"acb241" text null,
|
||
"salary" varchar(100) null,
|
||
"salarylow" varchar(100) null,
|
||
"salaryhight" varchar(100) null,
|
||
"aae397" date null,
|
||
"aab004" text null,
|
||
"aab022" text null,
|
||
"aab019" text null,
|
||
"aae006" text null,
|
||
"aab092" text null,
|
||
"org" text null,
|
||
"ace760" text null,
|
||
"aae004" text null,
|
||
"aae005" text null,
|
||
"num_employers" text null,
|
||
"experience" text null,
|
||
"highlight" text null,
|
||
"minimum_age" text null,
|
||
"maximum_age" text null,
|
||
"sex" text null,
|
||
"industrytype" varchar(100) null,
|
||
"industrysub" varchar(100) null,
|
||
"aab019_ok" varchar(100) null,
|
||
"aac011_ok" varchar(100) null,
|
||
"experience_ok" varchar(100) null,
|
||
"num_ok" varchar(100) null,
|
||
"collect_time" date null,
|
||
"clearflag" varchar(100) null,
|
||
"province" varchar(100) null,
|
||
"city" varchar(100) null,
|
||
"county" varchar(100) null,
|
||
"importdate" varchar(100) null,
|
||
"yearmonth" varchar(100) null,
|
||
"isrepeat" varchar(100) null,
|
||
"latitude" varchar(65) null,
|
||
"longitude" varchar(65) null,
|
||
"metro_line" varchar(50) null,
|
||
"district" varchar(50) null,
|
||
"station_name" varchar(50) null
|
||
);
|
||
create table "ks_db3"."statics"
|
||
(
|
||
"id" bigint not null,
|
||
"time" varchar(100) null,
|
||
"type" varchar(100) null,
|
||
"name" varchar(100) null,
|
||
"data" varchar(100) null,
|
||
"del_flag" varchar(100) null,
|
||
"create_time" timestamp(6) null,
|
||
"create_by" varchar(100) null,
|
||
"update_by" varchar(100) null,
|
||
"update_time" timestamp(6) null,
|
||
"remark" varchar(100) null
|
||
);
|
||
create table "ks_db3"."subway_line"
|
||
(
|
||
"line_id" bigint not null,
|
||
"line_name" varchar(255) not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."subway_station"
|
||
(
|
||
"station_id" bigint not null,
|
||
"station_name" varchar(255) not null,
|
||
"line_name" varchar(255) not null,
|
||
"line_id" bigint not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null,
|
||
"latitude" decimal(10,7) null,
|
||
"longitude" decimal(10,7) null,
|
||
"station_order" int null,
|
||
"address" varchar(100) null
|
||
);
|
||
create table "ks_db3"."sys_config"
|
||
(
|
||
"config_id" int not null,
|
||
"config_name" varchar(100) default ''
|
||
null,
|
||
"config_key" varchar(100) default ''
|
||
null,
|
||
"config_value" varchar(500) default ''
|
||
null,
|
||
"config_type" char(1) default 'n'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."sys_dept"
|
||
(
|
||
"dept_id" bigint not null,
|
||
"parent_id" bigint default 0
|
||
null,
|
||
"ancestors" varchar(50) default ''
|
||
null,
|
||
"dept_name" varchar(30) default ''
|
||
null,
|
||
"order_num" int default 0
|
||
null,
|
||
"leader" varchar(20) null,
|
||
"phone" varchar(11) null,
|
||
"email" varchar(50) null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null
|
||
);
|
||
create table "ks_db3"."sys_dict_data"
|
||
(
|
||
"dict_code" bigint not null,
|
||
"dict_sort" int default 0
|
||
null,
|
||
"dict_label" varchar(100) default ''
|
||
null,
|
||
"dict_value" varchar(100) default ''
|
||
null,
|
||
"dict_type" varchar(100) default ''
|
||
null,
|
||
"css_class" varchar(100) null,
|
||
"list_class" varchar(100) null,
|
||
"is_default" char(1) default 'n'
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."sys_dict_type"
|
||
(
|
||
"dict_id" bigint not null,
|
||
"dict_name" varchar(100) default ''
|
||
null,
|
||
"dict_type" varchar(100) default ''
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."sys_job"
|
||
(
|
||
"job_id" bigint not null,
|
||
"job_name" varchar(64) default ''
|
||
not null,
|
||
"job_group" varchar(64) default 'default'
|
||
not null,
|
||
"invoke_target" varchar(500) not null,
|
||
"cron_expression" varchar(255) default ''
|
||
null,
|
||
"misfire_policy" varchar(20) default '3'
|
||
null,
|
||
"concurrent" char(1) default '1'
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) default ''
|
||
null
|
||
);
|
||
create table "ks_db3"."sys_job_log"
|
||
(
|
||
"job_log_id" bigint not null,
|
||
"job_name" varchar(64) not null,
|
||
"job_group" varchar(64) not null,
|
||
"invoke_target" varchar(500) not null,
|
||
"job_message" varchar(500) null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"exception_info" varchar(2000) default ''
|
||
null,
|
||
"create_time" timestamp(0) null
|
||
);
|
||
create table "ks_db3"."sys_logininfor"
|
||
(
|
||
"info_id" bigint not null,
|
||
"user_name" varchar(50) default ''
|
||
null,
|
||
"ipaddr" varchar(128) default ''
|
||
null,
|
||
"login_location" varchar(255) default ''
|
||
null,
|
||
"browser" varchar(50) default ''
|
||
null,
|
||
"os" varchar(50) default ''
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"msg" varchar(255) default ''
|
||
null,
|
||
"login_time" timestamp(0) null
|
||
);
|
||
create table "ks_db3"."sys_menu"
|
||
(
|
||
"menu_id" bigint not null,
|
||
"menu_name" varchar(50) not null,
|
||
"parent_id" bigint default 0
|
||
null,
|
||
"order_num" int default 0
|
||
null,
|
||
"path" varchar(200) default ''
|
||
null,
|
||
"component" varchar(255) null,
|
||
"query" varchar(255) null,
|
||
"route_name" varchar(50) default ''
|
||
null,
|
||
"is_frame" int default 1
|
||
null,
|
||
"is_cache" int default 0
|
||
null,
|
||
"menu_type" char(1) default ''
|
||
null,
|
||
"visible" char(1) default '0'
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"perms" varchar(100) null,
|
||
"icon" varchar(100) default '#'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) default ''
|
||
null
|
||
);
|
||
create table "ks_db3"."sys_notice"
|
||
(
|
||
"notice_id" int not null,
|
||
"notice_title" varchar(50) not null,
|
||
"notice_type" char(1) not null,
|
||
"notice_content" text null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(255) null
|
||
);
|
||
create table "ks_db3"."sys_oper_log"
|
||
(
|
||
"oper_id" bigint not null,
|
||
"title" varchar(50) default ''
|
||
null,
|
||
"business_type" int default 0
|
||
null,
|
||
"method" varchar(200) default ''
|
||
null,
|
||
"request_method" varchar(10) default ''
|
||
null,
|
||
"operator_type" int default 0
|
||
null,
|
||
"oper_name" varchar(50) default ''
|
||
null,
|
||
"dept_name" varchar(50) default ''
|
||
null,
|
||
"oper_url" varchar(255) default ''
|
||
null,
|
||
"oper_ip" varchar(128) default ''
|
||
null,
|
||
"oper_location" varchar(255) default ''
|
||
null,
|
||
"oper_param" varchar(5000) default ''
|
||
null,
|
||
"json_result" text default ''
|
||
null,
|
||
"status" int default 0
|
||
null,
|
||
"error_msg" varchar(2000) default ''
|
||
null,
|
||
"oper_time" timestamp(0) null,
|
||
"cost_time" bigint default 0
|
||
null
|
||
);
|
||
create table "ks_db3"."sys_post"
|
||
(
|
||
"post_id" bigint not null,
|
||
"post_code" varchar(64) not null,
|
||
"post_name" varchar(50) not null,
|
||
"post_sort" int not null,
|
||
"status" char(1) not null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."sys_role"
|
||
(
|
||
"role_id" bigint not null,
|
||
"role_name" varchar(30) not null,
|
||
"role_key" varchar(100) not null,
|
||
"role_sort" int not null,
|
||
"data_scope" char(1) default '1'
|
||
null,
|
||
"menu_check_strictly" char(1) default 1
|
||
null,
|
||
"dept_check_strictly" char(1) default 1
|
||
null,
|
||
"status" char(1) not null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."sys_role_dept"
|
||
(
|
||
"role_id" bigint not null,
|
||
"dept_id" bigint not null
|
||
);
|
||
create table "ks_db3"."sys_role_menu"
|
||
(
|
||
"role_id" bigint not null,
|
||
"menu_id" bigint not null
|
||
);
|
||
create table "ks_db3"."sys_user"
|
||
(
|
||
"user_id" bigint not null,
|
||
"dept_id" bigint null,
|
||
"user_name" varchar(30) not null,
|
||
"nick_name" varchar(30) not null,
|
||
"user_type" varchar(2) default '00'
|
||
null,
|
||
"email" varchar(50) default ''
|
||
null,
|
||
"phonenumber" varchar(11) default ''
|
||
null,
|
||
"sex" char(1) default '0'
|
||
null,
|
||
"avatar" varchar(100) default ''
|
||
null,
|
||
"password" varchar(100) default ''
|
||
null,
|
||
"status" char(1) default '0'
|
||
null,
|
||
"del_flag" char(1) default '0'
|
||
null,
|
||
"login_ip" varchar(128) default ''
|
||
null,
|
||
"login_date" timestamp(0) null,
|
||
"create_by" varchar(64) default ''
|
||
null,
|
||
"create_time" timestamp(0) null,
|
||
"update_by" varchar(64) default ''
|
||
null,
|
||
"update_time" timestamp(0) null,
|
||
"remark" varchar(500) null
|
||
);
|
||
create table "ks_db3"."sys_user_post"
|
||
(
|
||
"user_id" bigint not null,
|
||
"post_id" bigint not null
|
||
);
|
||
create table "ks_db3"."sys_user_role"
|
||
(
|
||
"user_id" bigint not null,
|
||
"role_id" bigint not null
|
||
);
|
||
alter table "ks_db3"."fair_collection" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."fair_company" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."file" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."gen_table" add primary key("table_id") ;
|
||
|
||
alter table "ks_db3"."gen_table_column" add primary key("column_id") ;
|
||
|
||
alter table "ks_db3"."industry" add primary key("industry_id") ;
|
||
|
||
alter table "ks_db3"."job" add primary key("job_id") ;
|
||
|
||
alter table "ks_db3"."job_apply" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."job_bak" add primary key("job_id") ;
|
||
|
||
alter table "ks_db3"."job_candidates" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."job_collection" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."job_fair" add primary key("job_fair_id") ;
|
||
|
||
alter table "ks_db3"."job_recommend" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."job_title" add primary key("job_id") ;
|
||
|
||
alter table "ks_db3"."notice" add primary key("notice_id") ;
|
||
|
||
alter table "ks_db3"."qrtz_blob_triggers" add primary key("sched_name","trigger_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_calendars" add primary key("sched_name","calendar_name") ;
|
||
|
||
alter table "ks_db3"."qrtz_cron_triggers" add primary key("sched_name","trigger_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_fired_triggers" add primary key("sched_name","entry_id") ;
|
||
|
||
alter table "ks_db3"."qrtz_job_details" add primary key("sched_name","job_name","job_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_locks" add primary key("sched_name","lock_name") ;
|
||
|
||
alter table "ks_db3"."qrtz_paused_trigger_grps" add primary key("sched_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_scheduler_state" add primary key("sched_name","instance_name") ;
|
||
|
||
alter table "ks_db3"."qrtz_simple_triggers" add primary key("sched_name","trigger_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_simprop_triggers" add primary key("sched_name","trigger_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_triggers" add primary key("sched_name","trigger_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."resume" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."row_work" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."row_work_tmp" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."statics" add primary key("id") ;
|
||
|
||
alter table "ks_db3"."subway_line" add primary key("line_id") ;
|
||
|
||
alter table "ks_db3"."subway_station" add primary key("station_id") ;
|
||
|
||
alter table "ks_db3"."sys_config" add primary key("config_id") ;
|
||
|
||
alter table "ks_db3"."sys_dept" add primary key("dept_id") ;
|
||
|
||
alter table "ks_db3"."sys_dict_data" add primary key("dict_code") ;
|
||
|
||
alter table "ks_db3"."sys_dict_type" add primary key("dict_id") ;
|
||
|
||
alter table "ks_db3"."sys_job" add primary key("job_id","job_name","job_group") ;
|
||
|
||
alter table "ks_db3"."sys_job_log" add primary key("job_log_id") ;
|
||
|
||
alter table "ks_db3"."sys_logininfor" add primary key("info_id") ;
|
||
|
||
alter table "ks_db3"."sys_menu" add primary key("menu_id") ;
|
||
|
||
alter table "ks_db3"."sys_notice" add primary key("notice_id") ;
|
||
|
||
alter table "ks_db3"."sys_oper_log" add primary key("oper_id") ;
|
||
|
||
alter table "ks_db3"."sys_post" add primary key("post_id") ;
|
||
|
||
alter table "ks_db3"."sys_role" add primary key("role_id") ;
|
||
|
||
alter table "ks_db3"."sys_role_dept" add primary key("role_id","dept_id") ;
|
||
|
||
alter table "ks_db3"."sys_role_menu" add primary key("role_id","menu_id") ;
|
||
|
||
alter table "ks_db3"."sys_user" add primary key("user_id") ;
|
||
|
||
alter table "ks_db3"."sys_user_post" add primary key("user_id","post_id") ;
|
||
|
||
alter table "ks_db3"."sys_user_role" add primary key("user_id","role_id") ;
|
||
|
||
alter table "ks_db3"."qrtz_blob_triggers" add constraint "qrtz_blob_triggers_ibfk_1" foreign key("sched_name","trigger_name","trigger_group") references "ks_db3"."qrtz_triggers"("sched_name","trigger_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_cron_triggers" add constraint "qrtz_cron_triggers_ibfk_1" foreign key("sched_name","trigger_name","trigger_group") references "ks_db3"."qrtz_triggers"("sched_name","trigger_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_simple_triggers" add constraint "qrtz_simple_triggers_ibfk_1" foreign key("sched_name","trigger_name","trigger_group") references "ks_db3"."qrtz_triggers"("sched_name","trigger_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_simprop_triggers" add constraint "qrtz_simprop_triggers_ibfk_1" foreign key("sched_name","trigger_name","trigger_group") references "ks_db3"."qrtz_triggers"("sched_name","trigger_name","trigger_group") ;
|
||
|
||
alter table "ks_db3"."qrtz_triggers" add constraint "qrtz_triggers_ibfk_1" foreign key("sched_name","job_name","job_group") references "ks_db3"."qrtz_job_details"("sched_name","job_name","job_group") ;
|
||
|
||
alter table "ks_db3"."resume" add constraint "resume_ibfk_1" foreign key("user_id") references "ks_db3"."sys_user"("user_id") ;
|
||
|
||
alter table "ks_db3"."job_candidates" add constraint "cons134218986" check("score" >= 0) ;
|
||
|
||
alter table "ks_db3"."subway_station" add constraint "cons134218987" check("station_order" >= 0) ;
|
||
|
||
alter table "ks_db3"."sys_dict_type" add unique("dict_type") ;
|
||
|
||
comment on table "ks_db3"."fair_company" is '公司招聘会关联表';
|
||
|
||
comment on column "ks_db3"."fair_company"."company_id" is '公司id';
|
||
|
||
comment on column "ks_db3"."fair_company"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."fair_company"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."fair_company"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."fair_company"."id" is 'id';
|
||
|
||
comment on column "ks_db3"."fair_company"."job_fair_id" is '招聘会id';
|
||
|
||
comment on column "ks_db3"."fair_company"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."fair_company"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."fair_company"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."file" is '文件';
|
||
|
||
comment on column "ks_db3"."file"."bussinessid" is '业务id';
|
||
|
||
comment on column "ks_db3"."file"."file_url" is 'url';
|
||
|
||
comment on column "ks_db3"."file"."id" is 'id';
|
||
|
||
comment on table "ks_db3"."gen_table" is '代码生成业务表';
|
||
|
||
comment on column "ks_db3"."gen_table"."business_name" is '生成业务名';
|
||
|
||
comment on column "ks_db3"."gen_table"."class_name" is '实体类名称';
|
||
|
||
comment on column "ks_db3"."gen_table"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."gen_table"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."gen_table"."function_author" is '生成功能作者';
|
||
|
||
comment on column "ks_db3"."gen_table"."function_name" is '生成功能名';
|
||
|
||
comment on column "ks_db3"."gen_table"."gen_path" is '生成路径（不填默认项目路径）';
|
||
|
||
comment on column "ks_db3"."gen_table"."gen_type" is '生成代码方式（0zip压缩包 1自定义路径）';
|
||
|
||
comment on column "ks_db3"."gen_table"."module_name" is '生成模块名';
|
||
|
||
comment on column "ks_db3"."gen_table"."options" is '其它生成选项';
|
||
|
||
comment on column "ks_db3"."gen_table"."package_name" is '生成包路径';
|
||
|
||
comment on column "ks_db3"."gen_table"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."gen_table"."sub_table_fk_name" is '子表关联的外键名';
|
||
|
||
comment on column "ks_db3"."gen_table"."sub_table_name" is '关联子表的表名';
|
||
|
||
comment on column "ks_db3"."gen_table"."table_comment" is '表描述';
|
||
|
||
comment on column "ks_db3"."gen_table"."table_id" is '编号';
|
||
|
||
comment on column "ks_db3"."gen_table"."table_name" is '表名称';
|
||
|
||
comment on column "ks_db3"."gen_table"."tpl_category" is '使用的模板（crud单表操作 tree树表操作）';
|
||
|
||
comment on column "ks_db3"."gen_table"."tpl_web_type" is '前端模板类型（element-ui模版 element-plus模版）';
|
||
|
||
comment on column "ks_db3"."gen_table"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."gen_table"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."gen_table_column" is '代码生成业务表字段';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."column_comment" is '列描述';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."column_id" is '编号';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."column_name" is '列名称';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."column_type" is '列类型';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."dict_type" is '字典类型';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."html_type" is '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."is_edit" is '是否编辑字段（1是）';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."is_increment" is '是否自增（1是）';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."is_insert" is '是否为插入字段（1是）';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."is_list" is '是否列表字段（1是）';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."is_pk" is '是否主键（1是）';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."is_query" is '是否查询字段（1是）';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."is_required" is '是否必填（1是）';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."java_field" is 'java字段名';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."java_type" is 'java类型';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."query_type" is '查询方式（等于、不等于、大于、小于、范围）';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."sort" is '排序';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."table_id" is '归属表编号';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."gen_table_column"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."industry" is '行业表';
|
||
|
||
comment on column "ks_db3"."industry"."ancestors" is '祖级列表';
|
||
|
||
comment on column "ks_db3"."industry"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."industry"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."industry"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."industry"."industry_id" is '部门id';
|
||
|
||
comment on column "ks_db3"."industry"."industry_name" is '部门名称';
|
||
|
||
comment on column "ks_db3"."industry"."order_num" is '显示顺序';
|
||
|
||
comment on column "ks_db3"."industry"."parent_id" is '父部门id';
|
||
|
||
comment on column "ks_db3"."industry"."status" is '部门状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."industry"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."industry"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."job" is '岗位表';
|
||
|
||
comment on column "ks_db3"."job"."apply_num" is '申请次数';
|
||
|
||
comment on column "ks_db3"."job"."company_id" is '公司id';
|
||
|
||
comment on column "ks_db3"."job"."company_name" is '用人单位名称';
|
||
|
||
comment on column "ks_db3"."job"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."job"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."job"."data_source" is '数据来源';
|
||
|
||
comment on column "ks_db3"."job"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."job"."description" is '岗位描述';
|
||
|
||
comment on column "ks_db3"."job"."education" is '学历要求 对应字典education';
|
||
|
||
comment on column "ks_db3"."job"."experience" is '工作经验要求 对应字典experience';
|
||
|
||
comment on column "ks_db3"."job"."is_hot" is '是否火';
|
||
|
||
comment on column "ks_db3"."job"."is_publish" is '是否发布 0未发布 1发布';
|
||
|
||
comment on column "ks_db3"."job"."job_category" is '岗位分类名称';
|
||
|
||
comment on column "ks_db3"."job"."job_id" is '工作id';
|
||
|
||
comment on column "ks_db3"."job"."job_location" is '工作地点';
|
||
|
||
comment on column "ks_db3"."job"."job_location_area_code" is '工作地点区县字典代码';
|
||
|
||
comment on column "ks_db3"."job"."job_title" is '职位名称';
|
||
|
||
comment on column "ks_db3"."job"."latitude" is '纬度';
|
||
|
||
comment on column "ks_db3"."job"."longitude" is '经度';
|
||
|
||
comment on column "ks_db3"."job"."max_salary" is '最大薪资（元）';
|
||
|
||
comment on column "ks_db3"."job"."min_salary" is '最小薪资（元）';
|
||
|
||
comment on column "ks_db3"."job"."posting_date" is '发布时间';
|
||
|
||
comment on column "ks_db3"."job"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."job"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."job"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."job"."vacancies" is '招聘人数';
|
||
|
||
comment on column "ks_db3"."job"."view" is '浏览量';
|
||
|
||
comment on table "ks_db3"."job_apply" is '岗位申请表';
|
||
|
||
comment on column "ks_db3"."job_apply"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."job_apply"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."job_apply"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."job_apply"."id" is 'id';
|
||
|
||
comment on column "ks_db3"."job_apply"."job_id" is '岗位id';
|
||
|
||
comment on column "ks_db3"."job_apply"."matching_degree" is '匹配度';
|
||
|
||
comment on column "ks_db3"."job_apply"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."job_apply"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."job_apply"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."job_apply"."user_id" is 'app用户id';
|
||
|
||
comment on table "ks_db3"."job_bak" is '岗位表';
|
||
|
||
comment on column "ks_db3"."job_bak"."apply_num" is '申请次数';
|
||
|
||
comment on column "ks_db3"."job_bak"."company_id" is '公司id';
|
||
|
||
comment on column "ks_db3"."job_bak"."company_name" is '用人单位名称';
|
||
|
||
comment on column "ks_db3"."job_bak"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."job_bak"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."job_bak"."data_source" is '数据来源';
|
||
|
||
comment on column "ks_db3"."job_bak"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."job_bak"."description" is '岗位描述';
|
||
|
||
comment on column "ks_db3"."job_bak"."education" is '学历要求 对应字典education';
|
||
|
||
comment on column "ks_db3"."job_bak"."experience" is '工作经验要求 对应字典experience';
|
||
|
||
comment on column "ks_db3"."job_bak"."is_hot" is '是否火';
|
||
|
||
comment on column "ks_db3"."job_bak"."is_publish" is '是否发布 0未发布 1发布';
|
||
|
||
comment on column "ks_db3"."job_bak"."job_category" is '岗位分类名称';
|
||
|
||
comment on column "ks_db3"."job_bak"."job_id" is '工作id';
|
||
|
||
comment on column "ks_db3"."job_bak"."job_location" is '工作地点';
|
||
|
||
comment on column "ks_db3"."job_bak"."job_location_area_code" is '工作地点区县字典代码';
|
||
|
||
comment on column "ks_db3"."job_bak"."job_title" is '职位名称';
|
||
|
||
comment on column "ks_db3"."job_bak"."latitude" is '纬度';
|
||
|
||
comment on column "ks_db3"."job_bak"."longitude" is '经度';
|
||
|
||
comment on column "ks_db3"."job_bak"."max_salary" is '最大薪资（元）';
|
||
|
||
comment on column "ks_db3"."job_bak"."min_salary" is '最小薪资（元）';
|
||
|
||
comment on column "ks_db3"."job_bak"."posting_date" is '发布时间';
|
||
|
||
comment on column "ks_db3"."job_bak"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."job_bak"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."job_bak"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."job_bak"."vacancies" is '招聘人数';
|
||
|
||
comment on column "ks_db3"."job_bak"."view" is '浏览量';
|
||
|
||
comment on table "ks_db3"."job_candidates" is '岗位候选人';
|
||
|
||
comment on column "ks_db3"."job_candidates"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."job_candidates"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."job_candidates"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."job_candidates"."id" is 'id';
|
||
|
||
comment on column "ks_db3"."job_candidates"."job_id" is '岗位id';
|
||
|
||
comment on column "ks_db3"."job_candidates"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."job_candidates"."score" is '得分';
|
||
|
||
comment on column "ks_db3"."job_candidates"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."job_candidates"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."job_candidates"."user_id" is 'app用户id';
|
||
|
||
comment on table "ks_db3"."job_collection" is '用户岗位收藏表';
|
||
|
||
comment on column "ks_db3"."job_collection"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."job_collection"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."job_collection"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."job_collection"."id" is 'id';
|
||
|
||
comment on column "ks_db3"."job_collection"."job_id" is '岗位id';
|
||
|
||
comment on column "ks_db3"."job_collection"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."job_collection"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."job_collection"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."job_collection"."user_id" is 'app用户id';
|
||
|
||
comment on table "ks_db3"."job_fair" is '招聘会信息表';
|
||
|
||
comment on column "ks_db3"."job_fair"."address" is '地图地点';
|
||
|
||
comment on column "ks_db3"."job_fair"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."job_fair"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."job_fair"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."job_fair"."description" is '描述';
|
||
|
||
comment on column "ks_db3"."job_fair"."end_time" is '招聘会结束时间';
|
||
|
||
comment on column "ks_db3"."job_fair"."job_fair_id" is '招聘会id';
|
||
|
||
comment on column "ks_db3"."job_fair"."job_fair_type" is '招聘会类型 对应字典 job_fair_type';
|
||
|
||
comment on column "ks_db3"."job_fair"."latitude" is '纬度';
|
||
|
||
comment on column "ks_db3"."job_fair"."location" is '地点';
|
||
|
||
comment on column "ks_db3"."job_fair"."longitude" is '经度';
|
||
|
||
comment on column "ks_db3"."job_fair"."name" is '招聘会名称';
|
||
|
||
comment on column "ks_db3"."job_fair"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."job_fair"."start_time" is '招聘会开始时间';
|
||
|
||
comment on column "ks_db3"."job_fair"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."job_fair"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."qrtz_blob_triggers" is 'blob类型的触发器表';
|
||
|
||
comment on column "ks_db3"."qrtz_blob_triggers"."blob_data" is '存放持久化trigger对象';
|
||
|
||
comment on column "ks_db3"."qrtz_blob_triggers"."sched_name" is '调度名称';
|
||
|
||
comment on column "ks_db3"."qrtz_blob_triggers"."trigger_group" is 'qrtz_triggers表trigger_group的外键';
|
||
|
||
comment on column "ks_db3"."qrtz_blob_triggers"."trigger_name" is 'qrtz_triggers表trigger_name的外键';
|
||
|
||
comment on table "ks_db3"."qrtz_calendars" is '日历信息表';
|
||
|
||
comment on column "ks_db3"."qrtz_calendars"."calendar" is '存放持久化calendar对象';
|
||
|
||
comment on column "ks_db3"."qrtz_calendars"."calendar_name" is '日历名称';
|
||
|
||
comment on column "ks_db3"."qrtz_calendars"."sched_name" is '调度名称';
|
||
|
||
comment on table "ks_db3"."qrtz_cron_triggers" is 'cron类型的触发器表';
|
||
|
||
comment on column "ks_db3"."qrtz_cron_triggers"."cron_expression" is 'cron表达式';
|
||
|
||
comment on column "ks_db3"."qrtz_cron_triggers"."sched_name" is '调度名称';
|
||
|
||
comment on column "ks_db3"."qrtz_cron_triggers"."time_zone_id" is '时区';
|
||
|
||
comment on column "ks_db3"."qrtz_cron_triggers"."trigger_group" is 'qrtz_triggers表trigger_group的外键';
|
||
|
||
comment on column "ks_db3"."qrtz_cron_triggers"."trigger_name" is 'qrtz_triggers表trigger_name的外键';
|
||
|
||
comment on table "ks_db3"."qrtz_fired_triggers" is '已触发的触发器表';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."entry_id" is '调度器实例id';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."fired_time" is '触发的时间';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."instance_name" is '调度器实例名';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."is_nonconcurrent" is '是否并发';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."job_group" is '任务组名';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."job_name" is '任务名称';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."priority" is '优先级';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."requests_recovery" is '是否接受恢复执行';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."sched_name" is '调度名称';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."sched_time" is '定时器制定的时间';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."state" is '状态';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."trigger_group" is 'qrtz_triggers表trigger_group的外键';
|
||
|
||
comment on column "ks_db3"."qrtz_fired_triggers"."trigger_name" is 'qrtz_triggers表trigger_name的外键';
|
||
|
||
comment on table "ks_db3"."qrtz_job_details" is '任务详细信息表';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."description" is '相关介绍';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."is_durable" is '是否持久化';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."is_nonconcurrent" is '是否并发';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."is_update_data" is '是否更新数据';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."job_class_name" is '执行任务类名称';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."job_data" is '存放持久化job对象';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."job_group" is '任务组名';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."job_name" is '任务名称';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."requests_recovery" is '是否接受恢复执行';
|
||
|
||
comment on column "ks_db3"."qrtz_job_details"."sched_name" is '调度名称';
|
||
|
||
comment on table "ks_db3"."qrtz_locks" is '存储的悲观锁信息表';
|
||
|
||
comment on column "ks_db3"."qrtz_locks"."lock_name" is '悲观锁名称';
|
||
|
||
comment on column "ks_db3"."qrtz_locks"."sched_name" is '调度名称';
|
||
|
||
comment on table "ks_db3"."qrtz_paused_trigger_grps" is '暂停的触发器表';
|
||
|
||
comment on column "ks_db3"."qrtz_paused_trigger_grps"."sched_name" is '调度名称';
|
||
|
||
comment on column "ks_db3"."qrtz_paused_trigger_grps"."trigger_group" is 'qrtz_triggers表trigger_group的外键';
|
||
|
||
comment on table "ks_db3"."qrtz_scheduler_state" is '调度器状态表';
|
||
|
||
comment on column "ks_db3"."qrtz_scheduler_state"."checkin_interval" is '检查间隔时间';
|
||
|
||
comment on column "ks_db3"."qrtz_scheduler_state"."instance_name" is '实例名称';
|
||
|
||
comment on column "ks_db3"."qrtz_scheduler_state"."last_checkin_time" is '上次检查时间';
|
||
|
||
comment on column "ks_db3"."qrtz_scheduler_state"."sched_name" is '调度名称';
|
||
|
||
comment on table "ks_db3"."qrtz_simple_triggers" is '简单触发器的信息表';
|
||
|
||
comment on column "ks_db3"."qrtz_simple_triggers"."repeat_count" is '重复的次数统计';
|
||
|
||
comment on column "ks_db3"."qrtz_simple_triggers"."repeat_interval" is '重复的间隔时间';
|
||
|
||
comment on column "ks_db3"."qrtz_simple_triggers"."sched_name" is '调度名称';
|
||
|
||
comment on column "ks_db3"."qrtz_simple_triggers"."times_triggered" is '已经触发的次数';
|
||
|
||
comment on column "ks_db3"."qrtz_simple_triggers"."trigger_group" is 'qrtz_triggers表trigger_group的外键';
|
||
|
||
comment on column "ks_db3"."qrtz_simple_triggers"."trigger_name" is 'qrtz_triggers表trigger_name的外键';
|
||
|
||
comment on table "ks_db3"."qrtz_simprop_triggers" is '同步机制的行锁表';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."bool_prop_1" is 'boolean类型的trigger的第一个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."bool_prop_2" is 'boolean类型的trigger的第二个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."dec_prop_1" is 'decimal类型的trigger的第一个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."dec_prop_2" is 'decimal类型的trigger的第二个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."int_prop_1" is 'int类型的trigger的第一个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."int_prop_2" is 'int类型的trigger的第二个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."long_prop_1" is 'long类型的trigger的第一个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."long_prop_2" is 'long类型的trigger的第二个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."sched_name" is '调度名称';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."str_prop_1" is 'string类型的trigger的第一个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."str_prop_2" is 'string类型的trigger的第二个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."str_prop_3" is 'string类型的trigger的第三个参数';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."trigger_group" is 'qrtz_triggers表trigger_group的外键';
|
||
|
||
comment on column "ks_db3"."qrtz_simprop_triggers"."trigger_name" is 'qrtz_triggers表trigger_name的外键';
|
||
|
||
comment on table "ks_db3"."qrtz_triggers" is '触发器详细信息表';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."calendar_name" is '日程表名称';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."description" is '相关介绍';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."end_time" is '结束时间';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."job_data" is '存放持久化job对象';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."job_group" is 'qrtz_job_details表job_group的外键';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."job_name" is 'qrtz_job_details表job_name的外键';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."misfire_instr" is '补偿执行的策略';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."next_fire_time" is '上一次触发时间（毫秒）';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."prev_fire_time" is '下一次触发时间（默认为-1表示不触发）';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."priority" is '优先级';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."sched_name" is '调度名称';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."start_time" is '开始时间';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."trigger_group" is '触发器所属组的名字';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."trigger_name" is '触发器的名字';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."trigger_state" is '触发器状态';
|
||
|
||
comment on column "ks_db3"."qrtz_triggers"."trigger_type" is '触发器的类型';
|
||
|
||
comment on table "ks_db3"."subway_line" is '地铁线路表';
|
||
|
||
comment on column "ks_db3"."subway_line"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."subway_line"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."subway_line"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."subway_line"."line_id" is 'id';
|
||
|
||
comment on column "ks_db3"."subway_line"."line_name" is '线路名称';
|
||
|
||
comment on column "ks_db3"."subway_line"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."subway_line"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."subway_line"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."subway_station" is '地铁站点表';
|
||
|
||
comment on column "ks_db3"."subway_station"."address" is '地址';
|
||
|
||
comment on column "ks_db3"."subway_station"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."subway_station"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."subway_station"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."subway_station"."latitude" is '纬度';
|
||
|
||
comment on column "ks_db3"."subway_station"."line_id" is '线路id';
|
||
|
||
comment on column "ks_db3"."subway_station"."line_name" is '所属线路名称';
|
||
|
||
comment on column "ks_db3"."subway_station"."longitude" is '经度';
|
||
|
||
comment on column "ks_db3"."subway_station"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."subway_station"."station_id" is 'id';
|
||
|
||
comment on column "ks_db3"."subway_station"."station_name" is '地铁名称';
|
||
|
||
comment on column "ks_db3"."subway_station"."station_order" is '站点排序';
|
||
|
||
comment on column "ks_db3"."subway_station"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."subway_station"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."sys_config" is '参数配置表';
|
||
|
||
comment on column "ks_db3"."sys_config"."config_id" is '参数主键';
|
||
|
||
comment on column "ks_db3"."sys_config"."config_key" is '参数键名';
|
||
|
||
comment on column "ks_db3"."sys_config"."config_name" is '参数名称';
|
||
|
||
comment on column "ks_db3"."sys_config"."config_type" is '系统内置（y是 n否）';
|
||
|
||
comment on column "ks_db3"."sys_config"."config_value" is '参数键值';
|
||
|
||
comment on column "ks_db3"."sys_config"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_config"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_config"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."sys_config"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_config"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."sys_dept" is '部门表';
|
||
|
||
comment on column "ks_db3"."sys_dept"."ancestors" is '祖级列表';
|
||
|
||
comment on column "ks_db3"."sys_dept"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_dept"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_dept"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."sys_dept"."dept_id" is '部门id';
|
||
|
||
comment on column "ks_db3"."sys_dept"."dept_name" is '部门名称';
|
||
|
||
comment on column "ks_db3"."sys_dept"."email" is '邮箱';
|
||
|
||
comment on column "ks_db3"."sys_dept"."leader" is '负责人';
|
||
|
||
comment on column "ks_db3"."sys_dept"."order_num" is '显示顺序';
|
||
|
||
comment on column "ks_db3"."sys_dept"."parent_id" is '父部门id';
|
||
|
||
comment on column "ks_db3"."sys_dept"."phone" is '联系电话';
|
||
|
||
comment on column "ks_db3"."sys_dept"."status" is '部门状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."sys_dept"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_dept"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."sys_dict_data" is '字典数据表';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."css_class" is '样式属性（其他样式扩展）';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."dict_code" is '字典编码';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."dict_label" is '字典标签';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."dict_sort" is '字典排序';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."dict_type" is '字典类型';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."dict_value" is '字典键值';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."is_default" is '是否默认（y是 n否）';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."list_class" is '表格回显样式';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."status" is '状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_dict_data"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."sys_dict_type" is '字典类型表';
|
||
|
||
comment on column "ks_db3"."sys_dict_type"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_dict_type"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_dict_type"."dict_id" is '字典主键';
|
||
|
||
comment on column "ks_db3"."sys_dict_type"."dict_name" is '字典名称';
|
||
|
||
comment on column "ks_db3"."sys_dict_type"."dict_type" is '字典类型';
|
||
|
||
comment on column "ks_db3"."sys_dict_type"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."sys_dict_type"."status" is '状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."sys_dict_type"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_dict_type"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."sys_job" is '定时任务调度表';
|
||
|
||
comment on column "ks_db3"."sys_job"."concurrent" is '是否并发执行（0允许 1禁止）';
|
||
|
||
comment on column "ks_db3"."sys_job"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_job"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_job"."cron_expression" is 'cron执行表达式';
|
||
|
||
comment on column "ks_db3"."sys_job"."invoke_target" is '调用目标字符串';
|
||
|
||
comment on column "ks_db3"."sys_job"."job_group" is '任务组名';
|
||
|
||
comment on column "ks_db3"."sys_job"."job_id" is '任务id';
|
||
|
||
comment on column "ks_db3"."sys_job"."job_name" is '任务名称';
|
||
|
||
comment on column "ks_db3"."sys_job"."misfire_policy" is '计划执行错误策略（1立即执行 2执行一次 3放弃执行）';
|
||
|
||
comment on column "ks_db3"."sys_job"."remark" is '备注信息';
|
||
|
||
comment on column "ks_db3"."sys_job"."status" is '状态（0正常 1暂停）';
|
||
|
||
comment on column "ks_db3"."sys_job"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_job"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."sys_job_log" is '定时任务调度日志表';
|
||
|
||
comment on column "ks_db3"."sys_job_log"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_job_log"."exception_info" is '异常信息';
|
||
|
||
comment on column "ks_db3"."sys_job_log"."invoke_target" is '调用目标字符串';
|
||
|
||
comment on column "ks_db3"."sys_job_log"."job_group" is '任务组名';
|
||
|
||
comment on column "ks_db3"."sys_job_log"."job_log_id" is '任务日志id';
|
||
|
||
comment on column "ks_db3"."sys_job_log"."job_message" is '日志信息';
|
||
|
||
comment on column "ks_db3"."sys_job_log"."job_name" is '任务名称';
|
||
|
||
comment on column "ks_db3"."sys_job_log"."status" is '执行状态（0正常 1失败）';
|
||
|
||
comment on table "ks_db3"."sys_logininfor" is '系统访问记录';
|
||
|
||
comment on column "ks_db3"."sys_logininfor"."browser" is '浏览器类型';
|
||
|
||
comment on column "ks_db3"."sys_logininfor"."info_id" is '访问id';
|
||
|
||
comment on column "ks_db3"."sys_logininfor"."ipaddr" is '登录ip地址';
|
||
|
||
comment on column "ks_db3"."sys_logininfor"."login_location" is '登录地点';
|
||
|
||
comment on column "ks_db3"."sys_logininfor"."login_time" is '访问时间';
|
||
|
||
comment on column "ks_db3"."sys_logininfor"."msg" is '提示消息';
|
||
|
||
comment on column "ks_db3"."sys_logininfor"."os" is '操作系统';
|
||
|
||
comment on column "ks_db3"."sys_logininfor"."status" is '登录状态（0成功 1失败）';
|
||
|
||
comment on column "ks_db3"."sys_logininfor"."user_name" is '用户账号';
|
||
|
||
comment on table "ks_db3"."sys_menu" is '菜单权限表';
|
||
|
||
comment on column "ks_db3"."sys_menu"."component" is '组件路径';
|
||
|
||
comment on column "ks_db3"."sys_menu"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_menu"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_menu"."icon" is '菜单图标';
|
||
|
||
comment on column "ks_db3"."sys_menu"."is_cache" is '是否缓存（0缓存 1不缓存）';
|
||
|
||
comment on column "ks_db3"."sys_menu"."is_frame" is '是否为外链（0是 1否）';
|
||
|
||
comment on column "ks_db3"."sys_menu"."menu_id" is '菜单id';
|
||
|
||
comment on column "ks_db3"."sys_menu"."menu_name" is '菜单名称';
|
||
|
||
comment on column "ks_db3"."sys_menu"."menu_type" is '菜单类型（m目录 c菜单 f按钮）';
|
||
|
||
comment on column "ks_db3"."sys_menu"."order_num" is '显示顺序';
|
||
|
||
comment on column "ks_db3"."sys_menu"."parent_id" is '父菜单id';
|
||
|
||
comment on column "ks_db3"."sys_menu"."path" is '路由地址';
|
||
|
||
comment on column "ks_db3"."sys_menu"."perms" is '权限标识';
|
||
|
||
comment on column "ks_db3"."sys_menu"."query" is '路由参数';
|
||
|
||
comment on column "ks_db3"."sys_menu"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."sys_menu"."route_name" is '路由名称';
|
||
|
||
comment on column "ks_db3"."sys_menu"."status" is '菜单状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."sys_menu"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_menu"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."sys_menu"."visible" is '菜单状态（0显示 1隐藏）';
|
||
|
||
comment on table "ks_db3"."sys_notice" is '通知公告表';
|
||
|
||
comment on column "ks_db3"."sys_notice"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_notice"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_notice"."notice_content" is '公告内容';
|
||
|
||
comment on column "ks_db3"."sys_notice"."notice_id" is '公告id';
|
||
|
||
comment on column "ks_db3"."sys_notice"."notice_title" is '公告标题';
|
||
|
||
comment on column "ks_db3"."sys_notice"."notice_type" is '公告类型（1通知 2公告）';
|
||
|
||
comment on column "ks_db3"."sys_notice"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."sys_notice"."status" is '公告状态（0正常 1关闭）';
|
||
|
||
comment on column "ks_db3"."sys_notice"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_notice"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."sys_oper_log" is '操作日志记录';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."business_type" is '业务类型（0其它 1新增 2修改 3删除）';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."cost_time" is '消耗时间';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."dept_name" is '部门名称';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."error_msg" is '错误消息';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."json_result" is '返回参数';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."method" is '方法名称';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."operator_type" is '操作类别（0其它 1后台用户 2手机端用户）';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."oper_id" is '日志主键';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."oper_ip" is '主机地址';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."oper_location" is '操作地点';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."oper_name" is '操作人员';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."oper_param" is '请求参数';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."oper_time" is '操作时间';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."oper_url" is '请求url';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."request_method" is '请求方式';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."status" is '操作状态（0正常 1异常）';
|
||
|
||
comment on column "ks_db3"."sys_oper_log"."title" is '模块标题';
|
||
|
||
comment on table "ks_db3"."sys_post" is '岗位信息表';
|
||
|
||
comment on column "ks_db3"."sys_post"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_post"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_post"."post_code" is '岗位编码';
|
||
|
||
comment on column "ks_db3"."sys_post"."post_id" is '岗位id';
|
||
|
||
comment on column "ks_db3"."sys_post"."post_name" is '岗位名称';
|
||
|
||
comment on column "ks_db3"."sys_post"."post_sort" is '显示顺序';
|
||
|
||
comment on column "ks_db3"."sys_post"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."sys_post"."status" is '状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."sys_post"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_post"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."sys_role" is '角色信息表';
|
||
|
||
comment on column "ks_db3"."sys_role"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_role"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_role"."data_scope" is '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）';
|
||
|
||
comment on column "ks_db3"."sys_role"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."sys_role"."dept_check_strictly" is '部门树选择项是否关联显示';
|
||
|
||
comment on column "ks_db3"."sys_role"."menu_check_strictly" is '菜单树选择项是否关联显示';
|
||
|
||
comment on column "ks_db3"."sys_role"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."sys_role"."role_id" is '角色id';
|
||
|
||
comment on column "ks_db3"."sys_role"."role_key" is '角色权限字符串';
|
||
|
||
comment on column "ks_db3"."sys_role"."role_name" is '角色名称';
|
||
|
||
comment on column "ks_db3"."sys_role"."role_sort" is '显示顺序';
|
||
|
||
comment on column "ks_db3"."sys_role"."status" is '角色状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."sys_role"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_role"."update_time" is '更新时间';
|
||
|
||
comment on table "ks_db3"."sys_role_dept" is '角色和部门关联表';
|
||
|
||
comment on column "ks_db3"."sys_role_dept"."dept_id" is '部门id';
|
||
|
||
comment on column "ks_db3"."sys_role_dept"."role_id" is '角色id';
|
||
|
||
comment on table "ks_db3"."sys_role_menu" is '角色和菜单关联表';
|
||
|
||
comment on column "ks_db3"."sys_role_menu"."menu_id" is '菜单id';
|
||
|
||
comment on column "ks_db3"."sys_role_menu"."role_id" is '角色id';
|
||
|
||
comment on table "ks_db3"."sys_user" is '用户信息表';
|
||
|
||
comment on column "ks_db3"."sys_user"."avatar" is '头像地址';
|
||
|
||
comment on column "ks_db3"."sys_user"."create_by" is '创建者';
|
||
|
||
comment on column "ks_db3"."sys_user"."create_time" is '创建时间';
|
||
|
||
comment on column "ks_db3"."sys_user"."del_flag" is '删除标志（0代表存在 2代表删除）';
|
||
|
||
comment on column "ks_db3"."sys_user"."dept_id" is '部门id';
|
||
|
||
comment on column "ks_db3"."sys_user"."email" is '用户邮箱';
|
||
|
||
comment on column "ks_db3"."sys_user"."login_date" is '最后登录时间';
|
||
|
||
comment on column "ks_db3"."sys_user"."login_ip" is '最后登录ip';
|
||
|
||
comment on column "ks_db3"."sys_user"."nick_name" is '用户昵称';
|
||
|
||
comment on column "ks_db3"."sys_user"."password" is '密码';
|
||
|
||
comment on column "ks_db3"."sys_user"."phonenumber" is '手机号码';
|
||
|
||
comment on column "ks_db3"."sys_user"."remark" is '备注';
|
||
|
||
comment on column "ks_db3"."sys_user"."sex" is '用户性别（0男 1女 2未知）';
|
||
|
||
comment on column "ks_db3"."sys_user"."status" is '帐号状态（0正常 1停用）';
|
||
|
||
comment on column "ks_db3"."sys_user"."update_by" is '更新者';
|
||
|
||
comment on column "ks_db3"."sys_user"."update_time" is '更新时间';
|
||
|
||
comment on column "ks_db3"."sys_user"."user_id" is '用户id';
|
||
|
||
comment on column "ks_db3"."sys_user"."user_name" is '用户账号';
|
||
|
||
comment on column "ks_db3"."sys_user"."user_type" is '用户类型（00系统用户）';
|
||
|
||
comment on table "ks_db3"."sys_user_post" is '用户与岗位关联表';
|
||
|
||
comment on column "ks_db3"."sys_user_post"."post_id" is '岗位id';
|
||
|
||
comment on column "ks_db3"."sys_user_post"."user_id" is '用户id';
|
||
|
||
comment on table "ks_db3"."sys_user_role" is '用户和角色关联表';
|
||
|
||
comment on column "ks_db3"."sys_user_role"."role_id" is '角色id';
|
||
|
||
comment on column "ks_db3"."sys_user_role"."user_id" is '用户id';
|
||
|