Loading... > 发布页的建表语句少字段且没字段注释，备份一下 ~~~sql -- Create table create table DEVICEAETITLEFORQRSCP ( qrdeviceid NUMBER(16) not null, ae_titletype VARCHAR2(40) not null, cfindaetitle VARCHAR2(64) not null, cfindipaddress VARCHAR2(16) not null, cmoveaetitle VARCHAR2(64) not null, cmoveipaddress VARCHAR2(16) not null, cmoveport NUMBER(16) default 0, cmoveovertime NUMBER(32) default 600, isavailable NUMBER(4) default 0, describle VARCHAR2(200), operatorid VARCHAR2(200), operatetime DATE ) tablespace PACS55 pctfree 10 initrans 1 maxtrans 255 storage ( initial 64K next 1M minextents 1 maxextents unlimited ); -- Add comments to the columns comment on column DEVICEAETITLEFORQRSCP.qrdeviceid is '序号。'; comment on column DEVICEAETITLEFORQRSCP.ae_titletype is 'QR_SCU'; comment on column DEVICEAETITLEFORQRSCP.cfindaetitle is '访问的客户端AE标题。'; comment on column DEVICEAETITLEFORQRSCP.cfindipaddress is '访问的客户端IP地址。'; comment on column DEVICEAETITLEFORQRSCP.cmoveaetitle is '客户端所能接收图像的AE标题。'; comment on column DEVICEAETITLEFORQRSCP.cmoveipaddress is '客户端所能接收图像的IP地址。'; comment on column DEVICEAETITLEFORQRSCP.cmoveport is '客户端所能接收图像的端口。'; comment on column DEVICEAETITLEFORQRSCP.cmoveovertime is '接收图像超时时间，单位秒。'; comment on column DEVICEAETITLEFORQRSCP.isavailable is '是否可用。'; comment on column DEVICEAETITLEFORQRSCP.describle is '描述。'; comment on column DEVICEAETITLEFORQRSCP.operatorid is '操作者。'; comment on column DEVICEAETITLEFORQRSCP.operatetime is '操作时间。'; ~~~ 最后修改：2024 年 04 月 16 日 © 允许规范转载 赞 如果觉得我的文章对你有用，请随意赞赏