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