tbl_citations

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
citationid serial 10 √ nextval('"tbl_Citations_CitationID_seq"'::regclass)
jtbl_citationgroups.citationid jtbl_citationgroups_citationid_fkey C
jtbl_collection_citations.citationid jtbl_collection_citations_citationid_fkey C
jtbl_project_citations.citationid jtbl_project_citations_citationid_fkey C
title text 2147483647 √ null
creators text 2147483647 √ null
abstractnote text 2147483647 √ null
booktitle text 2147483647 √ null
bookeditors text 2147483647 √ null
publicationtitle text 2147483647 √ null
containerisbn varchar 255 √ null
volume int4 10 √ null
issue int4 10 √ null
pages varchar 255 √ null
publicationdate text 2147483647 √ null
publisher varchar 255 √ null
place varchar 255 √ null
edition int4 10 √ null
isbn varchar 255 √ null
issn varchar 255 √ null
doi varchar 255 √ null
url varchar 255 √ null
accessdate text 2147483647 √ null
language text 2147483647 √ null
rights text 2147483647 √ null
extra text 2147483647 √ null
tags text 2147483647 √ null
dateadded text 2147483647 √ null
datemodified text 2147483647 √ null
citationorcollection text 2147483647 √ null

Is it a citation or a collection or both
thesis text 2147483647 √ null
itemtypeid int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_Citations_pkey Primary key Asc citationid

Relationships

Close relationships within degrees of separation