Re: [Gmod-schema] Inquiry About Primary Key Types and Formats in GMOD Databases

[Scott C. <sc...@sc...>]

Hi Parwa,

The database you are using is probably Chado, that database that sits under
a Tripal instance (and is used in other settings too). The schema you are
probably using is 1.31 which has been around for a long time. The primary
keys of all of the tables are auto incrementing bigserials (bigints). The
schema is defined here:

https://raw.githubusercontent.com/GMOD/Chado/1.31/chado/modules/default_schema.sql

And more information can be found from the gmod web site:
https://gmod.org/wiki/Introduction_to_Chado

Generally, PostgreSQL manages the creation of new primary keys on INSERT.

Please let us know if you have any other questions,
Scott


On Wed, Aug 7, 2024 at 9:36 AM PARWAMUHSIN ISMAEL <
par...@og...> wrote:

> Dear GMOD Team,
>
> I hope this message finds you well.
>
> I am currently working with databases that utilize GMOD tools and have a
> few questions regarding the primary keys used in these databases.
> Specifically, I would like to understand the format and generation method
> of these primary keys, including but not limited to cv_ids, cvterm_ids, and
> other key types:
>
> Are the primary keys auto-incremented integers, UUIDs, or do they follow a
> different format?
> Could you provide details on how primary keys such as cv_ids, cvterm_ids,
> and others are generated and managed?
> If there is specific documentation or a schema that outlines these
> details, I would appreciate it if you could point me to it.
> Your assistance with this matter would be greatly appreciated.
>
> Thank you for your help!
>
> Best regards,
> Parwa Ismael
> Istanbul University
>


-- 
------------------------------------------------------------------------
Scott Cain, Ph. D.                                                  scott
at scottcain dot net
GMOD Project Manager (http://gmod.org/)
216-392-3087
WormBase Developer (http://wormbase.org/)
Alliance of Genome Resources Group Leader (http://alliancegenome.org/)
VirusSeq Project Manager (https://virusseq-dataportal.ca/)
Human Cancer Models Initiative Project Manager (
https://hcmi-searchable-catalog.nci.nih.gov/)