dat-relational

group:dat

category = {
	cid:number, name:string, parent:number
	1, 'anything', NULL
2, 'entertainment', 1
3, 'games', 2
4, 'health', 1
5, 'sports', 4
6, 'football', 5
7, 'electronics', 1
8, 'phones', 7
9, 'mobile phones', 8  
}

product = {
	pid:number, name:string, description:string, manufacturer:string, manufacturer_link:string, first_list_date:string, cid:number
	
1, 'Galaxy Note 7', 'Samsung Phon', 'Samsung', 'www.samsung.com/', '10/02/2016 12:00:00', 9
2, 'iPhone 7', 'Apple Phone - 16GB', 'Appl', 'www.apple.com/', '01/01/2016 12:00:00', 9
3, 'Samsung TV', 'Samsung TV', 'Samsung', 'www.samsung.com/', '01/04/2014 12:00:00', 7
4, 'Rubiks Cub', 'Intelligent gam', NULL, NULL, '01/04/1992 12:00:00', 3
5, 'Adidas Football', 'Its a football...', 'Adidas', 'www.adidas.com', '02/20/2000 12:00:00', 6 
6, 'Blackberry Phon', 'very old and antiquated', 'Blackberrry', NULL, '2016-10-02 13:00:00', 9 
}

dealer = {
	did:number, name:string, address:string, payment_opts:string, is_collection_possible, registered_date
1, 'David Cameron', 'NW8 3AX London, UK', 'PayPal', 'true', '01/01/2010 12:00:00'
2, 'Angela Merkel', 'Berlin, Germany', 'Cash', 'true', '01/01/2010 12:00:00'
3, 'Theresa May',   'House of Commons, London, SW1A 0AA', 'Visa', 'true', '01/01/2010 12:00:00'
4, 'Nicola Sarcozy',   NULL , 'MasterCard', 'false', '01/03/2011 15:00:00'
5, 'David Beckham',   'Miami, US' , 'Visa', 'true', '01/03/2011 15:00:00'
}

offer = {
	oid:number, pid:number, did:number, link:string, price:number, offer_date:string, validity_date:string
	1, 1, 1, NULL, 700, '01/03/2011 15:00:00', '01/03/2017 15:00:00'
2, 1, 1, NULL, 500, '01/04/2013 15:00:00', '01/04/2017 15:00:00'
3, 1, 2, NULL, 650, '01/01/2012 15:00:00', '01/01/2017 15:00:00'
4, 1, 3, NULL, 665, '01/01/2012 15:00:00', '01/01/2017 15:00:00'
5, 1, 4, NULL, 880, '01/11/2011 15:00:00', '01/11/2017 15:00:00'
6, 2, 1, NULL, 800, '08/14/2016 15:00:00', '08/14/2017 15:00:00'
7, 2, 2, NULL, 540, '12/24/2016 15:00:00', '12/24/2017 15:00:00'
8, 2, 3, NULL, 330, '11/19/2016 15:00:00', '11/19/2017 15:00:00'
9, 2, 4, NULL, 1500, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
10, 3, 1, NULL, 100, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
11, 3, 1, NULL, 2000, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
12, 3, 2, NULL, 200, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
13, 3, 3, NULL, 350, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
14, 3, 3, NULL, 500, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
15, 3, 4, NULL, 800, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
16, 4, 1, NULL, 10, '08/14/2016 15:00:00', '08/14/2017 15:00:00'
17, 4, 1, NULL, 15, '08/14/2016 15:00:00', '08/14/2017 15:00:00'
18, 4, 2, NULL, 5, '12/24/2016 15:00:00', '12/24/2017 15:00:00'
19, 4, 3, NULL, 30, '11/19/2016 15:00:00', '11/19/2017 15:00:00'
20, 4, 4, NULL, 25, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
21, 4, 5, NULL, 1000, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
22, 5, 1, NULL, 100, '08/14/2016 15:00:00', '08/14/2017 15:00:00'
23, 5, 1, NULL, 150, '08/14/2016 12:00:00', '08/14/2017 12:00:00'
24, 5, 2, NULL, 50, '12/24/2016 10:00:00', '12/24/2017 10:00:00'
25, 5, 2, NULL, 250, '12/24/2016 11:30:00', '12/24/2017 11:30:00'
26, 5, 3, NULL, 300, '11/19/2016 17:50:00', '11/19/2017 17:50:00'
27, 5, 3, NULL, 10, '11/19/2016 05:55:00', '11/19/2017 05:55:00'
28, 5, 4, NULL, 2500, '05/04/2016 12:39:00', '05/04/2017 12:39:00'
29, 5, 4, NULL, 1250, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
30, 5, 5, NULL, 1000, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
31, 5, 5, NULL, 1000, '05/04/2016 15:00:00', '05/04/2017 15:00:00'
}