Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v guestres address
* id : int(11)
* customer_id : int(10)
* address_type : varchar(5)
* value1 : varchar(50)
* value2 : varchar(50)
* value3 : varchar(50)
* value4 : varchar(50)
* postal_code : varchar(50)
v guestres communication
* id : int(50)
* type : varchar(50)
* body : varchar(200)
* subject : varchar(50)
* reservation_type : int(10)
v guestres correspondence
* id : int(10)
* Customer_ID : int(10)
* RoomTrans_ID : int(10)
* Trans_ID : int(10)
* Doctype_ID : int(10)
* DocDescription : varchar(200)
* DocFileName : varchar(100)
* Employee_ID : int(25)
* CreateDateTime : date
v guestres customernotes
* id : int(10)
* Customer_ID : int(10)
* NoteType_ID : int(10)
* CreateDateTime : varchar(15)
* Employee_ID : int(10)
* RecurrenceType_ID : int(10)
* RecurrenceMonth : int(10)
* RecurrenceDay : int(10)
* DiaryDate : varchar(25)
v guestres customers
* id : int(10)
* created_date : varchar(25)
* CreatedBy : int(10)
* Surname : varchar(50)
* Initials : varchar(50)
* Title : varchar(10)
* AKA : varchar(50)
* Country_Code_C : varchar(25)
* Country_Code_W : varchar(25)
* Tel_H : int(15)
* Tel_W : varchar(15)
* Tel_C : int(15)
* EMail : varchar(50)
* GeneralNotes : varchar(150)
* DOB : varchar(25)
* RecMailYN : varchar(5)
* RecSMSYN : varchar(5)
* CustClass_ID : varchar(14)
* CCNumber : varchar(30)
* CCSecurityCode : varchar(16)
* CCCardHolder : varchar(50)
* CCExpiryDate : varchar(25)
* CCCartType_ID : varchar(25)
* Fax : varchar(25)
* EMail2 : varchar(30)
* InvoiceName : varchar(150)
* InvoiceRegNo : varchar(150)
* InvoiceAddress1 : varchar(100)
* InvoiceAddress2 : varchar(50)
* InvoiceAddress3 : varchar(25)
* InvoiceAddress4 : varchar(25)
* Address_Type : varchar(5)
* Newsletter : int(11)
v guestres diarynotes
* id : int(10)
* DiaryentryType_ID : int(10)
* CreateDateTime : varchar(25)
* Employee_ID : int(10)
* Customer_ID : int(10)
* Recipient_ID : int(10)
* RecurrenceType_ID : int(10)
* RecurrenceMonth_ID : int(10)
* RecurrenceDay_ID : int(10)
* PostDateTime : varchar(25)
* DiaryStatus_ID : int(10)
* Note : varchar(200)
* Subject : varchar(25)
v guestres eventsdiary
* id : int(10)
* EventType_ID : int(10)
* EventDescription : varchar(150)
* EventHost : varchar(150)
* EventGuestHost : varchar(50)
* Booking_ID : int(10)
* SalesRep_ID : int(10)
* CreateDateTime : varchar(25)
* StartDateTime : varchar(25)
* EndDateTime : varchar(25)
* Room_ID : int(10)
* GuestCostPP : decimal(10,0)
* HostingCostPP : decimal(10,0)
* TotalHostingCost : decimal(10,0)
* TotalOtherCost : decimal(10,0)
* TotalAccomodationCost : decimal(10,0)
* EventStatus_ID : int(10)
* ExpectedGuests : int(10)
* Note : varchar(150)
v guestres images
* id : int(10)
* filename : varchar(150)
v guestres l_amenities
* id : int(10)
* description : varchar(100)
v guestres l_area
* id : int(11)
* Area : varchar(50)
* AreaType_ID : int(10)
v guestres l_cccardtype
* id : int(10)
* CardType : varchar(15)
v guestres l_correspondencetype
* id : int(10)
* CorrespondenceType : varchar(20)
v guestres l_currencyex
* id : int(10)
* Currency : varchar(10)
* BuyRate : decimal(10,0)
* SellRate : decimal(10,0)
v guestres l_diaryday
* id : int(11)
* DiaryDay : int(10)
v guestres l_diaryentrytype
* id : int(10)
* DiaryEntryType : varchar(15)
v guestres l_diarymonth
* id : int(10)
* DiaryMonth : varchar(20)
v guestres l_diarystatus
* id : int(10)
* DiaryStatus : varchar(25)
v guestres l_eventstatus
* id : int(10)
* EventStatus : varchar(20)
v guestres l_eventtype
* id : int(10)
* EventType : varchar(25)
v guestres l_methodofpayment
* id : int(10)
* MethodOfPayment : varchar(30)
* DefaultStatus_ID : int(10)
v guestres l_occasion
* id : int(10)
* occasion : varchar(25)
v guestres l_options
* id : int(10)
* Product_ID : int(10)
* Option : varchar(25)
* DisplayOrder : int(10)
v guestres l_optionselect
* id : int(10)
* Option_ID : int(10)
* Selection : varchar(25)
* AddPrepSeconds : int(10)
* AddCost : decimal(10,0)
* DisplayOrder : int(10)
v guestres l_paymentstatus
* id : int(1)
* PaymentStatus : varchar(25)
v guestres l_pos
* id : int(10)
* PointOfSale : varchar(25)
v guestres l_prepstation
* id : int(10)
* PrepStation : varchar(25)
v guestres l_prepstatus
* id : int(10)
* PrepStatus : varchar(20)
v guestres l_proddepartment
* id : int(10)
* ProductType_ID : int(10)
* ProductDepartment : varchar(50)
v guestres l_products
* id : int(10)
* ProductType_ID : int(10)
* Description : varchar(150)
* Unit : varchar(10)
* UnitPrice : decimal(30,0)
* AvailableYN : varchar(5)
* PrepStation_ID : int(10)
* PrepSeconds : int(10)
* QtyOnHand : decimal(30,0)
* QtyOnOrder : decimal(30,0)
v guestres l_producttype
* id : int(10)
* ProductType : varchar(25)
* tva : decimal(10,0)
v guestres l_recurrencetype
* id : int(10)
* RecurrenceType : varchar(10)
v guestres l_room
* id : int(10)
* room : varchar(25)
v guestres l_servsessions
* id : int(10)
* Session : varchar(25)
* StartTime : varchar(25)
* EndTime : varchar(25)
v guestres l_sessions
* id : int(10)
* session : varchar(25)
v guestres l_stockadjuststatus
* id : int(10)
* StockAdjustStatus : varchar(25)
v guestres l_stockadjusttype
* id : int(1)
* StockAdjustType : varchar(15)
v guestres l_tables
* id : int(10)
* Area_ID : int(1)
* TableDescription : varchar(50)
* TableType_ID : int(10)
* Status_ID : int(10)
* DailyRate : decimal(10,0)
* Heads : int(10)
* SpecialDailyRate : decimal(10,0)
* SpecialStartDate : varchar(25)
* SpecialDurationDays : int(10)
* Tva : decimal(10,0)
* Filename : varchar(50)
* RoomHeadDesc : varchar(100)
* RoomFullDesc : varchar(500)
* RoomSizeDesc : varchar(100)
* RoomBedDesc : varchar(150)
v guestres l_tabletype
* id : int(10)
* TableType : varchar(50)
v guestres l_tax
* id : int(10)
* name : varchar(25)
* tax : varchar(10)
v guestres l_transactionstatus
* id : int(10)
* TransactionStatus : varchar(15)
v guestres l_transactiontype
* id : int(10)
* TransactionType : varchar(20)
v guestres l_visit_type
* id : int(10)
* visit_type : varchar(25)
v guestres l_waiter
* id : int(10)
* Waiter : varchar(50)
* ActiveYN : int(10)
* EmploymentStartDate : varchar(25)
* EmploymentEndDate : varchar(25)
* EmployeeType_ID : int(10)
* EmpWord : varchar(25)
v guestres notification
* id : int(10)
* user_id : int(10)
* notes : varchar(150)
* date_created : varchar(20)
* status : int(10)
* type : varchar(15)
* page : varchar(25)
* createdBy : int(10)
v guestres other
* id : int(25)
* room_trans_id : int(10)
* customer_id : int(25)
* description : varchar(50)
* price : decimal(10,0)
* roomname : varchar(25)
* other_trans_id : int(10)
* nights : int(11)
* firstnight : varchar(15)
* lastnight : varchar(15)
v guestres payments
* id : int(10)
* create_date : varchar(50)
* room_trans_id : int(10)
* customer_id : int(10)
* payment_method : varchar(150)
* payment_ref : varchar(25)
* amount_due : decimal(10,0)
* amount_paid : decimal(10,0)
* change : decimal(10,0)
* notes : varchar(25)
* status : decimal(10,0)
v guestres productorder
* id : int(10)
* create_date : varchar(25)
* room_trans_id : int(10)
* customer_id : int(10)
* product_id : int(25)
* qty : int(11)
* price : decimal(10,0)
* total : decimal(10,0)
* status : varchar(20)
* Notes : varchar(100)
v guestres roomamenity
* id : int(50)
* room_id : int(50)
* amenity_id : int(10)
v guestres roomimages
* id : int(50)
* room_id : int(50)
* filename : varchar(100)
* main : varchar(10)
* map : varchar(10)
v guestres roompayments
* id : int(10)
* RoomTrans_ID : int(10)
* POS_ID : int(10)
* PaymentDateTime : varchar(10)
* MethodOfPayment_ID : int(10)
* PaymentStatus_ID : int(10)
* PaymentReference : varchar(50)
* ZARAmountDue : decimal(10,0)
* TenderAmount : decimal(10,0)
* Currency_ID : int(10)
* CurrencyBuyRate : decimal(10,0)
* PaymentAmount : decimal(10,0)
* ChangeAmount : decimal(10,0)
* Employee_ID : int(10)
* PaymentDescription : varchar(50)
v guestres roomstock
* id : int(10)
* Room_ID : int(10)
* Product_ID : int(10)
* ReqQTY : int(10)
* OnHandQTY : int(10)
* OrderQTY : int(10)
v guestres roomtransactions
* id : int(11)
* Room_ID : int(11)
* Customer_ID : int(11)
* BookingDateTime : varchar(50)
* Status_ID : int(11)
* FirstNight : varchar(15)
* LastNight : varchar(15)
* Nights : int(11)
* SessionTime : varchar(25)
* SessionDesc : varchar(25)
* AccommodationTotal : decimal(10,0)
* OtherTotal : decimal(10,0)
* GrandTotal : decimal(10,0)
* PaidTotal : decimal(10,0)
* AlarmYN : varchar(10)
* AlarmTime : varchar(10)
* DailyRate : decimal(10,0)
* Notes : varchar(150)
* Complaints : varchar(150)
* SalesRep_ID : int(11)
* Booking_ID : int(11)
* Cancel_ID : int(11)
* CancelReason_ID : int(11)
* CancelDate : varchar(10)
* StandardDailyRate : decimal(15,0)
* PriceIncludes : varchar(150)
* ReferredBy : varchar(50)
* Pax : int(11)
* SoldBy : varchar(10)
* Identifier : varchar(25)
* CreatedBy : varchar(25)
* Occasion_ID : int(11)
* Session_ID : int(11)
* Period : varchar(200)
* Customer_ID2 : int(100)
v guestres sessionslot
* id : int(10)
* session_id : int(10)
* slot : varchar(25)
v guestres stockadjust
* id : int(10)
* AdjustDateTime : varchar(25)
* Employee_ID : int(10)
* AdjustType_ID : int(10)
* StockAdjustStatus_ID : int(10)
v guestres stockadjustdetail
* id : int(10)
* StockAdjust_ID : int(10)
* Product_ID : int(10)
* InputQTY : int(10)
* QTYOnHand : int(10)
* Adjustment : int(10)
v guestres transactiondetails
* id : int(10)
* Transaction_ID : int(10)
* CreateDateTime : varchar(10)
* SeatIdentification : int(10)
* Product_ID : int(11)
* ProductDescription : varchar(25)
* PrepGroup_ID : int(10)
* NoteToCheff : varchar(150)
* PrepStatus_ID : int(10)
* PrepStation_ID : int(11)
* PrepSeconds : int(10)
* SubUnitCost : decimal(10,0)
* ChargeQTY : decimal(10,0)
* SubCost : decimal(10,0)
* SubOptionalCost : decimal(10,0)
* SubTotal : decimal(10,0)
* PrepStartTime : varchar(25)
v guestres transactions
* id : int(10)
* TransactionType_ID : int(10)
* BookingDateTime : varchar(10)
* AppointmentDateTime : varchar(10)
* Table_ID : int(10)
* Identifier : varchar(15)
* Opperator_ID : int(10)
* Waiter_ID : int(10)
* Status_ID : int(10)
* TotalBaseCost : decimal(10,0)
* TotalOptionalCost : decimal(10,0)
* TotalPrepMinutes : int(10)
* RoomTransaction_ID : int(11)
* Customer_ID : int(10)
* Pax : int(10)
* Gratuity : decimal(10,0)
* TotalDue : decimal(10,0)
* TotalPaid : decimal(10,0)
* SalesRep_ID : int(10)
* Booking_ID : int(10)
* Cancel_ID : int(10)
* CancelReason_ID : int(10)
* CancelDate : varchar(50)
* Note : varchar(50)
* ReferredBy : varchar(50)
* Event_ID : int(10)
* Session_ID : int(10)
v guestres user
* id : int(10)
* name : varchar(25)
* surname : varchar(25)
* email : varchar(25)
* username : varchar(50)
* password : varchar(25)
* dateCreated : varchar(25)
* role : varchar(50)
* active : int(10)
v guestres useractivity
* id : int(10)
* user_id : varchar(25)
* loginTime : varchar(25)
* logoutTime : varchar(25)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship