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