floraum
Tables (12)
Category (category)
- Long (category_id) — Primary key — NOT NULL
- String (name)
Coupon (coupon)
- Long (coupon_id) — Primary key — NOT NULL
Order (orders)
- Long (order_id) — Primary key — NOT NULL
- Long (user_id) — Foreign key → User.Long — NOT NULL
- User (user)
- enum (status)
OrderProduct (order_product)
- Long (order_product_id) — Primary key — NOT NULL
- Long (order_id) — Foreign key → Order.Long — NOT NULL
- Long (product_id) — Foreign key → Product.Long — NOT NULL
- Product (product)
- Order (order)
- int (orderPrice)
- int (count)
Product (product)
- Long (product_id) — Primary key — NOT NULL
- String (name)
- int (price)
- int (stockQuantity)
ProductCategory (product_category)
- Long (product_category_id) — Primary key — NOT NULL
- Long (product_id) — Foreign key → Product.Long — NOT NULL
- Long (category_id) — Foreign key → Category.Long — NOT NULL
- Product (product)
- Category (category)
ProductTag (product_tag)
- Long (product_tag_id) — Primary key — NOT NULL
- Long (product_id) — Foreign key → Product.Long — NOT NULL
- Long (tag_id2) — Foreign key → Tag.Long — NOT NULL
ShopList (shop_list)
- Long (shop_list_id) — Primary key — NOT NULL
- Long (user_id) — Foreign key → User.Long — NOT NULL
- User (user)
ShopListProduct (shop_list_product)
- Long (shop_list_product_id) — Primary key — NOT NULL
- Long (shop_list_id) — Foreign key → ShopList.Long — NOT NULL
- Long (product_id) — Foreign key → Product.Long — NOT NULL
- Product (product)
- ShopList (shopList)
- int (shopListPrice)
- int (count)
Tag (tag)
- Long (tag_id) — Primary key — NOT NULL
User (user)
- Long (user_id) — Primary key — NOT NULL
- String (name)
UserCoupon (user_coupon)
- Long (user_coupon_id) — Primary key — NOT NULL
- Long (coupon_id) — Foreign key → Coupon.Long — NOT NULL
- Long (user_id) — Foreign key → User.Long — NOT NULL