사본

테이블 (39)

ShippingEvent

  • shipping_evnet_id — bigint — 기본 키 — NOT NULL
  • shipping_id — bigint — NOT NULL
  • shipping_event_type — enum
  • shipping_event_status — enum
  • shipping_event_description — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp
  • shipping_event_processed_by — enum

User

  • user_id — varchar(60)
  • user_email — varchar(60)
  • user_pw — varchar(60)
  • pre_pw — varchar(60)
  • user_name — varchar(30)
  • user_RR_number — varchar(14)
  • user_phone_number — varchar(30)
  • user_address — varchar(100)
  • user_gender — check('M', 'F')
  • user_registration_at — timestamp
  • user_id_creation_at — timestamp
  • sms_marketing_recieved_status — char(1)
  • email_marketing_recieved_status — char(1)
  • customer_status — enum
  • is_user_withdrawal — boolean
  • user_withdrawal_at — timestamp
  • user_withdrawal_reason — varchar(300)
  • created_at — timestamp
  • updated_at — timestamp
  • role — enum

business_info

  • business_info_id — bigint — 기본 키 — NOT NULL
  • company_name — varchar(30)
  • ceo_name — varchar(30)
  • main_phone — varchar(20)
  • company_address — varchar(200)
  • business_registration_number — varchar(60)
  • telecom_sales_registration_number — varchar(60)
  • privacy_officer — varchar(30)
  • customer_service_phone — varchar(20)
  • company_bank_account_number — varchar(60)
  • company_introduction — text
  • terms_of_service — text
  • privacy_policy — text
  • user_guide — text
  • created_at — timestamp
  • deleted_at — timestamp

cart

  • cart_id — bigint — 기본 키 — NOT NULL
  • item_id — bigint — NOT NULL
  • user_id — varchar(60)
  • quantity — int
  • input_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

category

  • category_id — bigint — 기본 키 — NOT NULL
  • category_id2 — bigint — NOT NULL
  • name — varchar(10)
  • depth — int

claim

  • claim_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • order_item_id — bigint — NOT NULL
  • employee_id — bigint — NOT NULL
  • title — varchar(30)
  • type — enum
  • detail — varchar(100)
  • status — enum
  • image_file_url_1 — varchar(30)
  • image_file_url_2 — varchar(30)
  • image_file_url_3 — varchar(30)
  • image_file_url_4 — varchar(30)
  • request_reason — enum
  • rejection_reason — enum
  • created_at — timestamp
  • updated_at — timestamp
  • shipping_evnet_id — bigint — NOT NULL

code

  • code_id — bigint — 기본 키 — NOT NULL
  • code_group_id — varchar(50) — NOT NULL
  • code_name — varchar(100)
  • 취소 — 등
  • code_value — varchar(50)
  • CANCEL — 등
  • code_description — varchar(200)
  • sort_order — number
  • use_status — boolean
  • created_at — timestamp
  • deleted_at — timestamp

code_group

  • code_group_id — varchar(50) — 기본 키 — NOT NULL
  • code_group_name — varchar(100)
  • 클레임 — 종류
  • 주문 — 상태
  • code_group_description — varchar(200)
  • sort_order — number
  • use_status — boolean
  • created_at — timestamp
  • deleted_at — timestamp

coupon

  • coupon_id — bigint — 기본 키 — NOT NULL
  • coupon_name — varchar(50)
  • coupon_number_check — varchar(30)
  • issued_quantity — number(3)
  • coupon_amount — number(6)
  • issued_date — timestamp
  • created_at — timestamp
  • updated_at — timestamp

customer_coupon

  • customer_coupon_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • coupon_id — bigint — NOT NULL
  • issued_date — timestamp
  • used_date — timestamp

delivery_destination

  • delivery_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • alias — varchar(30)
  • receiptor_name — varchar(30)
  • receiptor_phone_number — varchar(30)
  • address — varchar(100)
  • detailed_address — varchar(100)
  • is_default_address — boolaen
  • is_delivery_destination — boolean
  • created_at — timestamp
  • updated_at — timestamp

employee

  • employee_id — bigint — 기본 키 — NOT NULL
  • employee_name — varchar(10)
  • employee_role — enum
  • employee_email — varchar(30)
  • employee_status — enum

grade_change_history

  • grade_history_id — bigint — 기본 키 — NOT NULL
  • user_grade_id — bigint — NOT NULL
  • grade_change_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

inspection

  • inspection_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • stocktransaction_history_id — bigint — NOT NULL
  • order_item_id — bigint — NOT NULL
  • employee_id — bigint — NOT NULL
  • state — enum
  • type — enum
  • content — text
  • image_url — varchar(255)
  • approved_quantity — int
  • rejected_quantity — int
  • date — date
  • created_at — timestamp
  • updated_at — timestamp

inventory

  • inventory_id — bigint — 기본 키 — NOT NULL
  • item_id — bigint — NOT NULL
  • quantity — int
  • created_at — timestamp
  • updated_at — timestamp

inventory_history

  • inventory_history_id — bigint — 기본 키 — NOT NULL
  • inventory_id — bigint — NOT NULL
  • location_code — varchar(50)
  • zone — varchar(50)
  • rack — varchar(50)
  • shelf — varchar(50)
  • description — text
  • created_at — timestamp
  • updated_at — timestamp

item

  • item_id — bigint — 기본 키 — NOT NULL
  • category_id — bigint — NOT NULL
  • name — varchar(255)
  • image — varchar(255)
  • description — text
  • price — DECIMAL(10,2)
  • status — enum
  • grade — enum
  • manufacture_country — varchar(100)
  • is_best_seller — boolean
  • created_at — tiemstamp
  • updated_at — timestamp

login_logout_history

  • login_logout_history_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • login_at — timestamp
  • logout_at — timestamp
  • access_nation — enum
  • login_ip_address — varchar(30)
  • login_device_info — device_info
  • login_failure_at — timestamp
  • login_failure_reason — enum
  • created_at — timestamp
  • updated_at — timestamp

notice

  • notice_id — bigint — 기본 키 — NOT NULL
  • title — varchar(100)
  • content — text
  • view_count — int
  • is_visible — boolean
  • start_date — timestamp
  • end_date — timestamp
  • created_at — timestamp
  • updated_at — timestamp

option

  • option_id — bigint — 기본 키 — NOT NULL
  • item_id — bigint — NOT NULL
  • color — vharchar(50)
  • size — varchar(50)
  • is_required — boolean
  • created_at — timestamp
  • updated_at — timestamp

order

  • order_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • order_status — enum
  • shipping_amount — decimal(10, 2)
  • shipping_fee — decimal(10, 2)
  • created_at — timestamp
  • updated_at — timestamp

order_item

  • order_item_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • order_id — bigint — NOT NULL
  • item_id — bigint — NOT NULL
  • order_item_status — enum
  • delay_reason — enum
  • order_item_price — decimal(10, 2)

order_item_history

  • order_item_history_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • order_item_id — bigint — NOT NULL
  • order_status — enum
  • created_at — timestamp

payment_history

  • payment_history_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • order_id — bigint — NOT NULL
  • payment_key — varchar(255)
  • payment_method_type — enum
  • result_code — enum
  • requested_at — timestamp
  • approved_at — timestamp
  • receipt_url — varchar(255)
  • card_issuer_code — enum
  • card_acquirer_code — enum
  • card_number — varchar(255)
  • installment_months — int
  • va_account_number — varchar(255)
  • va_bank_code — enum
  • transfer_account_number — varchar(255)
  • transfer_bank_code — enum
  • order_amount — decimal(10, 2)
  • coupon_discount_amount — decimal(10, 2)
  • point_amount — decimal(10, 2)
  • membership_discount_amount — decimal(10, 2)
  • delivery_fee — decimal(10, 2)
  • final_paid_amount — decimal(10, 2)
  • refund_requested — boolean
  • refund_requested_at — timestamp
  • refund_status — enum
  • refund_reason — varchar(255)
  • refund_rejected_reason — varchar(255)
  • refund_amount — decimal(10, 2)

payment_method

  • payment_method_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • payment_method — enum
  • card_company_code — varchar(60)
  • card_number — varchar(255)
  • bank_code — enum
  • account_number — varchar(60)
  • user_cash_receipt_number — varchar(60)
  • user_taxpayer_identification_number — varchar(60)
  • billing_key — varchar(255)
  • is_default_payment_method — boolean
  • is_pay_available — boolean
  • pay_deny_reason — enum
  • owner_type — enum
  • created_at — timestamp
  • updated_at — timestamp

point

  • point_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • point_status — enum
  • point_balance — number(6)
  • created_at — timestamp
  • updated_at — timestamp

point_history

  • point_history_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • point_id — bigint — NOT NULL
  • changed_date — timestamp
  • created_at — timestamp
  • updated_at — timestamp

product_answer

  • product_answer_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • product_question_id — bigint — NOT NULL
  • employee_id — bigint — NOT NULL
  • content — text
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

product_question

  • product_question_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • item_id — bigint — NOT NULL
  • image_url — varchar(255)
  • question_type — enum
  • title — varchar(255)
  • content — text
  • is_private — boolean
  • is_answered — boolean
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

refund

  • refund_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • payment_history_id — bigint — NOT NULL
  • order_item_id — bigint — NOT NULL
  • updated_at — timestamp
  • created_at — timestamp
  • refund_account_bank_code — varchar(255)
  • refund_account_number — varchar(255)
  • refund_holder_name — varchar(10)

review

  • review_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • item_id — bigint — NOT NULL
  • rating — int
  • title — vharchar(50)
  • content — text
  • image_url — varchar(255)
  • view — int
  • is_hidden — boolean
  • created_at — timestamp
  • updated_at — timestamp

shipping

  • shipping_id — bigint — 기본 키 — NOT NULL
  • order_item_id — bigint — NOT NULL
  • shipping_type — enum
  • shipping_method — enum

shipping_history

  • shipping_history_id — bigint — 기본 키 — NOT NULL
  • shipping_id — bigint — NOT NULL
  • shipping_status — enum
  • shipping_location_name — varchar(20)
  • shipping_location_type — enum
  • memo — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp

stocktransaction_history

  • stocktransaction_history_id — bigint — 기본 키 — NOT NULL
  • inventory_id — bigint — NOT NULL
  • vendor_item_id — bigint — NOT NULL
  • quantity_change — int
  • inspected — boolean
  • delivery_driver_name — varchar(255)
  • applied_to_stock — boolean
  • change_date — date
  • applied_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp

user_grade

  • user_grade_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • user_grade — enum
  • grade_benefit — text
  • grade_detail — text
  • promotion_condition — text
  • demotion_condition — text
  • created_at — timestamp
  • updated_at — timestamp

vendor

  • vendor_id — bigint — 기본 키 — NOT NULL
  • business_number — varchar(50)
  • name — varchar(50)
  • phone_number — varchar(50)
  • email — varchar(50)
  • address — varchar(50)
  • created_at — timestamp
  • updated_at — timestamp

vendor_item

  • vendor_item_id — bigint — 기본 키 — NOT NULL
  • item_id — bigint — NOT NULL
  • partner — bigint — NOT NULL
  • price — DECIMAL(10, 2)
  • created_at — timestamp
  • updated_at — timestamp

vendor_manager

  • vendor_manager_id — bigint — 기본 키 — NOT NULL
  • vendor_id — bigint — NOT NULL
  • name — varchar(50)
  • position — varchar(50)
  • phone_number — varchar(50)
  • email — varchar(50)
  • address — varchar(50)
  • created_at — timestamp
  • updated_at — timestamp

wish_list

  • wish_list_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(60)
  • cart_id — bigint — NOT NULL
  • keep_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp