Table of contents
  1. publisher
    1. Description
    2. Columns
    3. Constraints
    4. Indexes
    5. Relations

publisher

Description

Columns

Name Type Default Nullable Extra Definition Children Parents Comment
id int(11)   false auto_increment podcast season    
name varchar(255)   false        
location varchar(255) NULL true        
website varchar(255) NULL true        
description longtext   false        
contact longtext   false        
created datetime   false       (DC2Type:datetime_immutable)
updated datetime   false       (DC2Type:datetime_immutable)
podcast_id int(11)   false     podcast  

Constraints

Name Type Definition
FK_9CE8D546786136AB FOREIGN KEY FOREIGN KEY (podcast_id) REFERENCES podcast (id)
PRIMARY PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
IDX_9CE8D546786136AB KEY IDX_9CE8D546786136AB (podcast_id) USING BTREE
publisher_ft KEY publisher_ft (name, description) USING FULLTEXT
PRIMARY PRIMARY KEY (id) USING BTREE

Relations

er

Generated by tbls