[thelist] SQL - Foreign Key Constraint - in another database?
.jeff
jeff at members.evolt.org
Wed Sep 5 13:16:21 CDT 2001
matt,
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: Warden, Matt
>
> CATEGORYS is a misspelling? Would it interest you to
> know that the evolt database, designed partly/mostly(?)
> by rudy has a table named CATEGORYS?
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
don't worry rudy, i got your back. *grin*
the spelling came from pre-evolt days when walker gave us the first version
of what has now grown into thesite.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> The point is not that you're wrong, or rudy/evolt was
> wrong. The point is that this problem woudln't exist
> if the table was named CATEGORY.
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
precisely. for this and other reasons i also prefer the singular naming
schemes. it makes even more sense when you're referencing the data from a
query.
plural
- users.id
- employees.last_name
- products.description
or
singular
- user.id
- employee.last_name
- product.description
the singular makes more sense to me too.
thanks,
.jeff
http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/
More information about the thelist
mailing list