test12315123151

Tables (25)

action_events

  • id — bigint(20) — Primary key — NOT NULL
  • batch_id — char(36) — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • name — varchar(255) — NOT NULL
  • actionable_type — varchar(255) — NOT NULL
  • actionable_id — bigint(20) — NOT NULL
  • target_type — varchar(255) — NOT NULL
  • target_id — bigint(20) — NOT NULL
  • model_type — varchar(255) — NOT NULL
  • model_id — bigint(20)
  • fields — text — NOT NULL
  • status — varchar(25) — NOT NULL
  • exception — text — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • original — text
  • changes — text

activity_log

  • id — bigint(20) — Primary key — NOT NULL
  • log_name — varchar(255)
  • description — text — NOT NULL
  • subject_type — varchar(255)
  • event — varchar(255)
  • subject_id — bigint(20)
  • causer_type — varchar(255)
  • causer_id — bigint(20)
  • properties — longtext
  • batch_uuid — char(36)
  • created_at — timestamp
  • updated_at — timestamp

browser

  • id — bigint(20) — Primary key — NOT NULL
  • key — varchar(255) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • job_code — int(11)
  • response — longtext
  • created_at — timestamp
  • updated_at — timestamp

category_templates

  • id — bigint(20) — Primary key — NOT NULL
  • group_name — varchar(255) — NOT NULL
  • template_name — varchar(255) — NOT NULL
  • categories — longtext — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

coupang_product_detail

  • id — bigint(20) — Primary key — NOT NULL
  • sale_started_at — datetime — NOT NULL
  • sale_ended_at — datetime — NOT NULL
  • display_product_name — varchar(255)
  • original_price — bigint(20) — NOT NULL
  • maximum_buy_for_person — int(10) — NOT NULL
  • maximum_buy_for_person_period — int(10) — NOT NULL
  • parallel_imported — enum('PARALLEL_IMPORTED','NOT_PARALLEL_IMPORTED') — NOT NULL
  • overseas_purchased — enum('OVERSEAS_PURCHASED','NOT_OVERSEAS_PURCHASED') — NOT NULL
  • offer_condition — enum('NEW','REFURBISHED','USED_BEST','USED_GOOD','USED_NORMAL') — NOT NULL
  • offer_description — varchar(255)
  • unit_count — bigint(20) — NOT NULL
  • delivery_method — enum('SEQUENCIAL','COLD_FRESH','MAKE_ORDER','AGENT_BUY','VENDOR_DIRECT') — NOT NULL
  • delivery_company_code — varchar(255) — NOT NULL
  • delivery_charge_type — enum('FREE','NOT_FREE','CHARGE_RECEIVED','CONDITIONAL_FREE') — NOT NULL
  • union_delivery_type — enum('UNION_DELIVERY','NOT_UNION_DELIVERY') — NOT NULL
  • delivery_charge — bigint(20) — NOT NULL
  • free_ship_over_amount — bigint(20) — NOT NULL
  • delivery_charge_on_return — bigint(20) — NOT NULL
  • return_charge — bigint(20) — NOT NULL
  • return_center_code — varchar(255) — NOT NULL
  • return_charge_name — varchar(255) — NOT NULL
  • company_contact_number — varchar(255) — NOT NULL
  • return_zip_code — varchar(255) — NOT NULL
  • return_address — varchar(255) — NOT NULL
  • return_address_detail — varchar(255) — NOT NULL
  • outbound_shipping_place_code — bigint(20) — NOT NULL
  • remote_area_deliverable — enum('N','Y') — NOT NULL
  • outbound_shipping_time_day — bigint(20) — NOT NULL
  • required_documents — longtext
  • extra_info_message — varchar(255)
  • manufacture — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp

media

  • id — bigint(20) — Primary key — NOT NULL
  • model_type — varchar(255) — NOT NULL
  • model_id — bigint(20) — NOT NULL
  • uuid — char(36)
  • collection_name — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • file_name — varchar(255) — NOT NULL
  • mime_type — varchar(255)
  • disk — varchar(255) — NOT NULL
  • conversions_disk — varchar(255)
  • size — bigint(20) — NOT NULL
  • manipulations — longtext — NOT NULL
  • custom_properties — longtext — NOT NULL
  • generated_conversions — longtext — NOT NULL
  • responsive_images — longtext — NOT NULL
  • order_column — int(10)
  • created_at — timestamp
  • updated_at — timestamp

migrations

  • id — int(10) — Primary key — NOT NULL
  • migration — varchar(255) — NOT NULL
  • batch — int(11) — NOT NULL

model_has_permissions

  • model_id — bigint(20) — Primary key — NOT NULL
  • model_type — varchar(255) — Primary key — NOT NULL
  • permission_id — int(10) — Foreign key → permissions.id — NOT NULL

model_has_roles

  • model_id — bigint(20) — Primary key — NOT NULL
  • model_type — varchar(255) — Primary key — NOT NULL
  • role_id — int(10) — Foreign key → roles.id — NOT NULL

naver_product_detail

  • id — bigint(20) — Primary key — NOT NULL
  • original_product — longtext — NOT NULL — (DC2Type:json)' CHECK (json_valid(`original_product`)
  • delivery_info — longtext — NOT NULL
  • detail_attribute — longtext — NOT NULL
  • customer_benefit — longtext — NOT NULL
  • window_channel_product — longtext — NOT NULL
  • smart_store_channel_product — longtext — NOT NULL
  • attribute_1 — longtext
  • attribute_2 — longtext
  • created_at — timestamp
  • updated_at — timestamp

nova_notifications

  • id — char(36) — Primary key — NOT NULL
  • type — varchar(255) — NOT NULL
  • notifiable_type — varchar(255) — NOT NULL
  • notifiable_id — bigint(20) — NOT NULL
  • data — text — NOT NULL
  • read_at — timestamp
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

nova_settings

  • id — bigint(20) — Primary key — NOT NULL
  • key — varchar(255) — NOT NULL
  • value — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp

out_bounds

  • id — bigint(20) — Primary key — NOT NULL
  • alias — varchar(255) — NOT NULL
  • post_code — varchar(255) — NOT NULL
  • address_road — varchar(255) — NOT NULL
  • address_jibun — varchar(255) — NOT NULL
  • address_detail — varchar(255)
  • primary_contact — varchar(255) — NOT NULL
  • secondary_contact — varchar(255)
  • is_origin_address_enabled — varchar(255)
  • is_return_address_enabled — varchar(255)
  • is_default_origin_address — varchar(255)
  • is_default_return_address — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp

password_resets

  • email — varchar(255) — NOT NULL
  • token — varchar(255) — NOT NULL
  • created_at — timestamp

permissions

  • id — int(10) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • group — varchar(255) — NOT NULL
  • guard_name — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

posts

  • id — bigint(20) — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • body — varchar(255) — NOT NULL
  • user_id — bigint(20) — Foreign key → users.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

product_add_parts

  • id — bigint(20) — Primary key — NOT NULL
  • add_part_name — varchar(255) — NOT NULL
  • option_name — varchar(255) — NOT NULL
  • add_part_price — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

product_delivery_options

  • id — bigint(20) — Primary key — NOT NULL
  • shipping_address — varchar(255) — NOT NULL
  • delivery_available_area — varchar(255) — NOT NULL
  • delivery_type — varchar(255) — NOT NULL
  • delivery_property — varchar(255) — NOT NULL
  • naver_delivery_property — varchar(255)
  • gmarket_oc_delivery_property — varchar(255)
  • coupang_delivery_property — varchar(255)
  • delivery_price_type — varchar(255) — NOT NULL
  • delivery_price — int(11) — NOT NULL
  • delivery_add_price — int(11)
  • delivery_company — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

products

  • id — bigint(20) — Primary key — NOT NULL
  • product_management_code — varchar(14) — NOT NULL
  • parent_product_id — bigint(20)
  • product_status — enum('SALE_PENDING','ON_SALE','EDIT_PENDING','CLOSE_PENDING','APPROVAL_PENDING','REJECTED','SOLDOUT','SUSPENDED')
  • commerce_id — bigint(20)
  • categoriable_id — bigint(20)
  • categoriable_type — varchar(255)
  • detailable_id — bigint(20)
  • detailable_type — varchar(255)
  • commerce_product_id — varchar(255)
  • leaf_category_id — bigint(20)
  • product_name — varchar(255) — NOT NULL
  • product_sale_price — bigint(20) — NOT NULL
  • stock_quantity — bigint(20) — NOT NULL
  • representative_image — varchar(255) — NOT NULL
  • additional_images — longtext
  • option — longtext
  • option_temp — longtext
  • origin_information — longtext — NOT NULL
  • tax_type — enum('TAX','DUTY_FREE','SMALL','NONE') — NOT NULL
  • delivery_information — longtext — NOT NULL
  • announcement_information — longtext — NOT NULL
  • is_minor_purchasable — tinyint(1) — NOT NULL
  • manufacturing_date — datetime
  • expiration_date — datetime
  • keyword — varchar(255)
  • content — longtext — NOT NULL
  • is_oversea_delivery_enabled — tinyint(1) — NOT NULL
  • brand — varchar(255)
  • barcode — varchar(255)
  • isbn_code — longtext
  • free_gift — longtext
  • certification_information — longtext
  • hs_code — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • category_template_id — int(10)

role_has_permissions

  • permission_id — int(10) — Foreign key → permissions.id — NOT NULL
  • role_id — int(10) — Foreign key → roles.id — NOT NULL

roles

  • id — int(10) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • guard_name — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

settlements

  • id — bigint(20) — Primary key — NOT NULL
  • bank_code_id — int(10) — NOT NULL
  • username — varchar(255) — NOT NULL
  • account_number — varchar(255) — NOT NULL
  • passbook_file — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • is_default — tinyint(1) — NOT NULL

user_accounts

  • id — varchar(255) — Primary key — NOT NULL
  • user_id — char(36) — NOT NULL
  • provider — varchar(255) — NOT NULL
  • token — varchar(255) — NOT NULL
  • refresh_token — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp

user_has_commerces

  • id — bigint(20) — Primary key — NOT NULL
  • commerce_id — bigint(20) — NOT NULL
  • is_active — tinyint(1) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

users

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • email_verified_at — timestamp
  • password — varchar(255) — NOT NULL
  • remember_token — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp