LostayDB

Tables (14)

ADMIN (관리자)

  • admin_no — BIGINT — Primary key — NOT NULL
  • admin_id — varvhar
  • admin_pw — varchar
  • admin_role — carchar

CART (찜테이블)

  • cart_no — bigint(20) — Primary key — NOT NULL
  • user_no — bigint(20) — Foreign key → USER.user_no — NOT NULL

CART_HOTEL (찜테이블 호텔테이블 연결테이블)

  • cart_no — bigint(20) — Foreign key → CART.cart_no — NOT NULL
  • hotel_no — bigint(20) — Foreign key → HOTEL.hotel_no — NOT NULL

DISCOUNT (할인테이블(페이 별 할인))

  • dis_no — bigint(20) — Primary key — NOT NULL
  • dis_category — varchar(255)
  • dis_rate — double
  • dis_image — varchar
  • dis_pg — varchar

EVENT (이벤트 테이블)

  • event_no — bigint(20) — Primary key — NOT NULL
  • event_create_At — datetime
  • event_end_At — datetime
  • event_img — varchar(255)
  • event_thumbnail — varchar(255)
  • event_title — varchar(255)

HOTEL (호텔테이블)

  • hotel_no — bigint(20) — Primary key — NOT NULL
  • hotel_name — varchar(25)
  • hotel_thumbnail — varchar(255)
  • hotel_img — varchar(255)
  • hotel_amenities — varchar(255)
  • hotel_rating — varchar(255)
  • hotel_addres — varchar(255)
  • hotel_ tourist_attraction — varchar(255)
  • hotel_introduction — varchar(255)

LOCATION (지역테이블)

  • location_no — bigint(20) — Primary key — NOT NULL
  • location_name — varchar
  • location_image — varchar

PAYMENT (결제테이블)

  • pay_no — bigint(20) — Primary key — NOT NULL
  • user_no — bigint(20) — Foreign key → USER.user_no — NOT NULL
  • room_no — bigint(20) — Foreign key → ROOM.room_no — NOT NULL
  • pay_type — varchar(20)
  • pay_day — datetime
  • pay_status — varchar(1)
  • pay_price — int
  • pay_point — int
  • cancle_day — datetime
  • imp_uid — varchar(255)

POINT (포인트내역테이블)

  • point_no — bigint(20) — Primary key — NOT NULL
  • user_no — bigint(20) — Foreign key → USER.user_no — NOT NULL
  • point_day — datetime
  • point_plus_minus — int
  • point_title — varchar(50)
  • status — int

REFRESH_TOKEN (리프레쉬토큰 테이블)

  • rt_no — bigint(20) — Primary key — NOT NULL
  • user_no — bigint(20) — Foreign key → USER.user_no — NOT NULL
  • rt_token — varchar(255)
  • rt_expiration — varchar(255)

RESERVATION (예약테이블)

  • reservation_no — bigint(20) — Primary key — NOT NULL
  • pay_no — bigint(20) — Foreign key → PAYMENT.pay_no — NOT NULL
  • check_in — datetime
  • check_out — datetime
  • res_status — VARCHAR(255)
  • res_review_status — VARCHAR(255)
  • phone — VARCHAR
  • name — VARCHAR

REVIEW (리뷰테이블)

  • review_no — bigint(20) — Primary key — NOT NULL
  • room_no — bigint(20) — Foreign key → ROOM.room_no — NOT NULL
  • user_no — bigint(20) — Foreign key → USER.user_no — NOT NULL
  • review_ rating — double
  • review_content — varchar(255)
  • review_img — varchar(255)
  • review_create_At — datetime
  • review_sanctions_at — date

ROOM (객실테이블)

  • room_no — bigint(20) — Primary key — NOT NULL
  • hotel_no — bigint(20) — Foreign key → HOTEL.hotel_no — NOT NULL
  • room_name — varchar(50)
  • room_people_max — int
  • room_people_info — varchar(10)
  • room_count — int
  • room_thumbnail — varchar(255)
  • room_img — varchar(255)
  • room_price — int
  • room_discount — int
  • room_amenities — varchar(255)
  • room_introdurction (room_introduction) — varchar(255)
  • room_checkin_time — time
  • room_checkout_time — time

USER (회원테이블)

  • user_no — bigint(20) — Primary key — NOT NULL
  • user_name — varchar(25)
  • user_nickname — varchar(25)
  • user_email — varchar(25)
  • user_phone — varchar(25)
  • user_point — int
  • user_role — varchar(10)
  • user_status — varchar(1)
  • user_create_At — varchar(10)
  • user_token — varchar(255)