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)