SQL Real state DB 12/2019 (Landords and tenants info, addresses, mails, etc...)

[Pastral]

15:09:29.325+00 2018-04-03 15:09:29.325+00 2019-01-22 16:45:54.269+00
Вообщем я не знаю за чем, но мне кажется это тут нужно.

23cfc70-3751-11e8-bb30-77efa766953a djerboua+muckmuse_doom_1522768169809@gmail.com 01fa0000-3751-11e8-b945-812d73924457 023a3d50-3751-11e8-bb30-77efa766953a t {"city": "5434", "email": "djerboua+muckmuse_doom_1522768169809@gmail.com", "number": "423423", "street": "342342", "country": "423423", "hasPets": {"checked": true}, "zipCode": "65645", "currency": "EUR", "language": "de-DE", "lastName": "Doom", "birthDate": "1978-02-26T11:00:00.000Z", "firstName": "Muckmuse", "occupation": "423423", "wasEvicted": {"checked": false}, "phoneNumber": "8382379423", "tenantSince": "4324675", "employerName": "8787686", "placeOfBirth": "test", "hadRentIssues": {"checked": false}, "signatureData": {"date": "2018-02-26T21:14:58.328Z", "signature": "g=="}, "hadForeclosure": {"checked": false}, "isIncomeEnough": {"checked": true}, "cellPhoneNumber": "48234239472398", "employerAddress": "645645", "isAnyoneSmoking": false, "desiredStartDate": "2018-02-28T11:00:00.000Z", "employmentPeriod": "312", "householdPersons": {"count": 1}, "netMonthlyIncome": 3263, "hasFiledBankruptcy": {"checked": false}, "otherIncomeSources": "432432", "limitedOrUnlimitedContract": "654654"} 2018-04-03

8-ef5aca069114", "resourcePath": "listing/f27eb2e1-3bb4-4c8a-ae18-220ce4368f06/form-data/8629f6f0-8022-11e7-a298-056baa3506ad/8a9f0ab0-802a-11e7-aaa8-ef5aca069114"}]}, "notificationStatuses": {"hasReceivedStep2InviteEmail": true, "hasReceivedStep2InvitationFromAdmin": false}, "hasPendingInformation": false, "isInterestedInContract": true}, "companyId": "341de250-2fd6-11e7-9e51-ff0020488d44", "createdAt": "2017-08-15T12:11:31.161Z", "deletedAt": null, "updatedAt": "2017-08-15T12:11:31.161Z", "contractId": "c1684f50-81b2-11e7-9bd7-73c41db9a373", "candidateId": "7b4dddb0-80c6-11e7-9a37-1deaaf9bde29"}, "floorNo": 3, "ownerId": "152ddae0-33ea-11e7-9072-cf60936ef67c", "surface": 90, "objectId": "44-5554", "createdAt": "2017-05-11T09:38:48.222Z", "deletedAt": null, "updatedAt": "2017-05-11T09:38:48.222Z", "mainStorage": false, "livingSurface": 85} 2017-05-11 09:38:48.222+00 2018-12-20 10:01:37.6+00 \N 152ddae0-33ea-11e7-9072-cf60936ef67c {"vacant": false, "terminated": false, "futureLeased": false, "currentlyLeased": true} RESIDENTIAL APARTMENT APARTMENT 44-5554

74311af0-66d2-11e7-b8bc-6b4f7805e9b6 a2483980-362d-11e7-9089-0514b5983506 DG {"rooms": {"rooms": 3, "bedrooms": 2, "bathrooms": 1}, "tenant": {"id": "a6eb8d20-a239-11e7-a3ef-6b9d8379393e", "data": {}, "unitId": "74311af0-66d2-11e7-b8bc-6b4f7805e9b6", "userId": "bfe66da0-9cb6-11e7-8892-b10fd867c418", "candidate": {"id": "857c0d50-9cb6-11e7-b6cc-fbc2c9a21558", "email": "djerboua+jatta@gmail.com", "notes": "", "rating": 4, "userId": "bfe66da0-9cb6-11e7-8892-b10fd867c418", "isWinner": true, "messages": [], "statuses": {"vettingStatus": "NONE", "scheduledStatus": "NOT_INVITED"}, "createdAt": "2017-09-18T21:15:39.558Z", "deletedAt": null, "isChecked": false, "listingId": "07ad0d0b-830a-4008-84b5-5a59d17ee7a6", "updatedAt": "2017-09-19T09:54:09.978Z", "isDisabled": false, "isScheduled": false, "disabledReason": null, "isNewApplicant": false, "isNewCandidate": false, "candidateSource": "MANUAL_EVERREAL_APPLICANT", "viewingStartDate": null, "applicationFormData": {"bic": "", "ssn": "", "city": "Meunchen", "iban": "", "email": "djerboua+jatta@gmail.com", "number": "99", "street": "Blumenstr.", "country": "Deutschland", "hasPets": {"answer": "Hund", "checked": true}, "zipCode": "89999", "bankName": "Combnka", "copyOfId": [{"name": "Test Dokument.pdf", "size": 87271, "type": "application/pdf", "resourceId": "86aaacd0-9cb7-11e7-8299-995c2f2f5de1", "resourcePath": "listing/07ad0d0b-830a-4008-84b5-5a59d17ee7a6/form-data/857c0d50-9cb6-11e7-b6cc-fbc2c9a21558/86aaacd0-9cb7-11e7-8299-995c2f2f5de1"}], "currency": "EUR", "language": "de-DE", "lastName": "Jatta", "birthDate": "1964-09-18T21:17:40.403Z", "firstName": "Katha", "occupation": "PM", "pfandungen": {"checked": false}, "references": {"count": 1, "values": [{"name": "Petra", "email": "dkdkdk@gj.de", "phoneNumber": "0303030333333", "relationship": "Bekannte"}]}, "wasEvicted": {"checked": false}, "companyName": "Test Unternehmen", "nationality": "Deutsch", "phoneNumber": "01222938888", "tenantSince": "2011", "creditReport": [{"name": "Test Dokument.pdf", "size": 87271, "type": "application/pdf", "resourceId": "86adba10-9cb7-11e7-8299-995c2f2f5de1", "resourcePath": "listing/07ad0d0b-830a-4008-84b5-5a59d17ee7a6/form-data/857c0d50-9cb6-11e7-b6cc-fbc2c9a21558/86adba10-9cb7-11e7-8299-995c2f2f5de1"}], "employerName": "Facebook", "familyStatus": "single", "landlordName": "Meier", "placeOfBirth": "Köln", "hadRentIssues": {"checked": false}, "proofOfIncome": [{"name": "Test Dokument.pdf", "size": 87271, "type": "application/pdf", "resourceId": "86b1d8c0-9cb7-11e7-8299-995c2f2f5de1", "resourcePath": "listing/07ad0d0b-830a-4008-84b5-5a59d17ee7a6/form-data/857c0d50-9cb6-11e7-b6cc-fbc2c9a21558/86b1d8c0-9cb7-11e7-8299-995c2f2f5de1"}], "signatureData": {"date": "2017-09-18T21:17:24.984Z", "signature": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASwAAACWCAYAAABkW7XSAAAAAXNSR0IArs4c6QAAO3dJRE

qa_backup_20191212.sql - AnonFile

anonfile.com

 

[eliadsonet]

Сколько строк в базе?