Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    May 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    http://dba.stackexchange.com/questions/65778/mysql-structure-based-on-date

    I have originally posted my question here on stackexchange

    mysql structure based on date - Database Administrators Stack Exchange

    Any help?

  • #2
    Senior Coder
    Join Date
    Jan 2011
    Location
    Missouri
    Posts
    4,330
    Thanks
    23
    Thanked 616 Times in 615 Posts
    You should have put your problem here instead of a link to it. I quoted it below. It has me asking a bunch of questions.
    He gave me table like this one

    Balance, date - 13.05.2014

    Warehouse: 21 60,000.00

    № Name Quantity Unit (weight) Netto

    1 Chicken (15 kg) 4,000 Box (15 kg.) 60,000.00

    Total: 4,000 60,000.00
    Warehouse: 21 has me asking "will the user have more then 1 warehouse? Is this his twenty-first warehouse or is he allowed to store in this warehouse?
    Chicken (15 kg) ; If that's the weight of a chicken we all should be very afraid. It doesn't belong here.
    Box (15 kg.) ; Are all the boxes he is storing the same weight? I ask this because the total weight has a decimal point and that means tenth of a Kg.
    Can he store boxes of different weight?
    Can he store other things besides chickens? If he had boxes of pigs does he just put them here or can he have another warehouse; if yes you will need a second table.

    The DB is easy to create if we know exactly what information we are storing and what we need from it. What you were given doesn't tell us what we need to know.
    Evolution - The non-random survival of random variants.

    "If you leave hydrogen alone, for long enough, it begins to think about itself."


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •