ERD-USHOP

Tables (50)

banknames

  • BANK_ID — int(5) — Primary key — NOT NULL
  • BANK_COUNTRY — varchar(5) — NOT NULL
  • BANK_CODE — varchar(5) — NOT NULL
  • BANK_CODE_SHORT — varchar(20) — NOT NULL
  • BANK_NAME — varchar(150) — NOT NULL
  • BANK_NAME_ENG — varchar(150) — NOT NULL

city

  • id — int(11) — Primary key — NOT NULL
  • return_address_roman — text — NOT NULL
  • search_address_roman — text — NOT NULL
  • return_address_native — text — NOT NULL
  • search_address_native — text — NOT NULL
  • country_code — text — NOT NULL
  • zip — text — NOT NULL
  • city_roman — text — NOT NULL
  • sub1_roman — text — NOT NULL
  • sub2_roman — text — NOT NULL
  • sub3_roman — text — NOT NULL
  • city_native — text — NOT NULL
  • sub1_native — text — NOT NULL
  • sub2_native — text — NOT NULL
  • sub3_native — text — NOT NULL

data_broker

  • id — varchar(32) — Primary key — NOT NULL
  • createdAt — datetime — NOT NULL
  • createdBy — text — NOT NULL
  • payload — mediumtext — NOT NULL
  • expire — datetime

datafeed_sg

  • DATA_ID — int(11) — Primary key — NOT NULL
  • TRANSACTION_ID — varchar(10) — NOT NULL
  • TXN_STATUS — varchar(10) — NOT NULL
  • TXN_SIGNATURE — text — NOT NULL
  • AUTH_ID — varchar(10) — NOT NULL
  • TRAN_DATE — datetime — NOT NULL
  • SALES_DATE — datetime — NOT NULL
  • RESPONSE_CODE — varchar(10) — NOT NULL
  • MERCHANT_TRANID — varchar(20) — NOT NULL

delivery_config_ph

  • id — int(11) — Primary key — NOT NULL
  • value — tinyint(1) — NOT NULL
  • title — varchar(11) — NOT NULL
  • date_created — date — NOT NULL
  • date_modified — date — NOT NULL
  • added_by — varchar(11) — NOT NULL

dhl_awb

  • id — int(11) — Primary key — NOT NULL
  • order_ref — varchar(50) — NOT NULL
  • order_number — varchar(50) — NOT NULL
  • AirwayBillNumber — varchar(50) — NOT NULL
  • time_stamp — timestamp — NOT NULL

email_subscription

  • id — int(11) — Primary key — NOT NULL
  • country — text — NOT NULL
  • email — text — NOT NULL
  • clock — datetime — NOT NULL

item_sales_price_rank

  • id — int(11) — Primary key — NOT NULL
  • country_code — varchar(20) — NOT NULL
  • item_code — varchar(20) — NOT NULL
  • sales_price — decimal(11,2)
  • sales_price_rank — decimal(11,2)
  • stamp_created — timestamp
  • stamp_updated — timestamp

item_sales_rank

  • id — int(11) — Primary key — NOT NULL
  • country_code — varchar(20) — NOT NULL
  • item_code — varchar(20) — NOT NULL
  • sales_count — decimal(11,2)
  • sales_rank — decimal(11,2)
  • stamp_created — timestamp
  • stamp_updated — timestamp

item_weighted_sales_count_rank

  • id — int(11) — Primary key — NOT NULL
  • country_code — varchar(20) — NOT NULL
  • item_code — varchar(20) — NOT NULL
  • Weighted_sales_count — decimal(11,2)
  • Weighted_sales_count_rank — decimal(11,2)
  • stamp_created — timestamp
  • stamp_updated — timestamp

item_weighted_sales_price_rank

  • id — int(11) — Primary key — NOT NULL
  • country_code — varchar(20) — NOT NULL
  • item_code — varchar(20) — NOT NULL
  • Weighted_sales_price — decimal(20,2)
  • Weighted_sales_price_rank — decimal(11,2)
  • stamp_created — timestamp
  • stamp_updated — timestamp

kr_devtable

  • table_name — varchar(30) — Primary key — NOT NULL
  • key_name — varchar(30)
  • order_by — varchar(255)
  • where — varchar(255)

log

  • id — int(11) — Primary key — NOT NULL
  • message — text — NOT NULL
  • response — text
  • url — text
  • clock — datetime — NOT NULL

lsb

  • dist_id — text — NOT NULL
  • country_code — varchar(3) — NOT NULL
  • period — text — NOT NULL
  • type — text — NOT NULL
  • points — text — NOT NULL
  • balance — text — NOT NULL

mockup_adapter_api

  • id — int(11) — Primary key — NOT NULL
  • createdAt — datetime — NOT NULL
  • mockupType — text — NOT NULL
  • data — mediumtext — NOT NULL
  • usageCounter — int(11) — NOT NULL

offline_db

  • payment_number — int(11) — Primary key — NOT NULL
  • itx_order_number — varchar(11) — NOT NULL
  • source — text — NOT NULL
  • reference_no — varchar(40) — NOT NULL
  • security_code — varchar(11) — NOT NULL
  • need_security_code — text — NOT NULL
  • token — text — NOT NULL
  • to_api — text — NOT NULL
  • from_api — text — NOT NULL
  • clock — datetime — NOT NULL

ph_delivery_api

  • id — int(11) — Primary key — NOT NULL
  • shipping_method — varchar(45)
  • success — varchar(45)
  • order_count — int(11)
  • status — tinyint(11)
  • current_time — datetime
  • current_day — datetime

ph_gift_wrap

  • id — int(11) — Primary key — NOT NULL
  • gift_wrap_date_created — datetime
  • order_created — datetime
  • order_id — varchar(45)
  • ba_name — varchar(45)
  • ba_id — varchar(45)
  • ba_shipping_address — varchar(100)
  • order_total_pv — int(11)
  • gift_quantity — varchar(45)
  • gift_identical — varchar(100)
  • gift_bag_1 — varchar(500)
  • gift_bag_2 — varchar(500)
  • gift_bag_3 — varchar(500)
  • gift_bag_4 — varchar(500)
  • gift_bag_5 — varchar(500)
  • gift_bag_6 — varchar(500)
  • gift_bag_7 — varchar(500)
  • gift_bag_8 — varchar(500)
  • gift_bag_9 — varchar(500)
  • gift_bag_10 — varchar(500)
  • gift_bag_11 — varchar(500)
  • gift_bag_12 — varchar(500)
  • gift_bag_13 — varchar(500)
  • gift_bag_14 — varchar(500)
  • gift_bag_15 — varchar(500)
  • gift_bag_16 — varchar(500)
  • gift_bag_17 — varchar(500)
  • gift_bag_18 — varchar(500)
  • gift_bag_19 — varchar(500)
  • gift_bag_20 — varchar(500)
  • gift_bag_21 — varchar(500)
  • gift_bag_22 — varchar(500)
  • gift_bag_23 — varchar(500)
  • gift_bag_24 — varchar(500)
  • gift_bag_25 — varchar(500)
  • gift_bag_26 — varchar(500)
  • gift_bag_27 — varchar(500)
  • gift_bag_28 — varchar(500)
  • gift_bag_29 — varchar(500)
  • gift_bag_30 — varchar(500)

ph_health_employees

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(45)
  • gender — varchar(45)
  • contact_number — varchar(45)
  • residence — varchar(45)

ph_health_residence

  • id — int(11) — Primary key — NOT NULL
  • city — varchar(45)

ph_healthcheck_reports

  • id — int(11) — Primary key — NOT NULL
  • hc_date_stamp — datetime
  • hc_date_updated — datetime
  • hc_name — varchar(45)
  • hc_gender — varchar(45)
  • hc_mobile — varchar(45)
  • hc_residence — varchar(200)
  • hc_temperature — varchar(45)
  • hc_q1 — varchar(45)
  • hc_q2 — varchar(45)
  • hc_q3 — varchar(45)
  • hc_q4 — varchar(45)
  • hc_q5 — varchar(45)
  • hc_q6 — varchar(45)
  • hc_q7 — varchar(45)
  • hc_q8 — varchar(45)
  • hc_quiz_q1 — varchar(45)
  • hc_quiz_q2 — varchar(45)
  • hc_quiz_q3 — varchar(45)
  • hc_quiz_q4 — varchar(45)
  • hc_quiz_q5 — varchar(45)
  • hc_quiz_q6 — varchar(45)
  • hc_quiz_q7 — varchar(45)
  • hc_quiz_q8 — varchar(45)
  • hc_quiz_q9 — varchar(45)
  • hc_quiz_q10 — varchar(45)
  • hc_quiz_q11 — varchar(45)
  • hc_total_score — int(11)

ph_ship_lbc_branch

  • Branch_id — int(11) — Primary key — NOT NULL
  • City_id — int(11) — Foreign key → ph_ship_lbc_city.City_id
  • Branch_name — varchar(255)
  • Branch_address — varchar(255)
  • Branch_URL — varchar(255)
  • Branch_status — int(11)

ph_ship_lbc_city

  • City_id — int(11) — Primary key — NOT NULL
  • Province_Id — int(11) — Foreign key → ph_ship_lbc_province.Province_Id
  • City_name — varchar(255)
  • City_status — int(11)

ph_ship_lbc_province

  • Province_Id — int(11) — Primary key — NOT NULL
  • Province_name — varchar(255)
  • PR_status — int(11)

ph_ushop_shipping_methods

  • id — int(11) — Primary key — NOT NULL
  • shipping_method — varchar(150)
  • shipping_type — varchar(45)
  • shipping_nice_name — varchar(45)
  • shipping_delivery_type — varchar(45)
  • shipping_location — varchar(45)
  • shipping_href_params — varchar(150)
  • status — tinyint(4)

priority_products

  • id — int(11) — Primary key — NOT NULL
  • product_id — int(11) — NOT NULL
  • country — varchar(3) — NOT NULL
  • sort — int(11) — NOT NULL

products

  • id — int(11) — Primary key — NOT NULL
  • country_code — char(3) — NOT NULL
  • item_code — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — tinytext — NOT NULL
  • updated_at — datetime
  • updated_by — tinytext
  • is_archive — tinyint(1) — NOT NULL
  • is_service_item — tinyint(1) — NOT NULL
  • is_liquefy — tinyint(1) — NOT NULL
  • is_renewal — tinyint(1) — NOT NULL
  • is_renewal_sellable — tinyint(1) — NOT NULL
  • is_starter_kit — tinyint(1) — NOT NULL
  • is_starter_kit_sellable — tinyint(1) — NOT NULL
  • allow_unipower — tinyint(1) — NOT NULL
  • allow_shop — tinyint(1) — NOT NULL
  • allow_enroll — tinyint(1) — NOT NULL
  • allow_cs — tinyint(1) — NOT NULL
  • allow_as — tinyint(1) — NOT NULL
  • only_status_list — text
  • product_sorting — int(11)
  • item_name_english — text — NOT NULL
  • item_name_native — text — NOT NULL
  • item_info_list_english — mediumtext — NOT NULL
  • item_info_list_native — mediumtext — NOT NULL
  • price_wholesale — decimal(18,2)
  • price_retail — decimal(18,2)
  • price_preferred — decimal(18,2)
  • price_employee — decimal(18,2)
  • pv — int(11)
  • image_url — text
  • remarks — text

products_categories

  • id — int(11) — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — tinytext — NOT NULL
  • updated_at — datetime
  • updated_by — tinytext
  • country_code — char(3) — NOT NULL
  • name_english — varchar(255) — NOT NULL
  • name_native — varchar(255) — NOT NULL
  • sorting — int(11)

products_inventory

  • id — int(11) — Primary key — NOT NULL
  • warehouse_id — int(11) — NOT NULL
  • product_id — int(11) — NOT NULL
  • is_enable — tinyint(1) — NOT NULL
  • is_allow_backorder — tinyint(1) — NOT NULL
  • updated_qty_at — datetime
  • qty_available — int(11) — NOT NULL
  • qty_buffer — int(11) — NOT NULL

products_mapping_categories

  • country_code — char(3) — Primary key — NOT NULL
  • category_id — int(11) — Primary key — NOT NULL
  • product_id — int(11) — Primary key — NOT NULL

products_mapping_tags

  • product_id — int(11) — Primary key — NOT NULL
  • tag_id — int(11) — Primary key — NOT NULL

products_request_counter

  • country_code — char(3) — Primary key — NOT NULL
  • hit — int(11) — NOT NULL
  • updated_qty_at — datetime
  • updated_qty_second — smallint(6)

products_tags

  • id — int(11) — Primary key — NOT NULL
  • created_at — datetime — NOT NULL
  • created_by — tinytext — NOT NULL
  • updated_at — datetime — NOT NULL
  • updated_by — tinytext — NOT NULL
  • name — varchar(255) — NOT NULL
  • is_system_tags — tinyint(1) — NOT NULL
  • sorting — int(11)
  • style_color — tinytext
  • style_background_color — tinytext
  • text_EN — tinytext — NOT NULL
  • text_AR — tinytext — NOT NULL
  • text_HK — tinytext — NOT NULL
  • text_ID — tinytext — NOT NULL
  • text_JP — tinytext — NOT NULL
  • text_KH — tinytext — NOT NULL
  • text_KR — tinytext — NOT NULL
  • text_LA — tinytext — NOT NULL
  • text_MM — tinytext — NOT NULL
  • text_TH — tinytext — NOT NULL
  • text_TW — tinytext — NOT NULL
  • text_VN — tinytext — NOT NULL

products_warehouses

  • id — int(11) — Primary key — NOT NULL
  • country_code — char(3) — NOT NULL
  • warehouse_name — varchar(255) — NOT NULL
  • warehouse_type — varchar(255) — NOT NULL
  • is_default — tinyint(1) — NOT NULL

promo

  • id — int(11) — Primary key — NOT NULL
  • type — varchar(10)
  • country_code — varchar(11) — NOT NULL
  • title — varchar(100)
  • body — text
  • image_url — varchar(255)
  • mobile_image_url — varchar(255)
  • link — varchar(255)
  • button — varchar(255)
  • text_position — varchar(50)
  • is_active — int(1) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

promo_read

  • id — int(11) — Primary key — NOT NULL
  • promo_id — int(11) — Foreign key → promo.id — NOT NULL
  • user_id — int(11) — NOT NULL
  • is_read — int(11) — NOT NULL
  • read_at — datetime — NOT NULL

provinces

  • PROVINCE_ID — int(5) — Primary key — NOT NULL
  • PROVINCE_CODE — varchar(2) — NOT NULL
  • PROVINCE_NAME — varchar(150) — NOT NULL
  • PROVINCE_NAME_ENG — varchar(150) — NOT NULL
  • GEO_ID — int(5) — NOT NULL

remote_storage

  • keyData — varchar(255) — Primary key — NOT NULL
  • valueData — mediumtext — NOT NULL
  • updatedAt — datetime — NOT NULL

request_cache

  • tag — varchar(255) — Primary key — NOT NULL
  • id — varchar(255) — Primary key — NOT NULL
  • timestamp — datetime — NOT NULL
  • value — mediumtext — NOT NULL
  • baId — varchar(50) — NOT NULL
  • requestData — mediumtext
  • usageCounter — int(11) — NOT NULL

sms_log

  • id — int(11) — Primary key — NOT NULL
  • number — varchar(50) — NOT NULL
  • msg — text — NOT NULL
  • result — text — NOT NULL

th_event_allowed_ba

  • id — int(11) — Primary key — NOT NULL
  • ba_id — varchar(100)
  • created_date — datetime — NOT NULL

th_event_healthcheck

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(200) — NOT NULL
  • ba_id — varchar(100)
  • id_card — varchar(20)
  • email — varchar(100)
  • mobile — varchar(100)
  • token — varchar(100)
  • registered_time — varchar(10)
  • is_cancel — varchar(1)
  • created_date — datetime — NOT NULL

th_free_enroll

  • id — int(11) — Primary key — NOT NULL
  • gov_id — varchar(100) — NOT NULL
  • request_data — text
  • done — varchar(1)
  • stamp_created — timestamp — NOT NULL

th_government_id_reenroll

  • gov_id — varchar(100) — Primary key — NOT NULL
  • used — varchar(1)

th_unishop_bioslifeair

  • id — int(11) — Primary key — NOT NULL
  • register_date — timestamp — NOT NULL
  • member_id — varchar(9) — NOT NULL
  • first_name — varchar(100)
  • last_name — varchar(100)
  • email — varchar(200)
  • address1 — varchar(200)
  • address2 — varchar(200)
  • city — varchar(200)
  • province — varchar(200)
  • zip — varchar(10)
  • big_address — text
  • country — varchar(200)
  • mobile_no — varchar(20)
  • order_no — varchar(50)
  • purchase_date — date — NOT NULL
  • serial_no — varchar(12) — NOT NULL
  • warehouse — varchar(200) — Unicity H.Q.| DSC
  • purchase_location — varchar(200)

th_unishop_bioslifeair_serialno

  • id — int(11) — Primary key — NOT NULL
  • serial_no — varchar(12) — NOT NULL
  • status — int(1) — NOT NULL — 0=In-active, 1=active

topup

  • id — int(11) — Primary key — NOT NULL
  • country — text — NOT NULL
  • system — text — NOT NULL
  • topup_date — text — NOT NULL

trips

  • id — int(11) — Primary key — NOT NULL
  • country_code — char(3) — NOT NULL
  • ba_fullname — varchar(255) — NOT NULL
  • ba_number — varchar(20) — NOT NULL
  • pre_point — varchar(255)
  • created_at — datetime — NOT NULL

ulink_enroll_state

  • id — int(11) — Primary key — NOT NULL
  • reference_id — varchar(100) — NOT NULL
  • payment_reference_id — varchar(100)
  • country_code — varchar(3)
  • enroller_id — varchar(100)
  • sponsor_id — varchar(100)
  • new_id — varchar(100)
  • step_select_products — text
  • step_order_details — text
  • created_date — timestamp — NOT NULL
  • updated_date — timestamp — NOT NULL

unipower_confirmed_token

  • id — int(11) — Primary key — NOT NULL
  • reference_id — varchar(100) — NOT NULL
  • from_id — varchar(50)
  • to_id — varchar(50) — NOT NULL
  • type — varchar(100)
  • token — varchar(255) — NOT NULL
  • is_activated — tinyint(1)
  • stamp_created — timestamp — NOT NULL
  • stamp_updated — timestamp