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