Search code examples
phpmysqldatabase-designnormalization

Mysql : should i put my data into 1 table or split per user?

This data is for a holiday cottage's simple accommodation calendars. The data is simple and stores dates when each cottage is booked.

The cols would be cottage_id, booked_from_date, booked_until_date and I would expect around 60 rows per user per year * 200-300 users.

I should put this is one table right?

Solution

  • COTTAGE


    cottage_id,
    address?,
    other info...

    USER

    user_id,
    name,
    other info...

    COTTAGE_RESERVATION

    cottage_id,
    user_id,
    from_date,
    to_date