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