-- Create table
create table SYS_APP
(
  APP_ID            NUMBER(10) not null,
  APP_CODE          VARCHAR2(20) not null,
  APPDESC           VARCHAR2(200),
  APPSTATUS_CODE    VARCHAR2(20) not null,
  VERSION           VARCHAR2(10),
  VERSIONDATE       DATE,
  CURRENTPATCH_ID   NUMBER(20),
  APPTYPE_CODE      VARCHAR2(20),
  HOMEAPPFEATURE_ID NUMBER(10),
  UPDATEDATE        DATE,
  UPDATEBYUSER_CODE VARCHAR2(20)
)
tablespace SYSINFO
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );