중고거래마켓
테이블 (8)
Category (category)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(200)
ChatRoom (chatroom)
- id (Key) — bigint — 기본 키 — NOT NULL
- product (FK1) — bigint — 외래 키 → Product.id — NOT NULL
- seller (FK2) — bigint — 외래 키 → UserProfile.id — NOT NULL
- category (FK4) — bigint — 외래 키 → Category.id — NOT NULL
- buyer (FK3) — bigint
- created_at (Field1) — datetime
- updated_at (Field2) — datetime
ChatbotMessage (chatbotmessage)
- id (Key) — bigint — 기본 키 — NOT NULL
- chatroom (FK1) — bigint — 외래 키 → ChatRoom.id — NOT NULL
- sender (FK2) — bigint — 외래 키 → UserProfile.id — NOT NULL
- content (Field1) — text
- sent_at (Field2) — datetime
- is_bot (Field3) — boolean
ChatbotRoom (chatbotroom)
- id (Key) — bigint — 기본 키 — NOT NULL
- user (FK1) — bigint — 외래 키 → UserProfile.id — NOT NULL
- is_bot (Field1) — boolean
Message (message)
- id (Key) — bigint — 기본 키 — NOT NULL
- chatroom (FK1) — bigint — 외래 키 → ChatRoom.id — NOT NULL
- sender (FK23) — bigint — 외래 키 → UserProfile.id — NOT NULL
- receiver (FK3) — bigint
- content (Field1) — text
- sent_at (Field2) — datetime
- is_read (Field3) — boolean
Product (product)
- id (Key) — bigint — 기본 키 — NOT NULL
- seller (FK1) — bigint — 외래 키 → UserProfile.id — NOT NULL
- category (FK3) — bigint — 외래 키 → Category.id — NOT NULL
- buyer (FK2) — bigint — NOT NULL
- region (Field1) — varchar(500)
- price (Field2) — int
- title (Field3) — varchar(200)
- content (Field4) — text
- images (Field5) — image
- created_at (Field6) — datetime
- updated_at (Field7) — datetime
- product_sold (Field8) — varchar
- view_cnt (Field9) — int
- chat_cnt (Field10) — int
Review (review)
- id (Key) — bigint — 기본 키 — NOT NULL
- product (FK1) — bigint — 외래 키 → Product.id — NOT NULL
- reviewer (FK2) — bigint — 외래 키 → UserProfile.id — NOT NULL
- category (FK4) — bigint — 외래 키 → Category.id — NOT NULL
- reviewee (FK3) — bigint
- content (Field1) — text
- created_at (Field2) — datetime
- score (Field3) — int
UserProfile (userprofile)
- id (Key) — bigint — 기본 키 — NOT NULL
- user (FK3) — bigint — NOT NULL
- manner (Field6) — float — NOT NULL
- nickname (Field5) — varchar — NOT NULL
- profile_img (Field4) — image
- region (Field) — varchar(500)
- region_certification (Field2) — varchar