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