airbnb
Tables (4)
lodging (Untitled)
- id — INT — Primary key — NOT NULL
- name — VARCHAR(128)
- location — VARCHAR(128)
- latitude — DECIMAL(18, 15)
- longitude — DECIMAL(18, 15)
- imageUrl — VARCHAR(256)
- startDate — DATE
- endDate — DATE
- maxPersonnel — INT
- options — VARCHAR(128)
- pricePerDay — INT
- averageStar — DECIMAL(3, 2)
- reviewCount — INT
reservation (Untitled3)
- id — INT — Primary key — NOT NULL
- userId — VARCHAR(32) — Foreign key → user.id — NOT NULL
- lodgingId — INT — Foreign key → lodging.id — NOT NULL
- checkin — DATE
- checkout — DATE
- guestCount — INT
- totalPrice — INT
user (Untitled2)
- id — VARCHAR(32) — Primary key — NOT NULL
- password — VARCHAR(128)
- salt — VARCHAR(128)
wishlist (Untitled4)
- userId — VARCHAR(32) — Foreign key → user.id — NOT NULL
- lodgingId — INT — Foreign key → lodging.id — NOT NULL