shop database

Tables (14)

Cart_item (cart_item)

  • cart_item_id (Key) — Primary key — NOT NULL
  • product_id (Key3) — bigint — Foreign key → Product.product_id — NOT NULL
  • cart_id (Key2) — bigint — Foreign key → cart.cart_id — NOT NULL
  • count (Field) — int — NOT NULL
  • option (Field2) — int — NOT NULL

Category (categories)

  • category_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20) — NOT NULL
  • created_at (Field2) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL

FavoriteProduct (favorite_products)

  • Key — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
  • product_id (FK2) — bigint — Foreign key → Product.product_id — NOT NULL
  • is_valid (Field) — boolean
  • created_at (Field2) — timestamp — NOT NULL

Order (order)

  • order_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • product_id (Key3) — bigint — Foreign key → Product.product_id — NOT NULL
  • customer_name (Field2) — varchar(20) — NOT NULL
  • customer_phone (Field7) — varchar(100) — NOT NULL
  • purchase_date (Field3) — timestamp — NOT NULL
  • order_price (Field4) — DECIMAL — NOT NULL
  • product_name (Field11) — varchar(100) — NOT NULL
  • quantity (Field5) — int — NOT NULL
  • payment_method (Field) — varchar(50) — NOT NULL
  • shipping_address (Field8) — varchar(200) — NOT NULL
  • shipping_name (Field9) — varchar(100)
  • shipping_phone (Field10) — varchar(100) — NOT NULL
  • status (Field12) — varchar(50)

OrderItem (주문내역)

  • Key — Primary key — NOT NULL
  • order_id (Key2) — bigint — Foreign key → Order.order_id — NOT NULL
  • user_id (Key3) — bigint — Foreign key → User.user_id — NOT NULL
  • productId (Field) — int — NOT NULL
  • productName (Field2) — varchar(100) — NOT NULL
  • productPrice (Field3) — int — NOT NULL
  • productCount (Field4) — int — NOT NULL
  • productTotalPrice (Field5) — float — NOT NULL
  • isCancel (Field6) — int — NOT NULL

Product (products)

  • product_id (Key) — bigint — Primary key — NOT NULL
  • seller_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
  • category_id (FK3) — bigint — Foreign key → Category.category_id — NOT NULL
  • price (Field2) — bigint — NOT NULL
  • product_name (Field3) — varchar(100) — NOT NULL
  • description (Field4) — varchar(300) — NOT NULL
  • thumb_nail_image (Field7) — varchar(250) — NOT NULL
  • view_cnt (Field8) — int — NOT NULL
  • like_cnt (Field9) — int
  • stock (Field) — int — NOT NULL
  • is_soldout (Field5) — int
  • created_at (Field10) — timestamp — NOT NULL
  • updated_at (Field11) — timestamp — NOT NULL

ProductImage (product_images)

  • Key — bigint — Primary key — NOT NULL
  • product_id (Key2) — bigint — Foreign key → Product.product_id — NOT NULL
  • image_url (Field) — varchar(250)
  • created_at (Field2) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL

Recommendation (recommendation)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • product_id (Key3) — bigint — Foreign key → Product.product_id — NOT NULL
  • recommendation_score (Field) — float — NOT NULL
  • recommendation_date (Field2) — Timestamp — NOT NULL

Sale (sale)

  • Key — Primary key — NOT NULL
  • seller_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • totalCount (Field) — int — NOT NULL

SaleItem (판매내역)

  • Key — Primary key — NOT NULL
  • seller_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • order_item (Key4) — Foreign key → OrderItem.Key — NOT NULL
  • sale_id (Key3) — bigint — Foreign key → Sale.Key — NOT NULL
  • productId (Field) — int — NOT NULL
  • itemName (Field2) — varchar(100) — NOT NULL
  • itemPrice (Field3) — int — NOT NULL
  • itemTotalPrice (Field4) — int — NOT NULL
  • isCancel (Field5) — int — NOT NULL
  • createDate (v) — timestamp — NOT NULL

SaleReview (sale_reviews)

  • salereview_id (Key) — bigint — Primary key — NOT NULL
  • product_id (FK3) — bigint — Foreign key → Product.product_id — NOT NULL
  • reviewer_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
  • reviewee_id (FK2) — bigint — Foreign key → User.user_id — NOT NULL
  • review_type (Field4) — int — NOT NULL
  • content (Field) — varchar(500) — NOT NULL
  • created_at (Field2) — timestamp — NOT NULL
  • updated_at (Field3) — timestamp — NOT NULL

User (users)

  • user_id (Key) — bigint — Primary key — NOT NULL
  • provider (Field8) — NOT NULL
  • providerId (Field) — bigint
  • name (Field2) — varchar(20) — NOT NULL
  • address (Field3) — varchar(20) — NOT NULL
  • role (Field5) — varchar(20) — NOT NULL
  • created_at (Field6) — timestamp — NOT NULL
  • updated_at (Field7) — timestamp — NOT NULL
  • email (Field4) — varchar(100) — NOT NULL
  • phone (Field9) — varchar(100) — NOT NULL
  • coin (Field10) — int — NOT NULL

cart

  • cart_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • count (Field) — int

feedback

  • feedback_id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → User.user_id — NOT NULL
  • feedback_type (Field) — int — NOT NULL
  • content (Field2) — varchar(200) — NOT NULL
  • form (Field3) — varchar(100)
  • score (Field5) — int — NOT NULL
  • created_at (Field4) — TIMESTAMP — NOT NULL
  • updated_at (Field6) — TIMESTAMP — NOT NULL