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