使用ID nr:s代替VARCHARS作为外键是否更好? 使用ID nr:s isntead of VARCHARS作为主键是否更好? ID nr我的意思是int!
This is what I have now:个
category table:
cat_id ( INT ) (PK)
cat_name (VARCHAR)
category options table:
option_id ( INT ) (PK)
car_id ( INT ) (FK)
option_name ( VARCHAR )
I COULD HAVE THIS I THINK:
category table:
cat_name (VARCHAR) (PK)
category options table:
cat_name ( VARCHAR ) (FK)
option_name ( VARCHAR ) ( PK )
还是我现在的 idea 完全错了?