bookstore

type Address struct {
	AddressId    int
	StreetNumber string
	StreetName   string
	City         string
	CountryId    int
}

type AddressStatus struct {
	StatusId      int
	AddressStatus string
}

type Author struct {
	AuthorId   int
	AuthorName string
}

type Book struct {
	BookId          int
	Title           string
	Isbn13          string
	LanguageId      int
	NumPages        int
	PublicationDate time.Time
	PublisherId     int
}

type BookAuthor struct {
	BookId   int
	AuthorId int
}

type BookLanguage struct {
	LanguageId   int
	LanguageCode string
	LanguageName string
}

type Country struct {
	CountryId   int
	CountryName string
}

type CustOrder struct {
	OrderId          int
	OrderDate        time.Time
	CustomerId       int
	ShippingMethodId int
	DestAddressId    int
}

type Customer struct {
	CustomerId int
	FirstName  string
	LastName   string
	Email      string
}

type CustomerAddress struct {
	CustomerId int
	AddressId  int
	StatusId   int
}

type OrderHistory struct {
	HistoryId  int
	OrderId    int
	StatusId   int
	StatusDate time.Time
}

type OrderLine struct {
	LineId  int
	OrderId int
	BookId  int
	Price   pgtype.Numeric
}

type OrderStatus struct {
	StatusId    int
	StatusValue string
}

type Publisher struct {
	PublisherId   int
	PublisherName string
}

type ShippingMethod struct {
	MethodId   int
	MethodName string
	Cost       pgtype.Numeric
}