diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-05-15 01:34:49 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-05-15 01:34:49 +0000 |
| commit | ed864fa46c7ce0aac2de4c5ba5d311ebfd7e6a88 (patch) | |
| tree | b04695b9c8a4d2b03ed1f44f318fa38d8c490364 /db/schema/vendorDocu.ts | |
| parent | 9beaabc8d1e0ac3a5c54c8202d3c690577bdbd39 (diff) | |
(대표님) 벤더 문서 관련 개발사항
Diffstat (limited to 'db/schema/vendorDocu.ts')
| -rw-r--r-- | db/schema/vendorDocu.ts | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index 1e166e6b..8eb9cbc6 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -13,6 +13,7 @@ export const documents = pgTable( // documentType: varchar("document_type", { length: 50 }).notNull(), + pic: varchar("pic", { length: 50 }), // 어느 계약(Contract) 소속인지 contractId: integer("contract_id") @@ -128,6 +129,7 @@ export const vendorDocumentsView = pgView("vendor_documents_view", { id: integer("id").notNull(), docNumber: varchar("doc_number", { length: 100 }).notNull(), title: varchar("title", { length: 255 }).notNull(), + pic: varchar("pic", { length: 255 }).notNull(), status: varchar("status", { length: 50 }).notNull(), issuedDate: date("issued_date"), @@ -152,6 +154,7 @@ export const vendorDocumentsView = pgView("vendor_documents_view", { d.id, d.doc_number, d.title, + d.pic, d.status, d.issued_date, |