test
Tables (6)
customer
- user_id — BIGINT — Primary key
- customer_password — VARCHAR
- role — ENUM
- customer_id — VARCHAR — NOT NULL
- reservation_count — TinyInt
- reservation_code — VARCHAR
hotels
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
point
- user_id — BIGINT — Foreign key → customer.user_id
- amount — BIGINT
- created_at — DATETIME
reservation
- reservation_id — auto_increment — Primary key — NOT NULL
- check_in — DATETIME
- check_out — DATETIME
- amount — TINYINT
- reservation_code — VARCHAR(100)
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- user_id — BIGINT
review
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- user_id — BIGINT — Foreign key → customer.user_id
- image — VARCHAR
- see — BOOLEAN
rooms
- room_id — BIGINT — Primary key — NOT NULL
- hotel_id — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- capacity — TINYINT — NOT NULL
- floor — TINYINT — NOT NULL
- bathtub_flag — TINYINT(1) — NOT NULL
- view_type — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- available_reservation (abaliable_reservation) — BOOLEAN