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