diff options
Diffstat (limited to 'db/schema/vendorDocu.ts')
| -rw-r--r-- | db/schema/vendorDocu.ts | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index 789f2cd7..b7136a5c 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -194,7 +194,9 @@ export const revisions = pgTable( createdAt: timestamp("created_at").defaultNow().notNull(), updatedAt: timestamp("updated_at").defaultNow().notNull(), - registerId: varchar("register_id", { length: 50 }), // 상대 시스템에서 생성한 ID + registerId: varchar("register_id", { length: 50 }), + + serialNo: varchar("serial_no", { length: 50 }), // 상대 시스템에서 생성한 ID }, (table) => { @@ -888,6 +890,7 @@ export const simplifiedDocumentsView = pgView("simplified_documents_view", { reviewerId: number | null; reviewerName: string | null; reviewComments: string | null; + serialNo: string | null; createdAt: Date; updatedAt: Date; attachments: Array<{ @@ -959,6 +962,7 @@ export const simplifiedDocumentsView = pgView("simplified_documents_view", { 'rejectedDate', r.rejected_date, 'reviewerId', r.reviewer_id, 'reviewerName', r.reviewer_name, + 'serialNo', r.serial_no, 'reviewComments', r.review_comments, 'createdAt', r.created_at, 'updatedAt', r.updated_at, |