Basic Schema Question - UNIQUE#1 vs UNIQUE

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Basic Schema Question - UNIQUE#1 vs UNIQUE

Rob Syme
Hi,
In the wiki schema descriptions (eg http://gmod.org/wiki/Chado_CV_Module#Tables), what is the difference between a column that is described as "UNIQUE#1 NOT NULL" and one described as "UNIQUE NOT NULL"? 
Thanks.
-r
Rob Syme
ACNFP, 
Curtin University

------------------------------------------------------------------------------
This SF.net email is sponsored by

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
_______________________________________________
Gmod-schema mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-schema
Reply | Threaded
Open this post in threaded view
|

Re: Basic Schema Question - UNIQUE#1 vs UNIQUE

Scott Cain
Hi Rob,

There is no meaning to that "#1"; that is an artifact of the automatic
generation of the documentation and is probably the result of a bug in
SQL::Translator.

Scott


On Mon, Aug 23, 2010 at 10:18 AM, Rob Syme <[hidden email]> wrote:

> Hi,
> In the wiki schema descriptions
> (eg http://gmod.org/wiki/Chado_CV_Module#Tables), what is the difference
> between a column that is described as "UNIQUE#1 NOT NULL" and one described
> as "UNIQUE NOT NULL"?
> Thanks.
> -r
> Rob Syme
> ACNFP, Curtin University
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by
>
> Make an app they can't live without
> Enter the BlackBerry Developer Challenge
> http://p.sf.net/sfu/RIM-dev2dev
> _______________________________________________
> Gmod-schema mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/gmod-schema
>
>



--
------------------------------------------------------------------------
Scott Cain, Ph. D.                                   scott at scottcain dot net
GMOD Coordinator (http://gmod.org/)                     216-392-3087
Ontario Institute for Cancer Research

------------------------------------------------------------------------------
This SF.net email is sponsored by

Make an app they can't live without
Enter the BlackBerry Developer Challenge
http://p.sf.net/sfu/RIM-dev2dev 
_______________________________________________
Gmod-schema mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-schema