using System.Collections.Generic;
public static void Main()
List<string> tables = new List<string> { "FactoryEnergyConversion",
"StorageLocationDetail_WP",
List<string> columns = new List<string> { "[_id] [nvarchar](50) NOT NULL, [BreakdownMaintenancePersonnel] [nvarchar](MAX) NOT NULL, [BreakdownReason] [nvarchar](50) NOT NULL, [CauseComponent] [nvarchar](200) NOT NULL, [CauseFault] [nvarchar](200) NOT NULL, [DatetimeBegin] [datetime] NOT NULL, [DatetimeEnd] [datetime] NOT NULL, [DatetimeRepair] [datetime] NOT NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [MachineList] [nvarchar](50) NOT NULL, [MaintenanceActivity] [nvarchar](50) NOT NULL, [NOT] [bit] NOT NULL, [NOTDetail] [nvarchar](MAX) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [Shift] [nvarchar](50) NOT NULL, [SystemFault] [nvarchar](200) NOT NULL, [SystemObject] [nvarchar](200) NOT NULL, [WorkOrder] [nvarchar](200) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [BRCat] [nvarchar](50) NOT NULL, [BRDeleted] [bit] NOT NULL, [BRInactive] [bit] NOT NULL, [BRName] [nvarchar](200) NOT NULL, [BRRemarks] [nvarchar](200) NOT NULL, [createdAt] [datetime] NOT NULL, [updatedAt] [datetime] NOT NULL, [BRCreatedAt] [datetime] NOT NULL, [BRCreatedBy] [nvarchar](200) NOT NULL, [BRLastUpdatedAt] [datetime] NOT NULL, [BRLastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Deleted] [bit] NOT NULL, [Details] [nvarchar](MAX) NULL, [Factory] [nvarchar](50) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [Shift] [nvarchar](50) NOT NULL, [Year] [int] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NOT NULL, [LastUpdatedAt] [datetime] NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NOT NULL",
"[_id] [nvarchar](50) NOT NULL, [address1] [nvarchar](200) NOT NULL, [address2] [nvarchar](200) NOT NULL, [address3] [nvarchar](200) NOT NULL, [city] [nvarchar](200) NOT NULL, [country] [int] NOT NULL, [deleted] [bit] NOT NULL, [inactive] [bit] NOT NULL, [name] [nvarchar](200) NULL, [phone] [nvarchar](200) NOT NULL, [remarks] [nvarchar](200) NOT NULL, [startBuyingYear] [datetime] NOT NULL, [state] [nvarchar](200) NOT NULL, [zip] [nvarchar](200) NOT NULL, [createdAt] [datetime] NOT NULL, [createdBy] [nvarchar](200) NOT NULL, [lastUpdatedAt] [datetime] NOT NULL, [lastUpdatedBy] [nvarchar](200) NOT NULL, [__v] [int] NOT NULL",
"[_id] [nvarchar](50) NOT NULL, [deleted] [bit] NOT NULL, [inactive] [bit] NOT NULL, [name] [nvarchar](200) NOT NULL, [remarks] [nvarchar](200) NOT NULL, [createdAt] [datetime] NOT NULL, [createdBy] [nvarchar](200) NULL, [lastUpdatedAt] [datetime] NOT NULL, [lastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Country] [nvarchar](50) NOT NULL, [Deleted] [bit] NOT NULL, [Description] [nvarchar](200) NOT NULL, [Inactive] [bit] NOT NULL, [Lat] [int] NOT NULL, [Long] [int] NOT NULL, [Name] [nvarchar](200) NOT NULL, [Province] [nvarchar](50) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL",
"[_id] [nvarchar](50) NOT NULL, [BlanketQty] [decimal](18, 4) NOT NULL, [Date] [datetime] NOT NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [HSMaster_Detail] [nvarchar](50) NULL, [Remarks] [nvarchar](200) NOT NULL, [RMWetProcess] [nvarchar](50) NULL, [Shift] [nvarchar](50) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Date] [datetime] NOT NULL, [Deleted] [bit] NOT NULL, [DryerBiomass] [decimal](18, 4) NOT NULL, [DryerCoal] [decimal](18, 4) NOT NULL, [DryerFuel] [decimal](18, 4) NOT NULL, [DryerGas] [decimal](18, 4) NOT NULL, [ElectricityDryLine] [decimal](18, 4) NOT NULL, [ElectricityEffluent] [decimal](18, 4) NOT NULL, [ElectricityLaboratory] [decimal](18, 4) NOT NULL, [ElectricityOffice] [decimal](18, 4) NOT NULL, [ElectricityPreclean] [decimal](18, 4) NOT NULL, [ElectricityWaterpump] [decimal](18, 4) NOT NULL, [ElectricityWetLine] [decimal](18, 4) NOT NULL, [ElectricityWorkshop] [decimal](18, 4) NOT NULL, [Factory] [nvarchar](50) NOT NULL, [LightingElectricity] [decimal](18, 4) NOT NULL, [Packing] [decimal](18, 4) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [Shift] [nvarchar](50) NOT NULL, [WarehouseElectricity] [decimal](18, 4) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [CO2Conversion] [decimal](18, 4) NOT NULL, [EnergyConst] [decimal](18, 4) NOT NULL, [EnergyCountry] [nvarchar](50) NOT NULL, [EnergyDeleted] [bit] NOT NULL, [EnergyFuelUnit] [nvarchar](200) NOT NULL, [EnergyGroup] [nvarchar](MAX) NOT NULL, [EnergyInactive] [bit] NOT NULL, [EnergyName] [nvarchar](200) NOT NULL, [EnergyRemarks] [nvarchar](200) NOT NULL, [EnergyCreatedAt] [datetime] NOT NULL, [EnergyCreatedBy] [nvarchar](200) NULL, [EnergyLastUpdatedAt] [datetime] NOT NULL, [EnergyLastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [AccessCode] [nvarchar](200) NOT NULL, [Display_BlanketQty_LabelName] [nvarchar](200) NOT NULL, [Display_PR_RLot] [bit] NOT NULL, [Display_RM_DRC] [bit] NOT NULL, [Display_RM_NetQty] [bit] NOT NULL, [Display_RM_Personal] [bit] NOT NULL, [Display_RM_Personal_LabelName] [nvarchar](200) NOT NULL, [Display_RM_Supplier] [bit] NOT NULL, [Display_SubFactory] [bit] NOT NULL, [FctyAcquisition] [datetime] NOT NULL, [FctyAddr1] [nvarchar](200) NOT NULL, [FctyAddr2] [nvarchar](200) NOT NULL, [FctyAddr3] [nvarchar](200) NOT NULL, [FctyAreaSize] [decimal](18, 4) NOT NULL, [FctyBrch] [nvarchar](50) NOT NULL, [FctyBusinessType] [int] NOT NULL, [FctyCity] [nvarchar](200) NOT NULL, [FctyCode] [nvarchar](200) NOT NULL, [FctyCountry] [nvarchar](50) NOT NULL, [FctyDeleted] [bit] NOT NULL, [FctyEstablished] [datetime] NOT NULL, [FctyInactive] [bit] NOT NULL, [FctyLat] [decimal](18, 4) NULL, [FctyLng] [decimal](18, 4) NULL, [FctyName] [nvarchar](200) NOT NULL, [FctyOffAddr1] [nvarchar](200) NOT NULL, [FctyOffAddr2] [nvarchar](200) NOT NULL, [FctyOffAddr3] [nvarchar](200) NOT NULL, [FctyOffCity] [nvarchar](200) NOT NULL, [FctyOffCountry] [nvarchar](50) NOT NULL, [FctyOffProvince] [nvarchar](50) NULL, [FctyOffState] [nvarchar](200) NULL, [FctyOffZIP] [nvarchar](200) NOT NULL, [FctyProcessType] [int] NOT NULL, [FctyProcessTypeAfterDrying] [int] NOT NULL, [FctyProvince] [nvarchar](50) NULL, [FctyRatedCapacity] [decimal](18, 4) NOT NULL, [FctyRegion] [nvarchar](200) NOT NULL, [FctyRemarks] [nvarchar](200) NOT NULL, [FctyState] [nvarchar](200) NULL, [FctyZIP] [nvarchar](200) NOT NULL, [FctyCreatedAt] [datetime] NOT NULL, [FctyCreatedBy] [nvarchar](200) NULL, [FctyLastUpdatedAt] [datetime] NOT NULL, [FctyLastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Deleted] [bit] NOT NULL, [Details] [nvarchar](MAX) NOT NULL, [Factory] [nvarchar](50) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [Year] [int] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [ConvBiomassType] [nvarchar](50) NOT NULL, [ConvCoalType] [nvarchar](50) NOT NULL, [ConvElectricityType] [nvarchar](50) NOT NULL, [ConvFactory] [nvarchar](50) NULL, [ConvFuelType] [nvarchar](50) NOT NULL, [ConvGasType] [nvarchar](50) NOT NULL, [Deleted] [bit] NOT NULL, [Inactive] [bit] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [BlanketQty] [decimal](18, 4) NOT NULL, [Datetime] [datetime] NOT NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [HSMaster_Detail] [nvarchar](50) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [RMWetProcess] [nvarchar](50) NOT NULL, [Shift] [nvarchar](50) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Capacity] [decimal](18, 4) NOT NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [Format] [nvarchar](200) NOT NULL, [HSNo] [nvarchar](200) NOT NULL, [Inactive] [bit] NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [ClosedRemarks] [nvarchar](200) NOT NULL, [CurrentCapacity] [decimal](18, 4) NOT NULL, [HSMaster] [nvarchar](50) NOT NULL, [LastNumbering] [int] NOT NULL, [NumberRepeat] [int] NOT NULL, [NumberResult] [nvarchar](200) NOT NULL, [Period] [nvarchar](200) NOT NULL, [StatusEmpty] [int] NOT NULL, [StatusFull] [int] NOT NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [MachAbvr] [nvarchar](200) NOT NULL, [MachDeleted] [bit] NOT NULL, [MachDesc] [nvarchar](200) NOT NULL, [MachGrp] [nvarchar](50) NOT NULL, [MachInactive] [bit] NOT NULL, [MachName] [nvarchar](200) NOT NULL, [MachRemarks] [nvarchar](200) NULL, [MachCreatedAt] [datetime] NOT NULL, [MachCreatedBy] [nvarchar](200) NULL, [MachLastUpdatedAt] [datetime] NOT NULL, [MachLastUpdatedBy] [nvarchar](200) NULL",
"[_id] [nvarchar](50) NOT NULL, [MachLstClass] [nvarchar](200) NOT NULL, [MachLstCode] [nvarchar](200) NOT NULL, [MachLstDeleted] [bit] NOT NULL, [MachLstFcty] [nvarchar](50) NOT NULL, [MachLstInactive] [bit] NOT NULL, [MachLstMachine] [nvarchar](50) NOT NULL, [MachLstRemarks] [nvarchar](200) NOT NULL, [MachLstCreatedAt] [datetime] NOT NULL, [MachLstCreatedBy] [nvarchar](200) NULL, [MachLstLastUpdatedAt] [datetime] NOT NULL, [MachLstLastUpdatedBy] [nvarchar](200) NULL",
"[_id] [nvarchar](50) NOT NULL, [Code] [nvarchar](200) NOT NULL, [Deleted] [bit] NOT NULL, [Description] [nvarchar](200) NOT NULL, [Inactive] [bit] NOT NULL, [Name] [nvarchar](200) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NOT NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL",
"[_id] [nvarchar](50) NOT NULL, [Date] [datetime] NOT NULL, [Deleted] [bit] NOT NULL, [DirectOT] [decimal](18, 4) NOT NULL, [DirectRegular] [decimal](18, 4) NOT NULL, [Factory] [nvarchar](50) NOT NULL, [IndirectOT] [decimal](18, 4) NOT NULL, [IndirectRegular] [decimal](18, 4) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [RuntimeDP] [decimal](18, 4) NOT NULL, [RuntimeDryer] [decimal](18, 4) NOT NULL, [RuntimeWetLine] [decimal](18, 4) NOT NULL, [Shift] [nvarchar](50) NOT NULL, [TotalWorkHourOT] [decimal](18, 4) NOT NULL, [TotalWorkHourRegular] [decimal](18, 4) NOT NULL, [WorkHourOT] [decimal](18, 4) NOT NULL, [WorkHourRegular] [decimal](18, 4) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [NCType] [nvarchar](50) NOT NULL, [ProdDetail] [nvarchar](50) NOT NULL, [Quantity] [decimal](18, 4) NULL, [Remarks] [nvarchar](200) NOT NULL, [Status] [int] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [AllocationStatus] [nvarchar](200) NOT NULL, [BuyerLotNo] [nvarchar](200) NULL, [DefaultTestResult] [int] NOT NULL, [Deleted] [bit] NOT NULL, [ExportPallet] [nvarchar](200) NOT NULL, [Factory] [nvarchar](50) NOT NULL, [InActive] [bit] NOT NULL, [Lot] [nvarchar](50) NULL, [PackingType] [nvarchar](50) NOT NULL, [PalletStatus] [nvarchar](200) NOT NULL, [PalletWeight] [decimal](18, 4) NOT NULL, [PrintLabelStatus] [bit] NOT NULL, [PrintQRCodeStatus] [bit] NOT NULL, [ProductGrade] [nvarchar](50) NOT NULL, [ProductionDate] [datetime] NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [SeqPallet] [nvarchar](200) NOT NULL, [ShippingInstruction] [nvarchar](200) NULL, [TestDate] [datetime] NOT NULL, [TestResultStatus] [bit] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NOT NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NOT NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [BatchNo] [nvarchar](200) NOT NULL, [Country] [nvarchar](50) NOT NULL, [Date] [datetime] NOT NULL, [Deleted] [bit] NOT NULL, [District] [nvarchar](50) NOT NULL, [DRC] [decimal](18, 4) NOT NULL, [Factory] [nvarchar](50) NOT NULL, [GrossWeight] [decimal](18, 4) NOT NULL, [Province] [nvarchar](50) NOT NULL, [PurchasingPersonnel] [nvarchar](200) NULL, [Remarks] [nvarchar](200) NOT NULL, [RMGrade] [nvarchar](50) NOT NULL, [StorageLocation] [nvarchar](50) NOT NULL, [SubDistrict] [nvarchar](50) NOT NULL, [Supplier] [nvarchar](200) NULL, [Village] [nvarchar](50) NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Date] [datetime] NOT NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [OutputDry] [decimal](18, 4) NOT NULL, [OutputWetLine] [decimal](18, 4) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [Shift] [nvarchar](50) NOT NULL, [WorkdayType] [int] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Country] [nvarchar](50) NOT NULL, [Deleted] [bit] NOT NULL, [Description] [nvarchar](200) NOT NULL, [Inactive] [bit] NOT NULL, [Lat] [decimal](18, 4) NOT NULL, [Long] [decimal](18, 4) NOT NULL, [Name] [nvarchar](200) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [UpdatedAt] [datetime] NOT NULL, [UpdatedBy] [nvarchar](200) NULL, [LastUpdatedBy] [nvarchar](200) NULL",
"[_id] [nvarchar](50) NOT NULL, [Code] [nvarchar](200) NOT NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [Inactive] [bit] NOT NULL, [Name] [nvarchar](200) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [RMGradeDetail] [nvarchar](MAX) NOT NULL, [RMType] [nvarchar](50) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Changed] [bit] NOT NULL, [Country] [nvarchar](50) NOT NULL, [Deleted] [bit] NOT NULL, [District] [nvarchar](50) NOT NULL, [InActive] [bit] NOT NULL, [Latitute] [decimal](18, 4) NULL, [Longitude] [decimal](18, 4) NULL, [Province] [nvarchar](50) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [SubDistrict] [nvarchar](50) NOT NULL, [Village] [nvarchar](200) NOT NULL, [ZipCode] [int] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NOT NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NOT NULL",
"[_id] [nvarchar](50) NOT NULL, [Closed] [bit] NOT NULL, [ClosedRemarks] [nvarchar](200) NOT NULL, [Date] [datetime] NOT NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [ProcessTime] [datetime] NOT NULL, [RLot] [nvarchar](200) NULL, [SendTo] [nvarchar](MAX) NOT NULL, [Shift] [nvarchar](50) NOT NULL, [WBNo] [nvarchar](200) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [Inactive] [bit] NOT NULL, [Name] [nvarchar](200) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [TimeBegin] [datetime] NOT NULL, [TimeEnd] [datetime] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL",
"[_id] [nvarchar](50) NOT NULL, [AreaSize] [decimal](18, 4) NOT NULL, [Changed] [bit] NOT NULL, [Country] [nvarchar](50) NOT NULL, [Deleted] [bit] NOT NULL, [District] [nvarchar](50) NOT NULL, [Latitute] [decimal](18, 4) NOT NULL, [Longitude] [decimal](18, 4) NOT NULL, [OfIsland] [decimal](18, 4) NOT NULL, [OfVillage] [decimal](18, 4) NOT NULL, [Province] [nvarchar](50) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [SubDistrict] [nvarchar](200) NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL",
"[_id] [nvarchar](50) NOT NULL, [CreatedBy] [nvarchar](200) NULL, [Deleted] [bit] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [Format] [nvarchar](200) NOT NULL, [Inactive] [bit] NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [StorageNo] [nvarchar](200) NOT NULL, [Capacity] [decimal](18, 4) NOT NULL, [CreatedAt] [datetime] NOT NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [GrossQty] [decimal](18, 4) NOT NULL, [RMWetProcess] [nvarchar](50) NOT NULL, [StatusEmpty] [int] NOT NULL, [StatusFull] [int] NOT NULL, [StorageLocation] [nvarchar](50) NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL",
"[_id] [nvarchar](50) NOT NULL, [Date] [datetime] NOT NULL, [Deleted] [bit] NOT NULL, [DischargeRatio] [int] NOT NULL, [EffluentDischarge] [decimal](18, 4) NOT NULL, [EffluentDischargeTo] [int] NOT NULL, [Factory] [nvarchar](50) NOT NULL, [Fresh] [decimal](18, 4) NOT NULL, [Recycle] [decimal](18, 4) NOT NULL, [Remarks] [nvarchar](200) NOT NULL, [Shift] [nvarchar](50) NOT NULL, [WaterConsumptionUsedFor] [nvarchar](MAX) NOT NULL, [WithdrawSource] [int] NOT NULL, [CreatedAt] [datetime] NOT NULL, [CreatedBy] [nvarchar](200) NULL, [LastUpdatedAt] [datetime] NOT NULL, [LastUpdatedBy] [nvarchar](200) NULL, [__v] [int] NULL"
for(var i = 0; i < tables.Count; i++)
var query = string.Empty;
query += "CREATE TABLE [MongoDb].[";
query += " CONSTRAINT [PK__MongoDb__" + i + "]";
query += " PRIMARY KEY CLUSTERED ( [_id] ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]";
if(columns[i].Contains("MAX")) query += " TEXTIMAGE_ON [PRIMARY]";
Console.WriteLine(query);
