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