shop
Tables (7)
order (Untitled5)
- orderId (Key) — Primary key — NOT NULL
- name (Field)
- userId (Key2) — Foreign key → user.userId — NOT NULL
- sellerId (Key3) — Foreign key → seller.sellerId — NOT NULL
- sellerProductId (Key4) — Foreign key → sellerProduct.sellerProductId — NOT NULL
- payments (Field2)
product (Untitled3)
- productId (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- price (Field3)
- count (Field4)
productContents (Untitled7)
- productContentsId (Key) — Primary key — NOT NULL
- image (Field)
- productId (Key2) — Foreign key → product.productId — NOT NULL
productItem (Untitled4)
- productItemId (Key) — Primary key — NOT NULL
- name (Field)
- price (Field2)
- count (Field3)
seller (Untitled2)
- sellerId (Key) — Primary key — NOT NULL
- username (Field)
- password (Field2)
- fee (Field3)
- companynumber (Field4)
sellerProduct (Untitled6)
- sellerProductId (Key) — Primary key — NOT NULL
- name (Field)
- contents (Field2)
- productId (Key2) — Foreign key → product.productId — NOT NULL
- link (Field3)
- publishedAt (Field4)
- sellerId (Key3) — Foreign key → seller.sellerId — NOT NULL
- count (Field5)
user (Untitled)
- userId (Key) — Primary key — NOT NULL
- username (Field)
- password (Field2)
- name (Field3)
- phone (Field4)