Table of contents

1. episode
   1. Description
   2. Columns
   3. Constraints
   4. Indexes
   5. Relations

episode

Description

Columns

Name	Type	Default	Nullable	Extra Definition	Children	Parents	Comment
id	int(11)		false	auto_increment	contribution
season_id	int(11)	NULL	true			season
podcast_id	int(11)		false			podcast
number	double		false
date	date		false
run_time	varchar(9)		false
title	varchar(255)		false
sub_title	varchar(255)	NULL	true
bibliography	longtext	NULL	true
transcript	longtext	NULL	true
description	longtext		false
created	datetime		false				(DC2Type:datetime_immutable)
updated	datetime		false				(DC2Type:datetime_immutable)
keywords	longtext	’[]’	false				(DC2Type:json)
permissions	longtext	NULL	true
guid	varchar(255)	NULL	true
episode_type	varchar(255)	‘full’	false
explicit	tinyint(1)	NULL	true
status	longtext	’[]’	false				(DC2Type:json)

Constraints

Name	Type	Definition
FK_DDAA1CDA4EC001D1	FOREIGN KEY	FOREIGN KEY (season_id) REFERENCES season (id)
FK_DDAA1CDA786136AB	FOREIGN KEY	FOREIGN KEY (podcast_id) REFERENCES podcast (id)
PRIMARY	PRIMARY KEY	PRIMARY KEY (id)
keywords	CHECK	CHECK (json_valid(keywords))
keywords	CHECK	CHECK (json_valid(keywords))
status	CHECK	CHECK (json_valid(status))
status	CHECK	CHECK (json_valid(status))
status	CHECK	CHECK (json_valid(status))

Indexes

Name	Definition
IDX_DDAA1CDA4EC001D1	KEY IDX_DDAA1CDA4EC001D1 (season_id) USING BTREE
IDX_DDAA1CDA786136AB	KEY IDX_DDAA1CDA786136AB (podcast_id) USING BTREE
PRIMARY	PRIMARY KEY (id) USING BTREE

Relations

---

Generated by tbls