diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-12-09 03:04:05 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-12-09 03:04:05 +0000 |
| commit | b5c174429548a53e5c86a13bdbfc61516e5ee345 (patch) | |
| tree | 4c3c6102c6e6357c6821446ddfe085bcff2291cf /db | |
| parent | 1ea1dfa5c2684838d37ebfc58e3e8fd98c2dc60b (diff) | |
(최겸) 구매 구매자서명 내 삼성중공업 정보 입력 추가
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema/basicContractDocumnet.ts | 2 | ||||
| -rw-r--r-- | db/schema/pq.ts | 1 |
2 files changed, 3 insertions, 0 deletions
diff --git a/db/schema/basicContractDocumnet.ts b/db/schema/basicContractDocumnet.ts index 5edc9836..7c8d4bc5 100644 --- a/db/schema/basicContractDocumnet.ts +++ b/db/schema/basicContractDocumnet.ts @@ -284,6 +284,8 @@ export type BasicContractTemplateStatsView = typeof basicContractTemplateStatsVi export const buyerSignatures = pgTable('buyer_signatures', { id: integer("id").primaryKey().generatedAlwaysAsIdentity(), name: varchar('name', { length: 255 }).notNull().default('삼성중공업'), + shiAddress: text('shi_address'), + shiCeoName: varchar('shi_ceo_name', { length: 255 }), imageUrl: text('image_url').notNull(), dataUrl: text('data_url'), // Base64 데이터 mimeType: varchar('mime_type', { length: 100 }), diff --git a/db/schema/pq.ts b/db/schema/pq.ts index 68c58613..e273f656 100644 --- a/db/schema/pq.ts +++ b/db/schema/pq.ts @@ -433,6 +433,7 @@ export const vendorInvestigationsView = pgView( // Essential vendor fields vendorName: vendors.vendorName, vendorCode: vendors.vendorCode, + vendorCountry: vendors.country, // PQ 정보 pqItems: vendorPQSubmissions.pqItems, |