Jeesite 对单表自动生成代码

建表语句

首先, 我们在数据库后台新建如下表:

 CREATE TABLE td_test1
 (
   fd_user character varying(10) NOT NULL, -- 用户名
   fd_name character varying(15) NOT NULL, -- 姓名
   fd_sex character(1), -- 姓别
   create_by character varying(10), -- 创建人
   create_date timestamp with time zone, -- 创建时间
   update_by character varying(10), -- 修改人
   update_date timestamp with time zone, -- 修改时间
   id character varying(64) NOT NULL, -- 编号
   status character(1),
   CONSTRAINT pkey_test_id PRIMARY KEY (id)
 )
 WITH (
   OIDS=FALSE
 );
 ALTER TABLE td_test1
   OWNER TO postgres;
 COMMENT ON COLUMN td_test1.fd_user IS '用户名';
 COMMENT ON COLUMN td_test1.fd_name IS '姓名';
 COMMENT ON COLUMN td_test1.fd_sex IS '姓别';
 COMMENT ON COLUMN td_test1.create_by IS '创建人';
 COMMENT ON COLUMN td_test1.create_date IS '创建时间';
 COMMENT ON COLUMN td_test1.update_by IS '修改人';
 COMMENT ON COLUMN td_test1.update_date IS '修改时间';
 COMMENT ON COLUMN td_test1.id IS '编号';