immich/mobile/packages/data/lib/db/table/stack.dart

21 lines
723 B
Dart

import 'package:drift/drift.dart';
import 'package:immich_data/db/table/user.dart';
import 'package:immich_data/db/util/defaults_mixin.dart';
@TableIndex.sql('CREATE INDEX IF NOT EXISTS idx_stack_primary_asset_id ON stack_entity (primary_asset_id)')
class StackEntity extends Table with DriftDefaultsMixin {
const StackEntity();
TextColumn get id => text()();
DateTimeColumn get createdAt => dateTime().withDefault(currentDateAndTime)();
DateTimeColumn get updatedAt => dateTime().withDefault(currentDateAndTime)();
TextColumn get ownerId => text().references(UserEntity, #id, onDelete: KeyAction.cascade)();
TextColumn get primaryAssetId => text()();
@override
Set<Column> get primaryKey => {id};
}