Page 1 of 1
Table of delivery types in store
Posted: Fri Jan 17, 2014 1:12 pm
by bagi
deliveryType
id; INT PRIMARY KEY AUTO_INCREMENT
name; TINYTEXT
description; TEXT
itemId; INT
Users have rights to add custom delivery type, but for default types price must counts automatically. How I can do that? I have an idea to create much one table with itemId column and some BOOL column for storing flag (automatically it counts or no)
Re: Table of delivery types in store
Posted: Fri Jan 17, 2014 1:20 pm
by requinix
What?
If your problem is finding a way to distinguish default versus non-default delivery types then yeah, I'd probably go for a flag field too.
Re: Table of delivery types in store
Posted: Sat Jan 18, 2014 10:35 am
by bagi
delivery
deliveryId; INT
itemId; INT
name; TINYTEXT
description; TEXT
deliveryType
id; INT PRIMARY KEY AUTO_INCREMENT
isAutomaticallyCount; BOOL
Asking for critique. I want to find out type of delivery using deliveryType.id and count a price of delivery
Re: Table of delivery types in store
Posted: Sat Jan 18, 2014 4:50 pm
by Christopher
Seems like it should be like this:
delivery
id; INT
deliveryTypeId; INT
itemId; INT
name; TINYTEXT
description; TEXT
deliveryType
id; INT PRIMARY KEY AUTO_INCREMENT
isAutomaticallyCount; BOOL
So you could: SELECT delivery.*,deliveryType.isAutomaticallyCount FROM delivery JOIN deliveryType ON delivery.deliveryTypeId=deliveryType.id WHERE deliver.id=42