import {
jsonb,
pgTable,
text,
timestamp,
uuid,
varchar,
} from 'drizzle-orm/pg-core';
export const tableName = 'videos';
export const VideoTable = pgTable(tableName, {
id: uuid('id').primaryKey().defaultRandom(),
url: text('url').notNull(),
transcription_id: varchar('transcription_id'),
transcription: jsonb('transcription').$type<
Array<{
start_time: number;
end_time: number;
type: string;
content: string;
}>
>(),
createdAt: timestamp('created_at', { withTimezone: true }).defaultNow(),
updatedAt: timestamp('updated_at', { withTimezone: true }).defaultNow(),
});
const Table = VideoTable;
export type Video = typeof Table.$inferSelect;
export type NewVideo = typeof Table.$inferInsert;
import {
jsonb,
pgTable,
text,
timestamp,
uuid,
varchar,
} from 'drizzle-orm/pg-core';
export const tableName = 'videos';
export const VideoTable = pgTable(tableName, {
id: uuid('id').primaryKey().defaultRandom(),
url: text('url').notNull(),
transcription_id: varchar('transcription_id'),
transcription: jsonb('transcription').$type<
Array<{
start_time: number;
end_time: number;
type: string;
content: string;
}>
>(),
createdAt: timestamp('created_at', { withTimezone: true }).defaultNow(),
updatedAt: timestamp('updated_at', { withTimezone: true }).defaultNow(),
});
const Table = VideoTable;
export type Video = typeof Table.$inferSelect;
export type NewVideo = typeof Table.$inferInsert;