diff options
Diffstat (limited to 'db/schema/items.ts')
| -rw-r--r-- | db/schema/items.ts | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/db/schema/items.ts b/db/schema/items.ts index e9c10058..fefb8e08 100644 --- a/db/schema/items.ts +++ b/db/schema/items.ts @@ -7,7 +7,7 @@ export const items = pgTable("items", { ProjectNo: varchar("project_no", { length: 100 }).notNull(), itemCode: varchar("item_code", { length: 100 }).notNull(), itemName: varchar("item_name", { length: 255 }).notNull(), - packageCode: varchar("package_code", { length: 255 }).notNull(), + packageCode: varchar("package_code", { length: 255 }), // nullable로 변경 (ECC에서 제공되지 않을 수 있음) smCode: varchar("sm_code", { length: 255 }), description: text("description"), parentItemCode: varchar("parent_item_code", { length: 18 }), // PRNT_CLAS_CD - 부모 아이템 코드 (부모 클래스 코드) |