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