nhn_exam_hotel_2

Tables (6)

hotels

  • hotel_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL

point

    review

    • review_id — BIGINT — Primary key — NOT NULL
    • content — varchar(500)
    • Field

    review-image

      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
      • INDEX — `fk_Rooms_hotels_idx`

      user