1 files changed, 14 insertions, 0 deletions
diff --git a/db/schema/basicContractDocumnet.ts b/db/schema/basicContractDocumnet.ts
index 3a0b84a9..7fc975a0 100644
--- a/db/schema/basicContractDocumnet.ts
+++ b/db/schema/basicContractDocumnet.ts
@@ -2,6 +2,10 @@ import { pgTable, pgView, text, timestamp, integer, varchar, boolean , unique, d
 import { vendors } from './vendors';
 import { eq, sql } from "drizzle-orm";
 import { users } from './users';
+import { biddingCompanies } from './bidding';
+import { rfqLastVendorResponses } from './rfqVendor';
+import { rfqLastDetails } from './rfqLast';
+import { generalContracts } from './generalContract';
 
 export const basicContractTemplates = pgTable('basic_contract_templates', {
   id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
@@ -33,6 +37,10 @@ export const basicContract = pgTable('basic_contract', {
   id: integer("id").primaryKey().generatedAlwaysAsIdentity(),
   templateId: integer('template_id').references(() => basicContractTemplates.id),
   vendorId: integer('vendor_id').references(() => vendors.id),
+  //biddingCompanies fk 추가, nullable
+  biddingCompanyId: integer('bidding_company_id').references(() => biddingCompanies.id),
+  rfqCompanyId: integer('rfq_company_id').references(() => rfqLastDetails.id),
+  generalContractId: integer('general_contract_id').references(() => generalContracts.id),
   requestedBy: integer('requested_by').references(() => users.id),
   
   // 상태값을 더 세분화
@@ -70,6 +78,12 @@ export const basicContractView = pgView('basic_contract_view').as((qb) => {
       vendorId: sql<number | null>`${basicContract.vendorId}`.as('vendor_id'),
       requestedBy: sql<number | null>`${basicContract.requestedBy}`.as('requested_by'),
       status: sql<string>`${basicContract.status}`.as('basic_contract_status'),
+
+      //견적,입찰, 계약
+      rfqCompanyId: sql<number | null>`${basicContract.rfqCompanyId}`.as('rfq_company_id'),
+      biddingCompanyId: sql<number | null>`${basicContract.biddingCompanyId}`.as('bidding_company_id'),
+      generalContractId: sql<number | null>`${basicContract.generalContractId}`.as('general_contract_id'),
+
       
       // 새로 추가된 필드들
       deadline: sql<string | null>`${basicContract.deadline}`.as('deadline'),