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