DB FORUM:
I have a what I call a reference table:
cs_Priority
-----------------------------
Pri_Id INT Primary Key
Pri_Txt varchar2
Also I have a software issue tracking
table:
cs_Issue
-----------------------------
Id INT Primary Key
Desc varchar2
Priority ??????????????????
Do you think it wiser to store the primary
key to the reference table or store the
text?
By storing the PK I will have to add joins
to my select statements. By adding the text
this adds more data to the table.
I have several 'reference' tables.
What do you all think?
LP
I have a what I call a reference table:
cs_Priority
-----------------------------
Pri_Id INT Primary Key
Pri_Txt varchar2
Also I have a software issue tracking
table:
cs_Issue
-----------------------------
Id INT Primary Key
Desc varchar2
Priority ??????????????????
Do you think it wiser to store the primary
key to the reference table or store the
text?
By storing the PK I will have to add joins
to my select statements. By adding the text
this adds more data to the table.
I have several 'reference' tables.
What do you all think?
LP