import type { ColumnType, Generated, Insertable, Selectable, Updateable } from "kysely";
import type { PromptType } from "../prompts";
import type { AudioMetadata, AudioStatus, Stamp, Transcription } from "../audio";
import type { FileMetadata, FileStatus, FileType } from "../file";
import type { LlmProcessingType, LlmProcessingMetadata } from "../llm";
import type { NoteType, NoteLinkMetadata } from "../notes";
export type Timestamp = ColumnType<Date, Date | string, Date | string>;
export type Json = JsonValue;
export type JsonArray = JsonValue[];
export type JsonObject = {
    [x: string]: JsonValue | undefined;
};
export type JsonPrimitive = boolean | number | string | null;
export type JsonValue = JsonArray | JsonObject | JsonPrimitive;
export interface NotesTable {
    id: Generated<string>;
    createdAt: Timestamp;
    title: string | null;
    content: string | null;
    flag: Generated<boolean>;
    updatedAt: Timestamp;
    deletedAt: Timestamp | null;
    userId: string;
    audioId: string | null;
    type: Generated<NoteType>;
    summary: string | null;
    sceneId: string | null;
    metadata: NoteLinkMetadata | null;
    tagId: string | null;
    raw: string | null;
    fileId: string | null;
}
export interface TagsTable {
    id: Generated<string>;
    name: string;
    description: string | null;
    userId: string;
    createdAt: Timestamp;
    autoTag: Generated<boolean>;
    promptId: string | null;
    color: string | null;
}
export interface NoteKeywordsTable {
    id: Generated<string>;
    noteId: string;
    keyword: string;
    userId: string;
}
export interface AudiosTable {
    id: string;
    createdAt: Timestamp;
    userId: string;
    duration: number;
    transcription: Transcription | null;
    metadata: AudioMetadata | null;
    stamps: Stamp[] | null;
    speakerMapping: Json | null;
    status: AudioStatus;
    sceneId: string | null;
    startedAt: Timestamp | null;
    finishedAt: Timestamp | null;
    vtt: string | null;
}
export interface FilesTable {
    id: string;
    createdAt: Timestamp;
    userId: string;
    type: FileType;
    status: FileStatus;
    metadata: FileMetadata | null;
    markdown: string | null;
}
export interface LlmProcessingTable {
    id: Generated<string>;
    createdAt: Generated<Timestamp>;
    userId: string;
    noteId: string;
    type: LlmProcessingType;
    model: string;
    reasoningEffort: string | null;
    reasoning: string | null;
    metadata: LlmProcessingMetadata | null;
    finishedAt: Timestamp | null;
}
export interface PromptsTable {
    id: Generated<string>;
    createdAt: Timestamp;
    title: string;
    description: string | null;
    prompt: string;
    userId: Generated<string>;
    type: Generated<PromptType>;
}
export interface ScenesTable {
    id: Generated<string>;
    createdAt: Timestamp;
    userId: string;
    name: string;
    promptId: string;
    formattedTitle: string | null;
    keytermId: string | null;
    followUp: Generated<boolean>;
}
export interface KeytermsTable {
    id: Generated<string>;
    content: string | null;
    userId: string;
}
export interface SceneTagsTable {
    id: Generated<string>;
    sceneId: string;
    tagId: string;
    userId: string;
}
export interface PeopleTable {
    id: Generated<string>;
    name: string;
    metadata: Json | null;
    userId: string;
    createdAt: Timestamp;
    nickname: string | null;
    persona: string | null;
}
export interface NotePeopleTable {
    id: Generated<string>;
    noteId: string;
    personId: string;
    userId: string;
}
export interface ScenePeopleTable {
    id: Generated<string>;
    sceneId: string;
    personId: string;
    userId: string;
}
export type SettingsRole = 'general' | 'contentCreator' | 'consultant' | 'productManager' | 'journalist' | 'entrepreneur';
export interface SettingsTable {
    id: string;
    language: Generated<string>;
    timezone: Generated<number>;
    role: SettingsRole | null;
    baseKeyterms: Generated<string>;
}
export interface ProfilesTable {
    id: string;
    subscriptionTier: Generated<string>;
    subscriptionExpiresAt: Timestamp | null;
    voiceUsageThisMonth: Generated<number>;
    usageResetAt: Timestamp | null;
    subscriptionId: string | null;
    transactionId: string | null;
    subscriptionStatus: Generated<string>;
    lastEventType: string | null;
    lastEventAt: Timestamp | null;
    createdAt: Timestamp;
    updatedAt: Timestamp;
}
export type NoteTypeFilter = "link" | "voice" | "text";
export interface FolderRules {
    tags: string[];
    people: string[];
    keywords: string[];
    noteTypes: NoteTypeFilter[];
}
export interface FoldersTable {
    id: Generated<string>;
    name: string;
    rules: FolderRules;
    userId: string;
    createdAt: Timestamp;
}
export type ExtensionType = "telegram" | "discord" | "slack" | "notion" | "guionalert" | "api";
export interface TelegramMetadata {
    username?: string;
}
export interface DiscordMetadata {
    username?: string;
}
export interface SlackMetadata {
    username?: string;
}
export interface NotionMetadata {
    accessToken: string;
    tokenType: string;
    botId: string;
    workspaceId: string;
    workspaceName?: string;
    workspaceIcon?: string;
    grantedPages: Array<{
        id: string;
        title: string;
    }>;
    createdAt?: number;
    updatedAt?: number;
}
export interface ApiKeyMetadata {
    prefix: string;
    lastFour: string;
    createdAt: number;
}
export type ExtensionMetadata = TelegramMetadata | DiscordMetadata | SlackMetadata | NotionMetadata | ApiKeyMetadata;
export interface TelegramSettings {
    sendConfirmation: boolean;
    listenTo?: string[];
}
export interface DiscordSettings {
}
export interface SlackSettings {
}
export interface NotionSettings {
    syncDstPageId?: string;
    databaseId?: string | null;
}
export type ExtensionSettings = TelegramSettings | DiscordSettings | SlackSettings | NotionSettings;
export interface ExtensionsTable {
    id: Generated<string>;
    type: ExtensionType;
    userId: string;
    platformId: string;
    metadata: ExtensionMetadata | null;
    settings: ExtensionSettings | null;
}
export interface Database {
    notes: NotesTable;
    tags: TagsTable;
    note_keywords: NoteKeywordsTable;
    audios: AudiosTable;
    files: FilesTable;
    llm_processing: LlmProcessingTable;
    prompts: PromptsTable;
    scenes: ScenesTable;
    scene_tags: SceneTagsTable;
    keyterms: KeytermsTable;
    people: PeopleTable;
    note_people: NotePeopleTable;
    scene_people: ScenePeopleTable;
    settings: SettingsTable;
    profiles: ProfilesTable;
    extensions: ExtensionsTable;
    folders: FoldersTable;
}
export type Note = Selectable<NotesTable>;
export type NewNote = Insertable<NotesTable>;
export type NoteUpdate = Updateable<NotesTable>;
export type Tag = Selectable<TagsTable>;
export type NewTag = Insertable<TagsTable>;
export type NoteKeyword = Selectable<NoteKeywordsTable>;
export type NewNoteKeyword = Insertable<NoteKeywordsTable>;
export type Audio = Selectable<AudiosTable>;
export type NewAudio = Insertable<AudiosTable>;
export type AudioUpdate = Updateable<AudiosTable>;
export type File = Selectable<FilesTable>;
export type NewFile = Insertable<FilesTable>;
export type FileUpdate = Updateable<FilesTable>;
export type LlmProcessing = Selectable<LlmProcessingTable>;
export type NewLlmProcessing = Insertable<LlmProcessingTable>;
export type LlmProcessingUpdate = Updateable<LlmProcessingTable>;
export type Prompt = Selectable<PromptsTable>;
export type NewPrompt = Insertable<PromptsTable>;
export type Scene = Selectable<ScenesTable>;
export type NewScene = Insertable<ScenesTable>;
export type Keyterm = Selectable<KeytermsTable>;
export type NewKeyterm = Insertable<KeytermsTable>;
export type SceneTag = Selectable<SceneTagsTable>;
export type NewSceneTag = Insertable<SceneTagsTable>;
export type Person = Selectable<PeopleTable>;
export type NewPerson = Insertable<PeopleTable>;
export type NotePerson = Selectable<NotePeopleTable>;
export type NewNotePerson = Insertable<NotePeopleTable>;
export type ScenePerson = Selectable<ScenePeopleTable>;
export type NewScenePerson = Insertable<ScenePeopleTable>;
export type Settings = Selectable<SettingsTable>;
export type NewSettings = Insertable<SettingsTable>;
export type Profile = Selectable<ProfilesTable>;
export type NewProfile = Insertable<ProfilesTable>;
export type Extension = Selectable<ExtensionsTable>;
export type NewExtension = Insertable<ExtensionsTable>;
export type ExtensionUpdate = Updateable<ExtensionsTable>;
export type Folder = Selectable<FoldersTable>;
export type NewFolder = Insertable<FoldersTable>;
export type FolderUpdate = Updateable<FoldersTable>;