penalty_type

8 rows where penalty_class_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

penalty_type_id ▼ penalty_description penalty_class_id
20 Misconduct - Abuse of officials 5 5
33 Misconduct 5 5
36 Misconduct - Instigating 5 5
62 Misconduct - Unsportsmanlike conduct 5 5
72 Misconduct - Continuing altercation 5 5
115 Misconduct - Throwing equipment 5 5
155 Misconduct - Goalkeeper 5 5
159 Misconduct - Visor 5 5

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE penalty_type (
                penalty_type_id INTEGER PRIMARY KEY AUTOINCREMENT,
                penalty_description TEXT UNIQUE NOT NULL,
                penalty_class_id INTEGER,
                FOREIGN KEY (penalty_class_id) REFERENCES penaltyclass(penalty_class_id)
            );