diff options
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}, '')` ), |