중고거래마켓

테이블 (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