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