环境:PowerDesigner 15.1.0.2850,oracle 11g
如需生成的表与表字段有comment(备注),钩选上红色框标识的checkbox.
操作菜单: Database->Generat Database ->Format
生成后脚本:
/*==============================================================*/
/* Table: "t_apply" */
/*==============================================================*/
create table "t_apply" (
"id" NUMBER,
"apply_num" NUMERIC,
"apply_name" VARCHAR2(100),
"apply_code" VARCHAR2(100),
"apply_state" CHAR(1),
"apply_time" DATE,
"apply_person_code" VARCHAR2(100),
"apply_person_name" VARCHAR2(100),
"apply_remark" VARCHAR2(1000)
);
comment on table "t_apply" is
'申请表';
comment on column "t_apply"."id" is
'id';
comment on column "t_apply"."apply_num" is
'申请编号';
comment on column "t_apply"."apply_name" is
'申请事项名称';
comment on column "t_apply"."apply_code" is
'申请事项代码';
comment on column "t_apply"."apply_state" is
'状态';
comment on column "t_apply"."apply_time" is
'申请时间';
comment on column "t_apply"."apply_person_code" is
'申请人代码';
comment on column "t_apply"."apply_person_name" is
'申请人名称';
comment on column "t_apply"."apply_remark" is
'申请说明';