Skip to content

Framework tables

Tables of the area Framework tables (Laravel) and their relations — Framework tables (Laravel): tables and foreign keys. Dashed lines lead to tables of other areas.

`cache`

Laravel cache in the database, also the single-use nonces of the Pulsar API.

3 columns

Column	Type	Null	Default	References
`key` PK	`varchar(255)`
`value`	`mediumtext`
`expiration`	`int(11)`

`cache_locks`

Locks of the scheduler (withoutOverlapping) and the cache.

3 columns

Column	Type	Null	Default	References
`key` PK	`varchar(255)`
`owner`	`varchar(255)`
`expiration`	`int(11)`

`jobs`

Queued jobs for the queue container.

7 columns

Column	Type	Null	Default	References
`id` PK	`bigint(20) unsigned`
`queue`	`varchar(255)`
`payload`	`longtext`
`attempts`	`tinyint(3) unsigned`
`reserved_at`	`int(10) unsigned`	yes
`available_at`	`int(10) unsigned`
`created_at`	`int(10) unsigned`

Indexes: queue

`job_batches`

Laravel job batches.

10 columns

Column	Type	Null	Default	References
`id` PK	`varchar(255)`
`name`	`varchar(255)`
`total_jobs`	`int(11)`
`pending_jobs`	`int(11)`
`failed_jobs`	`int(11)`
`failed_job_ids`	`longtext`
`options`	`mediumtext`	yes
`cancelled_at`	`int(11)`	yes
`created_at`	`int(11)`
`finished_at`	`int(11)`	yes

`failed_jobs`

Jobs that failed after their retries.

7 columns

Column	Type	Null	Default	References
`id` PK	`bigint(20) unsigned`
`uuid` unique	`varchar(255)`
`connection`	`text`
`queue`	`text`
`payload`	`longtext`
`exception`	`longtext`
`failed_at`	`timestamp`		`current_timestamp()`

Indexes: uuid (unique)

`migrations`

Database migrations that have run.

3 columns

Column	Type	Null	Default	References
`id` PK	`int(10) unsigned`
`migration`	`varchar(255)`
`batch`	`int(11)`