Ecommer
Uploaded by
binhnguyen.hoctap1912Ecommer
Uploaded by
binhnguyen.hoctap1912Language
0..1 0..1
id int
name string
User code string
0..1 *
id int createById int
email string *
updateById int
name string deletedAt datetime
password string createdAt datetime
phoneNumber string updatedAt datetime
avatar string
status UserStatus
totpSecret string
*
roleId int
*
createById int
*
updateById int
deletedAt datetime
createdAt datetime
updatedAt datetime
UserTranslation VerificationCode RefreshToken Permission
0..1
id int id int token string id int
* *
userId int email string userId int name string
*
languageId int code string expiresAt datetime description string
address string type VerificationCodeType createdAt datetime path string
description string expiresAt datetime method string
* *
createById int createdAt datetime createById int
* ProductTranslation *
updateById int updateById int
id int
deletedAt datetime deletedAt datetime
*
Product productId int
createdAt datetime createdAt datetime
0..1 0..1 *
id int languageId int
updatedAt datetime updatedAt datetime
base_price float name string
virtual_price float description string
* *
Role brandId int createById int Category
0..1 * * 0..1 0..1
id int createById int updateById int id int
* *
name string updateById int deletedAt datetime parentCategoryid int
*
description string deletedAt datetime createdAt datetime createById int
*
isActive boolean createdAt datetime updatedAt datetime updateById int
*
createById int updatedAt datetime deletedAt datetime
*
updateById int createdAt datetime
VariantOption
deletedAt datetime updatedAt datetime
0..1
Variant id int
createdAt datetime
0..1
id int value string
updatedAt datetime
*
name string variantId int Sku
* * 0..1
productId int createById int id int
* *
CategoryTranslation createById int updateById int value string
*
id int updateById int deletedAt datetime price float
*
categoryId int deletedAt datetime createdAt datetime stock int
*
languageId int createdAt datetime updatedAt datetime images string[]
*
name string updatedAt datetime productId int
*
description string createById int
* *
createById int updateById int
*
updateById int deletedAt datetime
deletedAt datetime createdAt datetime
createdAt datetime updatedAt datetime
updatedAt datetime
Brand
0..1
id int
logo string
*
createById int
*
updateById int
deletedAt datetime
createdAt datetime
updatedAt datetime
BrandTranslation
id int
*
brandId int
*
languageId int
name string
description string
*
createById int
*
updateById int
deletedAt datetime
createdAt datetime
updatedAt datetime
CartItem
id int
quanlity int
*
skuId int
*
userId int
createdAt datetime
updatedAt datetime
ProductSKUSnapshot
id int
productName String
price float
images string[]
skuValue string
*
skuId int
*
orderId int
createdAt datetime
Order
0..1
id int
*
userId int
status OrderStatus
*
createById int
*
updateById int
deletedAt datetime
createdAt datetime
updatedAt datetime
Review
id int
content string
rating int
*
productId int
*
userId int
createdAt datetime
updatedAt datetime
PaymentTransaction
id int
gateway string
transactionDate datetime
accountNumber string
subAccount string
amountIn int
amountOut int
accumulated int
code string
transactionContent string
referenceNumber string
body string
createdAt datetime
Message
id int
*
fromUserId int
*
toUserId int
content string
readAt datetime
ProductsCategories
*
product_id int
*
category_id int
SkusVariantOptions
PermissionsRoles *
sku_id Int
*
permission_id Int *
variant_option_id Int
*
role_id Int
Language
0..1 0..1
id int
name string
User code string
0..1 *
id int createById int
email string *
updateById int
name string deletedAt datetime
password string createdAt datetime
phoneNumber string updatedAt datetime
avatar string
status UserStatus
totpSecret string
*
roleId int
*
createById int
*
updateById int
deletedAt datetime
createdAt datetime
updatedAt datetime
UserTranslation VerificationCode RefreshToken Permission
0..1
id int id int token string id int
* *
userId int email string userId int name string
*
languageId int code string expiresAt datetime description string
address string type VerificationCodeType createdAt datetime path string
description string expiresAt datetime method string
* *
createById int createdAt datetime createById int
* ProductTranslation *
updateById int updateById int
id int
deletedAt datetime deletedAt datetime
*
Product productId int
createdAt datetime createdAt datetime
0..1 0..1 *
id int languageId int
updatedAt datetime updatedAt datetime
base_price float name string
virtual_price float description string
* *
Role brandId int createById int Category
0..1 * * 0..1 0..1
id int createById int updateById int id int
* *
name string updateById int deletedAt datetime parentCategoryid int
*
description string deletedAt datetime createdAt datetime createById int
*
isActive boolean createdAt datetime updatedAt datetime updateById int
*
createById int updatedAt datetime deletedAt datetime
*
updateById int createdAt datetime
VariantOption
deletedAt datetime updatedAt datetime
0..1
Variant id int
createdAt datetime
0..1
id int value string
updatedAt datetime
*
name string variantId int Sku
* * 0..1
productId int createById int id int
* *
CategoryTranslation createById int updateById int value string
*
id int updateById int deletedAt datetime price float
*
categoryId int deletedAt datetime createdAt datetime stock int
*
languageId int createdAt datetime updatedAt datetime images string[]
*
name string updatedAt datetime productId int
*
description string createById int
* *
createById int updateById int
*
updateById int deletedAt datetime
deletedAt datetime createdAt datetime
createdAt datetime updatedAt datetime
updatedAt datetime
Brand
0..1
id int
logo string
*
createById int
*
updateById int
deletedAt datetime
createdAt datetime
updatedAt datetime
BrandTranslation
id int
*
brandId int
*
languageId int
name string
description string
*
createById int
*
updateById int
deletedAt datetime
createdAt datetime
updatedAt datetime
CartItem
id int
quanlity int
*
skuId int
*
userId int
createdAt datetime
updatedAt datetime
ProductSKUSnapshot
id int
productName String
price float
images string[]
skuValue string
*
skuId int
*
orderId int
createdAt datetime
Order
0..1
id int
*
userId int
status OrderStatus
*
createById int
*
updateById int
deletedAt datetime
createdAt datetime
updatedAt datetime
Review
id int
content string
rating int
*
productId int
*
userId int
createdAt datetime
updatedAt datetime
PaymentTransaction
id int
gateway string
transactionDate datetime
accountNumber string
subAccount string
amountIn int
amountOut int
accumulated int
code string
transactionContent string
referenceNumber string
body string
createdAt datetime
Message
id int
*
fromUserId int
*
toUserId int
content string
readAt datetime
ProductsCategories
*
product_id int
*
category_id int
SkusVariantOptions
PermissionsRoles *
sku_id Int
*
permission_id Int *
variant_option_id Int
*
role_id Int
Enum OrderStatus {
PENDING_CONFIRMATION
PENDING_PICKUP
PENDING_DELIVERY
DELIVERED
RETURNED
CANCELLED
}
Enum VerificationCode {
REGISTER
FORGOT_PASSWORD
}
Enum UserStatus {
ACTIVE
BLOCKED
}
You might also like
- Users Courses Lessons Course - EnrollmentsNo ratings yetUsers Courses Lessons Course - Enrollments2 pages
- App - Dic - Domain - Id App - Org - Id Permission - Id App - User - IdNo ratings yetApp - Dic - Domain - Id App - Org - Id Permission - Id App - User - Id2 pages
- Resources: Updated - by Updated - at DescriptionNo ratings yetResources: Updated - by Updated - at Description2 pages
- Resource - Types Permission - Types: Varchar Varchar Varchar VarcharNo ratings yetResource - Types Permission - Types: Varchar Varchar Varchar Varchar2 pages
- Password - Resets - Tokens Personal - Access - Tokens Failed - Jobs Migrations Activity - LogNo ratings yetPassword - Resets - Tokens Personal - Access - Tokens Failed - Jobs Migrations Activity - Log2 pages
- Created by Unlicensed Version: Class Diagram: Bus Pass Management SystemNo ratings yetCreated by Unlicensed Version: Class Diagram: Bus Pass Management System1 page
- DBMS 1: Introduction + ER Diagram + Functional DependencyNo ratings yetDBMS 1: Introduction + ER Diagram + Functional Dependency9 pages
- C++ Programming: Ministry of Higher EducationNo ratings yetC++ Programming: Ministry of Higher Education37 pages
- ESP32 P10 (Interfacing P10 LED Display With ESP32 + Set Text On P10 With Webserver)No ratings yetESP32 P10 (Interfacing P10 LED Display With ESP32 + Set Text On P10 With Webserver)12 pages
- C++ Worksheet On Function, Array and StructureNo ratings yetC++ Worksheet On Function, Array and Structure11 pages
- Overview of Computer Software and Programming Languages: by Er. Rupesh Kumar Nidhi 1No ratings yetOverview of Computer Software and Programming Languages: by Er. Rupesh Kumar Nidhi 114 pages
- 19 Ways To Bypass Software Restrictions and Spawn A ShellNo ratings yet19 Ways To Bypass Software Restrictions and Spawn A Shell26 pages
- Android: For Software Development For Portable Devices 2016 by Ayush KumarNo ratings yetAndroid: For Software Development For Portable Devices 2016 by Ayush Kumar18 pages
- Cse2002 Data-structures-And-Algorithms LTP 2.0 2 Cse2002 Data-structures-And-Algorithms LTP 2.0 1 Cse2002-Data Structures and AlgorithmsNo ratings yetCse2002 Data-structures-And-Algorithms LTP 2.0 2 Cse2002 Data-structures-And-Algorithms LTP 2.0 1 Cse2002-Data Structures and Algorithms3 pages
- Bachelor of Science in Information Technology (Robotics) 3100% (1)Bachelor of Science in Information Technology (Robotics) 32 pages
- المعايير الاكاديمية القومية المرجعية NarsNo ratings yetالمعايير الاكاديمية القومية المرجعية Nars51 pages
- 1z0-809.exam.53q: Number: 1z0-809 Passing Score: 800 Time Limit: 120 MinNo ratings yet1z0-809.exam.53q: Number: 1z0-809 Passing Score: 800 Time Limit: 120 Min44 pages
- Lecture 3 Part 1 - CS50's Introduction To Programming With PythonNo ratings yetLecture 3 Part 1 - CS50's Introduction To Programming With Python2 pages