Database

[Rashmikareddya]

Here is the ER diagram with the changes (Version 2.1)

[Rashmikareddya]

Please mention your requirements, we will test the queries accordingly and push the SQL files. @ShubhraBhuniaGhosh @rishi4rks @pavleen14 @TheForeverLost

[ShubhraBhuniaGhosh]

create table code dedo!!!

[pavleen14]

Requirement as of now, is mainly for MeetingRoom & amenities table(s) from my end.

• for fetching all the meeting room details
• for fetching the credits/cost of each amenity.

[rishikeshshede]

query to check if DB already has data add 'n' number of users at once which I'm fetching and parsing from XML file

[Shalaka2021]

Please add the date field/column separately instead of datetime together, in the meetings table. Start and end time separate and date separate.

[alanpjohn]

Refer https://github.com/TheForeverLost/techyons-code-fury/tree/database/sql folder to get the SQL queries that are added to that branch

if you want to take the code into your own branch then

• fetch the repo
• check out the database branch locally and get it up to date with the remote database
• go back to your own branch and then git rebase from the database branch

or you could do the simpler thing and copy paste the sql queries from github to workbench

[muskansingh11]

user table in which email should be kept unique

[alanpjohn]

Please add the date field/column separately instead of datetime together, in the meetings table. Start and end time separate and date separate.

@Shalaka2021 Will be it be okay if we keep it as DATETIME ?
I don't think it makes any difference if we use 3 columns with [ DATE , TIME , TIME ] or 2 columns with [DATETIME, DATETIME ].

There is one benefit to using [DATETIME , DATETIME] is that if the meeting crosses midnight, we can handle it better

[Shalaka2021]

@TheForeverLost Okay, we can go with this

[Rashmikareddya]

TO DO:

• query to check if DB already has data add 'n' number of users at once
• fetching all the meeting room details
• fetching the credits/cost of each amenity
• user table in which email should be kept unique
• Trigger for update action
• Trigger for last login

[ShubhraBhuniaGhosh]

please mention the database name.
give queries to insert at least 10 values in each table except amenities because its values are mentioned in the project description.

[ShubhraBhuniaGhosh]

if u are calculating total credit
then try to do the same when an edit happens on the meeting room table

[alanpjohn]

This is being transferred to #33