class FactResellerSales
    {
        public int ProductKey;
        public int OrderDateKey;
        public int ResellerKey;
        public int EmployeeKey;
        public int PromotionKey;
        public int CurrencyKey;
        public int SalesTerritoryKey;
        public string SalesOrderNumber;
        public byte SalesOrderLineNumber;
        public short OrderQuantity;
        public string CarrierTrackingNumber;
        public string CustomerPONumber;
    }

    class DimProduct
    {
        public int ProductKey;
        public string ProductAlternateKey;
        public string EnglishProductName;
        public string Color;
        public short SafetyStockLevel;
        public short ReorderPoint;
        public string SizeRange;
        public int DaysToManufacture;
        public string StartDate;
    }

    class DimReseller
    {
        public int ResellerKey;
        public string ResellerAlternateKey;
        public string Phone;
        public string BusinessType;
        public string ResellerName;
        public int NumberEmployees;
        public string OrderFrequency;
        public string ProductLine;
        public string AddressLine1;
        public string BankName;
        public int YearOpened;
    }

    class DimCurrency
    {
        public int CurrencyKey;
        public string CurrencyAlternateKey;
        public string CurrencyName;
    }

    class DimPromotion
    {
        public int PromotionKey;
        public int PromotionAlternateKey;
        public string EnglishPromotionName;
        public string EnglishPromotionType;
        public string EnglishPromotionCategory;
        public string StartDate;
        public string EndDate;
        public int MinQty;
    }

    class DimSalesTerritory
    {
        public int SalesTerritoryKey;
        public int SalesTerritoryAlternateKey;
        public string SalesTerritoryRegion;
        public string SalesTerritoryCountry;
        public string SalesTerritoryGroup;
    }

    class DimEmployee
    {
        public int EmployeeKey;
        public string FirstName;
        public string LastName;
        public string Title;
        public string BirthDate;
        public string LoginID;
        public string EmailAddress;
        public string Phone;
        public string MaritalStatus;
        public string Gender;
        public byte PayFrequency;
        public short VacationHours;
        public short SickLeaveHours;
        public string DepartmentName;
        public string StartDate;
    }

    class DimDate
    {
        public int DateKey;
        public string FullDateAlternateKey;
        public byte DayNumberOfWeek;
        public string EnglishDayNameOfWeek;
        public byte DayNumberOfMonth;
        public short DayNumberOfYear;
        public byte WeekNumberOfYear;
        public string EnglishMonthName;
        public byte MonthNumberOfYear;
        public byte CalendarQuarter;
        public short CalendarYear;
        public byte CalendarSemester;
        public byte FiscalQuarter;
        public short FiscalYear;
        public byte FiscalSemester;
    }