shop
Tables (6)
CrossShopProduct
- PK (id) — int — Primary key — NOT NULL
- price — int
- Field
Order
- PK (id) — int — Primary key — NOT NULL
- 유저 (user_idx) — int
- Field (amount) — int
- 포인트 (point) — int
- 배송비 (delivery_fee) — int
- Field (deposit_type) — varchar(2)
- Field (receiver_name) — varchar(100) — 테이블을 따로 분리해도 되지 않을까 싶다
- Field (receiver_phone) — varchar(40)
- Field (shipping_address_id) — int
- Field (address) — text
- Field (address_detail) — text
- Field (address_img_url) — varchar(150)
- Field (delivery_memo) — text
- Field (user_memo) — text
- Field (manager_order_type) — smallint
- Field (memo) — text
- Field (os_type) — varchar(10)
- created_at — datetime
- updated_at — datetime
OrderGroup
- PK (id) — int — Primary key — NOT NULL
- FK (order_id) — int — Foreign key → Order.PK — NOT NULL
- FK (product_id) — int — Foreign key → CrossShopProduct.PK — NOT NULL — 여기 둘지 고민해볼것
- 수량 (count) — int
- 그외 정보들 (iso_code) — varchar(2)
- Field (option_id) — int unsigned
- Field (total_price) — int
- Field (product_name) — text
- Field (product_option) — text
- Field (product_img_url) — varchar(150)
- Field (product_thumbnail_img_url) — varchar(150)
- Field (product_special_item) — tinyint(1) — 이거 필요없어보임 product.sale_type 보면 됨
- Field (is_reviewed) — tinyint(1)
- Field (product_item_url) — text — 이건 사용하지 않는듯함
- Field (status) — varchar(50)
- Field (status_history) — text
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field2 (delivered_at) — datetime
OrderProduct
- PK (id) — int — Primary key — NOT NULL
- FK (prodict_id) — int — Foreign key → CrossShopProduct.PK — NOT NULL
- FK (group_id) — int — Foreign key → OrderGroup.PK — NOT NULL
- 상태 (status) — int
- Field (status_history) — text
- Field (price) — int — 얘는 product에 있어서 여기서 넣어야 할지 고민되네
- Field2 (stock_price) — int
- Field (parcel_agent_code) — varchar(5)
- Field (parcel_agent_name) — varchar(20)
- Field (parcel_tracking_no) — varchar(30)
- Field (parcel_status) — varchar(64)
- Field (parcel_status_code) — varchar(2)
- Field (parcel_status_history) — text
- Field (parcel_tracking_log_id) — int
- Field (korean_name) — varchar(50)
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (delivered_at) — datetime
Refund
- PK (id) — int — Primary key — NOT NULL
- FK (order_id) — int — Foreign key → Order.PK — NOT NULL
- 총환불금액 (refund_amount) — int — 실제 환불 금액(amount - point + delivery_fee)
- Field (total_product_amount) — int — sum(product * count)
- Field (point) — int
- Field (delivery_fee) — int
- Field (refund_reason) — smallint
- Field (refund_reason_etc) — varchar(100)
- Field (deposit_type) — tinyint
- Field (service_ref_id) — int
- Field (status) — varchar(50)
- Field (status_history) — text
- Field (created_at) — datetime
- Field (updated_at) — datetime
- Field (refunded_at) — datetime
Refund_detail (RefundDetail)
- PK (id) — int — Primary key — NOT NULL
- FK (refund_id) — int — Foreign key → Refund.PK — NOT NULL
- PK (order_product_id) — int — Foreign key → OrderProduct.PK — NOT NULL
- Field2 (status) — varchar(50)
- Field (status_history) — text
- Field (refunded_at) — datetime
- created_at — datetime
- updated_at — datetime