umc

Tables (8)

chatroom (Untitled7)

  • chatroomId (Key) — int — Primary key — NOT NULL
  • sellerId (Key3) — int — Foreign key → user.userId — NOT NULL
  • objetId (Key2) — int — Foreign key → object.objetId — NOT NULL
  • buyerId (FK) — int
  • Field3

like (Untitled3)

  • likeId (Key2) — int — Primary key — NOT NULL
  • userId (Key) — int — Foreign key → user.userId — NOT NULL
  • postId (Key3) — int — Foreign key → post.postId — NOT NULL

message (Untitled8)

  • messageId (Key) — int — Primary key — NOT NULL
  • chatroomId (Key2) — int — Foreign key → chatroom.chatroomId — NOT NULL
  • userId (Key3) — int — Foreign key → chatroom.sellerId — NOT NULL
  • senderId (FK)
  • content (Field) — text
  • CreatedAt (Field2)

object (Untitled4)

  • objetId (Key) — int — Primary key — NOT NULL
  • postId (Key2) — int — Foreign key → post.postId — NOT NULL

post (Untitled2)

  • postId (Key) — int — Primary key — NOT NULL

review (Untitled5)

  • reviewId (Key) — int — Primary key — NOT NULL
  • storeId (Key2) — int — Foreign key → store.storeId — NOT NULL
  • userId (Key22) — int — Foreign key → store.userId — NOT NULL
  • reviewerId (Field3)
  • text (Field) — varchar
  • score (Field2) — int

store (Untitled6)

  • storeId (Key) — int — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → user.userId — NOT NULL

user (Untitled)

  • userId (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar