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