import { GeneratedAlways, Selectable } from "kysely";

// Define the schema for subject statuses
export interface Subject {
  id: GeneratedAlways<number>;
  reviewState: string;
  createdAt: string;
  updatedAt: string;
  lastReportedAt?: string | null;
  lastReviewedBy?: string | null;
  lastReviewedAt?: string | null;
  takendown: number;
  subjectRepoHandle?: string | null;
  subjectBlobCids: string;
  tags: string;
  did: string;
  recordPath: string;
  lastAppealedAt?: string | null;
  suspendUntil?: string | null;
  muteUntil?: string | null;
  muteReportingUntil?: string | null;
  comment?: string | null;
}

export type SubjectRow = Selectable<Subject>;