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