import { pgTable, bigserial, bigint, text, real } from "drizzle-orm/pg-core";
import { magicPlanRoom } from "./room";

export const magicPlanDoor = pgTable(
  "magic_plan_door",
  {
    id:         bigserial("id", { mode: "bigint" }).primaryKey(),
    roomId:     bigint("magic_plan_room_id", { mode: "bigint" })
      .notNull()
      .references(() => magicPlanRoom.id),
    widthMm:    real("width_mm"),
    heightMm:   real("height_mm"),
    type:       text("type"),
  },
);