entity

type Customer struct {
	CustomerNumber         int         `json:"customerNumber"`
	CustomerName           string      `json:"customerName"`
	ContactLastName        string      `json:"contactLastName"`
	ContactFirstName       string      `json:"contactFirstName"`
	Phone                  string      `json:"phone"`
	AddressLine1           string      `json:"adressLine1"`
	AddressLine2           null.String `json:"adressLine2"`
	City                   string      `json:"city"`
	State                  null.String `json:"state"`
	PostalCode             null.String `json:"postalCode"`
	Country                string      `json:"country"`
	SalesRepEmployeeNumber null.Int    `json:"salesRepEmployeeNumber"`
	CreditLimit            null.Float  `json:"creditLimit"`
	Order                  null.String `json:"orders"`
	Product                null.String `json:"products"`
	NumberProduct          null.Int    `json:"numberProducts"`
	TotalPrice             null.Float  `json:"totalPrice"`
}

type Employee struct {
	EmployeeNumber     int64    `json:"employeeNumber"`
	EmployeeLastName   string   `json:"lastName"`
	EmployeeFirstName  string   `json:"firstName"`
	EmployeeExtension  string   `json:"extension"`
	EmployeeEmail      string   `json:"email"`
	EmployeeOfficeCode string   `json:"officeCode"`
	EmployeeReportTo   null.Int `json:"reportsTo"`
	EmployeeJobTitle   string   `json:"jobTitle"`
}

type Office struct {
	OfficeCode   string      `json:"officeCode"`
	City         string      `json:"city"`
	Phone        string      `json:"phone"`
	AddressLine1 string      `json:"addressLine1"`
	AddressLine2 null.String `json:"addressLine2"`
	State        null.String `json:"state"`
	Country      string      `json:"country"`
	PostalCode   string      `json:"postalCode"`
	Territory    string      `json:"territory"`
	Employee     null.String `json:"employees"`
}

type Product struct {
	ProductCode        string  `json:"productCode"`
	ProductName        string  `json:"productName"`
	ProductLine        string  `json:"productLine"`
	ProductScale       string  `json:"productScale"`
	ProductVendor      string  `json:"productVendor"`
	ProductDescription string  `json:"productDescription"`
	QuantityInStock    int     `json:"quantityInStock"`
	BuyPrice           float64 `json:"buyPrice"`
	MSRP               float32 `json:"MSRP"`
}