22

Tables (10)

es_item_orders (Untitled9)

  • id (Key) — Foreign key → z_sf_item_orders.id — NOT NULL

es_order_msg_log (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • store_id (Field)
  • store_name (Field2)
  • order_id (Key2) — Foreign key → z_sf_item_orders.id — NOT NULL
  • staus (Field3)
  • requset_time (Field4)

sf_items (Untitled5)

  • id (Key) — Primary key — NOT NULL

sf_order_log (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • store_id (Field)
  • order_id (Key2) — Foreign key → z_sf_item_orders.id — NOT NULL
  • user_pk (Key3) — Foreign key → users.id — NOT NULL
  • status (Field3)
  • insert_date (Field2)

user_buy_item_aggreagtion_202011 (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_group_id — Foreign key → user_group_define.id — NOT NULL
  • item_id (Key2) — Foreign key → sf_items.id — NOT NULL
  • item_buy_count (Field)
  • item_clcik_count (Field2)
  • review_create_count (Field3)

user_cache_aggreagtion (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → users.id — NOT NULL
  • store_id (Field)
  • refund_cnt (Field13)
  • order_cnt (Field2)
  • total_price (Field3)
  • basket_cnt (Field4)
  • click_cnt (Field5)
  • update_date (Field7)
  • negative_count (Field6)
  • review_count (Field8)
  • negative (Field9)
  • positvie_count (Field10)
  • review_sore_avg (Field11)
  • base_date (Field12)

user_group_define (Untitled)

  • id — Primary key — NOT NULL
  • store_id (Field)
  • group_setting (Field2)
  • group_name (Field3)
  • is_use (Field4)
  • is_delete (Field5)
  • create_date (Field6)
  • update_date (Field8)
  • is_use_register (Field7)

user_group_list (Untitled3)

  • Key — Primary key — NOT NULL
  • store_id (Field)
  • include_type (Field2)
  • insert_date (Field4)
  • user_group_id (id) — Foreign key → user_group_define.id — NOT NULL
  • user_key (Key2) — Foreign key → users.id — NOT NULL
  • user_id (Field3)

users (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • user_Id (Field)

z_sf_item_orders (Untitled8)

  • id (Key) — Primary key — NOT NULL