v2
Tables (35)
cart_cart
- id — bigint — Primary key — NOT NULL
- doc_id — varchar(50) — NOT NULL
- product_type — varchar(10) — NOT NULL
- size1 — varchar(10)
- size2 — varchar(10)
- thickness1 — varchar(10)
- thickness2 — varchar(10)
- end1 — varchar(50)
- end2 — varchar(50)
- coating — varchar(50)
- pressure_rating — varchar(50)
- bore — varchar(50)
- stem — varchar(50)
- seat — varchar(50)
- operating_type — varchar(50)
- trim_no — varchar(50)
- disc — varchar(50)
- plug — varchar(50)
- bonnet_type — varchar(50)
- length — decimal(20,2)
- quantity — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_id — bigint — Foreign key → user_user.id
estimate_availableitem
- id — bigint — Primary key — NOT NULL
- material_description — longtext — NOT NULL
- quantity — int — NOT NULL
- category_id — bigint — Foreign key → user_categoryclosure.id — NOT NULL
- estimate_id — bigint — Foreign key → estimate_estimate.id — NOT NULL
estimate_cartitem
- id — bigint — Primary key — NOT NULL
- doc_id — varchar(50) — NOT NULL
- product_type — varchar(10) — NOT NULL
- size1 — varchar(10)
- size2 — varchar(10)
- thickness1 — varchar(10)
- thickness2 — varchar(10)
- end1 — varchar(50)
- end2 — varchar(50)
- coating — varchar(50)
- pressure_rating — varchar(50)
- bore — varchar(50)
- stem — varchar(50)
- seat — varchar(50)
- operating_type — varchar(50)
- trim_no — varchar(50)
- disc — varchar(50)
- plug — varchar(50)
- bonnet_type — varchar(50)
- length — decimal(20,2)
- quantity — int
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- estimate_id — bigint — Foreign key → estimate_estimate.id
- user_id — bigint — Foreign key → user_user.id
estimate_estimate
- id — bigint — Primary key — NOT NULL
- estimate_type — int — NOT NULL
- item_type — int — NOT NULL
- estimate_status — int — NOT NULL
- process_status — int — NOT NULL
- is_auto_price — tinyint(1)
- created_at — datetime(6) — NOT NULL
- reject_reason — longtext
- admin_note — longtext
- manager_id — bigint — Foreign key → user_user.id
- user_id — bigint — Foreign key → user_user.id
- rfq_number — varchar(20)
- is_notified — tinyint(1) — NOT NULL
estimate_estimateinvitation
- id — bigint — Primary key — NOT NULL
- expire_time — datetime(6) — NOT NULL
- is_give_up — tinyint(1) — NOT NULL
- give_up_reason — longtext
- category_id — bigint — Foreign key → user_categoryclosure.id
- estimate_id — bigint — Foreign key → estimate_estimate.id
- user_id — bigint — Foreign key → user_user.id
estimate_fileitem
- id — bigint — Primary key — NOT NULL
- request_file — varchar(100)
- estimate_id — bigint — Foreign key → estimate_estimate.id
estimate_productprice
- id — bigint — Primary key — NOT NULL
- product_type — varchar(50) — NOT NULL
- total_quantity — int — NOT NULL
- supply_price — int — NOT NULL
- vat — int — NOT NULL
- total_price — int — NOT NULL
- estimate_id — bigint — Foreign key → estimate_requestestimate.id
estimate_project
- id — bigint — Primary key — NOT NULL
- project_name — varchar(100) — NOT NULL
- end_user — varchar(100) — NOT NULL
- bid_closing_date — date — NOT NULL
- required_delivery_date — date
- restricted_country — varchar(100)
- terms_of_payment — varchar(255)
- shipping_area — varchar(100)
- is_loading — tinyint(1) — NOT NULL
- approved_vendor_list — varchar(100)
- additional_request — varchar(100)
- additional_request_text — longtext
- estimate_id — bigint — Foreign key → estimate_estimate.id
estimate_reqitem
- id — bigint — Primary key — NOT NULL
- unit_price — int
- supply_price — int
- quantity — int
- available_item_id — bigint — Foreign key → estimate_availableitem.id
- estimate_id — bigint — Foreign key → estimate_requestestimate.id
- total_price — int
- vat — int
estimate_requestestimate
- id — bigint — Primary key — NOT NULL
- expiry_date — date — NOT NULL
- delivery_date — date — NOT NULL
- delivery_condition — longtext
- terms_of_payment — longtext
- note — longtext
- additional_request — varchar(100)
- supply_price — int — NOT NULL
- vat — int — NOT NULL
- total_price — int — NOT NULL
- reject_reason — longtext
- created_at — datetime(6) — NOT NULL
- estimate_id — bigint — Foreign key → estimate_estimate.id
- user_id — bigint — Foreign key → user_user.id
- admin_reject_reason — longtext
- estimate_status — int — NOT NULL
estimate_resestimateuser
- id — bigint — Primary key — NOT NULL
- req_estimate_id — bigint — Foreign key → estimate_requestestimate.id
- res_estimate_id — bigint — Foreign key → estimate_responseestimate.id
estimate_resitem
- id — bigint — Primary key — NOT NULL
- unit_price — int
- supply_price — int
- quantity — int
- material_description — longtext
- margin_price — int
- estimate_id — bigint — Foreign key → estimate_responseestimate.id
- total_price — int
- vat — int
estimate_responseestimate
- id — bigint — Primary key — NOT NULL
- estimate_type — int — NOT NULL
- terms_of_payment — varchar(255)
- expiry_date — date
- delivery_date — date
- delivery_condition — varchar(255)
- additional_request — varchar(100)
- note — longtext
- margin_percentage — int
- estimate_id — bigint — Foreign key → estimate_estimate.id
- estimate_status — int — NOT NULL
estimate_resproductprice
- id — bigint — Primary key — NOT NULL
- product_type — varchar(50) — NOT NULL
- total_quantity — int — NOT NULL
- supply_price — int — NOT NULL
- vat — int — NOT NULL
- total_price — int — NOT NULL
- margin_price — int
- estimate_id — bigint — Foreign key → estimate_responseestimate.id
estimate_shippinginfo
- id — bigint — Primary key — NOT NULL
- driver_info — longtext
- place_of_loading — varchar(255)
- place_of_unloading — varchar(255)
- estimated_date_of_unloading — datetime(6)
- estimated_date_of_loading — datetime(6)
- additional_info — longtext
- estimate_id — bigint — Foreign key → estimate_estimate.id
notification_notification
- id — bigint — Primary key — NOT NULL
- msg_type — varchar(50) — NOT NULL
- is_processed — tinyint(1)
- user_id — bigint — Foreign key → user_user.id — NOT NULL
- extra_field — json
notification_servicenotification
- id — bigint — Primary key — NOT NULL
- is_processed — tinyint(1)
- message — longtext — NOT NULL
- user_id — bigint — Foreign key → user_user.id — NOT NULL
- created_at — datetime(6) — NOT NULL
- url — varchar(200)
- subject — longtext
product_flangedimension
- id — bigint — Primary key — NOT NULL
- pressure_rating — varchar(50) — NOT NULL
- category — varchar(50) — NOT NULL
- type2 — varchar(50) — NOT NULL
- thickness1 — varchar(50)
- size1 — varchar(50) — NOT NULL
- is_static — tinyint(1) — NOT NULL
- pre_material_weight — decimal(20,2) — NOT NULL
- fabricating_cost — int — NOT NULL
- margin — decimal(20,2) — NOT NULL
product_flangematerialgradeprice
- id — bigint — Primary key — NOT NULL
- material_grade — varchar(50) — NOT NULL
- kg_price — int — NOT NULL
- weight — decimal(20,2) — NOT NULL
- is_cs — tinyint(1) — NOT NULL
product_manufactured
- id — bigint — Primary key — NOT NULL
- category — varchar(8)
- code — varchar(50)
- item — varchar(40)
- type1 — varchar(50)
- type2 — varchar(50)
- type3 — varchar(50)
- material_grade — varchar(50)
- group — varchar(50)
- material — varchar(50)
- size1 — varchar(50)
- size2 — varchar(50)
- thickness1 — varchar(50)
- thickness2 — varchar(50)
- end1 — varchar(50)
- end2 — varchar(50)
- coating — varchar(50)
- pressure_rating — varchar(50)
- bonnet_type — varchar(50)
- bore — varchar(50)
- stem — varchar(50)
- seat — varchar(50)
- trim_no — varchar(50)
- operating_type — varchar(50)
- disc — varchar(20)
- plug — varchar(20)
product_manufacturedspec
- id — bigint — Primary key — NOT NULL
- is_certified — tinyint(1)
- is_drawing_report — tinyint(1)
- is_hydro_report — tinyint(1)
- is_material_report — tinyint(1)
- is_scratched — tinyint(1)
- is_rusted — tinyint(1)
- is_dented — tinyint(1)
- certi_file — varchar(100)
- drawing_report_file — varchar(100)
- hydro_report_file — varchar(100)
- material_report_file — varchar(100)
- manufactured_date — date
- grade — varchar(1)
- created_at — datetime(6) — NOT NULL
- manufactured_id — bigint — Foreign key → product_manufactured.id — NOT NULL
- seller_id — bigint — Foreign key → user_user.id — NOT NULL
product_pipebasematerialgradeprice
- id — bigint — Primary key — NOT NULL
- base_price — int — NOT NULL
- updated_at — date — NOT NULL
product_pipematerialgradeprice
- id — bigint — Primary key — NOT NULL
- material_grade — varchar(50) — NOT NULL
- price_ratio — decimal(20,3) — NOT NULL
- weight_factor — decimal(20,16) — NOT NULL
product_pipesizethicknessprice
- id — bigint — Primary key — NOT NULL
- size1 — varchar(10) — NOT NULL
- thickness1 — varchar(10) — NOT NULL
- price — int — NOT NULL
- od_wall — decimal(20,4) — NOT NULL
search_materialgrade
- id — bigint — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- product_type — varchar(50) — NOT NULL
- material — varchar(50) — NOT NULL
- material_grade — varchar(50) — NOT NULL
search_popularmaterialgrade
- id — bigint — Primary key — NOT NULL
- product_type — varchar(20) — NOT NULL
- category — varchar(20) — NOT NULL
- material_grade — varchar(20) — NOT NULL
- count — int — NOT NULL
search_searchresultlog
- id — bigint — Primary key — NOT NULL
- search_query — longtext
- click_result — varchar(50) — NOT NULL
- click_index — int
- click_type — varchar(10) — NOT NULL
- product_type — varchar(20) — NOT NULL
- category — varchar(20) — NOT NULL
- created_at — datetime(6) — NOT NULL
- user_id — bigint — Foreign key → user_user.id — NOT NULL
seller_stockmaterial
- id — bigint — Primary key — NOT NULL
- stock_material_file — varchar(100)
- admin_check — tinyint(1) — NOT NULL
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- user_id — bigint — Foreign key → user_user.id
user_categoryclosure
- id — bigint — Primary key — NOT NULL
- depth — int — NOT NULL
- ancestor_id — bigint — Foreign key → user_categoryname.id — NOT NULL
- descendant_id — bigint — Foreign key → user_categoryname.id — NOT NULL
user_categoryname
- id — bigint — Primary key — NOT NULL
- name — varchar(50)
- created_at — datetime(6) — NOT NULL
user_materialcategorygroup
- id — bigint — Primary key — NOT NULL
- category_id — bigint — Foreign key → user_categoryclosure.id — NOT NULL
- user_id — bigint — Foreign key → user_user.id — NOT NULL
user_notificationstatus
- id — bigint — Primary key — NOT NULL
- email — tinyint(1) — NOT NULL
- sms — tinyint(1) — NOT NULL
- user_id — bigint — Foreign key → user_user.id — NOT NULL
user_profile
- id — bigint — Primary key — NOT NULL
- company_name — longtext
- company_department — varchar(40)
- company_title — varchar(40)
- company_address — varchar(255)
- company_tel — varchar(50)
- company_registration_number — varchar(15)
- company_certificate — varchar(100)
- company_certificate_confirm — int — NOT NULL
- bankbook_copy — varchar(100)
- bankbook_copy_confirm — int — NOT NULL
- bank_nationality — varchar(255)
- bank_name — varchar(255)
- bsb_code — varchar(255)
- branch_address — varchar(255)
- account_no — varchar(255)
- iban_code — varchar(255)
- swift_code — varchar(255)
- aba_no — varchar(255)
- sort_code — varchar(255)
- blz_code — varchar(255)
- eft_no — varchar(255)
- marketing_approval — tinyint(1) — NOT NULL
- user_id — bigint — Foreign key → user_user.id — NOT NULL
user_user
- id — bigint — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime(6)
- is_superuser — tinyint(1) — NOT NULL
- email — varchar(255) — NOT NULL
- name — varchar(50) — NOT NULL
- phone_code — varchar(5) — NOT NULL
- phone — varchar(20) — NOT NULL
- is_active — tinyint(1) — NOT NULL
- is_admin — tinyint(1) — NOT NULL
- date_joined — datetime(6) — NOT NULL
- is_verified — tinyint(1) — NOT NULL
- user_status — int — NOT NULL
- is_notified — tinyint(1) — NOT NULL
user_verificationtoken
- id — bigint — Primary key — NOT NULL
- code — varchar(40)
- type — int
- created_at — datetime(6) — NOT NULL
- is_verified — tinyint(1) — NOT NULL
- user_id — bigint — Foreign key → user_user.id