BD shopping

Tables (4)

Category (Untitled3)

  • id (Key) — String — Primary key — NOT NULL
  • name (Field) — String
  • thumbnailImageUrl (Field2) — String
  • parentId (Field3) — String
  • show (Field4) — Boolean
  • createdAt (Field5) — Date
  • updatedAt (Field6) — Date

Product (Untitled4)

  • id (Key) — String — Primary key — NOT NULL
  • categoryPath (Field) — Array
  • name (Field2) — String
  • recommendedRetailPrice (Field3) — Number
  • discountRate (Field4) — Number
  • discountedPrice (Field5) — Number
  • totalStock (Field6) — Number
  • stock (Field7) — Number
  • mainOriginalImageUrls (Field8) — Array
  • mainThumbnailImageUrls (Field9) — Array
  • contentImageUrl (Field10) — Array
  • createdAt (Field11) — Date
  • updatedAt (Field12) — Date

User (Untitled)

  • id (Key) — String — Primary key — NOT NULL
  • email (Field) — String — NOT NULL
  • password (Field2) — String — NOT NULL
  • status (Field7) — String
  • isBlocked (Field8) — Boolean — NOT NULL
  • isDeleted (Field5) — Boolean
  • deletedAt (Field6) — Date
  • createdAt (Field3) — Date
  • updatedAt (Field4) — Date

UserProfile (Untitled2)

  • id (Key) — String — Foreign key → User.id — NOT NULL
  • nickname (Field2) — String
  • allowMarketingEmail (Field) — Boolean
  • registerAuthToken (Field3) — String
  • registeredAt (Field4) — Date
  • passwordAuthToken (Field5) — String
  • passwordExpiredAt (Field6) — Date
  • createdAt (Field7) — Date
  • updatedAt (Field8) — Date