Changes between Version 2 and Version 3 of ER-Diagram

Timestamp:

12/29/24 18:41:31 (2 weeks ago)

Author:

173067

Comment:

--

ER-Diagram

@@ -15 +15 @@
    - Password - varchar
    - Phone number - varchar
-   - DateJoined - datetime
+   - Date Joined - datetime
 
 **2. Flight** - Ентитет за лет.\\
 
    - FlightID - примарен клуч, int
-   - FlightNumber - varchar
-   - DepartureAirport - varchar
-   - ArrivalAirport - varchar
-   - DepartureTime - datetime
-   - ArrivalTime - datetime
+   - Flight Number - varchar
+   - Departure Airport - varchar
+   - Arrival Airport - varchar
+   - Departure Time - datetime
+   - Arrival Time - datetime
    - Duration - time
    - Price - decimal(10,2)
-   - AvailableSeats - int \\
+   - Available Seats - int \\
 
 **3. Booking** - Ентитет за листата на резервирани летови за корисникот.\\
@@ -34 +34 @@
    - UserID - foreign key, int
    - FlightID - foreign key, int
-   - BookingDate - datetime
-   - PaymentStatus - enum('Pending','Completed', 'Cancelled')
-   - TotalCost - decimal(10,2)
-   - SeatNumber - int\\
+   - Booking Date - datetime
+   - Payment Status - enum('Pending','Completed', 'Cancelled')
+   - Total Cost - decimal(10,2)
+   - Seat Number - int\\
 
 **4. Destination** - Ентитет за дестинација.\\
@@ -45 +45 @@
    - Country - varchar 
    - Description - text
-   - PopularAttraction - text 
-   - BestTimeToVisit - varchar\\
+   - Popular Attraction - text 
+   - Best Time To Visit - varchar\\
 
 
@@ -54 +54 @@
    - UserID - foreign key, int,
    - TargetID - foreign key, int (може да биде FlightID или DestinationID)
-   - ReviewComment - text
+   - Review Comment - text
    - Rating - decimal(2,1)
    - Date - datetime
@@ -73 +73 @@
    - Payment method - enum('Credit Card','Debit card', 'PayPal')
    - Amount - decimal(10,2)
-   - TransactionDate - datetime
-   - PaymentStatus - enum('Success', 'Failed', 'Processing')\\
+   - Transaction Date - datetime
+   - Payment Status - enum('Success', 'Failed', 'Processing')\\
 
 **8. Notification** - Ентитет за известувања.\\
@@ -82 +82 @@
    - Message - text
    - Type - enum('Booking Confirmation', 'Flight Delay', 'General Update')
-   - DateSent - datetime\\
+   - Date Sent - datetime\\
 
 **9. Wishlist** - Ентитет за листа со посакувани дестинации.\\
@@ -89 +89 @@
    - UserID - foreign key, int
    - TargetID - foreign key, int (може да биде FlightID или DestinationID)
-   - DateAdded - datetime \\
+   - Date Added - datetime \\
 
 
@@ -97 +97 @@
 
 
-**11. SupportTicket** - Ентитет за тикети за поддршка.\\
+**11. Support Ticket** - Ентитет за тикети за поддршка.\\
 
    - TicketID- примарен клуч, int
@@ -104 +104 @@
    - Description - text
    - Status - enum('Open', 'In Progress', 'Resolved')
-   - DateCreated - datetime
-   - DateResolved - datetime (nullable)
-   - AssignedTo - foreign key, int\\
+   - Date Created - datetime
+   - Date Resolved - datetime (nullable)
+   - Assigned To - foreign key, int\\