diff options
Diffstat (limited to 'db/schema/users.ts')
| -rw-r--r-- | db/schema/users.ts | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/db/schema/users.ts b/db/schema/users.ts index 0e8809b7..f01db8db 100644 --- a/db/schema/users.ts +++ b/db/schema/users.ts @@ -67,6 +67,9 @@ export const users = pgTable("users", { isDeletedOnNonSap: boolean("is_deleted_on_non_sap"), // 퇴직여부 (SHI-API DEL_YN (Y/N)) isRegularEmployee: boolean("is_regular_employee"), // 정직원여부 (SHI-API REGL_ORORD_GB (S/N)) + // 사용자 코드 (구매그룹코드) + userCode: varchar("user_code", { length: 50 }), + }, (table) => { return { emailIdx: uniqueIndex("users_email_idx").on(table.email), |