import { pgTable, varchar, integer, timestamp } from "drizzle-orm/pg-core";

export const companies = pgTable("companies", {
  id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
  name: varchar("name", { length: 255 }).notNull(),
  taxID: integer("taxID").notNull(),
  // 회사가 여러 군데일 경우를 대비하여 unique는 걸지 않을 수도 있음
  createdAt: timestamp("created_at", { withTimezone: true })
    .defaultNow()
    .notNull(),
});

export type Company = typeof companies.$inferSelect

export const ownerCompanies = pgTable("owner_companies", {
  id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
  name: varchar("name", { length: 255 }).notNull(),
  createdAt: timestamp("created_at", { withTimezone: true })
    .defaultNow()
    .notNull(),
});

export type OwnerCompany = typeof ownerCompanies.$inferSelect