markpjohnson
3/7/2017 - 5:12 PM

Data Models

Data Models

class UserProfile
{
	public int UserId { get; set; }
	public string Username { get; set; }
	public string Email { get; set; }
	public DateTime Created { get; set; }
}

abstract class Restaurant
{
	public int RestaurantId { get; set; }
	public string RestaurantType { get; set; }
	public string Address { get; set; }
	public string Name { get; set; }
	public string Description { get; set; }
	public double Longitude { get; set; }
	public double Latitude { get; set; }
	public DateTime Created { get; set; }
}

class Brewery : Restaurant
{
	public List<Beer> Beers { get; set; }
}

class Beer
{
	public int BeerId { get; set; }
	public string Name { get; set; }
	public string Type { get; set; }
	public double ABV { get; set; }
	public DateTime Created { get; set; }
}

class Pizza
{
	public int PizzaId { get; set; }
	public string Name { get; set; }
	public string Description { get; set; }
	public DateTime Created { get; set; }
}

class Pairing
{
	public int PairingId { get; set; } // ?
	public int BeerId { get; set; }
	public int PizzaId { get; set; }
	public string Description { get; set; }
	public DateTime Created { get; set; }
}

class Review
{
	public int ReviewId { get; set; }
	public int RestaurantId { get; set; }
	public int UserId { get; set; }
	public string Description { get; set; }
	public int Rating { get; set; }
	public DateTime Created { get; set; }
}

class Photo
{
	public int PhotoId { get; set; }
	public int RestaurantId { get; set; }
	public int UserId { get; set; }
	public string Url { get; set; }
	public string Description { get; set; }
	public DateTime Created { get; set; }
}