먹깨비상회 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