= Логички и физички дизајн == Релациска шема (мапирачка трансформација) * примарни клучеви: bold и underline * Надворешни клучеви: bold и * до името на надворешниот клуч, во заграда табелата кон која покажува == Шема Customer('''__customerId__''', registrationDate, firstName, lastName, email, password, role, phone, address, membershipLevel) Reservation('''__reservationId__''', customerId*(Customer), paymentId*(Payment), menuId*(Menu), tableId*(Table), paymentStatus, partySize, reservationDateTime, specialRequests, status, checkInTime, checkOutTime) Payment('''__paymentId__''', '''__customerId__'''*(Customer), totalPrice, date, reservationNumber) Menu('''__menuId__''', restaurantId*(Restaurant),itemName, category, price, description, dietaryInformation) Restaurant('''__restaurantId__''', name, address, cuisineType, phone, operatingHours, website, socialMediaLinks, rating) Table('''__tableId__''', restaurantId*(Restaurant), capacity, location, isSmokingArea, description)