ustora
Tables (7)
address (Untitled)
- id (Key) — Primary key — NOT NULL
- isDefault (Field)
- shippingAddress1 (Field2)
- shippingAddress2 (Field3)
- shippingCity (Field4)
- shippingCompany (Field5)
- shippingCountry (Field6)
- shippingFirstName (Field7)
- shippingLastName (Field8)
- shippingState (Field9)
- email (Key2) — Foreign key → users.email — NOT NULL
cart (Untitled6)
- id (Key) — Primary key — NOT NULL
- id (Key2) — Foreign key → address.id — NOT NULL
- pid (Key3) — Foreign key → product.pid — NOT NULL
- quantity (Field)
- totalprice (Field2)
comment (Untitled7)
- id (Key) — Primary key — NOT NULL
- content (Field)
- createAt (Field2)
- nickname (Field3)
- pid (Key2) — Foreign key → product.pid — NOT NULL
- email (Key3) — Foreign key → users.email — NOT NULL
orderDetail (Untitled5)
- id (Key) — Primary key — NOT NULL
- priceAtOrder (Field)
- quantity (Field2)
- id (Key2) — Foreign key → orders.id — NOT NULL
- pid (Key3) — Foreign key → product.pid — NOT NULL
orders (Untitled4)
- id (Key) — Primary key — NOT NULL
- currencyCode (Field)
- orderDate (Field2)
- id (Key2) — Foreign key → address.id — NOT NULL
product (Untitled3)
- pid (Key) — Primary key — NOT NULL
- author (Field)
- brand (Field2)
- pname (Field3)
- price (Field4)
- category1 (Field5)
- category2 (Field6)
users (Untitled2)
- email (Key) — Primary key — NOT NULL
- name (Field)
- password (Field2)