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