erd
Tables (9)
CATEGORY
- id — bigint
- name — varchar(255)
CHAT_MESSAGE
- id — bigint
- chat_room_id — bigint
- sender_id — bigint
- message — text
- message_type — varchar(50)
- is_read — boolean
- created_at — datetime
CHAT_ROOM
- id — bigint
- product_id — bigint
- seller_id — bigint
- buyer_id — bigint
- last_message — varchar(255)
- updated_at — datetime
MEMBER
- id — bigint
- email — varchar(255)
- nickname — varchar(255)
- kakao_id — varchar(255)
- role — varchar(50)
- created_at — datetime
MEMBER_INTEREST_CATEGORY
- id — bigint
- member_id — bigint
- category_id — bigint
PRODUCT
- id — bigint
- seller_id — bigint
- category_id — bigint
- title — varchar(255)
- description — text
- price — int
- sale_type — varchar(50)
- status — varchar(50)
- transaction_method — varchar(50)
- region_1depth — varchar(255)
- region_2depth — varchar(255)
- created_at — datetime
PRODUCT_IMAGE
- id — bigint
- product_id — bigint
- image_url — varchar(255)
- is_thumbnail — boolean
PROMISE
- id — bigint
- chat_room_id — bigint
- promise_time — datetime
- place — varchar(255)
- latitude — double
- longitude — double
- status — varchar(50)
WISH_LIST
- id — bigint
- member_id — bigint
- product_id — bigint
- created_at — datetime