(대표님, 최겸) 기본계약, 입찰, 파일라우트, 계약서명라우트, 인포메이션, 메뉴설정, PQ(메일템플릿 관련)

1 files changed, 3 insertions, 0 deletions

diff --git a/db/schema/legal.ts b/db/schema/legal.ts
index e4880517..3047bc2a 100644
--- a/db/schema/legal.ts
+++ b/db/schema/legal.ts
@@ -1,6 +1,7 @@
 import { pgView,pgTable, serial, varchar, boolean, date, text, timestamp, integer, decimal } from 'drizzle-orm/pg-core';
 import { vendors } from './vendors';
 import { eq , sql, relations} from "drizzle-orm";
+import { basicContract } from './basicContractDocumnet';
 
 // 법무 업무 테이블
 export const legalWorks = pgTable('legal_works', {
@@ -38,6 +39,8 @@ export const legalWorks = pgTable('legal_works', {
   // 메타데이터
   createdAt: timestamp('created_at').defaultNow().notNull(),
   updatedAt: timestamp('updated_at').defaultNow().notNull(),
+  basicContractId: integer("basic_contract_id")
+  .references(() => basicContract.id, { onDelete: "set null" }),
 });
 
 // 타입 정의