// src/server/features/operations/db/cleaning_schedule_rooms.table.ts
// Таблица привязки номеров к графику уборки за месяц

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

export const cleaningScheduleRooms = mysqlTable('cleaning_schedule_rooms', {
  id: varchar('id', { length: 36 }).primaryKey(),
  month: int('month').notNull(),
  year: int('year').notNull(),
  roomId: varchar('room_id', { length: 10 }).notNull(),
  roomType: varchar('room_type', { length: 100 }).notNull(),
  beds: int('beds').notNull().default(0),
  createdAt: timestamp('created_at').notNull().defaultNow(),
  updatedAt: timestamp('updated_at').notNull().defaultNow().onUpdateNow(),
}, (table) => ({
  unq: uniqueIndex('cleaning_rooms_month_room_idx').on(table.year, table.month, table.roomId),
}));