table design for Globalization in Oracle ERP

Giganews Newsgroups
Subject: table design for Globalization in Oracle ERP
Posted by:  lsllcm (lsll…@gmail.com)
Date: Tue, 25 Aug 2009

Hi All,

I have one question about table design for Globalization in Oracle
ERP. The following example is from Oracle ERP. Do I have other chocies
to design table for this kind of requirement.

CREATE TABLE product_information
( product_id NUMBER(6)
, product_name VARCHAR2(50)
, product_description VARCHAR2(2000)
, category_id NUMBER(2)
, warranty_period INTERVAL YEAR TO MONTH
, supplier_id NUMBER(6)
, product_status VARCHAR2(20)
, list_price NUMBER(8,2)
);

CREATE TABLE product_descriptions
( product_id NUMBER(6)
, language_id VARCHAR2(3)
, translated_name NVARCHAR2(50)
, translated_description NVARCHAR2(2000)
);

Thanks at first
Jacky

Replies