10 lines
429 B
Dart
10 lines
429 B
Dart
import 'package:drift/drift.dart';
|
|
|
|
class Projects extends Table {
|
|
IntColumn get id => integer().autoIncrement()();
|
|
TextColumn get name => text().withLength(min: 1, max: 100).unique()();
|
|
IntColumn get colorValue => integer()();
|
|
TextColumn get description => text().nullable()();
|
|
DateTimeColumn get archivedAt => dateTime().nullable()();
|
|
DateTimeColumn get createdAt => dateTime().withDefault(currentDateAndTime)();
|
|
}
|