test
Tables (9)
hotels
- hotel_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
point_detail
- point_detail_id (point_id) — BIGINT — Primary key — NOT NULL
- point_history — VARCHAR
- created_at — LocalDate
- point_id (point_id2) — BIGINT — Foreign key → points.point_id — NOT NULL
- earn_point — BIGINT
- deducted_point (deductive_point) — BIGINT
points
- point_id — BIGINT — Primary key — NOT NULL
- point — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
reservations
- reservation_id — BIGINT — Primary key — NOT NULL
- check_in_date — LOCALDATE
- check_out_date — LocalDate
- people_count — INT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
reviews
- review_id (Key) — INT — Primary key — NOT NULL
- content — VARCHAR
- image — VARCHAR
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
role
- role_id — INTEGER — Primary key — NOT NULL
- role_name — VARCHAR
roles
- role_id — INT — Primary key — NOT NULL
- role_name — VARCHAR(100) — 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
- capacity — TINYINT — NOT NULL
- floor — TINYINT — NOT NULL
- bathtub_flag — TINYINT(1) — NOT NULL
- view_type — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR
- password — VARCHAR
- review_id (Field) — BIGINT
- role (role_id) — INTEGER — Foreign key → role.role_id — NOT NULL