[SQL?] Studying for DB design test - Tilted Forum Project Discussion Community

bltzkriegmcanon · 03-29-2004, 05:39 PM

hey guys, just had a quick question about a part of database design, specifically making Entity Relationship Diagrams.

What the hell is a code table? I've looked around on google, but couldn't find a definite defintion and what it's used for.

Any help would be appreciated.

wondash · 04-09-2004, 04:34 AM

I believe that a code table is a general term for a table which contains code/description pairs. It's usually linked to other tables via a foreign key and used for code look-ups. Also know as a Look-up table.

03-29-2004, 05:39 PM	#1 (permalink)
bltzkriegmcanon Holy Knight of The Alliance Location: Stormwind, The Eastern Kingdoms, Azeroth	[SQL?] Studying for DB design test hey guys, just had a quick question about a part of database design, specifically making Entity Relationship Diagrams. What the hell is a code table? I've looked around on google, but couldn't find a definite defintion and what it's used for. Any help would be appreciated. __________________ What do you say to one last showdown? - Ocelot, Metal Gear Solid 3 The password is "Who are the Patriots?" and "La-Li-Lu-Le-Lo." "La-Li-Lu-Le-Lo." Gotcha. - The Colonel and Snake, Metal Gear Solid 3

04-09-2004, 04:34 AM	#2 (permalink)
wondash Psycho	I believe that a code table is a general term for a table which contains code/description pairs. It's usually linked to other tables via a foreign key and used for code look-ups. Also know as a Look-up table.