diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-17 09:08:16 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-17 09:08:16 +0000 |
| commit | f7117370b9cc0c7b96bd1eb23a1b9f5b16cc8ceb (patch) | |
| tree | 4efb0a5ce420b44a402810fc19c35afc92ec5271 /db/schema/MDG/mdg.ts | |
| parent | c54e2acaed641b7ae2c1a7304b08626f9ca973db (diff) | |
| parent | 7433eea5b4bbc0899e255b88e1a7e91f26e9d95b (diff) | |
Merge branch 'dujinkim' of https://github.com/DTS-Development/SHI_EVCP into dujinkim
Diffstat (limited to 'db/schema/MDG/mdg.ts')
| -rw-r--r-- | db/schema/MDG/mdg.ts | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/db/schema/MDG/mdg.ts b/db/schema/MDG/mdg.ts index 7dd2db88..f4f68a20 100644 --- a/db/schema/MDG/mdg.ts +++ b/db/schema/MDG/mdg.ts @@ -1039,8 +1039,9 @@ export const MATERIAL_MASTER_PART_MATL_UNIT = mdgSchema.table('MATERIAL_MASTER_P // [별도 테이블] 자재그룹코드 마스터 - MATKL, MAKTX 중복 최소화 export const MATERIAL_GROUP_MASTER = mdgSchema.table('MATERIAL_GROUP_MASTER', { - MATKL: varchar('MATKL', { length: 1000 }).primaryKey(), // Material Group Code (자재그룹코드) - 기본 키 - MAKTX: varchar('MAKTX', { length: 1000 }), // Material Group Description (자재그룹명) - 영어(SPRAS='E') 기준 + materialGroupCode: varchar('material_group_code', { length: 1000 }).primaryKey(), // Material Group Code (자재그룹코드) - 기본 키 + materialGroupDescription: varchar('material_group_description', { length: 1000 }), // Material Group Description (자재그룹명) - 영어 + materialGroupUom: varchar('material_group_uom', { length: 1000 }), // Material Group UOM (UOM = Unit of Measure) createdAt: timestamp('created_at').defaultNow().notNull(), updatedAt: timestamp('updated_at').defaultNow().notNull(), |