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