Oracle建表

create table alarm_approve_remark
(
  alarmid        number(10)    not null,
  cityid         number(10)    not null,
  deviceid       number(10)    not null,
  contentcode    number(10)    not null,
  agreeoperator  varchar(20)    not null,
  agreeremark    varchar(50)   null
)
tablespace ALARMSPACE;
alter table alarm_approve_remark
   add constraint alarm_approve_remark_PRIMARY primary key (alarmid, cityid,deviceid)
   using index 
   tablespace ALARMSPACE;