Deal8

Tables (9)

Account (Untitled)

  • username (Key) — Primary key — NOT NULL

Category (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • icon (Field2)

Chat (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • roomId (Key2) — Foreign key → ChatRoom.roomId — NOT NULL
  • content (Field)
  • writer (Key3) — Foreign key → Account.username — NOT NULL
  • createdAt (Field2)

ChatAttend (Untitled8)

  • roomId (Key) — UUID — Foreign key → ChatRoom.roomId — NOT NULL
  • username (Key2) — Foreign key → Account.username — NOT NULL
  • isAttend (Field)

ChatRoom (Untitled5)

  • roomId (Key) — UUID — Primary key — NOT NULL
  • productId (Key4) — INT — Foreign key → Product.id — NOT NULL

InterestProduct (Untitled4)

  • username (Key) — Foreign key → Account.username — NOT NULL
  • id (Key2) — CHAR — Foreign key → Product.id — NOT NULL

Location (Untitled2)

  • username (Key) — Foreign key → Account.username — NOT NULL
  • location (Field) — VARCHAR

Product (CopyOfUntitled)

  • id (Key) — INT — Primary key — NOT NULL
  • category (Key3) — Foreign key → Category.id — NOT NULL
  • author (Key2) — Foreign key → Account.username — NOT NULL
  • title (Field)
  • content (Field7)
  • cost (Field9)
  • status (Field11)
  • location (Field10)
  • thumnail (Field4)
  • createdAt (Field2)
  • updatedAt (Field5)
  • countOfView (Field8)

ProductImage (Untitled7)

  • id (Key) — INT — Foreign key → Product.id — NOT NULL
  • image (Field) — VARCHAR