hoter-service

Tables (6)

Hotels

  • hotel_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL

Points (Untitled2)

  • point_id (Key) — BIGINT — Primary key — NOT NULL
  • type (Field) — TINYINT — Primary key — NOT NULL
  • user_id (Field5) — BIGINT — NOT NULL
  • amount (Field2) — INT — NOT NULL
  • expires_at (Field4) — DATETIME — NOT NULL
  • created_at (Field3) — DATETIME — NOT NULL

Rates (Untitled3)

  • rate_id (Key) — TINYINT — Primary key — NOT NULL
  • rate (Field) — NUMBER — NOT NULL
  • type (Field2) — TINYINT — NOT NULL

Reservations

  • reservation_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • rate_id (Key) — TINYINT — Foreign key → Rates.rate_id — NOT NULL
  • user_id (Field4) — BIGINT — NOT NULL
  • check_in (Field2) — DATETIME — NOT NULL
  • check_out (Field3) — DATETIME — NOT NULL
  • reservation_at (Field) — DATETIME — NOT NULL
  • canceled_at (Field5) — DATETIME

Reviews (Untitled)

  • review_id (Key) — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • user_id (Field2) — BIGINT — NOT NULL
  • content (Field) — TEXT — NOT NULL
  • visible (Field4) — TINYINT — NOT NULL
  • created_at (Field3) — DATETIME — NOT NULL

Rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • hotel_id — BIGINT — Foreign key → Hotels.hotel_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price (Field) — NUMBER — NOT NULL
  • capacity — TINYINT — NOT NULL
  • floor — TINYINT — NOT NULL
  • bathtub_flag — TINYINT — NOT NULL
  • view_type — TINYINT — NOT NULL
  • available_flag (Field2) — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL