(대표님) rfq, 계약, 서명 등

1 files changed, 17 insertions, 1 deletions

diff --git a/db/schema/basicContractDocumnet.ts b/db/schema/basicContractDocumnet.ts
index 7fc975a0..0f335e90 100644
--- a/db/schema/basicContractDocumnet.ts
+++ b/db/schema/basicContractDocumnet.ts
@@ -244,4 +244,20 @@ export const basicContractTemplateStatsView = pgView('basic_contract_template_st
     );
 });
 
-export type BasicContractTemplateStatsView = typeof basicContractTemplateStatsView.$inferSelect;
\ No newline at end of file
+export type BasicContractTemplateStatsView = typeof basicContractTemplateStatsView.$inferSelect;
+
+
+export const buyerSignatures = pgTable('buyer_signatures', {
+  id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
+  name: varchar('name', { length: 255 }).notNull().default('삼성중공업'),
+  imageUrl: text('image_url').notNull(),
+  dataUrl: text('data_url'), // Base64 데이터
+  mimeType: varchar('mime_type', { length: 100 }),
+  fileSize: integer('file_size'),
+  isActive: boolean('is_active').default(true),
+  createdAt: timestamp('created_at').defaultNow().notNull(),
+  updatedAt: timestamp('updated_at').defaultNow().notNull(),
+});
+
+export type BuyerSignature = typeof buyerSignatures.$inferSelect;
+export type NewBuyerSignature = typeof buyerSignatures.$inferInsert;
\ No newline at end of file