activity

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
activity_event.activity_id FK_25AC3C1481C06096 C
activity_execution.activity_id FK_9BEEE2F981C06096 C
title VARCHAR 255 null
description LONGTEXT 2147483647 √ NULL
emoji VARCHAR 64 √ NULL
max_participants INT UNSIGNED 10 √ NULL
meeting_point VARCHAR 255 √ NULL
pid VARCHAR 16 √ NULL
created_at DATETIME 19 null
updated_at DATETIME 19 null
location_id INT UNSIGNED 10 null
location.id FK_AC74095A64D218E R
level INT UNSIGNED 10 √ NULL
heightlevel_up INT UNSIGNED 10 √ NULL
heightlevel_down INT UNSIGNED 10 √ NULL
organisatory_info LONGTEXT 2147483647 √ NULL
requirements VARCHAR 255 √ NULL
bookable TINYINT 3 1

Indexes

Constraint Name Type Sort Column(s)
activity_s_pk Primary key Asc id
IDX_AC74095A64D218E Performance Asc location_id
PRIMARY Must be unique Asc id
UNIQ_AC74095A5550C4ED Must be unique Asc pid

Relationships

Close relationships within degrees of separation