스플릿티

테이블 (22)

category

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL

chat_member

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • goods_id — BIGINT — 외래 키 → goods.id — NOT NULL
  • quantity — INT — NOT NULL
  • reviewed — BIT — NOT NULL
  • active — BIT — NOT NULL
  • trade_role — VARCHAR(255) — NOT NULL — BUYER, SELLER
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

chat_message

  • id — BIGINT — 기본 키 — NOT NULL
  • message — VARCHAR(2000)
  • trade_member_id — BIGINT — 외래 키 → chat_member.id
  • type — VARCHAR(255) — TEXT, ENTER, LEAVE
  • created_at — DATETIME(6) — NOT NULL

goods

  • id — BIGINT — 기본 키 — NOT NULL
  • seller_id — BIGINT — 외래 키 → member.id
  • category_id — BIGINT — 외래 키 → category.id
  • neigh_name — VARCHAR(20) — NOT NULL
  • latitude — DOUBLE
  • longitude — DOUBLE
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — VARCHAR(255) — NOT NULL — OPEN, CLOSED, COMPLETED
  • total_price — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • view_count — INT — NOT NULL
  • total_quantity — INT — NOT NULL
  • left_quantity — INT — NOT NULL
  • curr_participants — INT — NOT NULL
  • preferred_location — VARCHAR(255)
  • main_image_name — VARCHAR(255)
  • total_wishlist — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

goods_image

  • id — BIGINT — 기본 키 — NOT NULL
  • goods_id — BIGINT — 외래 키 → goods.id
  • image_name — VARCHAR(255) — NOT NULL

group_chat_member

  • id — BIGINT — 기본 키 — NOT NULL
  • group_chat_room_id — BIGINT — 외래 키 → group_chat_room.id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

group_chat_message

  • id — BIGINT — 기본 키 — NOT NULL
  • group_chat_member_id — BIGINT — 외래 키 → group_chat_member.id — NOT NULL
  • message — VARCHAR(2000)
  • created_at — DATETIME(6) — NOT NULL

group_chat_room

  • id — BIGINT — 기본 키 — NOT NULL
  • group_id — BIGINT — 외래 키 → small_group.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

group_member

  • id — BIGINT — 기본 키 — NOT NULL
  • group_id — BIGINT — 외래 키 → small_group.id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • role — VARCHAR(255) — NOT NULL — HOST, MEMBER
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

group_trade

  • id — BIGINT — 기본 키 — NOT NULL
  • group_id — BIGINT — 외래 키 → small_group.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price_per_person — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

group_trade_item

  • id — BIGINT — 기본 키 — NOT NULL
  • group_trade_id — BIGINT — 외래 키 → group_trade.id — NOT NULL
  • item_name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

member

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • social_id — VARCHAR(255)
  • social_type — VARCHAR(255) — NOT NULL — KAKAO
  • role — VARCHAR(255) — NOT NULL — USER, ADMIN
  • username — VARCHAR(60) — NOT NULL
  • rating — FLOAT — NOT NULL
  • review_count — INT — NOT NULL
  • neigh_name — VARCHAR(20)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • profile_image_url — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

notification

  • id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255)
  • body — VARCHAR(255)
  • goods_id — BIGINT — 외래 키 → goods.id
  • created_at — DATETIME(6) — NOT NULL

notification_history

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • notification_id — BIGINT — 외래 키 → notification.id — NOT NULL

products

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(500) — NOT NULL
  • quantity — INT — NOT NULL
  • price — INT
  • rating — FLOAT
  • review_count — INT
  • image_url — TEXT
  • product_url — TEXT
  • created_at — DATETIME(6) — NOT NULL

purchase_request

  • id — BIGINT — 기본 키 — NOT NULL
  • requester_id — BIGINT — 외래 키 → member.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • deadline — DATETIME(6)
  • preferred_location — VARCHAR(255)
  • fee — INT — NOT NULL
  • content — TEXT
  • view_count — INT — NOT NULL
  • image_name — VARCHAR(255)
  • status — VARCHAR(255) — NOT NULL — OPEN, CLOSED
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

purchase_request_chat_message

  • id — BIGINT — 기본 키 — NOT NULL
  • chat_room_id — BIGINT — 외래 키 → purchase_request_chat_room.id — NOT NULL
  • sender_id — BIGINT — 외래 키 → member.id — NOT NULL
  • sender_username — VARCHAR(255) — NOT NULL
  • message — VARCHAR(2000)
  • type — VARCHAR(255) — NOT NULL — TEXT, ENTER, LEAVE
  • created_at — DATETIME(6) — NOT NULL

purchase_request_chat_room

  • id — BIGINT — 기본 키 — NOT NULL
  • purchase_request_id — BIGINT — 외래 키 → purchase_request.id — NOT NULL
  • helper_id — BIGINT — 외래 키 → member.id — NOT NULL
  • active — BIT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

review

  • id — BIGINT — 기본 키 — NOT NULL
  • reviewee_id — BIGINT — 외래 키 → member.id
  • reviewer_id — BIGINT — 외래 키 → chat_member.id
  • content — TEXT
  • rating — FLOAT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

search_history

  • id — BIGINT — 기본 키 — NOT NULL
  • keyword — VARCHAR(255) — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

small_group

  • id — BIGINT — 기본 키 — NOT NULL
  • host_id — BIGINT — 외래 키 → member.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200)
  • join_code — VARCHAR(8) — NOT NULL
  • max_member_count — INT — NOT NULL
  • current_member_count — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

wish_list

  • id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.id — NOT NULL
  • goods_id — BIGINT — 외래 키 → goods.id — NOT NULL
  • quantity — BIGINT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL