人力资源
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.
 
 
 
 

18 lines
598 B

CREATE TABLE PUBLIC.dept_training (
ID serial NOT NULL CONSTRAINT dept_training_pkey PRIMARY KEY,
departmentname VARCHAR ( 255 ) NOT NULL,
trainingtype VARCHAR ( 255 ) NOT NULL,
traindate TIMESTAMP NOT NULL,
traincontent VARCHAR ( 255 ) NOT NULL,
trainwho VARCHAR ( 255 ),
trainer VARCHAR ( 255 ),
trainmethod VARCHAR ( 255 ) NOT NULL,
appraisalmethod VARCHAR ( 255 ) NOT NULL,
traintime VARCHAR ( 255 ) NOT NULL,
attachpath VARCHAR ( 255 ),
origin VARCHAR ( 255 ),
filesize VARCHAR ( 255 ),
filename VARCHAR ( 255 ),
filetype VARCHAR ( 255 ),
updatedate TIMESTAMP WITH TIME ZONE
);