penalty_type

4 rows where penalty_class_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

penalty_type_id ▼ penalty_description penalty_class_id
49 Double minor - Butt-ending (attempt) 2 2
59 Double minor - Spearing (attempt) 2 2
68 Double minor - High-sticking 2 2
108 Double minor - Head-butting (attempt) 2 2

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)
            );