supermall
Tables (12)
cart_items (Untitled10)
- ccart_item_id (cart_item_id) — Long — Primary key — NOT NULL
- cart_id — Long — Foreign key → carts.cart_id — NOT NULL
- item_id (item_id2) — Long — Foreign key → item.item_id — NOT NULL
- price — Int
- count — Int
- crate_at (create_at) — Date
carts (Untitled4)
- cart_id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → user.user_id — NOT NULL
category (Untitled3)
- category_id — Long — Primary key — NOT NULL
- category_name — Varchar
item (Untitled2)
- item_id — Long — Primary key — NOT NULL
- category_id — Long — Foreign key → category.category_id — NOT NULL
- itme_name (item_name) — Varchar
- color — Varchar
- price — Int
- stock — Int
- item_description — Varchar
- deletedAt — Date
- createAt — Date
item_image (Untitled12)
- image_id — Long — Primary key — NOT NULL
- item_id — Long — Foreign key → item.item_id — NOT NULL
- image_url — Varchar
- rep_img — Varchar
order_item (Untitled11)
- order_item_id — Long — Primary key — NOT NULL
- order_id — Long — Foreign key → orders.order_id — NOT NULL
- item_id (item_id2) — Long — Foreign key → item.item_id — NOT NULL
- price — Int
- count — Int
orders (Untitled8)
- order_id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → user.user_id — NOT NULL
- total_price — Int
- status — Varchar
- createAt — Long
refresh_token (Untitled5)
- refresh_token_id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → user.user_id — NOT NULL
- refresh_token — Varchar
role (Untitled6)
- role_id — Long — Primary key — NOT NULL
- role_name — Varchar
sales (Untitled9)
- sale_id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → user.user_id — NOT NULL
- item_id — Long — Foreign key → item.item_id — NOT NULL
- stock — Int
- createAt — Date
user (Untitled)
- user_id — Long — Primary key — NOT NULL
- user_name — Varchar
- email — Varchar
- password — Varchar
- phoneNumber (phone_number) — Varchar
- address — Varchar
- gender — Varchar
- social_user_id — Varchar
- social_name — Varchar
- createAt — Date
- deletedAt — Date
user_role (Untitled7)
- user_role_id — Long — Primary key — NOT NULL
- role_id (role_id2) — Long — Foreign key → role.role_id — NOT NULL
- user_id — Long — Foreign key → user.user_id — NOT NULL