summaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/schema/S_ERP/s_erp.ts487
1 files changed, 487 insertions, 0 deletions
diff --git a/db/schema/S_ERP/s_erp.ts b/db/schema/S_ERP/s_erp.ts
new file mode 100644
index 00000000..1b24f0e7
--- /dev/null
+++ b/db/schema/S_ERP/s_erp.ts
@@ -0,0 +1,487 @@
+import { serial, varchar, timestamp, text, boolean, numeric, decimal, integer, real } from "drizzle-orm/pg-core";
+import { pgSchema } from "drizzle-orm/pg-core";
+
+export const sErpSchema = pgSchema("S-ERP");
+
+export const tbSAPEquipInfo = sErpSchema.table("TB_SAP_EquipInfo", {
+ id: serial().primaryKey(),
+ Equipment: varchar({ length: 20 }),
+ Description: varchar({ length: 100 }),
+ EquipCategory: varchar({ length: 2 }),
+ SystemStatus: varchar({ length: 10 }),
+ UserStatus: varchar({ length: 10 }),
+ ObjectType: varchar({ length: 10 }),
+ ABCIndicator: varchar({ length: 2 }),
+ PlanningPlant: varchar({ length: 10 }),
+ PlannerGroup: varchar({ length: 10 }),
+ MainWorkCenter: varchar({ length: 10 }),
+ CostCenter: varchar({ length: 10 }),
+ CatalogProfile: varchar({ length: 10 }),
+ FunctionLocation: varchar({ length: 20 }),
+ FunctionLocationDesc: varchar({ length: 100 }),
+ SuperordEquip: varchar({ length: 10 }),
+ COL1: varchar({ length: 10 }),
+ ConstType: varchar({ length: 10 }),
+ AssetNo: varchar({ length: 10 }),
+ TechnivalIdenNo: varchar({ length: 10 }),
+ Class: varchar({ length: 10 }),
+ MaintenancePlant: varchar({ length: 10 }),
+ PlantSection: varchar({ length: 10 }),
+ PlantSectionDescription: varchar({ length: 10 }),
+ ObjectTypeDesc: varchar({ length: 100 }),
+ MainWorkCenterDesc: varchar({ length: 100 }),
+ CostCenterDesc: varchar({ length: 100 }),
+ ObjectNumber: varchar({ length: 30 }),
+ SubAssetNo: varchar({ length: 10 }),
+ AuthorizGroup: varchar({ length: 10 }),
+ Weight: numeric({ precision: 16, scale: 3 }),
+ WeightUnit: varchar({ length: 10 }),
+ SizeDimension: varchar({ length: 20 }),
+ InventoryNumber: varchar({ length: 50 }),
+ StartUpDate: varchar({ length: 10 }),
+ AcquistnValue: decimal({ precision: 19, scale: 4 }), // MONEY 타입을 decimal로 변환
+ AcquistnValueCurr: varchar({ length: 10 }),
+ AcquistionDate: varchar({ length: 10 }),
+ Manufacturer: varchar({ length: 50 }),
+ ModelNumber: varchar({ length: 10 }),
+ ManufPartNo: varchar({ length: 10 }),
+ ManufCountry: varchar({ length: 4 }),
+ ManufSerialNo: varchar({ length: 50 }),
+ ConstrYr: varchar({ length: 4 }),
+ ConstrMth: varchar({ length: 2 }),
+ Location: varchar({ length: 10 }),
+ Room: varchar({ length: 10 }),
+ WorkCenter: varchar({ length: 10 }),
+ PPWorkCenter: varchar({ length: 10 }),
+ PPWorkCenterDesc: varchar({ length: 100 }),
+ SortField: varchar({ length: 10 }),
+ CompanyCode: varchar({ length: 10 }),
+ BusinessArea: varchar({ length: 10 }),
+ WBSElement: varchar({ length: 10 }),
+ MainWorkCtrPlant: varchar({ length: 10 }),
+ Position: varchar({ length: 10 }),
+ FinancialManagementArea: varchar({ length: 10 }),
+ CommitmentItem: varchar({ length: 20 }),
+ SysStatus: varchar({ length: 1 }),
+});
+
+export const tbSAPOrder = sErpSchema.table("TB_SAP_Order", {
+ id: serial().primaryKey(),
+ BreakdownIndicator: varchar({ length: 50 }),
+ Order: varchar({ length: 50 }),
+ OrderType: varchar({ length: 50 }),
+ OrderDescription: varchar({ length: 150 }),
+ MainWorkCenterDesc: varchar({ length: 100 }),
+ FunctionalLocation: varchar({ length: 50 }),
+ Equipment: varchar({ length: 50 }),
+ EquipmentDescriprion: varchar({ length: 100 }),
+ EquipmentSortField: varchar({ length: 50 }),
+ TagNumber: varchar({ length: 50 }),
+ Notification: varchar({ length: 50 }),
+ Priority: varchar({ length: 50 }),
+ PriorityDesc: varchar({ length: 50 }),
+ PlantSection: varchar({ length: 50 }),
+ PMActivityType: varchar({ length: 10 }),
+ MaintenancePlan: varchar({ length: 50 }),
+ StartDate: varchar({ length: 10 }),
+ FinishDate: varchar({ length: 10 }),
+ SystemStatus: varchar({ length: 50 }),
+ UserStatus: varchar({ length: 50 }),
+ CreatedBy: varchar({ length: 50 }),
+ Name: varchar({ length: 50 }),
+ PlanningPlant: varchar({ length: 50 }),
+ PlannerGroupName: varchar({ length: 50 }),
+ MainWorkCenter: varchar({ length: 50 }),
+ MaintenancePlant: varchar({ length: 50 }),
+ PlantSectionDescription: varchar({ length: 50 }),
+ COL1: varchar({ length: 50 }),
+ COL2: varchar({ length: 50 }),
+ BasicStartTime: varchar({ length: 50 }),
+ ActualStartDate: varchar({ length: 50 }),
+ ActualFinishTime: varchar({ length: 50 }),
+ PlanCost: integer(),
+ ActualCost: integer(),
+ SettlementCost: integer(),
+ Balance: integer(),
+ Currency: varchar({ length: 50 }),
+ EquiCategory: varchar({ length: 50 }),
+ ObjectType: varchar({ length: 50 }),
+ ABCOmdocatior: varchar({ length: 50 }),
+ EWRNo: varchar({ length: 50 }),
+});
+
+export const tbSAPOrderConfirm = sErpSchema.table("TB_SAP_OrderConfirm", {
+ id: serial().primaryKey(),
+ Confirmation: varchar({ length: 50 }),
+ Count: varchar({ length: 50 }),
+ Order: varchar({ length: 50 }),
+ OpAc: varchar({ length: 50 }),
+ OperationText: varchar({ length: 200 }),
+ ActualWork: decimal({ precision: 10, scale: 1 }),
+ Unit: varchar({ length: 50 }),
+ CreateOn: varchar({ length: 10 }),
+ CreateBy: varchar({ length: 50 }),
+ ActualWorker: varchar({ length: 50 }),
+ Name: varchar({ length: 50 }),
+ Reversed: varchar({ length: 50 }),
+ CanceledConfirmation: varchar({ length: 50 }),
+ OrderDescription: varchar({ length: 200 }),
+ BUDAT: varchar({ length: 10 }),
+ STATUS: varchar({ length: 10 }),
+ IWERK: varchar({ length: 50 }),
+ INGRP: varchar({ length: 50 }),
+ GRWRK: varchar({ length: 50 }),
+ AUART: varchar({ length: 50 }),
+});
+
+export const tbSAPOrderNotice = sErpSchema.table("TB_SAP_OrderNotice", {
+ id: serial().primaryKey(),
+ Status: varchar({ length: 50 }),
+ Notification: integer(),
+ Type: varchar({ length: 50 }),
+ Description: varchar({ length: 64 }),
+ PlanningPlant: varchar({ length: 50 }),
+ PlannerGroup: varchar({ length: 50 }),
+ NameOfPlannerGroup: varchar({ length: 50 }),
+ WorkCenter: varchar({ length: 50 }),
+ NameOfWorkCenter: varchar({ length: 50 }),
+ FunctionalLocation: varchar({ length: 50 }),
+ Equipment: integer(),
+ TagNumber: varchar({ length: 50 }),
+ EquipmentDesc: varchar({ length: 50 }),
+ PlantSection: varchar({ length: 50 }),
+ CostCenter: varchar({ length: 50 }),
+ CostCenterDesc: varchar({ length: 50 }),
+ ABCIndicator: varchar({ length: 50 }),
+ NotificationDate: varchar({ length: 50 }),
+ Createdby: varchar({ length: 50 }),
+ SystemStatus: varchar({ length: 50 }),
+ UserStatus: varchar({ length: 50 }),
+ Order: integer(),
+ Requester: varchar({ length: 50 }),
+ RequesterName: varchar({ length: 50 }),
+ CodeGroup: varchar({ length: 50 }),
+ Code: integer(),
+ CodeDescription: varchar({ length: 50 }),
+ BreakdownIndicator: varchar({ length: 50 }),
+ Priority: varchar({ length: 50 }),
+ PriorityDesc: varchar({ length: 50 }),
+ NotifcatnType: varchar({ length: 50 }),
+ Name1: varchar({ length: 50 }),
+ WorkCenterInt: integer(),
+ ObjectNumber: varchar({ length: 50 }),
+ CHAR05: varchar({ length: 50 }),
+ Link: varchar({ length: 50 }),
+ Link1: varchar({ length: 50 }),
+ Tooltip: varchar({ length: 50 }),
+ PlantSectionDesc: varchar({ length: 50 }),
+ Catalog: varchar({ length: 50 }),
+ Partner: varchar({ length: 50 }),
+ NotificationTime: varchar({ length: 50 }),
+ CompletionDate: varchar({ length: 50 }),
+ CompletionTime: varchar({ length: 50 }),
+ ExtRequester: varchar({ length: 50 }),
+ COL1: varchar({ length: 50 }), // 일상점검미흡
+ OrderBasicStart: varchar({ length: 50 }),
+ EWRNo: varchar({ length: 50 }),
+ MalfunctionStart: varchar({ length: 50 }),
+ StartTime: varchar({ length: 50 }),
+ MalfunctionEnd: varchar({ length: 50 }),
+ EndTime: varchar({ length: 50 }),
+ BreakdownDuration: real(), // float4 타입을 real로 변환
+});
+
+export const tbSAPOrderBreakdown = sErpSchema.table("TB_SAP_OrderBreakdown", {
+ id: serial().primaryKey(),
+ Order: integer(),
+ OrderType: varchar({ length: 50 }),
+ FunctionalLocation: varchar({ length: 50 }),
+ FLDesc: varchar({ length: 50 }),
+ Equipment: integer(),
+ EquipmentDesc: varchar({ length: 50 }),
+ ABCIndicator: varchar({ length: 50 }),
+ MainWorkCenter: varchar({ length: 50 }),
+ WorkCenterDesc: varchar({ length: 50 }),
+ PlannerGroup: varchar({ length: 50 }),
+ PlannerGroupDesc: varchar({ length: 50 }),
+ ActStartDate: varchar({ length: 50 }),
+ ActEndDate: varchar({ length: 50 }),
+ WorkTimeHR: real(), // float4 타입을 real로 변환
+ ObjectPart: varchar({ length: 50 }),
+ Damage: varchar({ length: 50 }),
+ Cause: varchar({ length: 50 }),
+ Activity: varchar({ length: 50 }),
+ MaterialCost: varchar({ length: 50 }),
+ LaborCost: varchar({ length: 50 }),
+ TotalCost: varchar({ length: 50 }),
+ Currency: varchar({ length: 50 }),
+ Breakdown: varchar({ length: 50 }),
+ MalfunctionStart: varchar({ length: 50 }),
+ StartTime: varchar({ length: 50 }),
+ MalfunctionEnd: varchar({ length: 50 }),
+ EndTime: varchar({ length: 50 }),
+ BreakdownDuration: real(), // float4 타입을 real로 변환
+ Plant: varchar({ length: 50 }),
+ Notification: integer(),
+ ObjectNumber: varchar({ length: 50 }),
+ OrderDesc: varchar({ length: 64 }),
+ PlantSectionDesc: varchar({ length: 50 }),
+ TagNumber: varchar({ length: 50 }),
+});
+
+export const tbSAPMainternanceBOM = sErpSchema.table("TB_SAP_MainternanceBOM", {
+ id: serial().primaryKey(),
+ Date: varchar({ length: 50 }),
+ Order: integer(),
+ Description: varchar({ length: 50 }),
+ FuncLocation: varchar({ length: 50 }),
+ Description_1: varchar({ length: 50 }),
+ WorkCenter: varchar({ length: 50 }),
+ ObjectType: varchar({ length: 50 }),
+ Equipment: integer(),
+ Discription: varchar({ length: 50 }),
+ TagNumber: varchar({ length: 50 }),
+ ICT: varchar({ length: 50 }),
+ Component: varchar({ length: 50 }),
+ Quantity: integer(),
+ Unit: varchar({ length: 50 }),
+ Description_2: varchar({ length: 50 }),
+ Specification: varchar({ length: 50 }),
+ GEWRK: integer(),
+ STLNR: varchar({ length: 50 }),
+ STLAL: varchar({ length: 50 }),
+ WERKS: varchar({ length: 50 }),
+ TPLNR_T: varchar({ length: 50 }),
+ EQUNR_T: integer(),
+});
+
+export const tbSAPMaterialRepair = sErpSchema.table("TB_SAP_MaterialRepair", {
+ id: serial().primaryKey(),
+ BreakdownIndicator: varchar({ length: 50 }),
+ Order: integer(),
+ OrderType: varchar({ length: 50 }),
+ OrderDescription: varchar({ length: 50 }),
+ MainWorkCenterDescription: varchar({ length: 50 }),
+ FunctionalLocation: varchar({ length: 50 }),
+ Equipment: integer(),
+ EquipmentDescription: varchar({ length: 50 }),
+ EquipmentSortField: varchar({ length: 50 }),
+ TagNumber: varchar({ length: 50 }),
+ Notification: integer(),
+ Priority: varchar({ length: 50 }),
+ PriorityDesc: varchar({ length: 50 }),
+ PlantSection: varchar({ length: 50 }),
+ PMActivityType: varchar({ length: 50 }),
+ MaintenancePlan: varchar({ length: 50 }),
+ StartDate: varchar({ length: 50 }),
+ FinishDate: varchar({ length: 50 }),
+ SystemStatus: varchar({ length: 50 }),
+ UserStatus: varchar({ length: 50 }),
+ CreatedBy: varchar({ length: 50 }),
+ Name: varchar({ length: 50 }),
+ PlanningPlant: varchar({ length: 50 }),
+ PlannerGroup: varchar({ length: 50 }),
+ PlannerGroupName: varchar({ length: 50 }),
+ MainWorkCenter: varchar({ length: 50 }),
+ Maintenanceplant: varchar({ length: 50 }),
+ PlantSectionDescription: varchar({ length: 50 }),
+ Priority_1: varchar({ length: 50 }),
+ Priority_2: varchar({ length: 50 }),
+ BasicStartTime: varchar({ length: 50 }),
+ BasicFinishTime: varchar({ length: 50 }),
+ ActualStartDate: varchar({ length: 50 }),
+ ActualStartTime: varchar({ length: 50 }),
+ ActualFinishDate: varchar({ length: 50 }),
+ ActualFinishTIme: varchar({ length: 50 }),
+ PlanCost: varchar({ length: 50 }),
+ ActualCost: varchar({ length: 50 }),
+ SettlementCost: varchar({ length: 50 }),
+ Balance: varchar({ length: 50 }),
+ Currency: varchar({ length: 50 }),
+ EquiCategory: integer(),
+ ObjectType: varchar({ length: 50 }),
+ ABCIndicatior: varchar({ length: 50 }),
+ EWRNo: varchar({ length: 50 }),
+});
+
+export const tbSAPMaterialInfo = sErpSchema.table("TB_SAP_MaterialInfo", {
+ id: serial().primaryKey(),
+ Plnt: varchar({ length: 50 }),
+ Material: varchar({ length: 50 }),
+ Sloc: varchar({ length: 50 }),
+ Bin: varchar({ length: 50 }),
+ MatlGroup: varchar({ length: 50 }),
+ MaterialDescription: varchar({ length: 500 }),
+ MaterialName: varchar({ length: 500 }),
+ Specification: varchar({ length: 500 }),
+ Unrestr: integer(),
+ QualInsp: integer(),
+ Blocked: integer(),
+ Bun: varchar({ length: 50 }),
+ Warehouse: varchar({ length: 50 }),
+ Message: varchar({ length: 500 }),
+});
+
+export const tbSAPMaterialStock = sErpSchema.table("TB_SAP_MaterialStock", {
+ id: serial().primaryKey(),
+ WBS: varchar({ length: 50 }),
+ OldProjec: varchar({ length: 50 }),
+ Material: varchar({ length: 50 }),
+ MaterialD: varchar({ length: 50 }),
+ Specificat: varchar({ length: 50 }),
+ MRPType: varchar({ length: 50 }),
+ Batch: varchar({ length: 50 }),
+ Amount: varchar({ length: 50 }),
+ StorageLo: varchar({ length: 50 }),
+ StorageLo_1: varchar({ length: 50 }),
+ StorageBin: varchar({ length: 50 }),
+ Warehouse: varchar({ length: 50 }),
+ Warehouse_1: varchar({ length: 50 }),
+ MMTNo: varchar({ length: 50 }),
+ TNo: varchar({ length: 50 }),
+ BOXNo: varchar({ length: 50 }),
+ MaterialT: varchar({ length: 50 }),
+ Unrestrict: integer(),
+ QIStock: integer(),
+ BlockedSt: integer(),
+ REMARK: varchar({ length: 50 }),
+ TotalStoc: integer(),
+ Unit: varchar({ length: 50 }),
+ MAP: varchar({ length: 50 }),
+ NetWeight: real(), // float4 타입을 real로 변환
+ TotalWeig: real(), // float4 타입을 real로 변환
+ WeightUni: varchar({ length: 50 }),
+ Individual: varchar({ length: 50 }),
+ SpecialSt: varchar({ length: 50 }),
+ Vendor: varchar({ length: 50 }),
+ VendorDes: varchar({ length: 50 }),
+ MaterialG: varchar({ length: 50 }),
+ Procuremen: varchar({ length: 50 }),
+ PLMID: varchar({ length: 50 }),
+ ValveFitt: varchar({ length: 50 }),
+ BLNo: varchar({ length: 50 }),
+ TAGNO: varchar({ length: 50 }),
+});
+
+export const tbSAPMaterialRelease = sErpSchema.table("TB_SAP_MaterialRelease", {
+ id: serial().primaryKey(),
+ PostingGIdate: varchar({ length: 50 }),
+ Plant: varchar({ length: 50 }),
+ StorageLoc: varchar({ length: 50 }),
+ StockWBS: varchar({ length: 50 }),
+ InputWBS: varchar({ length: 50 }),
+ Material: varchar({ length: 50 }),
+ OldMaterialNumber: varchar({ length: 50 }),
+ MaterialDesc: varchar({ length: 50 }),
+ Spec: varchar({ length: 64 }),
+ Batch: varchar({ length: 50 }),
+ MovementType: varchar({ length: 50 }),
+ Quantity: integer(),
+ BUn: varchar({ length: 50 }),
+ GoodsRecipinet: varchar({ length: 50 }), // Goods Recipinet(Ship-To Party)
+ NetWeight: real(), // float4 타입을 real로 변환
+ GrossWeight: real(), // float4 타입을 real로 변환
+ Unit: varchar({ length: 50 }),
+ Amount: varchar({ length: 50 }),
+ Currency: varchar({ length: 50 }),
+ MvtTypeTxt: varchar({ length: 50 }),
+ MaterialDocument: integer(),
+ DocumentYear: integer(),
+ S: varchar({ length: 50 }),
+ MatName: varchar({ length: 50 }),
+ MatGroupDesc: varchar({ length: 50 }),
+ InputProject: varchar({ length: 50 }),
+ HeaderText: varchar({ length: 50 }),
+});
+
+export const tbSAPMaterialReceiving = sErpSchema.table("TB_SAP_MaterialReceiving", {
+ id: serial().primaryKey(),
+ PostingGRDate: varchar({ length: 50 }),
+ Plant: varchar({ length: 50 }),
+ StorageLoc: varchar({ length: 50 }),
+ StockWBS: varchar({ length: 50 }),
+ InputWBS: varchar({ length: 50 }),
+ Material: varchar({ length: 50 }),
+ OldMaterialNumber: varchar({ length: 50 }),
+ MaterialDesc: varchar({ length: 50 }),
+ Spec: varchar({ length: 50 }),
+ Batch: varchar({ length: 50 }),
+ MovementType: varchar({ length: 50 }),
+ Quantity: integer(),
+ BUn: varchar({ length: 50 }),
+ GoodsRecipinet: varchar({ length: 50 }), // Goods Recipinet(Ship-To Party)
+ PO: varchar({ length: 50 }),
+ POItem: integer(),
+ Vendor: varchar({ length: 50 }),
+ VendorName: varchar({ length: 50 }),
+ NetWeight: real(), // float4 타입을 real로 변환
+ GrossWeight: real(), // float4 타입을 real로 변환
+ Unit: varchar({ length: 50 }),
+ Amount: varchar({ length: 50 }),
+ Currency: varchar({ length: 50 }),
+ MvtTypeTxt: varchar({ length: 50 }),
+ MatDoc: integer(),
+ Year: integer(),
+ S: varchar({ length: 50 }),
+ MatName: varchar({ length: 50 }),
+ MatGroupDesc: varchar({ length: 50 }),
+ InputProject: varchar({ length: 50 }),
+ HeaderText: varchar({ length: 50 }),
+});
+
+export const tbSAPMaterialPurchase = sErpSchema.table("TB_SAP_MaterialPurchase", {
+ id: serial().primaryKey(),
+ Status: varchar({ length: 50 }),
+ Notification: integer(),
+ Type: varchar({ length: 50 }),
+ Description: varchar({ length: 64 }),
+ PlanningPlant: varchar({ length: 50 }),
+ PlannerGroup: varchar({ length: 50 }),
+ NameOfPlannerGroup: varchar({ length: 50 }),
+ WorkCenter: varchar({ length: 50 }),
+ NameOfWorkCenter: varchar({ length: 50 }),
+ FunctionalLocation: varchar({ length: 50 }),
+ Equipment: integer(),
+ TagNumber: varchar({ length: 50 }),
+ EquipmentDesc: varchar({ length: 50 }),
+ PlantSection: varchar({ length: 50 }),
+ CostCenter: varchar({ length: 50 }),
+ CostCenterDesc: varchar({ length: 50 }),
+ ABCIndicator: varchar({ length: 50 }),
+ NotificationDate: varchar({ length: 50 }),
+ CreatedBy: varchar({ length: 50 }),
+ SystemStatus: varchar({ length: 50 }),
+ UserStatus: varchar({ length: 50 }),
+ Order: integer(),
+ Requester: varchar({ length: 50 }),
+ RequesterName: varchar({ length: 50 }),
+ CodeGroup: varchar({ length: 50 }),
+ Code: integer(),
+ CodeDescription: varchar({ length: 50 }),
+ BreakdownIndicator: varchar({ length: 50 }),
+ Priority: varchar({ length: 50 }),
+ PriorityDesc: varchar({ length: 50 }),
+ NotifcatnType: varchar({ length: 50 }),
+ Name1: varchar({ length: 50 }),
+ WorkCenterInt: integer(),
+ ObjectNumber: varchar({ length: 50 }),
+ CHAR05: varchar({ length: 50 }),
+ Link: varchar({ length: 50 }),
+ Link1: varchar({ length: 50 }),
+ Tooltip: varchar({ length: 50 }),
+ PlantSectionDesc: varchar({ length: 50 }),
+ Catalog: varchar({ length: 50 }),
+ Partner: varchar({ length: 50 }),
+ NotificationTime: varchar({ length: 50 }),
+ CompletionDate: varchar({ length: 50 }),
+ CompletionTime: varchar({ length: 50 }),
+ ExtRequester: varchar({ length: 50 }),
+ COL1: varchar({ length: 50 }), // 일상점검미흡
+ OrderBasicStart: varchar({ length: 50 }),
+ EWRNo: varchar({ length: 50 }),
+ MalfunctionStart: varchar({ length: 50 }),
+ StartTime: varchar({ length: 50 }),
+ MalfunctionEnd: varchar({ length: 50 }),
+ EndTime: varchar({ length: 50 }),
+ BreakdownDuration: real(), // float4 타입을 real로 변환
+}); \ No newline at end of file
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-07 13:26:56 +0000