export const receipt = mysqlTable('receipt', {
id: serial('id').primaryKey(),
userId: int('user_id').notNull(),
typeId: int('type_id').notNull(),
name: varchar('name', { length: 100 }),
date: date('date').notNull(),
nominal: decimal('nominal', { precision: 10, scale: 2 }).notNull(),
note: text('note'),
statusId: int('status_id').notNull(),
createdAt: timestamp('created_at').defaultNow().notNull()
});
export const receipt = mysqlTable('receipt', {
id: serial('id').primaryKey(),
userId: int('user_id').notNull(),
typeId: int('type_id').notNull(),
name: varchar('name', { length: 100 }),
date: date('date').notNull(),
nominal: decimal('nominal', { precision: 10, scale: 2 }).notNull(),
note: text('note'),
statusId: int('status_id').notNull(),
createdAt: timestamp('created_at').defaultNow().notNull()
});