schema top-level property Null safety
final
A consumable database structure including the latest generated migration.
Implementation
final schema =
Schema(20210805035603, generatorVersion: 1, tables: <SchemaTable>{
SchemaTable('Run', columns: <SchemaColumn>{
SchemaColumn('_brick_id', Column.integer,
autoincrement: true, nullable: false, isPrimaryKey: true),
SchemaColumn('id', Column.varchar, unique: true),
SchemaColumn('event_id', Column.varchar),
SchemaColumn('created', Column.varchar),
SchemaColumn('end', Column.varchar),
SchemaColumn('state', Column.varchar),
SchemaColumn('is_race_day', Column.boolean),
SchemaColumn('distance', Column.num),
SchemaColumn('average_speed', Column.Double),
SchemaColumn('user_id', Column.varchar),
SchemaColumn('timezone_offset', Column.num),
SchemaColumn('meta', Column.varchar),
SchemaColumn('device_informations', Column.varchar)
}, indices: <SchemaIndex>{
SchemaIndex(columns: ['id'], unique: true)
}),
SchemaTable('User', columns: <SchemaColumn>{
SchemaColumn('_brick_id', Column.integer,
autoincrement: true, nullable: false, isPrimaryKey: true),
SchemaColumn('id', Column.varchar, unique: true),
SchemaColumn('firstname', Column.varchar),
SchemaColumn('lastname', Column.varchar),
SchemaColumn('email', Column.varchar),
SchemaColumn('password', Column.varchar)
}, indices: <SchemaIndex>{
SchemaIndex(columns: ['id'], unique: true)
}),
SchemaTable('_brick_RunFile_split_times', columns: <SchemaColumn>{
SchemaColumn('_brick_id', Column.integer,
autoincrement: true, nullable: false, isPrimaryKey: true),
SchemaColumn('l_RunFile_brick_id', Column.integer,
isForeignKey: true,
foreignTableName: 'RunFile',
onDeleteCascade: true,
onDeleteSetDefault: false),
SchemaColumn('f_SplitTime_brick_id', Column.integer,
isForeignKey: true,
foreignTableName: 'SplitTime',
onDeleteCascade: true,
onDeleteSetDefault: false)
}, indices: <SchemaIndex>{
SchemaIndex(
columns: ['l_RunFile_brick_id', 'f_SplitTime_brick_id'], unique: true)
}),
SchemaTable('_brick_RunFile_locations', columns: <SchemaColumn>{
SchemaColumn('_brick_id', Column.integer,
autoincrement: true, nullable: false, isPrimaryKey: true),
SchemaColumn('l_RunFile_brick_id', Column.integer,
isForeignKey: true,
foreignTableName: 'RunFile',
onDeleteCascade: true,
onDeleteSetDefault: false),
SchemaColumn('f_RunLocation_brick_id', Column.integer,
isForeignKey: true,
foreignTableName: 'RunLocation',
onDeleteCascade: true,
onDeleteSetDefault: false)
}, indices: <SchemaIndex>{
SchemaIndex(
columns: ['l_RunFile_brick_id', 'f_RunLocation_brick_id'], unique: true)
}),
SchemaTable('RunFile', columns: <SchemaColumn>{
SchemaColumn('_brick_id', Column.integer,
autoincrement: true, nullable: false, isPrimaryKey: true),
SchemaColumn('id', Column.varchar, unique: true),
SchemaColumn('run_Run_brick_id', Column.integer,
isForeignKey: true,
foreignTableName: 'Run',
onDeleteCascade: false,
onDeleteSetDefault: false),
SchemaColumn('status', Column.varchar)
}, indices: <SchemaIndex>{
SchemaIndex(columns: ['id'], unique: true)
}),
SchemaTable('SpeechPackage', columns: <SchemaColumn>{
SchemaColumn('_brick_id', Column.integer,
autoincrement: true, nullable: false, isPrimaryKey: true),
SchemaColumn('id', Column.varchar, unique: true),
SchemaColumn('name', Column.varchar),
SchemaColumn('lang', Column.varchar),
SchemaColumn('url', Column.varchar),
SchemaColumn('version', Column.varchar)
}, indices: <SchemaIndex>{
SchemaIndex(columns: ['id'], unique: true)
}),
SchemaTable('SplitTime', columns: <SchemaColumn>{
SchemaColumn('_brick_id', Column.integer,
autoincrement: true, nullable: false, isPrimaryKey: true),
SchemaColumn('id', Column.varchar, unique: true),
SchemaColumn('created', Column.varchar),
SchemaColumn('run_time', Column.num),
SchemaColumn('average_speed', Column.Double),
SchemaColumn('distance', Column.num),
SchemaColumn('run_id', Column.varchar),
SchemaColumn('location', Column.varchar),
SchemaColumn('locations_count', Column.num),
SchemaColumn('cheat', Column.num),
SchemaColumn('meta', Column.varchar),
SchemaColumn('event_id', Column.varchar)
}, indices: <SchemaIndex>{
SchemaIndex(columns: ['id'], unique: true)
}),
SchemaTable('RunLocation', columns: <SchemaColumn>{
SchemaColumn('_brick_id', Column.integer,
autoincrement: true, nullable: false, isPrimaryKey: true),
SchemaColumn('uuid', Column.varchar, unique: true),
SchemaColumn('run_id', Column.varchar),
SchemaColumn('coords', Column.varchar),
SchemaColumn('activity', Column.varchar),
SchemaColumn('battery', Column.varchar),
SchemaColumn('meta', Column.varchar),
SchemaColumn('triggered_split_time', Column.boolean),
SchemaColumn('odometers', Column.varchar),
SchemaColumn('location_service_timestamp', Column.varchar),
SchemaColumn('recorded_timestamp', Column.varchar)
}, indices: <SchemaIndex>{
SchemaIndex(columns: ['uuid'], unique: true)
})
});