먹깨비상회 DB

테이블 (49)

account_delete_reason_lists

  • id — bigint(20) — 기본 키 — NOT NULL
  • account_delete_reason — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

account_delete_reasons

  • id — bigint(20) — 기본 키 — NOT NULL
  • account_delete_reason_id — bigint(20) — 외래 키 → account_delete_reasons.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

address_line_ones

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 — NOT NULL
  • status — enum('active','inactive','used') — NOT NULL
  • state_id — bigint(20) — 외래 키 — NOT NULL
  • city_id — bigint(20) — 외래 키 → cities.id — NOT NULL
  • street_id — bigint(20) — 외래 키 — NOT NULL
  • street_number_id — bigint(20) — 외래 키 — NOT NULL
  • post_code — int(11) — NOT NULL
  • receiver — varchar(255) — NOT NULL
  • mobile — varchar(255) — NOT NULL
  • address_line_two — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

admin_account_numbers

  • id — bigint(20) — 기본 키 — NOT NULL
  • admin_member_id — bigint(20) — 외래 키 → admin_members.id — NOT NULL
  • bank — varchar(255) — NOT NULL
  • account_number — varchar(255) — NOT NULL
  • status — enum('active','inactive') — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

admin_contract_rates

  • id — bigint(20) — 기본 키 — NOT NULL
  • admin_member_id — bigint(20) — 외래 키 → admin_members.id — NOT NULL
  • commission_rate — varchar(255) — NOT NULL
  • effective_date — timestamp
  • created_at — timestamp
  • updated_at — timestamp

admin_members

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 — NOT NULL
  • role — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp

applied_delivery_fees

  • id — bigint(20) — 기본 키 — NOT NULL
  • order_id — bigint(20) — 외래 키 — NOT NULL
  • applied_delivery_fee — int(11)
  • created_at — timestamp
  • updated_at — timestamp

applied_mukkebi_fees

  • id — bigint(20) — 기본 키 — NOT NULL
  • settlement_id — bigint(20) — 외래 키 — NOT NULL
  • mukkebi_fee_id — bigint(20) — 외래 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

applied_sales_man_fees

  • id — bigint(20) — 기본 키 — NOT NULL
  • settlement_id — bigint(20) — 외래 키 — NOT NULL
  • sales_man_fee_id — bigint(20) — 외래 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

applied_transaction_fees

  • id — bigint(20) — 기본 키 — NOT NULL
  • settlement_id — bigint(20) — 외래 키 — NOT NULL
  • transaction_fee_id — bigint(20) — 외래 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

bank_names

  • id — bigint(20) — 기본 키 — NOT NULL
  • code — char(2) — NOT NULL
  • bank_name — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

birthdays

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 — NOT NULL
  • birthday — date — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

brands

  • id — bigint(20) — 기본 키 — NOT NULL
  • brand_name — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

business_registration_numbers

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 — NOT NULL
  • business_name — varchar(255) — NOT NULL
  • business_registration_number — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

business_sectors

  • id — bigint(20) — 기본 키 — NOT NULL
  • display_order — tinyint(4) — NOT NULL
  • display_image_link — varchar(255) — NOT NULL
  • mart_event_id — bigint(20) — 외래 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

cancel_request_reasons

  • id — bigint(20) — 기본 키 — NOT NULL
  • cancel_request_reason — text — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

canceled_reasons

  • id — bigint(20) — 기본 키 — NOT NULL
  • order_id — bigint(20) — 외래 키 — NOT NULL
  • cancel_reason_id — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

cart_addresses

  • id — bigint(20) — 기본 키 — NOT NULL
  • cart_id — bigint(20) — 외래 키 → carts.id — NOT NULL
  • address_line_one_id — bigint(20) — 외래 키 → address_line_ones.id — NOT NULL
  • receiver — varchar(255) — NOT NULL
  • mobile — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

carts

  • id — bigint(20) — 기본 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 — NOT NULL
  • cart_type — enum('add_cart','buy_now') — NOT NULL
  • cart_status — enum('pending','charged') — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

charge_requests

  • id — bigint(20) — 기본 키 — NOT NULL
  • cart_id — bigint(20) — 외래 키 → carts.id — NOT NULL
  • charge_amount — int(11) — NOT NULL
  • oid — varchar(40) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

charged_carts

  • id — bigint(20) — 기본 키 — NOT NULL
  • cart_id — bigint(20) — 외래 키 → carts.id — NOT NULL
  • charge_request_id — bigint(20) — 외래 키 → charge_requests.id — NOT NULL
  • tid — varchar(40) — NOT NULL
  • tot_price — int(11) — NOT NULL
  • moid — varchar(40) — NOT NULL
  • pay_method — varchar(255) — NOT NULL
  • appl_date — date — NOT NULL
  • appl_time — time — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

charged_delivery_fees

  • id — bigint(20) — 기본 키 — NOT NULL
  • order_id — bigint(20) — 외래 키 — NOT NULL
  • admin_member_id — bigint(20) — 외래 키 → admin_members.id — NOT NULL
  • charged_delivery_fee — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

charged_orders

  • id — bigint(20) — 기본 키 — NOT NULL
  • order_id — bigint(20) — 외래 키 — NOT NULL
  • charged_amount — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

cities

  • id — bigint(20) — 기본 키 — NOT NULL
  • state_id — bigint(20) — 외래 키 — NOT NULL
  • city_name — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

commission_contracts

  • id — bigint(20) — 기본 키 — NOT NULL
  • sales_man_id — bigint(20) — 외래 키 — NOT NULL
  • commission_rate — varchar(255) — NOT NULL
  • effective_date — timestamp
  • created_at — timestamp
  • updated_at — timestamp

concern_photos

  • id — bigint(20) — 기본 키 — NOT NULL
  • concern_id — bigint(20) — 외래 키 → concerns.id — NOT NULL
  • concern_photo_link — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

concern_replies

  • id — bigint(20) — 기본 키 — NOT NULL
  • concern_id — bigint(20) — 외래 키 → concerns.id — NOT NULL
  • case_manager_id — bigint(20) — 외래 키 — NOT NULL
  • reply_content — text — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

concern_with_orders

  • id — bigint(20) — 기본 키 — NOT NULL
  • concern_id — bigint(20) — 외래 키 → concerns.id — NOT NULL
  • order_id — bigint(20) — 외래 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

concerns

  • id — bigint(20) — 기본 키 — NOT NULL
  • inquiry_type_id — bigint(20) — 외래 키 — NOT NULL
  • user_id — bigint(20) — 외래 키 — NOT NULL
  • writer — varchar(255)
  • mobile — varchar(255)
  • email — varchar(255)
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

coupon_expired_by_dates

  • id — bigint(20) — 기본 키 — NOT NULL
  • coupon_id — bigint(20) — 외래 키 → coupons.id — NOT NULL
  • expired_date — date — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

coupon_expired_by_days

  • id — bigint(20) — 기본 키 — NOT NULL
  • coupon_id — bigint(20) — 외래 키 → coupons.id — NOT NULL
  • given_days — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

coupon_limits

  • id — bigint(20) — 기본 키 — NOT NULL
  • coupon_id — bigint(20) — 외래 키 → coupons.id — NOT NULL
  • coupon_limit — int(11) — NOT NULL
  • remaining_amount — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

coupon_usable_item_lists

  • id — bigint(20) — 기본 키 — NOT NULL
  • coupon_id — bigint(20) — 외래 키 → coupons.id — NOT NULL
  • item_list_id — bigint(20) — 외래 키 — NOT NULL
  • apply_per — enum('order','quantity')
  • created_at — timestamp
  • updated_at — timestamp

coupon_usable_regions

  • id — bigint(20) — 기본 키 — NOT NULL
  • coupon_id — bigint(20) — 외래 키 → coupons.id — NOT NULL
  • city_id — bigint(20) — 외래 키 → cities.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

coupons

  • id — bigint(20) — 기본 키 — NOT NULL
  • coupon_name — varchar(255) — NOT NULL
  • admin_member_id — bigint(20) — 외래 키 → admin_members.id — NOT NULL
  • discount_type — enum('percentage','amount') — NOT NULL
  • coupon_amount — int(11) — NOT NULL
  • apply_per — enum('order','quantity') — NOT NULL
  • effective_date — date — NOT NULL
  • coupon_status — enum('active','inactive','exhausted') — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

courier_delivery_fees

  • id — bigint(20) — 기본 키 — NOT NULL
  • item_list_id — bigint(20) — 외래 키 — NOT NULL
  • maximum_quantity — int(11)
  • courier_delivery_fee — int(11)
  • created_at — timestamp
  • updated_at — timestamp

couriers

  • id — bigint(20) — 기본 키 — NOT NULL
  • courier_name — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

deducted_direct_delivery_fees

  • id — bigint(20) — 기본 키 — NOT NULL
  • cart_id — bigint(20) — 외래 키 → carts.id — NOT NULL
  • order_id — bigint(20) — 외래 키 — NOT NULL
  • deducted_amount — int(11) — NOT NULL
  • status — enum('used','canceled') — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

delivered_orders

  • id — bigint(20) — 기본 키 — NOT NULL
  • order_id — bigint(20) — 외래 키 — NOT NULL
  • admin_member_id — bigint(20) — 외래 키 → admin_members.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

delivery_city_item_lists

  • id — bigint(20) — 기본 키 — NOT NULL
  • direct_delivery_city_id — bigint(20) — 외래 키 → direct_delivery_cities.id — NOT NULL
  • item_list_id — bigint(20) — 외래 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

delivery_infos

  • id — bigint(20) — 기본 키 — NOT NULL
  • item_list_id — bigint(20) — 외래 키 — NOT NULL
  • delivery_info — text — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

delivery_restricted_areas

  • id — bigint(20) — 기본 키 — NOT NULL
  • city_id — bigint(20) — 외래 키 → cities.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

denied_refund_requests

  • id — bigint(20) — 기본 키 — NOT NULL
  • order_id — bigint(20) — 외래 키 — NOT NULL
  • checker_id — bigint(20) — 외래 키 — NOT NULL
  • denied_reason — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

denied_refund_waybill_numbers

  • id — bigint(20) — 기본 키 — NOT NULL
  • denied_refund_request_id — bigint(20) — 외래 키 → denied_refund_requests.id — NOT NULL
  • denied_refund_waybill_number — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

direct_delivery_cities

  • id — bigint(20) — 기본 키 — NOT NULL
  • direct_delivery_state_id — bigint(20) — 외래 키 → direct_delivery_states.id — NOT NULL
  • city_id — bigint(20) — 외래 키 → cities.id — NOT NULL
  • every_item — tinyint(1) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

direct_delivery_everywheres

  • id — bigint(20) — 기본 키 — NOT NULL
  • admin_member_id — bigint(20) — 외래 키 → admin_members.id — NOT NULL
  • everywhere — tinyint(1) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

direct_delivery_fees

  • id — bigint(20) — 기본 키 — NOT NULL
  • item_list_id — bigint(20) — 외래 키 — NOT NULL
  • direct_delivery_fee — int(11) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

direct_delivery_state_item_lists

  • id — bigint(20) — 기본 키 — NOT NULL
  • direct_delivery_state_id — bigint(20) — NOT NULL
  • item_list_id — bigint(20) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

direct_delivery_states

  • id — bigint(20) — 기본 키 — NOT NULL
  • direct_delivery_everywhere_id — bigint(20) — 외래 키 → direct_delivery_everywheres.id — NOT NULL
  • state_id — bigint(20) — 외래 키 — NOT NULL
  • every_city — tinyint(1) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp