table design for Globalization in Oracle ERP
From: lsllcm <lsllcm_at_gmail.com>
Date: Tue, 25 Aug 2009 05:02:54 -0700 (PDT)
Message-ID: <38fb5ea3-90e1-4671-b618-de1336456671_at_a37g2000prf.googlegroups.com>
Hi All,
, 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)
);
Date: Tue, 25 Aug 2009 05:02:54 -0700 (PDT)
Message-ID: <38fb5ea3-90e1-4671-b618-de1336456671_at_a37g2000prf.googlegroups.com>
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
Received on Tue Aug 25 2009 - 07:02:54 CDT