AED_ERD

Tables (4)

Copy Of Copy Of Copy Of product_lists (product_details)

  • id — serial — Primary key — NOT NULL
  • create_dt — timestamptz
  • update_dt — timestamptz
  • status — varchar
  • currency — varchar
  • locale — varchar
  • title — varchar
  • product_url — varchar
  • product_id — varchar
  • status_id — varchar
  • ship_to — varchar
  • total_stock — int4
  • total_orders — int4
  • wishlist_count — int4
  • unit_name — varchar
  • unit_name_plural — varchar
  • units_per_product — int4
  • has_purchase_limit — bool
  • max_purchase_limit — int4
  • processing_time_in_days — int4
  • has_single_price — bool
  • has_attributes — bool
  • has_reviews_ratings — bool
  • has_properties — bool
  • has_variations — bool
  • html_description — varchar
  • product_images — json
  • product_category — json
  • seller — json
  • seller_details — json
  • price_summary — json
  • attributes — json
  • reviews_ratings — json
  • properties — json
  • variations — json
  • shipping — json
  • price — json

Copy Of Copy Of product_lists (users)

  • id — serial — Primary key — NOT NULL
  • create_dt — timestamptz
  • update_dt — timestamptz
  • first_name — varchar(30)
  • last_name — varchar(30)
  • email — varchar(255)
  • password — varchar(60)

Copy Of product_lists (search_texts)

  • id — serial — Primary key — NOT NULL
  • create_dt — timestamptz
  • update_dt — timestamptz
  • text — varchar
  • page — int4

product_lists

  • Key (id) — serial — Primary key — NOT NULL
  • search_text_id — int4 — Foreign key → Copy Of product_lists.id — NOT NULL
  • Field2 (create_dt) — timestamptz
  • Field (update_dt) — timestamptz
  • Field (information) — json