aaa
Tables (23)
addresses
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
artworks
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- theme_id — BIGINT — Foreign key → themes.id
base_product_option_values
- id — BIGINT — Primary key — NOT NULL
- base_product_option_id — BIGINT — Foreign key → base_product_options.id — NOT NULL
base_product_options
- id — BIGINT — Primary key — NOT NULL
- base_product_id — BIGINT — Foreign key → base_products.id — NOT NULL
base_products
- id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → categories.id — NOT NULL
categories
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → categories.id
coupon_targets
- id — BIGINT — Primary key — NOT NULL
- coupon_id — BIGINT — Foreign key → coupons.id — NOT NULL
- category_id — BIGINT — Foreign key → categories.id
- base_product_id — BIGINT — Foreign key → base_products.id
- product_id — BIGINT — Foreign key → products.id
coupons
- id — BIGINT — Primary key — NOT NULL
order_item_claims
- id — BIGINT — Primary key — NOT NULL
- order_item_id — BIGINT — Foreign key → order_items.id — NOT NULL
- processed_by — BIGINT — Foreign key → users.id
order_item_options
- id — BIGINT — Primary key — NOT NULL
- order_item_id — BIGINT — Foreign key → order_items.id — NOT NULL
- base_product_option_value_id — BIGINT — Foreign key → base_product_option_values.id
order_items
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- shipment_id — BIGINT — Foreign key → shipments.id
orders
- id — BIGINT — Primary key — NOT NULL
- buyer_id — BIGINT — Foreign key → users.id — NOT NULL
- address_id — BIGINT — Foreign key → addresses.id
payments
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
point_transactions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- order_id — BIGINT — Foreign key → orders.id
product_curations
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
- created_by — BIGINT — Foreign key → users.id — NOT NULL
product_tags
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
products
- id — BIGINT — Primary key — NOT NULL
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- base_product_id — BIGINT — Foreign key → base_products.id — NOT NULL
- artwork_id — BIGINT — Foreign key → artworks.id — NOT NULL
shipments
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- carrier_id — BIGINT — Foreign key → shipping_carriers.id
shipping_carriers
- id — BIGINT — Primary key — NOT NULL
tags
- id — BIGINT — Primary key — NOT NULL
themes
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
user_coupons
- id — BIGINT — Primary key — NOT NULL
- coupon_id — BIGINT — Foreign key → coupons.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- order_id — BIGINT — Foreign key → orders.id
- order_item_id — BIGINT — Foreign key → order_items.id
users
- id — BIGINT — Primary key — NOT NULL