sql

create table SCOUTING_FORM
(
	ID BIGINT default (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_5EF89BD2_00C5_48FC_88F2_D9B6D5AC3180) auto_increment
		primary key,
	BUDDY_CLIMB BOOLEAN,
	COMMENT VARCHAR(255) not null,
	CROSS_HABITAT_LINE BOOLEAN not null,
	DEFENSE BOOLEAN,
	DROPPED_GAME_PIECES INTEGER,
	GOT_LIFTED BOOLEAN,
	HAB_LEVEL_CLIMB INTEGER not null,
	HAB_LEVEL_START INTEGER not null,
	LIFTED BOOLEAN,
	MATCH_NUMBER INTEGER not null,
	PRELOAD INTEGER,
	ROCKET_LEVEL INTEGER,
	SANDSTORM_CARGO_BALL_COUNT INTEGER not null,
	SANDSTORM_CARGO_HATCH_PANEL_COUNT INTEGER not null,
	SANDSTORM_ROCKET_BALL_COUNT INTEGER not null,
	SANDSTORM_ROCKET_HATCH_PANEL_COUNT INTEGER not null,
	SCORE INTEGER not null,
	TEAM_NUMBER INTEGER not null,
	TELEOP_CARGO_BALL_COUNT INTEGER not null,
	TELEOP_CARGO_HATCH_PANEL_COUNT INTEGER not null,
	TELEOP_ROCKET_BALL_COUNT INTEGER not null,
	TELEOP_ROCKET_HATCH_PANEL_COUNT INTEGER not null
);