shopping-mall-management-backend-service

Tables (7)

countries (Untitled)

  • Key (id) — int — Primary key — NOT NULL
  • Field (country_code) — varchar(4)
  • Field (country_dcode) — varchar(3)
  • Field (country_name) — varchar(50)

coupon-types (Untitled6)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — varchar(200)
  • Field (type) — enum
  • Field (discount_value) — decimal(8, 2)

coupons (Untitled5)

  • Key (id) — Primary key — NOT NULL
  • Key (coupon_type_id) — Foreign key → coupon-types.Key — NOT NULL
  • Field (coupon_code) — varchar(36)
  • Field (is_used) — boolean
  • Field (created_at) — datetime
  • Field (expires_at) — datetime
  • 실제 할인액 (discount_amount) — decimal(8, 2)

deliveries (Untitled7)

  • Key (id) — Primary key — NOT NULL
  • Key (order_id) — Foreign key → orders.Key — NOT NULL
  • Field (status) — enum

delivery_costs (Untitled2)

  • Key (id) — int — Primary key — NOT NULL
  • Key (country_index) — int — Foreign key → countries.Key — NOT NULL
  • Field (quantity) — int
  • Field (cost) — decimal(8, 2)

orders (Untitled3)

  • Key (id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → users.Key — NOT NULL
  • Key (country_index) — int — Foreign key → countries.Key — NOT NULL
  • Key (coupon_id) — int — Foreign key → coupons.Key — NOT NULL
  • Field (pay_state) — enum
  • Field (quantity) — int
  • Field (original_price) — decimal(8, 2)
  • Field (discounted_price) — decimal(8, 2)
  • Field (final_price) — decimal(8, 2)
  • Field (original_delivery_cost) — decimal(8, 2)
  • Field (discounted_delivery_cost) — decimal(8, 2)
  • Field (final_delivery_cost) — decimal(8, 2)
  • 쿠폰, 할인, 배달비 적용 (total_price) — decimal(8, 2)
  • Field (buyr_zipx) — varchar(20)
  • Field (buyr_city) — varchar(50)
  • Field (vccode) — int
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

users (Untitled4)

  • Key (id) — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (is_deleted) — boolean