Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
3 10
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 6 votes cast
Sep
17
comment Mobile Phone & Tariffs
Description part into columns is a good idea and I will look into that. My question was is the relationship design between phone, tarrif, network and saleType is ok? I assume you understood from my tables design? Basically operator can select a retailer which then select Mobile Network.. then select what type of sale (eg: consumer upgrade) and then select phone with related related tariffs. Depending what tarrifs and/or phone they have selected - operator gets number of points.
Sep
17
asked Mobile Phone & Tariffs
Mar
6
asked Database Design - Employee Clocking In and Out System
Feb
15
comment Generating Invoices and Tracking
I have managed to translate your SQL Server example into MySQL. I went through and I understood very well now. What would AllocationType would be if I want to send client money? Do I need to insert into CashPayment table as well (let say paying them via BACS)?
Feb
15
accepted Generating Invoices and Tracking
Feb
15
revised Generating Invoices and Tracking
deleted 7 characters in body
Feb
15
revised Generating Invoices and Tracking
added 130 characters in body
Feb
15
asked Generating Invoices and Tracking
Feb
13
comment Tick boxes and Dropdown
extra_id's (ketchup, Mayo, etc) already mapped into group (see groups and groups_extras) - so therefore use groups_id to apply in items_options_extras or items_options_extras
Feb
13
accepted Tick boxes and Dropdown
Feb
13
comment Tick boxes and Dropdown
Second question: If multiple items have same options name and if I've rename the option name from the backend (eg: Donner to Donner Special) - I don't want all items that have same Option name to be replaced..
Feb
13
comment Tick boxes and Dropdown
Thanks you very much for detailed response. Just two questions. items_extras and items_options_extras tables you have provided. I think you meant extra_id to be groups_id?
Feb
13
revised Tick boxes and Dropdown
added 152 characters in body
Feb
13
revised Tick boxes and Dropdown
added 3022 characters in body
Feb
13
comment Tick boxes and Dropdown
There is no need for boolean field. Check groups_extras_options result. It apply item to the group's (item to many group's)
Feb
13
comment Tick boxes and Dropdown
Still no reply?!
Feb
12
asked Tick boxes and Dropdown
Dec
21
awarded  Supporter
Dec
21
awarded  Scholar
Dec
21
accepted Improve `Update` performance (rows locking issue)