You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
909 B
19 lines
909 B
CREATE TABLE employee_communicate
|
|
(
|
|
id serial PRIMARY KEY NOT NULL,
|
|
personalName varchar(255) NOT NULL, -- 被沟通人
|
|
job varchar(255) NOT NULL, -- 岗位
|
|
departmentName varchar(255) NOT NULL, -- 部门名称
|
|
communicateDate timestamp NOT NULL, -- 沟通时间
|
|
communicateContent text NOT NULL, -- 沟通内容
|
|
communicateResult text NOT NULL, -- 沟通成果
|
|
valuation varchar(255) NOT NULL, -- 被沟通人近期评价
|
|
communicateCondition text NOT NULL, -- 沟通情况反馈
|
|
nextPlan text NOT NULL, -- 下一步计划货方向
|
|
topic text NOT NULL, -- 沟通主题
|
|
communicateEndDate timestamp NOT NULL, -- 沟通截止时间
|
|
background text NOT NULL, -- 沟通背景
|
|
suggestion text NOT NULL, -- 反馈获取的信息与处理建议
|
|
toPersonSugges text NOT NULL, -- 给予被沟通人的改进建议
|
|
training text NOT NULL -- 培训需求
|
|
);
|