Table studip30.lit_catalog Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
catalog_id varchar 32
lit_list_content.catalog_id Implied Constraint R
user_id varchar 32
auth_user_md5.user_id Implied Constraint R
mkdate int 10 0
chdate int 10 0
lit_plugin varchar 100 Studip
accession_number varchar 100  √  null
dc_title varchar 255
dc_creator varchar 255
dc_subject varchar 255  √  null
dc_description text 65535  √  null
dc_publisher varchar 255  √  null
dc_contributor varchar 255  √  null
dc_date date 10  √  null
dc_type varchar 100  √  null
dc_format varchar 100  √  null
dc_identifier varchar 255  √  null
dc_source varchar 255  √  null
dc_language varchar 10  √  null
dc_relation varchar 255  √  null
dc_coverage varchar 255  √  null
dc_rights varchar 255  √  null

Table contained 5 rows at Do Aug 02 15:05 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
catalog_id Primary key Asc PRIMARY

Close relationships: