Tokyo Sports Facility Service
Laravel history is less than a month.
Based on the "Reservation from date and time of use" system in the above link when creating a product for job hunting after learning authentication and basic CRUD, a detuned usage application (reservation application) web application I'm trying to create a table, but I'm troubled by the definition of the table.
Laravel 6.5.0
Homestead
Database …… MariaDB
The column that was written out as necessary for processing like the activity diagram is the first normalization part at the lower left of the table relationship diagram.
Think about it yourself and feel that the relationship between the user and the facility will be many-to-many, and it is the upper part of the figure that I tried to define it, but understanding the table Add 5 columns to users or facilities in the reservation section, that is, reservation date/time, reservation number issued when applying, application date/time, and update (when application is changed) I thought it would be nice to create a separate table for the relation, or maybe I would like to point out some advice on whether there is a completely different definition.
Because it is a snake, the relationship between users and password_reset remains the default when Auth authentication is introduced.
-
Answer # 1
Related articles
- reflection of table definition in mysql by laravel migration does not work well
- why sql throws incorrect definition of table for mariadb (mysql fork)
- mysql - refer to another table and insert the default value
- mysql - [laravel] how can i make an outer join in a many-to-many table?
- i want to display all records of a specific table in mysql
- mysql data table basic operation table structure operation, field operation example analysis
- mysql - regarding production alter table a add
- Resolve the failure of MySQL table self-increment id overflow
- mysql - about er diagram entity definition document
- mysql, mariadb table creation error
- mysql - message board, comment and tag table design
- mysql - grouped according to the contents of the related table
- Example of importing and exporting MySQL table data
- mysql - [beginner] i want to add columns to a db table created on aws
- is there an sql one-to-one table definition?
- i don't know how to get (column name, data type) in a table with mysql in php
- mysql - common reasons for table partitioning in sql normalization
- Detailed MySQL database optimization table and database operation examples
- MySql table, database, shard and partition knowledge points
- Simple example of MySQL trigger definition and usage
- php - laravel relation cannot be defined
- php - laravel can't access local mysql
- php - regarding when extracting laravel relation defined data
- mysql - "database seeding completed successfully" is displayed using seeder, but it is not inserted in the db
- php - [laravel] cannot save multiple data by selecting multiple check boxes
- reflection of table definition in mysql by laravel migration does not work well
- python - if you delete one of the records, how to delete the records in the other related tables
- php - what is the best way to save balances in mysql?
- php - laravel hypertextcandy tutorial chapter 8 linking userid
- postgresql - i don't know the initial password for postgressql
I think only 3 tables are needed.
(Column names and types are appropriate)
The points are below
No need for user_reservation
If only reservation_time is used, the start time and end time will be unknown, so it will not be possible to search for free time (if there is a limit of one set per day)
reservation_number is unnecessary by using id
Replace time with begin/end and abolish date to make it easier to search for reservations within the desired time zone (and can handle cases that span dates)
Although it is not considered, it is better to have something like a business hours table.