import { varchar, jsonb, timestamp, index, primaryKey } from "drizzle-orm/pg-core";
import { knoxSchema } from "./employee";

export const title = knoxSchema.table(
  "title",
  {
    companyCode: varchar("company_code", { length: 10 }).notNull(),
    titleCode: varchar("title_code", { length: 20 }).notNull(),

    titleName: varchar("title_name", { length: 100 }),
    enTitleName: varchar("en_title_name", { length: 100 }),
    sortOrder: varchar("sort_order", { length: 10 }),

    // 전체 원본 JSON 데이터 저장
    raw: jsonb("raw").notNull(),

    createdAt: timestamp("created_at", { withTimezone: true }).defaultNow().notNull(),
    updatedAt: timestamp("updated_at", { withTimezone: true }).defaultNow().notNull(),
  },
  (table) => {
    return {
      companyIdx: index("knox_title_company_idx").on(table.companyCode),
      pk: primaryKey(table.companyCode, table.titleCode),
    };
  }
);

export type KnoxTitle = typeof title.$inferSelect;
export type NewKnoxTitle = typeof title.$inferInsert;