Displaying 1 result from an estimated 1 matches for "category_codes".
Did you mean:
category_code
2005 Dec 16
10
''Code table'' best practices?
...or a while.
I reverse my opinion on it every project, and I''m wondering if anyone
has any advice/battle scars to share. As usual, please forgive my
long-windedness in advance.
Let''s say I have this:
Table: PLANS
ID int
CATEGORY_CODE_ID int
--Other junk removed for clarity
Table: CATEGORY_CODES
ID int
DESCRIPTION varchar(200)
"category codes", to the user, are 6-digit numbers, sometimes with
leading zeroes, that have specific meanings.
My customers usually want a metric truckload full of reports. Often,
there are more reports than actual business logic. So much fun.
Reports...