Re: Database design question
Date: Mon, 26 Jun 2006 11:25:28 -0600
Message-ID: <1151342257_41411_at_sp6iad.superfeed.net>
<sreedhardasi_at_gmail.com> wrote in message news:1151333970.145260.93970_at_y41g2000cwy.googlegroups.com...
>I have a database design questions. How can we specify one of two
> columns in a table should be not null? In other words, if one column is
>
> null then another column should not be null.
My first thought is the following, either at the dbms level or application level.
if( tableA.group_id == null)
{
tableB.user_id = IDGenerator();
}
Mike
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Received on Mon Jun 26 2006 - 19:25:28 CEST