------------ ERP_I_PRODUCTDESC --------------
create table ERP_I_PRODUCTDESC
(
  TRANSFER_ID             NUMBER not null,
  TRANSFER_STATUS         NUMBER default 0 not null,
  PRODUCTCODE             VARCHAR2(12) not null,
  LANGUAGECODE            VARCHAR2(5) not null,
  DESCRIPTION             VARCHAR2(30) not null,
  LONGDESCRIPTION         VARCHAR2(60) not null  
);
-- Create primary, unique and foreign key constraints 
alter table ERP_I_PRODUCTDESC
  add constraint PK_ERP_I_PRODUCTDESC primary key (TRANSFER_ID, PRODUCTCODE, LANGUAGECODE);
alter table ERP_I_PRODUCTDESC
  add constraint FK_ERP_I_PRODUCTDESC foreign key (TRANSFER_ID, PRODUCTCODE)
  references ERP_I_PRODUCT (TRANSFER_ID, CODE) on delete cascade;
  
ALTER TABLE ERP_I_PRODUCTDESC ADD (TIMESTAMP DATE DEFAULT SYSDATE NOT NULL);
