schema top-level property Null safety

Schema schema
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)
  })
});