// src/server/features/operations/db/linen.table.ts
// Linen table schema for linen tracking

import { mysqlTable, varchar, int, timestamp } from 'drizzle-orm/mysql-core';

export const linen = mysqlTable('linen', {
  id: varchar('id', { length: 36 }).primaryKey(),
  roomNumber: varchar('room_number', { length: 10 }).notNull(),
  type: varchar('type', { length: 50 }).notNull(),
  quantity: int('quantity').notNull(),
  status: varchar('status', { length: 50 }).notNull(),
  createdAt: timestamp('created_at').notNull().defaultNow(),
  updatedAt: timestamp('updated_at').notNull().defaultNow().onUpdateNow(),
});