hotel

Tables (4)

hotels (호텔)

  • hotel_id (호텔아이디) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(100) — NOT NULL

member (멤버)

  • member_id (회원 아이디) — VARCHAR(30) — Primary key — NOT NULL
  • pwd (비밀번호) — VARCHAR(255) — NOT NULL

reservation (예약)

  • resevationId (예약아이디) — BIGINT — Primary key — NOT NULL
  • id (회원 아이디) — VARCHAR(30) — Foreign key → member.member_id — NOT NULL
  • Room_id (방아이디) — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • check_in_date (체크인날짜) — DATE — NOT NULL
  • check_out_date (체크아웃날짜) — DATE — 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
  • bathtub_flag — TINYINT(1) — NOT NULL
  • view_type — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL