From cc023040c83dc663659ab89a99c133e357ec5a5a Mon Sep 17 00:00:00 2001 From: dujinkim Date: Mon, 10 Nov 2025 09:28:57 +0000 Subject: (임수민) fileType varchar 제한 변경 (mime type 사용) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- db/schema/vendorDocu.ts | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'db') diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index bfa43849..84fc036a 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -234,7 +234,7 @@ export const documentAttachments = pgTable( .references(() => revisions.id, { onDelete: "cascade" }), fileName: varchar("file_name", { length: 255 }).notNull(), filePath: varchar("file_path", { length: 1024 }).notNull(), - fileType: varchar("file_type", { length: 50 }), + fileType: varchar("file_type", { length: 1024 }), fileSize: integer("file_size"), // DOLCE 연동 관련 필드 추가 @@ -1816,7 +1816,7 @@ export const stageSubmissionAttachments = pgTable( // 파일 정보 fileName: varchar("file_name", { length: 255 }).notNull(), originalFileName: varchar("original_file_name", { length: 255 }).notNull(), - fileType: varchar("file_type", { length: 100 }), // application/pdf, image/jpeg, etc. + fileType: varchar("file_type", { length: 1024 }), // application/pdf, image/jpeg, etc. fileExtension: varchar("file_extension", { length: 20 }), fileSize: bigint("file_size", { mode: "number" }).notNull(), // bytes @@ -1828,7 +1828,7 @@ export const stageSubmissionAttachments = pgTable( bucketName: varchar("bucket_name", { length: 255 }), // 파일 메타데이터 - mimeType: varchar("mime_type", { length: 100 }), + mimeType: varchar("mime_type", { length: 1024 }), checksum: varchar("checksum", { length: 255 }), // MD5 or SHA256 // 문서 분류 (옵션) -- cgit v1.2.3