1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
import { nonsapSchema } from './nonsap';
import { varchar } from 'drizzle-orm/pg-core';
export const nonsapUser = nonsapSchema.table('nonsap_user', {
// "USR_ID": "string",
USR_ID: varchar({ length: 255 }).primaryKey(),
// "USR_NM": "string",
USR_NM: varchar({ length: 255 }),
// "USR_ENM": "string",
USR_ENM: varchar({ length: 255 }),
// "EMPNO": "string",
EMPNO: varchar({ length: 255 }),
// "CO_CD": "string",
CO_CD: varchar({ length: 255 }),
// "CO_NM": "string",
CO_NM: varchar({ length: 255 }),
// "DEPTCD": "string",
DEPTCD: varchar({ length: 255 }),
// "DEPTNM": "string",
DEPTNM: varchar({ length: 255 }),
// "MAST_DEPTCD": "string",
MAST_DEPTCD: varchar({ length: 255 }),
// "MAST_DEPTNM": "string",
MAST_DEPTNM: varchar({ length: 255 }),
// "VNDRCD": "string",
VNDRCD: varchar({ length: 255 }),
// "VNDRNM": "string",
VNDRNM: varchar({ length: 255 }),
// "REGL_ORORD_GB": "string",
REGL_ORORD_GB: varchar({ length: 255 }),
// "JG_CD": "string",
JG_CD: varchar({ length: 255 }),
// "JG_NM": "string",
JG_NM: varchar({ length: 255 }),
// "JK_CD": "string",
JK_CD: varchar({ length: 255 }),
// "JK_NM": "string",
JK_NM: varchar({ length: 255 }),
// "EMAIL_ADR": "string",
EMAIL_ADR: varchar({ length: 255 }),
// "TELNO": "string",
TELNO: varchar({ length: 255 }),
// "HP_NO": "string",
HP_NO: varchar({ length: 255 }),
// "ADR": "string",
ADR: varchar({ length: 255 }),
// "MYSNG_ID": "string",
MYSNG_ID: varchar({ length: 255 }),
// "MYSNG_USR_ID": "string", // 별도 고유값
MYSNG_USR_ID: varchar({ length: 255 }),
// "MYSNG_USE_YN": "string",
MYSNG_USE_YN: varchar({ length: 255 }),
// "CHRG_BIZ_NM": "string",
CHRG_BIZ_NM: varchar({ length: 255 }),
// "FIN_PWD_CHG_DTM": "string",
FIN_PWD_CHG_DTM: varchar({ length: 255 }),
// "FIN_LGN_DTM": "string",
FIN_LGN_DTM: varchar({ length: 255 }),
// "FIN_LOGOUT_DTM": "string",
FIN_LOGOUT_DTM: varchar({ length: 255 }),
// "FIN_LGN_FAIL_TMS": "string",
FIN_LGN_FAIL_TMS: varchar({ length: 255 }),
// "FIN_USEIP": "string",
FIN_USEIP: varchar({ length: 255 }),
// "UNLOCK_DTM": "string",
UNLOCK_DTM: varchar({ length: 255 }),
// "LOCK_YN": "string",
LOCK_YN: varchar({ length: 255 }),
// "AGR_YN": "string",
AGR_YN: varchar({ length: 255 }),
// "DEL_YN": "string",
DEL_YN: varchar({ length: 255 }),
// "BIZLOC_GB_CD": "string",
BIZLOC_GB_CD: varchar({ length: 255 }),
// "BIZLOC_GB_NM": "string",
BIZLOC_GB_NM: varchar({ length: 255 }),
// "GRD_NM": "string",
GRD_NM: varchar({ length: 255 }),
// "CH_DEPTCD": "string",
CH_DEPTCD: varchar({ length: 255 }),
// "CH_DEPTNM": "string",
CH_DEPTNM: varchar({ length: 255 }),
// "ORG_OTHER_NAME": "string",
ORG_OTHER_NAME: varchar({ length: 255 }),
// "GRADE_OTHER_NAME": "string",
GRADE_OTHER_NAME: varchar({ length: 255 }),
// "FAX_NO": "string",
FAX_NO: varchar({ length: 255 }),
// "FS_INPR_ID": "string",
FS_INPR_ID: varchar({ length: 255 }),
// "FS_INP_DTM": "string",
FS_INP_DTM: varchar({ length: 255 }),
// "FIN_CHGR_ID": "string",
FIN_CHGR_ID: varchar({ length: 255 }),
// "FIN_CHG_DTM": "string",
FIN_CHG_DTM: varchar({ length: 255 }),
// "LOFF_GB": "string",
LOFF_GB: varchar({ length: 255 }),
// "DEL_DTM": "string",
DEL_DTM: varchar({ length: 255 }),
});
|
