Categories
Database Design

One Resource Table

One Resource Table
Using one resource table method is similar to many lookup tables. The difference is this one resource table actually combines all lookup tables by adding just one more field. Of course, this one resource table will be much larger because it combines all lookup tables.

Using back the same lookup tables at previous blog, let’s create one resource table to replace all lookup tables.

TypeCodeDesc
StateJHJohor
StateKHKedah
StateKTKelantan
StateMKMelaka
StateNSNegeri Sembilan
StatePHPahang
StatePGPulau Pinang
StatePKPerak
StatePSPerlis
StateSBSabah
StateSWSarawak
StateSLSelangor
StateTGTerengganu
StateKLW.P. Kuala Lumpur
StateLBW.P. Labuan
StatePJW.P. Putrajaya
CountryCNChina
CountryHKHong Kong
CountryINIndia
CountryMYMalaysia
CountrySGSingapore

That’s it. Use both type and code field to make the primary/unique key.