Brand

PK id bigint
name nvarchar(50)
create_at date
update_at date
create_by bigint
update_by bigint
deleted boolean

Product
Origin
Image
PK id bigint
PK id bigint
PK id bigint
code varchar(20)
name nvarchar(50)
name text
name varchar(50)
create_at date
FK id_product_detail bigint
description text
update_at date
create_at date
FK id_brand bigint
create_by bigint
update_at date
FK id_origin bigint
update_by bigint
create_by bigint
FK id_material bigint
deleted boolean
update_by bigint
FK id_category bigint
deleted boolean
create_at date
Promotion_Product_Detail
update_at date Material
Promotion PK id bigint
create_by bigint
Product_Detail PK id bigint
PK id bigint FK id_promotion bigint update_by bigint
name nvarchar(50)
start_date date FK id_product_detail bigint PK id bigint
deleted bigint
create_at date
end_date date create_at date price float
update_at date
type enum update_at date quantity int
Size create_by bigint
value float create_by bigint FK id_product bigint
update_by bigint
create_at date update_by bigint FK id_size bigint PK id bigint
deleted boolean
update_at date deleted boolean FK id_color bigint name nvarchar(50)
create_by bigint create_at date create_at date
update_by bigint update_at date update_at date
Message Category
deleted boolean create_by bigint create_by bigint
PK id bigint Chat_Room PK id bigint
update_by bigint update_by bigint
FK id_room bigint PK id bigint name nvarchar(50)
deleted boolean deleted boolean
content bigint id_client bigint create_at date

seen bigint id_staff bigint level bigint

create_by bigint create_at time_stamp Color FK parent_id bigint

create_at time_stamp deleted boolean PK id bigint update_at date

Notification Cart Order_Detail
deleted boolean name nvarchar(50) create_by bigint
PK id bigint PK id bigint PK id bigint
create_at date update_by bigint
content text FK id_product_detail bigint FK id_product_detail bigint
update_at date deleted boolean
id_user bigint FK id_customer bigint FK id_order bigint
viewed boolean quantity int quantity bigint create_by bigint

deleted boolean create_at time stamp price date update_by bigint

create_at time_stamp update_at date total_money float deleted boolean

create_at date
update_at date
deleted boolean

Phi?u gi?m giá

Order Voucher
Gi?m giá generate uuid
User_Role User PK id bigint PK id bignit
Role FK id_user bigint PK id bigint FK id_user bigint Discount code varchat(255)
PK id bigint FK id_role bigint email varchar(255) FK id_discount bigint PK id bigint FK id_discount bigint
name varchat(50) password varchar(50) FK id_payment_method bigint code varchat(255) create_at date
full_name varchat(50) phone_number varchar(10) condition json update_at date
phone_number varchar(10) address varchar(255) type enum used_at date
birth date ship_date date value float create_by bigint
gender enum money_ship float max_value float update_by bigint
Role_Permission
avatar text total_money float start_date date used_by varchar(255)
FK id_role bigint Permission
id_google_account varchar(255) money_reduced float end_date date deleted BOOLEAN
FK id_permission bigint PK id bigint id_facebook_account varchar(255) note text discount_status enum
name varchat(50) is_admin boolean status enum create_at date
create_at date create_at date update_at date
update_at date update_at date create_by bigint
deleted boolean update_by bigint
deleted boolean

process_send email_detail
Payment_method
PK id_process_send bigint PK id_email_detail bigint template_mail
PK id bigint
created_at date content text PK id_template_email bigint
method enum
count_mail_sended int status boolean name nvarchar(50)
mail_send_log description text
count_mail_unsended int send_at date subject text
PK id bigint create_at date
size_process bigint created_at date body text
status boolean update_at date
FK id_mail_detail bigint type enum create_at date
description text create_by bigint
FK send_to (id_user) bigint update_at date
create_at date FK id_template_mail bigint
update_by bigint - ? ?ng kí account thành công, Xác nh?n ??t hàng, C?p nh?t tr?ng thái ??n hàng (?ang chu?n b?hàng, ?ang giao) - api c?a ghtk, Hóa ??n ??n hàng, Thông báo khuy?n mãi, ? ?i m?t kh?u
FK process_send_id bigint deleted boolean