test
Tables (7)
hotels
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
point
- point_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- point — BIGINT
- created_at — DATETIME
- Field
reservations
- reservation_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
- checked_in_date — DATETIME
- checked_out_date — DATETIME
- people_count — TINYINT
- Field
review
- review_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- content — VARCHAR(200)
- Field2
role
- role_id — BIGINT — Primary key — NOT NULL
- role_name — VARCHAR(100)
- Field
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
user
- user_id — BIGINT — Primary key — NOT NULL
- role_id — BIGINT — Foreign key → role.role_id — NOT NULL
- username — VARCHAR(100)
- password — VARCHAR(100)
- Field