erd3
Tables (21)
ACCOMMODATION
- accommodation_id — BIGINT — Primary key — NOT NULL
- accommodation_type — VARCHAR(20) — NOT NULL
- accommodation_name — VARCHAR(100) — NOT NULL
- region — VARCHAR(50)
- address — VARCHAR(200)
- accommodation_lat — DECIMAL(10,7)
- accommodation_lng — DECIMAL(10,7)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
ACCOMMODATION_REVIEWS
- review_id — BIGINT — Primary key — NOT NULL
- accommodation_id — BIGINT — Foreign key → ACCOMMODATION.accommodation_id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- star — TINYINT — NOT NULL
- review_contents — VARCHAR(1000) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
ACCOMMODATION_REVIEW_IMG
- id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → ACCOMMODATION_REVIEWS.review_id — NOT NULL
- img_url — VARCHAR(500) — NOT NULL
- img_order — INT — NOT NULL
BOARD
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- category — VARCHAR(20) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- contents — TEXT — NOT NULL
- hit — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
BOARD_COMMENT
- id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → BOARD.id — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- parent_id — BIGINT — Foreign key → BOARD_COMMENT.id
- contents — VARCHAR(1000) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
BOARD_IMG
- id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → BOARD.id — NOT NULL
- img_url — VARCHAR(500) — NOT NULL
- img_order — INT — NOT NULL
BOOKING
- booking_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- total_amount — DECIMAL(12,0) — NOT NULL
- booking_status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
BOOKING_ITEM
- booking_item_id — BIGINT — Primary key — NOT NULL
- booking_id — BIGINT — Foreign key → BOOKING.booking_id — NOT NULL
- room_id — BIGINT — Foreign key → ROOM.room_id — NOT NULL
- check_in_date — DATE — NOT NULL
- check_out_date — DATE — NOT NULL
- room_quantity — INT — NOT NULL
- guest_count — INT — NOT NULL
- unit_price — DECIMAL(12,0) — NOT NULL
- subtotal — DECIMAL(12,0) — NOT NULL
CART
- cart_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
CART_ITEM
- cart_item_id — BIGINT — Primary key — NOT NULL
- cart_id — BIGINT — Foreign key → CART.cart_id — NOT NULL
- room_id — BIGINT — Foreign key → ROOM.room_id — NOT NULL
- check_in_date — DATE — NOT NULL
- check_out_date — DATE — NOT NULL
- room_quantity — INT — NOT NULL
- guest_count — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
LIKE_BOARD
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- board_id — BIGINT — Foreign key → BOARD.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
PAYMENT
- payment_id — BIGINT — Primary key — NOT NULL
- booking_id — BIGINT — Foreign key → BOOKING.booking_id — NOT NULL
- pay_cost_total — DECIMAL(12,0) — NOT NULL
- pay_state — TINYINT — NOT NULL
- pay_method — VARCHAR(30)
- pg_tid — VARCHAR(100)
- paid_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
PLACE
- place_id — BIGINT — Primary key — NOT NULL
- place_category — VARCHAR(30) — NOT NULL
- place_name — VARCHAR(100) — NOT NULL
- region — VARCHAR(50) — NOT NULL
- place_lat — DECIMAL(10,7)
- place_lng — DECIMAL(10,7)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
PLACE_TAG
- place_id — BIGINT — Foreign key → PLACE.place_id — NOT NULL
- tag_id — BIGINT — Foreign key → TAG.tag_id — NOT NULL
PLACE_VIEW_HISTORY
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- place_id — BIGINT — Foreign key → PLACE.place_id — NOT NULL
- viewed_at — TIMESTAMP — NOT NULL
REVIEWS
- review_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id — NOT NULL
- place_id — BIGINT — Foreign key → PLACE.place_id — NOT NULL
- star — TINYINT — NOT NULL
- review_contents — VARCHAR(1000) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
REVIEW_IMG
- id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → REVIEWS.review_id — NOT NULL
- img_url — VARCHAR(500) — NOT NULL
- img_order — INT — NOT NULL
ROOM
- room_id — BIGINT — Primary key — NOT NULL
- accommodation_id — BIGINT — Foreign key → ACCOMMODATION.accommodation_id — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
- price — DECIMAL(12,0) — NOT NULL
- total_room_count — INT — NOT NULL
- max_guest — INT — NOT NULL
- has_spa — TINYINT(1) — NOT NULL
- contents — VARCHAR(1000) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
ROOM_IMG
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — Foreign key → ROOM.room_id — NOT NULL
- img_url — VARCHAR(500) — NOT NULL
- img_order — INT — NOT NULL
TAG
- tag_id — BIGINT — Primary key — NOT NULL
- tag_name — VARCHAR(30) — NOT NULL
USERS
- id — BIGINT — Primary key — NOT NULL
- login_email — VARCHAR(100)
- login_password — VARCHAR(255)
- provider — VARCHAR(20) — NOT NULL
- social_uid — VARCHAR(100)
- nickname — VARCHAR(30) — NOT NULL
- location — VARCHAR(50)
- profile_url — VARCHAR(500)
- age_group — VARCHAR(20)
- gender — TINYINT
- enabled — TINYINT(1) — NOT NULL
- refresh_token — VARCHAR(500)
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL