ATGN02_006_last_test

테이블 (10)

객실 (rooms)

  • room_id — BIGINT — 기본 키 — NOT NULL
  • hotel_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • capacity — TINYINT — NOT NULL
  • floor — TINYINT — NOT NULL
  • bathtub_flag — TINYINT(1) — NOT NULL
  • view_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • hotel_id (hotel_id2) — BIGINT — 외래 키 → 호텔.hotel_id — NOT NULL

객실가격 (room_prices)

  • room_price_id — BIGINT — 기본 키 — NOT NULL
  • room_id — BIGINT — NOT NULL
  • holiday_id — BIGINT
  • season_type — VARCHAR(20) — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • room_id (room_id2) — BIGINT — 외래 키 → 객실.room_id — NOT NULL
  • holiday_id (holiday_id2) — BIGINT — 외래 키 → 휴일.holiday_id — NOT NULL

객실이미지 (room_images)

  • image_id — BIGINT — 기본 키 — NOT NULL
  • room_id — BIGINT — NOT NULL
  • image_url — TEXT — NOT NULL
  • room_id (room_id2) — BIGINT — 외래 키 → 객실.room_id — NOT NULL

예약 (reservations)

  • reservation_id — BIGINT — 기본 키 — NOT NULL
  • room_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • check_in_date — DATE — NOT NULL
  • check_out_date — DATE — NOT NULL
  • guest_count — TINYINT — NOT NULL
  • reservation_code — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • room_id (room_id2) — BIGINT — 외래 키 → 객실.room_id — NOT NULL
  • user_id (user_id2) — BIGINT — 외래 키 → 유저.user_id — NOT NULL

유저 (users)

  • user_id — BIGINT — 기본 키 — NOT NULL
  • user_email — VARCHAR(200) — NOT NULL
  • user_name — VARCHAR(60) — NOT NULL
  • user_password — VARCHAR(200) — NOT NULL
  • user_phonenumber — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • withdrawl_at — DATETIME

유저포인트 (user_points)

  • point_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — NOT NULL
  • point — INT — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • expired_at — DATETIME — NOT NULL
  • user_id (user_id2) — BIGINT — 외래 키 → 유저.user_id — NOT NULL

호텔 (hotels)

  • hotel_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • field — VARCHAR(255)

후기 (reviews)

  • review_id — BIGINT — 기본 키 — NOT NULL
  • reservation_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • rating — DECIMAL(2,1) — NOT NULL
  • visible — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • reservation_id (reservation_id2) — BIGINT — 외래 키 → 예약.reservation_id — NOT NULL

후기이미지 (review_images)

  • image_id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — NOT NULL
  • image_url — TEXT — NOT NULL
  • review_id (review_id2) — BIGINT — 외래 키 → 후기.review_id — NOT NULL

휴일 (holidays)

  • holiday_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • date — DATE — NOT NULL