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
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
|
|
);
|