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