-- Create table
create table adam.fco_pi_pens_temp
(
    random number NOT NULL,
    compania char(4) NOT NULL,
    trabajador char(10) NOT NULL, 
    sucursal char(10) NOT NULL,
    relacion_laboral char(10) NULL, 
    fecha_ingreso date NULL, 
    fecha_baja date NULL, 
    clave_unica varchar2(25) NULL,
    nombre varchar2(100) NOT NULL,
    registro_fiscal varchar2(20) NULL,
    secuencia number NOT NULL
)
tablespace TS_ADAMDATOS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table fco_pi_pens_temp
  add constraint PK_fco_pi_pens_temp primary key (random, compania, trabajador)
  using index 
  tablespace TS_ADAMINDICES
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
