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