imlab
Tables (7)
Country Code (국가 코드)
- Key (id) — Primary key — NOT NULL
- Field (code)
- Field (dcode)
- Field (name)
Coupon (쿠폰)
- Key (id) — Primary key — NOT NULL
- Key (coupon_type_id) — Foreign key → Coupon Type.Key — NOT NULL
- Field (code)
- Field (is_used)
- Field (created_at)
- Field (dueDate)
- Field (discount)
Coupon Type (쿠폰 타입)
- Key (id) — Primary key — NOT NULL
- Field (name)
- Field (discount_type) — enum
- Field (discount_value)
- Field (discount_at) — enum
Delivery (배송)
- Key (id) — Primary key — NOT NULL
- Key (order_id) — Foreign key → Order.Key — NOT NULL
- Field (state) — enum
Delivery Cost (배송 비용)
- Key (id) — Primary key — NOT NULL
- Key (country_code_id) — Foreign key → Country Code.Key — NOT NULL
- Field (quantity)
- Field (cost)
Order (주문)
- Key (id) — Primary key — NOT NULL
- Key (country_code_id) — Foreign key → Country Code.Key — NOT NULL
- Key (user_id) — Foreign key → User.Key — NOT NULL
- Key (coupon_id) — Foreign key → Coupon.Key — NOT NULL
- Field (pay_state)
- Field (quantity)
- Field (buyr_zipx)
- Field (vccode)
- Field (price)
- Field (total_price)
- Field (created_at)
- Field (updated_at)
User (사용자)
- Key (id) — Primary key — NOT NULL
- Field (name)