스플릿티
테이블 (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