oracle2

-- Create table 告警表
create table OMSFM.TBL_CURRENT_ALARM
(
  ALARMSN                   NUMBER(11) not null,
  COUNTER                   NUMBER(11),
  CLEARED                   NUMBER(1),
  CLEARUSER                 VARCHAR2(90),
  ACKED                     NUMBER(1),
  ACKUSER                   VARCHAR2(90),
  ACKTIME                   NUMBER(20),
  LATESTLOGTIME             NUMBER(20),
  LATESTLOGSN               NUMBER(11),
  CLEAREDTIME               NUMBER(20),
  CLEAREDTYPE               NUMBER(1),
  CLEAREDCLASS              NUMBER(1),
  SEVERITYCHANGEDTIME       NUMBER(20),
  MODN                      VARCHAR2(255) not null,
  NEDN                      VARCHAR2(255),
  SOURCE                    VARCHAR2(255),
  OBJECTINSTANCE            VARCHAR2(375),
  OBJECTCLASS               VARCHAR2(128),
  NETYPE                    VARCHAR2(128),
  MOVERSION                 VARCHAR2(128),
  NEVERSION                 VARCHAR2(128),
  DEVCSN                    NUMBER(11),
  NOTIFICATIONID            NUMBER(11),
  EVENTTIME                 NUMBER(20) not null,
  ARRIVEDTIME               NUMBER(20),
  EVENTTYPE                 NUMBER(2),
  ALARMID                   NUMBER(11) not null,
  ALARMNAME                 VARCHAR2(150),
  PERCEIVEDSEVERITY         NUMBER(1),
  PROBABLECAUSE             NUMBER(11),
  DETAILEDINFORMATION       VARCHAR2(255),
  PROPOSEDREPAIRACTIONS     VARCHAR2(255),
  BACKEDUPSTATUS            NUMBER(1),
  SERVICEAFFECTINGINDICATOR NUMBER(1),
  ROOTCASEALARMINDICATOR    NUMBER(1),
  THRESHOLDINFO             VARCHAR2(384),
  ROOTCASEALARMSN           NUMBER(11),
  ADDITIONALTEXT            VARCHAR2(768),
  ADDITIONALINFORMATION     VARCHAR2(768),
  USERDATA                  VARCHAR2(1023)
)
tablespace OMSFMDB
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints
alter table OMSFM.TBL_CURRENT_ALARM
  add primary key (ALARMSN)
  using index
  tablespace OMSFMDB
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );