©Mike Moxcey 1999

Example Tables

Lookup Table
field namedata typerequired?
lk_type varchar(6)not null
lk_code varchar(6)not null
lk_desc varchar(6)not null

Denormalized recursive table holds ALL lookup values


home next