Open-source and local-first Slack and Notion alternative that puts you in control of your data
TypeScript chatchat-applicationcrdteditorelectronknowledge-baselocal-firstnotionnotion-alternativerealtime-collaborationself-hostedslacksqliteteam-collaborationwikiyjs
import { ColumnType, Insertable, Selectable, Updateable } from 'kysely';
import { JobScheduleStatus, JobStatus } from '@colanode/client/jobs';
import { FileSubtype, WorkspaceRole, WorkspaceStatus } from '@colanode/core';
interface ServerTable {
domain: ColumnType<string, string, never>;
name: ColumnType<string, string, string>;
avatar: ColumnType<string, string, string>;
attributes: ColumnType<string, string, string>;
version: ColumnType<string, string, string>;
created_at: ColumnType<string, string, string>;
synced_at: ColumnType<string | null, string | null, string>;
}
export type SelectServer = Selectable<ServerTable>;
export type CreateServer = Insertable<ServerTable>;
export type UpdateServer = Updateable<ServerTable>;
interface MetadataTable {
namespace: ColumnType<string, string, never>;
key: ColumnType<string, string, never>;
value: ColumnType<string, string, string>;
created_at: ColumnType<string, string, never>;
updated_at: ColumnType<string | null, string | null, string | null>;
}
export type SelectMetadata = Selectable<MetadataTable>;
export type CreateMetadata = Insertable<MetadataTable>;
export type UpdateMetadata = Updateable<MetadataTable>;
interface AccountTable {
id: ColumnType<string, string, never>;
server: ColumnType<string, string, never>;
name: ColumnType<string, string, string>;
email: ColumnType<string, string, never>;
avatar: ColumnType<string | null, string | null, string | null>;
token: ColumnType<string, string, string>;
device_id: ColumnType<string, string, never>;
created_at: ColumnType<string, string, string>;
updated_at: ColumnType<string | null, string | null, string | null>;
synced_at: ColumnType<string | null, string | null, string | null>;
}
export type SelectAccount = Selectable<AccountTable>;
export type CreateAccount = Insertable<AccountTable>;
export type UpdateAccount = Updateable<AccountTable>;
export interface JobTableSchema {
id: ColumnType<string, string, never>;
queue: ColumnType<string, string, never>;
input: ColumnType<string, string, string>;
options: ColumnType<string | null, string | null, string | null>;
status: ColumnType<JobStatus, JobStatus, JobStatus>;
retries: ColumnType<number, number, number>;
scheduled_at: ColumnType<string, string, string>;
deduplication_key: ColumnType<string | null, string | null, string | null>;
concurrency_key: ColumnType<string | null, string | null, string | null>;
schedule_id: ColumnType<string | null, string | null, string | null>;
created_at: ColumnType<string, string, string>;
updated_at: ColumnType<string, string, string>;
}
export type SelectJob = Selectable<JobTableSchema>;
export type InsertJob = Insertable<JobTableSchema>;
export type UpdateJob = Updateable<JobTableSchema>;
export interface JobScheduleTableSchema {
id: ColumnType<string, string, never>;
queue: ColumnType<string, string, never>;
input: ColumnType<string, string, string>;
options: ColumnType<string | null, string | null, string | null>;
status: ColumnType<JobScheduleStatus, JobScheduleStatus, JobScheduleStatus>;
interval: ColumnType<number, number, number>;
next_run_at: ColumnType<string, string, string>;
last_run_at: ColumnType<string | null, string | null, string | null>;
created_at: ColumnType<string, string, string>;
updated_at: ColumnType<string, string, string>;
}
export type SelectJobSchedule = Selectable<JobScheduleTableSchema>;
export type InsertJobSchedule = Insertable<JobScheduleTableSchema>;
export type UpdateJobSchedule = Updateable<JobScheduleTableSchema>;
interface TempFileTable {
id: ColumnType<string, string, never>;
name: ColumnType<string, string, string>;
path: ColumnType<string, string, string>;
size: ColumnType<number, number, number>;
subtype: ColumnType<FileSubtype, FileSubtype, FileSubtype>;
mime_type: ColumnType<string, string, string>;
extension: ColumnType<string, string, string>;
created_at: ColumnType<string, string, string>;
opened_at: ColumnType<string, string, string>;
}
export type SelectTempFile = Selectable<TempFileTable>;
export type InsertTempFile = Insertable<TempFileTable>;
export type UpdateTempFile = Updateable<TempFileTable>;
interface TabTable {
id: ColumnType<string, string, never>;
location: ColumnType<string, string, string>;
index: ColumnType<string, string, string>;
last_active_at: ColumnType<string, string, string>;
created_at: ColumnType<string, string, string>;
updated_at: ColumnType<string | null, string | null, string | null>;
}
export type SelectTab = Selectable<TabTable>;
export type InsertTab = Insertable<TabTable>;
export type UpdateTab = Updateable<TabTable>;
interface WorkspacesTable {
user_id: ColumnType<string, string, never>;
workspace_id: ColumnType<string, string, string>;
account_id: ColumnType<string, string, string>;
name: ColumnType<string, string, string>;
description: ColumnType<string | null, string | null, string | null>;
avatar: ColumnType<string | null, string | null, string | null>;
role: ColumnType<WorkspaceRole, WorkspaceRole, WorkspaceRole>;
max_file_size: ColumnType<string | null, string | null, string | null>;
created_at: ColumnType<string, string, string>;
updated_at: ColumnType<string | null, string | null, string | null>;
status: ColumnType<WorkspaceStatus, WorkspaceStatus, WorkspaceStatus>;
}
export type SelectWorkspace = Selectable<WorkspacesTable>;
export type InsertWorkspace = Insertable<WorkspacesTable>;
export type UpdateWorkspace = Updateable<WorkspacesTable>;
interface AvatarsTable {
id: ColumnType<string, string, never>;
path: ColumnType<string, string, string>;
size: ColumnType<number, number, number>;
created_at: ColumnType<string, string, string>;
opened_at: ColumnType<string, string, string>;
}
export type SelectAvatar = Selectable<AvatarsTable>;
export type InsertAvatar = Insertable<AvatarsTable>;
export type UpdateAvatar = Updateable<AvatarsTable>;
export interface AppDatabaseSchema {
servers: ServerTable;
metadata: MetadataTable;
accounts: AccountTable;
workspaces: WorkspacesTable;
jobs: JobTableSchema;
job_schedules: JobScheduleTableSchema;
temp_files: TempFileTable;
avatars: AvatarsTable;
tabs: TabTable;
}