ncomm
Tables (50)
api_line
- api_line_id — int(10) — Primary key — NOT NULL
- line_token — varchar(200) — NOT NULL
- line_active_status — int(11) — NOT NULL
- last_update — timestamp — NOT NULL
api_midtrans
- id_midtrans — int(10) — Primary key — NOT NULL
- production_server_key — text — NOT NULL
- production_client_key — text — NOT NULL
- sandbox_server_key — text — NOT NULL
- sandbox_client_key — text — NOT NULL
- production_javascript_link — text — NOT NULL
- sandbox_javascript_link — text — NOT NULL
- midtrans_payment_method — text — NOT NULL
- active_midtrans — int(11) — NOT NULL
- active_production_status — int(11) — NOT NULL
- update_date — timestamp — NOT NULL
api_shipping
- shipping_id — int(10) — Primary key — NOT NULL
- shipping_api_name — varchar(200) — NOT NULL
- shipping_api_acc — text — NOT NULL
- create_date — timestamp — NOT NULL
blog_category
- blog_category_id — int(10) — Primary key — NOT NULL
- blog_category_name — varchar(45)
blog_category_details
- blog_category_details_id — int(10) — Primary key — NOT NULL
- blog_category_details_title — varchar(45)
- blog_category_details_review — text — NOT NULL
- blog_category_details_description — text
- blog_category_details_image — varchar(200)
- blog_author — varchar(200) — NOT NULL
- blog_category_details_create_date — datetime
- viewers_blog — int(11) — NOT NULL
- blog_category_blog_category_id — int(10) — Foreign key → blog_category.blog_category_id — NOT NULL
collections
- id — int(10) — Primary key — NOT NULL
- name — varchar(45)
- slug — varchar(250)
- img — varchar(45)
contactAddress
- idstoreAddress — int(10) — Primary key — NOT NULL
- phone — varchar(45)
- email — varchar(45)
- address — text
- addressTitle — varchar(45)
- addressStatus — varchar(45)
contact_message
- contact_message_id — int(10) — Primary key — NOT NULL
- contact_name — varchar(150) — NOT NULL
- contact_email — varchar(200) — NOT NULL
- contact_subject — varchar(100) — NOT NULL
- contact_message — text — NOT NULL
- message_date — datetime — NOT NULL
defaultCurrency
- iddefaultCurrency — int(10) — Primary key — NOT NULL
- currency — varchar(45)
email_api
- email_api_id — int(10) — Primary key — NOT NULL
- email_api_protocol — varchar(191) — NOT NULL
- email_api_smtphost — varchar(191) — NOT NULL
- email_api_smtpuser — varchar(191) — NOT NULL
- email_api_smtppassword — varchar(191) — NOT NULL
- email_api_smtpport — varchar(191) — NOT NULL
- email_api_sender — varchar(191) — NOT NULL
email_checkout_setting
- email_checkout_id — int(10) — Primary key — NOT NULL
- email_subject_cust — varchar(200) — NOT NULL
- email_description_message_cust — text — NOT NULL
- email_receiver — varchar(200) — NOT NULL
- email_subject_owner — varchar(200) — NOT NULL
- email_description_message_owner — text — NOT NULL
email_confirmation_payment
- email_confirmation_id — int(10) — Primary key — NOT NULL
- conf_subject_customer — varchar(250) — NOT NULL
- conf_message_customer — text — NOT NULL
- conf_subject_owner — varchar(250) — NOT NULL
- conf_message_owner — text — NOT NULL
email_contact
- email_contact_id — int(10) — Primary key — NOT NULL
- customer_subject_contact — varchar(250) — NOT NULL
- customer_content — text — NOT NULL
- owner_subject — varchar(250) — NOT NULL
- owner_content — text — NOT NULL
email_forgot_password
- email_forgot_password — int(10) — Primary key — NOT NULL
- forgot_content — text — NOT NULL
- forgot_subject — text — NOT NULL
email_registration_user
- id_email — int(10) — Primary key — NOT NULL
- email_content_customer — text — NOT NULL
- subject_customer — text — NOT NULL
- email_content_owner — text — NOT NULL
- subject_owner — text — NOT NULL
email_shipping_code
- email_shop_code_id — int(10) — Primary key — NOT NULL
- email_subject — text — NOT NULL
- shipping_content — text — NOT NULL
failed_jobs
- id — bigint(20) — Primary key — NOT NULL
- connection — text — NOT NULL
- queue — text — NOT NULL
- payload — longtext — NOT NULL
- exception — longtext — NOT NULL
- failed_at — timestamp — NOT NULL
feature_slider
- slider_id — int(10) — Primary key — NOT NULL
- slider_title — varchar(250) — NOT NULL
- slider_image — varchar(250) — NOT NULL
- slider_content — text — NOT NULL
- btn_name — varchar(250) — NOT NULL
- btn_url — text — NOT NULL
- status — int(11) — NOT NULL
- slider_position — int(11) — NOT NULL
- last_update — timestamp — NOT NULL
feature_subscribe_user
- id_subsciber — int(10) — Primary key — NOT NULL
- subscribe_email — varchar(200) — NOT NULL
- time_added — timestamp — NOT NULL
footerScript
- footerScriptId — int(10) — Primary key — NOT NULL
- footerScript — text — NOT NULL
- footerScriptStatus — tinyint(4) — NOT NULL
headerScript
- headerScript_id — int(10) — Primary key — NOT NULL
- headerScript — text — NOT NULL
- headerStatus — tinyint(4) — NOT NULL
layer2_result_question
- id_layer2_question — int(10) — Primary key — NOT NULL
- funding_are_you_looking_for — text — NOT NULL
- type_of_collateral — text — NOT NULL
- expecting_to_pay — text — NOT NULL
- typical_maturity_you_are_expecting — text — NOT NULL
- ideally_need_the_money — text — NOT NULL
- need_beyond_the_capital — text — NOT NULL
- available_for_a_program — text — NOT NULL
- program_you_are_expecting — text — NOT NULL
- gender_approach — text — NOT NULL
- are_you_Indonesian — text — NOT NULL
- legal_status_of_your_company — text — NOT NULL
- add_time — timestamp — NOT NULL
- layer1_question_result — int(11) — NOT NULL
login_attempts
- idlogin_attempts — int(11) — Primary key — NOT NULL
- ip — varchar(50) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
mergeLocationCurrency
- id — int(10) — Primary key — NOT NULL
- fk_currency — int(10) — Foreign key → tb_currency.id — NOT NULL
- fk_warehouse — int(10) — Foreign key — NOT NULL
mergeProductInformation
- id — int(10) — Primary key — NOT NULL
- fk_product_information — int(10) — Foreign key → productInformation.id — NOT NULL
- fk_product — int(10) — Foreign key → tb_product.id — NOT NULL
merge_image_product
- id — int(10) — Primary key — NOT NULL
- fk_product — int(10) — Foreign key → tb_product.id — NOT NULL
- fk_img — int(10) — Foreign key → prod_img.id — NOT NULL
- img_position — int(11)
merge_warehouse_product
- id — int(10) — Primary key — NOT NULL
- fk_merge_currency — int(10) — Foreign key → mergeLocationCurrency.id — NOT NULL
- fk_product — int(10) — Foreign key → tb_product.id — NOT NULL
- price — int(11)
- discount — int(11)
- product_status — tinyint(4)
- discount_status — tinyint(4)
- featured_status — tinyint(4)
- soldout_status — tinyint(4)
- new_status — tinyint(4)
migrations
- id — int(10) — Primary key — NOT NULL
- migration — varchar(191) — NOT NULL
- batch — int(11) — NOT NULL
pages_about
- pages_about_id — int(10) — Primary key — NOT NULL
- pages_title — text — NOT NULL
- pages_about_content — text — NOT NULL
- last_update — timestamp — NOT NULL
pages_general
- pages_id — int(10) — Primary key — NOT NULL
- pages_name — text — NOT NULL
- pages_title — text — NOT NULL
- pages_content — text — NOT NULL
- pages_status — int(11) — NOT NULL
- last_update — timestamp — NOT NULL
password_resets
- email — varchar(191) — NOT NULL
- token — varchar(191) — NOT NULL
- created_at — timestamp
payment_confirmation
- payment_confirmation_id — int(10) — Primary key — NOT NULL
- payment_method — varchar(150) — NOT NULL
- amount_payment — int(11) — NOT NULL
- bank_acc_number — varchar(100) — NOT NULL
- get_orderpurchase_id — varchar(100) — NOT NULL
payment_method_transfer
- payment_method_id — int(10) — Primary key — NOT NULL
- p_bank_name — varchar(100)
- p_account_number — varchar(100)
- p_cardholder — varchar(100)
- p_bank_branch — varchar(100)
- bank_status — int(11) — NOT NULL
- crate_date — datetime
prod_img
- id — int(10) — Primary key — NOT NULL
- name — varchar(45)
- img_full_link — text
- created_at — datetime
- update_at — timestamp
productAlternative
- id — int(10) — Primary key — NOT NULL
- name — varchar(250)
- fk_product — int(10) — NOT NULL
productInformation
- id — int(10) — Primary key — NOT NULL
- title — varchar(100)
- description — text
promo_code
- promo_code_id — int(10) — Primary key — NOT NULL
- Promo_Name — text
- promo_description — text
- total_user_using_promo — int(11)
- remain_coupon_user — int(11)
- promo_code — varchar(250)
- total_promo — int(11)
- promo_target_user — int(10) — Foreign key → promo_target_user.promo_target_1 — NOT NULL
- pro_start — date
- pro_end — date
- promotion_create — date
- promo_statusid — int(10) — Foreign key → promo_status.promo_status_id — NOT NULL
- isPersentage — tinyint(4)
promo_spesific_user
- promo_spesific_id — int(10) — Primary key — NOT NULL
- promo_email — varchar(200) — NOT NULL
- promo_code_tb_id — int(10) — Foreign key → promo_code.promo_code_id — NOT NULL
promo_status
- promo_status_id — int(10) — Primary key — NOT NULL
- promo_status_name — varchar(45)
promo_target_user
- promo_target_1 — int(10) — Primary key — NOT NULL
- promo_target — text — NOT NULL
promo_user_history
- promo_history_id — int(10) — Primary key — NOT NULL
- user_email — varchar(250) — NOT NULL
- promo_id — int(10) — Foreign key → promo_code.promo_code_id — NOT NULL
- purchase_id — int(11) — NOT NULL
- using_date — datetime — NOT NULL
- tb_purchase_purchase_id — int(10) — Foreign key — NOT NULL
purchase_history
- id_history — int(10) — Primary key — NOT NULL
- history_title — text — NOT NULL
- history_description — text — NOT NULL
- update_by — varchar(250) — NOT NULL
- purchase_id — int(11) — NOT NULL
- purchase_status — int(11) — NOT NULL
- date — datetime — NOT NULL
- tb_purchase_purchase_id — int(10) — Foreign key — NOT NULL
setting_url
- url_setting_id — int(10) — Primary key — NOT NULL
- url_web — varchar(200) — NOT NULL
- url_cms — varchar(200) — NOT NULL
- urlgallery — varchar(200) — NOT NULL
- create_date — timestamp — NOT NULL
shipping_country
- ship_country_id — int(10) — Primary key — NOT NULL
- ship_country — varchar(100) — NOT NULL
store_detail
- id — int(10) — Primary key — NOT NULL
- serverclientKey — text
- name — varchar(100) — NOT NULL
- domain_name — varchar(100) — NOT NULL
- logo_dark — varchar(200) — NOT NULL
- logo_light — varchar(200) — NOT NULL
- favicon — varchar(200) — NOT NULL
- office_address — varchar(100) — NOT NULL
- province — varchar(100) — NOT NULL
- province_id — int(11) — NOT NULL
- city — varchar(100) — NOT NULL
- city_id — int(11) — NOT NULL
- zipcode — varchar(100) — NOT NULL
- country — varchar(100) — NOT NULL
- google_map — text — NOT NULL
- phone_number — varchar(100) — NOT NULL
- email — varchar(100) — NOT NULL
- email_receiver — text — NOT NULL
- taxPricePersentage — int(11)
- address — text
- fk_status — int(10) — Foreign key → store_status.id — NOT NULL
store_status
- id — int(10) — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- description — text — NOT NULL
sub_category
- id — int(10) — Primary key — NOT NULL
- name — varchar(100)
- slug — varchar(100) — NOT NULL
- fk_category — int(10) — Foreign key — NOT NULL
- fk_product — int(10) — Foreign key → tb_product.id — NOT NULL
- created_at — timestamp
- update_at — timestamp
tb_currency
- id — int(10) — Primary key — NOT NULL
- symbol — varchar(5) — NOT NULL
- name — text — NOT NULL
- rate — int(11)
- status — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
tb_product
- id — int(10) — Primary key — NOT NULL
- prod_sku — varchar(100)
- fk_collection — int(10) — Foreign key → collections.id — NOT NULL
- name — varchar(191)
- slug — varchar(191)
- description — text
- meta_data — text
- created_at — timestamp
- updated_at — timestamp
tb_product_order
- tb_product_order_id — int(10) — Primary key — NOT NULL
- o_variant_id — int(11)
- o_SKU_prod — varchar(100)
- o_SKU_per_item — varchar(200)
- o_prodname — varchar(45)
- o_prod_variant — varchar(100)
- o_prod_option_group_name — varchar(200)
- option_value_name — varchar(200)
- o_prodprice — double(8,2)
- o_real_prodprice — int(11)
- o_prod_price_currency — varchar(10)
- o_pricediscount — int(11)
- o_price_method — tinyint(4)
- o_qty — int(11)
- o_total_price — double(8,2)
- o_real_total_price — int(11)
- tb_purchase_purchase_id — int(10) — Foreign key — NOT NULL