publications


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
projectpublications.publication_id projectpublications_ibfk_2 C
publicationdata.publication_id publicationdata_ibfk_1 C
stories.publication_id stories_ibfk_1 N
doi TEXT 65535 null
fallback_cache MEDIUMTEXT 16777215 √ null
created_on DATETIME 19 CURRENT_TIMESTAMP
updated_on TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation