123

Tables (15)

Buyers (CopyOfCopyOfUntitled225)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • email (Field2) — VARCHAR(100)

Chat (CopyOfCopyOfUntitled22)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • id (Key2) — BIGINT — Foreign key → Room.id — NOT NULL
  • message (Field) — TEXT
  • sender (Field2) — VARCHAR(50)
  • timestamp (Field3) — DATETIME

Comments (CopyOfCopyOfUntitled223)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • productId (Key2) — BIGINT — Foreign key → Products.id — NOT NULL
  • buyerId (Key3) — BIGINT — Foreign key → Buyers.id — NOT NULL
  • content (Field) — TEXT
  • createdAt (Field2) — DATETIME

Likes (CopyOfCopyOfUntitled222)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • productId (Key2) — BIGINT — Foreign key → Products.id — NOT NULL
  • buyerId (Key3) — BIGINT — Foreign key → Buyers.id — NOT NULL

PdtUrl (CopyOfCopyOfUntitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • productId (Key2) — BIGINT — Foreign key → Product.id — NOT NULL
  • id (Key22) — BIGINT — Foreign key → Product.userId — NOT NULL
  • url (Field) — VARCHAR(255)

Product (CopyOfUntitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • userId (Key2) — BIGINT — Foreign key → User.id — NOT NULL
  • imageUrl (Field4) — VARCHAR(255)
  • price (Field3) — FLOAT
  • pdtId (Field) — BIGINT
  • pdtName (Field2) — VARCHAR(50)
  • dType (Field5) — VARCHAR(50)

Products (CopyOfUntitled22)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • sellerId (Key2) — BIGINT — Foreign key → Sellers.id — NOT NULL
  • name (Field) — VARCHAR(50)
  • description (Field2) — TEXT
  • price (Field3) — FLOAT

Purchase (CopyOfCopyOfUntitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • productId (Key3) — BIGINT — Foreign key → Product.id — NOT NULL
  • id (Key2) — BIGINT — Foreign key → Product.userId — NOT NULL

Room (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • roomUid (Field) — VARCHAR(50)

RoomUser (CopyOfUntitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • roomId (Key2) — BIGINT — Foreign key → Room.id — NOT NULL
  • user (Field) — VARCHAR(50)
  • other (Field2) — VARCHAR(50)

Sellers (CopyOfCopyOfUntitled226)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • email (Field2) — VARCHAR(100)

User

  • id (Key) — BIGINT — Primary key — NOT NULL
  • userName (Field) — VARCHAR(50)
  • emails (Field2) — VARCHAR(100)
  • password (Field3) — VARCHAR(60) — NOT NULL
  • hp (Field4) — VARCHAR(50)
  • address (Field5) — VARCHAR(255)
  • roles (Field6) — VARCHAR(50)
  • enable (Field7) — BOOLEAN — NOT NULL

User (CopyOfCopyOfCopyOfUntitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • email (Field) — VARCHAR(100)

Wish (CopyOfCopyOfUntitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • productId (Key3) — BIGINT — Foreign key → Product.id — NOT NULL
  • id (Key2) — BIGINT — Foreign key → Product.userId — NOT NULL

productRequests (CopyOfCopyOfUntitled224)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • BuyerId (Key2) — BIGINT — Foreign key → Buyers.id — NOT NULL
  • productName (Field) — VARCHAR(50)
  • descriptions (Field2) — TEXT
  • createdAt (Field3) — DATETIME