erd

Tables (10)

hotels (호텔)

  • hotel_id (pk) — BIGINT — Primary key — NOT NULL
  • name (Field) — varchar(100)

pointHistory (포인트이력)

  • pointHistory_id (Key) — BIGINT — Primary key — NOT NULL
  • pointType_id (Key2) — BiGINT — Foreign key → pointType.pointType — NOT NULL
  • accumulate_point (Field2) — BIGINT
  • is_Add (Field3) — tinyint(1)

pointType (포인트타입)

  • pointType (Key) — BiGINT — Primary key — NOT NULL
  • type (Field) — varchar(100)

pointrule (포인트룰)

  • pointrule_id (Key) — BIGINT — Primary key — NOT NULL
  • pointType_id (Key2) — BiGINT — Foreign key → pointType.pointType — NOT NULL
  • point (Field2) — BIGINT

reservation (예약)

  • reservation_id (Field2) — Primary key
  • room_id (pk) — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_id (pk2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • cnt (Field3) — INT
  • in_date (Field4) — datetime
  • out_date (Field5) — date
  • Field6

review (리뷰)

  • review_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (fk) — BIGINT — Foreign key → user.user_id — NOT NULL
  • room_id (pk2) — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • content (Field) — text
  • is_blind (Field2) — tinyint(1)

reviewImage (리뷰이미지)

  • reviewImage_id (Key) — BIGINT — Primary key — NOT NULL
  • image_url (Field) — text
  • review_id (fk) — BIGINT — Foreign key → review.review_id — NOT NULL

roomImage (방이미지)

  • roomImage_id (Key) — BIGINT — Primary key — NOT NULL
  • image_url (Field) — text

rooms (방)

  • room_id (pk) — BIGINT — Primary key — NOT NULL
  • hotel_id (fk) — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
  • name (Field) — varchar(100)
  • capacity (Field2) — tinyint
  • floor (Field3) — tinyint
  • bathtub_flag (Field4) — tinyint(1)
  • view_type (Field5) — tinyint
  • created_at (Field6) — DATETIME

user (Untitled3)

  • user_id (pk) — BIGINT — Primary key — NOT NULL
  • username (Field) — varchar(100)
  • password (Field2) — varchar(100)
  • point (Field3) — BIGINT