doit-shop

Tables (5)

Account (Untitled2)

  • accountId (Key) — Long — Primary key — NOT NULL
  • accountName (Field) — String
  • accountNumber (Field2) — String
  • accountBankName (Field3) — String
  • accountBalance (Field6) — Integer
  • createdAt (Field4) — DateTime
  • modifiedAt (Field5) — DateTime
  • userId (Key2) — Long — Foreign key → User.userId — NOT NULL

Category (Untitled5)

  • categortId (Key) — Long — Primary key — NOT NULL
  • categoryType (Field) — Enum
  • createdAt (Field2) — DateTime
  • modifiedAt (Field3) — DateTime

Order (Untitled4)

  • orderId (Key) — Long — Primary key — NOT NULL
  • createdAt (Field) — DateTime
  • modifiedAt (Field2) — DateTime
  • orderedStock (Field3) — Integer
  • orderStatus (Field5) — Enum
  • totalPrice (Field4) — Integer
  • productId (Key2) — Long — Foreign key → Product.productId — NOT NULL
  • userId (Key3) — Long — Foreign key → User.userId — NOT NULL

Product (Untitled3)

  • productId (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • description (Field2) — String
  • image (Field5) — String
  • price (Field3) — Integer
  • stock (Field4) — Integer
  • createdAt (Field6) — DateTime
  • modifiedAt (Field7) — DateTime
  • categortId (Key2) — Long — Foreign key → Category.categortId — NOT NULL
  • userId (Key3) — Long — Foreign key → User.userId — NOT NULL

User (Untitled)

  • userId (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • loginId (Field2) — String
  • password (Field3) — String
  • phoneNumber (Field4) — String
  • createdAt (Field5) — DateTime
  • modifiedAt (Field6) — DateTime