diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-01 10:31:23 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-10-01 10:31:23 +0000 |
| commit | 74843fe598702a9a55f914f2d2d291368a5abb13 (patch) | |
| tree | a88abdaf039f51dd843e0416321f08877b17ea75 /db/schema | |
| parent | 33e8452331c301430191b3506825ebaf3edac93a (diff) | |
(대표님) dolce 수정, spreadjs 수정 등
Diffstat (limited to 'db/schema')
| -rw-r--r-- | db/schema/vendorDocu.ts | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/db/schema/vendorDocu.ts b/db/schema/vendorDocu.ts index 1c634f64..aa6eb946 100644 --- a/db/schema/vendorDocu.ts +++ b/db/schema/vendorDocu.ts @@ -201,7 +201,8 @@ export const revisions = pgTable( registerId: varchar("register_id", { length: 50 }), - serialNo: varchar("serial_no", { length: 50 }), // 상대 시스템에서 생성한 ID + serialNo: varchar("serial_no", { length: 50 }), + registerSerialNoMax: varchar("register_serial_no_max", { length: 50 }), }, (table) => { @@ -210,6 +211,7 @@ export const revisions = pgTable( table.issueStageId, table.revision, table.usage, + table.serialNo, sql`COALESCE(${table.usageType}, '')` ), |