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