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