comma_capstone
Tables (6)
Bookings
- id — UUID
- checkIn — TIMESTAMP — NOT NULL
- checkOut — TIMESTAMP — NOT NULL
- status — BookingStatus — NOT NULL
- room_id — INT
- user_id — UUID
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
Comments
- id — SERIAL
- body — TEXT — NOT NULL
- room_id — INT
- user_id — UUID
- createdAt — TIMESTAMP
Likes
- id — SERIAL
- room_id — INT
- user_id — UUID
- createdAt — TIMESTAMP
Payments
- id — UUID
- paymentKey — VARCHAR(255)
- amount — INT — NOT NULL
- status — PaymentStatus — NOT NULL
- orderId — VARCHAR(255)
- booking_id — UUID
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
Rooms
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- category — VARCHAR(255)
- price — INT
- user_id — UUID
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
Users
- id — UUID
- email — VARCHAR(255) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP