diff options
Diffstat (limited to 'db')
| -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, |