mirror of
https://github.com/knex/knex.git
synced 2025-12-31 00:57:45 +00:00
36 lines
534 B
TypeScript
36 lines
534 B
TypeScript
import type { Knex } from '../types';
|
|
|
|
export const clientConfig: Knex.Config = {
|
|
client: 'sqlite3',
|
|
connection: {
|
|
filename: './mydb.sqlite',
|
|
},
|
|
};
|
|
|
|
export interface User {
|
|
id: number;
|
|
age: number;
|
|
name: string;
|
|
active: boolean;
|
|
departmentId: number;
|
|
}
|
|
|
|
export interface Department {
|
|
id: number;
|
|
departmentName: string;
|
|
}
|
|
|
|
export interface Article {
|
|
id: number;
|
|
subject: string;
|
|
body?: string;
|
|
authorId?: string;
|
|
}
|
|
|
|
export interface Ticket {
|
|
name: string;
|
|
from: string;
|
|
to: string;
|
|
at: Date;
|
|
}
|