Hotel Room Booking System ER Diagram

erDiagram
  ROOM_TYPE ||--o{ ROOM : groups
  GUEST ||--o{ BOOKING : makes
  BOOKING ||--|{ BOOKING_ROOM : includes
  ROOM ||--o{ BOOKING_ROOM : "reserved in"
  BOOKING ||--o{ PAYMENT : "paid by"
  BOOKING ||--o| INVOICE : "billed in"
  ROOM_TYPE {
    int type_id PK
    string name
    decimal rate
    int capacity
  }
  ROOM {
    int room_no PK
    int type_id FK
    int floor
    string status
  }
  GUEST {
    int guest_id PK
    string name
    string phone
    string email
  }
  BOOKING {
    int booking_id PK
    int guest_id FK
    date check_in
    date check_out
    string status
  }
  BOOKING_ROOM {
    int booking_id FK
    int room_no FK
  }
  PAYMENT {
    int payment_id PK
    int booking_id FK
    decimal amount
    string method
  }
  INVOICE {
    int invoice_id PK
    int booking_id FK
    decimal total
    date issued_on
  }