DDIP
Tables (6)
Ddip (Untitled6)
- id (PK) — String — Primary key — NOT NULL
- userD (FK) — Array — Foreign key — NOT NULL
- product (FK2) — String — Foreign key → Product.id — NOT NULL
- ddip_num (Field) — Int
- quantity (Field2) — Int
- payment (Field3) — Int
- pay_successed (Field4) — Bool
- pay_date (Field5) — Date
- QR_verified (Field6) — Bool
- createAt (Field7) — Date
- updatedAt (Field8) — Date
Location (Untitled3)
- id (PK) — String — Primary key — NOT NULL
- user (FK) — String — Foreign key → User.id — NOT NULL
- location (Field) — String
- latitude (Field2) — Float
- longitude (Field3) — Float
- createdAt (Field4) — Date
- updatedAt (Field5) — Date
Market (Untitled4)
- id (Key) — String — Primary key — NOT NULL
- login_id (Field) — String
- password (Field2) — String
- name (Field3) — String
- tel_market (Field4) — String
- location (Field5) — String
- createdAt (Field6) — Date
- updatedAt (Field7) — Date
Phone (Untitled2)
- id (PK) — String — Primary key — NOT NULL
- tel (Field) — String
- certification (Field2) — String
Product (Untitled5)
- id (Key) — String — Primary key — NOT NULL
- Market (FK) — String — Foreign key → Market.id — NOT NULL
- name (Field) — String
- manufacturer (Field2) — String
- category (Field3) — String
- image (Field4) — String
- price (Field5) — Float
- total_quantity (Field6) — Int
- description (Field7) — String
- createdAt (Field8) — Date
- updatedAt (Field9) — Date
User (Untitled)
- id (PK) — String — Primary key — NOT NULL
- ddipsU (FK) — Array — Foreign key → Ddip.id — NOT NULL
- username (Field) — String
- password (Field2) — String
- email (Field3) — String
- tel (Field4) — String
- certification (Field5) — String
- createdAt (Field8) — Date
- updatedAt (Field9) — Date