算是mark一下,第一次通过语句给列加注释。
--建表
create table "SHMC"."BH_ASSESS_KPI_WORK_ORDER"(
"ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (
START WITH 1,
INCREMENT BY 1,
CACHE 20,
NO MINVALUE,
NO MAXVALUE,
NO CYCLE,
NO ORDER
),
"work_order_num" varchar(20),
"trandate" varchar(10),
"branch_name" varchar(100),
"order_status" varchar(10),
"current_status" varchar(10),
"submit_time" varchar(20),
"submit_person" varchar(10),
"operate_name" varchar(10)
) in "TAPP_16K";
--加注释
COMMENT ON "SHMC"."BH_ASSESS_KPI_WORK_ORDER" (
"ID" IS '自然主键',
"work_order_num" IS '工单编号' ,
"trandate" IS '日期',
"branch_name" IS '分公司',
"order_status" IS '工单状态',
"current_status" IS '当前状态',
"submit_time" IS '提交时间',
"submit_person" IS '提交人',
"operate_name" IS '操作'
);