From 2ce5f9dfbb69f0898c42ab862db5ad142fa24943 Mon Sep 17 00:00:00 2001 From: dujinkim Date: Tue, 14 Oct 2025 09:14:10 +0000 Subject: (최겸) 구매 입찰 1회성 품목 기준정보 개발(스키마, 테이블, CRUD, 페이지 등) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/items.ts | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'db/schema/items.ts') diff --git a/db/schema/items.ts b/db/schema/items.ts index d7640049..e9c10058 100644 --- a/db/schema/items.ts +++ b/db/schema/items.ts @@ -88,4 +88,21 @@ export type ItemOffshoreHull = typeof itemOffshoreHull.$inferSelect; //각 테이블별 컬럼 변경(itemid -> itemCode) +// 품목 관리 테이블 - 사용자 요구사항에 맞게 설계 +export const procurementItems = pgTable("procurement_items", { + id: serial("id").primaryKey(), + itemCode: varchar("item_code", { length: 100 }), + itemName: varchar("item_name", { length: 255 }).notNull(), + material: varchar("material", { length: 100 }), // 재질 + specification: varchar("specification", { length: 255 }), // 규격 + unit: varchar("unit", { length: 50 }), // 단위 + isActive: varchar("is_active", { length: 1 }).default('Y').notNull(), // 활성화여부 (Y/N) + createdBy: varchar("created_by", { length: 100 }), // 등록자 + createdAt: timestamp("created_at").defaultNow().notNull(), // 등록일시 + updatedAt: timestamp("updated_at").defaultNow().notNull(), // 수정일시 +}); + +export type ProcurementItem = typeof procurementItems.$inferSelect; +export type ProcurementItemInsert = typeof procurementItems.$inferInsert; + -- cgit v1.2.3