Hi,
Please can someone advise on the best approach of creating system lookup tables for an application.
I've created below tables but they don't handle scenarios where a lookup is dependent on another lookup. such as Area, City & Country
create table lookup_code
(lookup_code varchar2(30 byte),
lookup_description varchar2(50 byte)
);
create table lookup_code_detail
(
lookup_code varchar2(30),
lookup_code_value varchar(30),
lookup_code_desc varchar2(30)
);
thanks