E-Commerce Modernization Blueprint

Project Roadmap & Integration Schedule

Gantt Milestone Schedule

8-Week Timeline

Milestone Phase

W1-2

W3-4

W5-6

W7-8

Phase 1: DB Scaffolding Setup framework & tables

Dev 1 Setup Base Core

Dev 2-5 Schemas Draft

Phase 2: Core Domain Logic Wizard engine & CRM lists

Devs 3 & 4 Integrations

Phase 3: Storefront & Sales Public checkout & billing

Devs 2 & 5 Carts/Settlements

Phase 4: Launch & Auditing Full system dry-run & signing

Integrate & Polish

Modernization Statistics

Total Legacy Tables

80

Team Members

5

Modernized Schema

100%

Framework Target

Laravel 11

How to navigate: Click on any table pill inside a developer role card below to instantly view its legacy columns and indexes in the Database Directory.

5-Developer Work Assignment Scopes

Developer 1

The Core Systems & Security Architect

Dev 1

Core Focus: Backend infrastructure, authentication, security compliance, tenant control, system utilities, and fundamental platform scaffolding.

Key Milestones

Infra Scaffolding: Setup the base Laravel 11 project structure, database migrations base, Docker configuration, and Git repository workflows.
Security & SSO: Integrate 2FA authentication, Google & Microsoft SSO services, and design dynamic role permissions.
Audit Trail Engine: Implement global model observers that record all user modifications automatically into the audit logs.
Staff Management: Create staff profiles, secure file storage directory mapping for supporting documents, and variable fields.

Owned Tables (19)

main_user_login main_user_account_access_level_list main_user_login_device main_user_login_email_list company branch employee_list emp_supporting_doc_list emp_support_doc_img_pth_list emp_variable_list emp_variable_anwer_list audit_trail_report department_email_history department_email_notification department_email_notification_has_email_history downloads email_sms_link_manament email_sms_link_view_history usefull_url_list

Developer 2

The E-Commerce & Public Web Specialist

Dev 2

Core Focus: Frontend storefront development, interactive public views, shopping cart session states, and public marketing interfaces.

Key Milestones

Public Catalog Routing: Display categories and brands to public guests with highly responsive interfaces.
Session Cart Mechanics: Build standard browser cookies and user-authenticated shopping cart caches.
Cart Checkout Flow: Map cart items to delivery/pickup logic, shipping addresses, and online payment methods.
Static CMS & Blog: Implement the testimonial carousels, public blog categories, dynamic banner slides, and SEO metadata headers.

Owned Tables (14)

cart_cook_list_customer_data cart_cook_list_customer_data_has_cart_main_data_list cart_cook_list_customer_data_has_main_user_login cart_is_user cart_item_service_list cart_main_data_list cart_wish_list_item_service cus_sup_list_has_cart_main_data_list blog blog_images blog_list blog_type_list testimonials banner_img

Developer 3

The Wizard Engine & Inventory Master

Dev 3

Core Focus: Stateful Livewire development, inventory variants cataloging, batch serial tracking, dynamic metadata structures, and product reviews.

Key Milestones

11-Step Livewire Wizard: Refactor the procedural HTML steps into a beautifully structured Livewire wizard component.
Dynamic Variant Form: Build dynamic input generators based on selected category variable structures (checkboxes, text inputs, dropdowns, images).
Asset Batch Serial Ledger: Manage the batch tracking and validation rules for physical serial inputs (auto-generated vs manual keys).
Physical Stock Metrics: Build inventory valuation listeners checking current warehouse levels.

Owned Tables (29)

item_serivice_list item_serivice_list_info_data item_serivice_category item_serivice_category_list item_serivice_category_variable_list item_serivice_category_variable_list_answer_list item_serivice_images item_serivice_list_downloads_list item_serivice_list_has_item_serivice_tags item_serivice_list_terms_and_condtion item_serivice_list_unique_id_name_list item_serivice_list_unique_id_name_list_data_list item_serivice_list_variable_name_list item_serivice_list_variable_answer_list item_serivice_list_variable_selector_image_or_text_list item_serivice_list_variable_selector_image_variable_answer_list item_serivice_list_variable_selector_img_value_list item_serivice_list_variable_selector_text_value_list item_serivice_tags item_service_barnd_list item_service_branding_list item_service_measuring_unit about_us_text_content allowance item_rating item_serivice_advacne_details item_serivice_list_review_data v_selector_img_val_list_has_item_serivice_list_v_ans_list v_selector_text_val_list_has_item_serivice_list_v_ansr_list

Developer 4

The CRM & Supplier Profile Specialist

Dev 4

Core Focus: Client management modules, supplier directories, corporate dynamic variables, bank integration settings, and credit control rules.

Key Milestones

CRM Workspace: Create highly functional panels managing Customer/Supplier contact cards, bank accounts, and addresses.
Credit Limit Logic: Write core validation listeners enforcing credit thresholds (`cus_credit_limit`, `sup_credit_limit`) and payment period delays.
Corporate Profile Attribute Forms: Implement custom onboarding fields for corporate structures versus personal accounts.
Audited Risk Controls: Alert system admins via notifications when credit risks or blocked states are modified.

Owned Tables (12)

cus_sup_list cus_sup_address_list cus_sup_address_list_has_cart_main_data_list cus_sup_bank_account cus_sup_contact_person cus_sup_form_type_variable cus_sup_from_type cus_sup_special_condtion cus_sup_type cus_sup_variable_answers cus_sup_variable_answers_big_text cus_sup_variable_list

Developer 5

The Invoicing, Statement & Treasury Lead

Dev 5

Core Focus: Financial ledger execution, transaction vouchers, multiple currencies, PDF engines, and cashier drawer states.

Key Milestones

Dynamic Statement Vouchers: Build dynamic invoice pipelines executing raw line-item math, tax modifiers, and final totals.
Payment Settling & Cash Flow: Implement invoice settlements, partial settlements, and split payment listings.
Multi-Currency Caches: Pull exchange rates, caching rates relative to the system's base currency setting.
Secure PDF Generator: Integrate a clean PDF generator (like Barryvdh Snappy or DomPDF) formatting printable Invoices/GRNs.

Owned Tables (6)

statement_list_of_currency statement_doc_payment_listing statement_doc_payment_listing_cus_sup_data statement_doc_payment_listing_user_account statement_doc_payment_settlment_hisorty statement_doc_payment_settlment_hisorty_user_account

Developer 6

🤝 Project Integration Timeline & Checkpoints

Dev 6

Core Focus:

Key Milestones

Owned Tables (0)

Database Directory & Columns

Showing 80 of 80 Tables

about_us_text_content

6 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	title	`varchar(500) DEFAULT NULL`	—
5	dis	`longtext`	—
6	dis_title	`varchar(200) DEFAULT NULL`	—

allowance

6 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	price_3_month	`varchar(45) DEFAULT NULL`	—
5	price_1_year	`varchar(45) DEFAULT NULL`	—
6	price_1_more_year	`varchar(45) DEFAULT NULL`	—

item_rating

10 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key Component)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	rating_value	`int(11) DEFAULT NULL`	—
5	dis	`varchar(80) DEFAULT NULL`	—
6	item_serivice_list_id	`int(11) DEFAULT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
7	cart_main_data_list_id	`int(11) DEFAULT NULL` (Foreign Key -> `cart_main_data_list.id`)	FK
8	is_item	`tinyint(1) DEFAULT NULL`	—
9	is_order	`tinyint(1) DEFAULT NULL`	—
10	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`, Primary Key Component)	PK FK

item_serivice_advacne_details

7 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	variable_name	`varchar(450) DEFAULT NULL`	—
5	variable_dis	`varchar(4500) DEFAULT NULL`	—
6	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
7	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK

item_serivice_category

16 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	name_of_cat	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	parent_cat_id	`int(11) DEFAULT NULL`	—
6	cat_no_of_count	`int(11) DEFAULT NULL`	—
7	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
8	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
9	url_name	`varchar(45) DEFAULT NULL`	—
10	image_state	`tinyint(1) DEFAULT NULL`	—
11	dis	`varchar(4500) DEFAULT NULL`	—
12	seo_key_words	`varchar(4500) DEFAULT NULL`	—
13	image_pth	`varchar(4500) DEFAULT NULL`	—
14	show_on_web	`tinyint(1) DEFAULT NULL`	—
15	submit_for_seach_engin	`tinyint(1) DEFAULT NULL`	—
16	next_layer_avabile	`tinyint(1) DEFAULT NULL`	—

item_serivice_category_list

8 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
5	item_serivice_category_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_category.id`)	FK
6	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
8	count_no	`int(11) DEFAULT NULL`	—

item_serivice_category_variable_list

14 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	variable_name	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	type_of_variable	`varchar(45) DEFAULT NULL`	—
6	cus_statement_show	`tinyint(1) DEFAULT NULL`	—
7	sup_statement_show	`tinyint(1) DEFAULT NULL`	—
8	web_show	`tinyint(1) DEFAULT NULL`	—
9	item_serivice_category_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_category.id`)	FK
10	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
11	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
12	active	`tinyint(1) DEFAULT NULL`	—
13	requard	`tinyint(1) DEFAULT NULL`	—
14	place_holder_txt	`varchar(45) DEFAULT NULL`	—

item_serivice_category_variable_list_answer_list

9 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	variable_name	`varchar(450) DEFAULT NULL`	—
5	variable_asnwer	`varchar(450) DEFAULT NULL`	—
6	item_serivice_category_variable_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_category_variable_list.id`)	FK
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
8	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
9	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

item_serivice_images

9 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	alt_txt	`varchar(450) DEFAULT NULL`	—
5	img_pth	`varchar(4500) DEFAULT NULL`	—
6	show_on_web	`tinyint(1) DEFAULT NULL`	—
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
8	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
9	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#10

item_serivice_list

47 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
3	production_state	`tinyint(1) DEFAULT NULL`	—
4	item_state	`tinyint(1) DEFAULT NULL`	—
5	service_satate	`tinyint(1) DEFAULT NULL`	—
6	name	`varchar(450) DEFAULT NULL`	—
7	dis	`varchar(4500) DEFAULT NULL`	—
8	ast	`tinyint(1) DEFAULT NULL`	—
9	sdt	`timestamp NULL DEFAULT NULL`	—
10	main_image	`varchar(4500) DEFAULT NULL`	—
11	st_show_on_web	`tinyint(1) DEFAULT NULL`	—
12	st_unique_id	`tinyint(1) DEFAULT NULL`	—
13	st_item_variable	`tinyint(1) DEFAULT NULL`	—
14	st_extra_image_state	`tinyint(1) DEFAULT NULL`	—
15	st_bunding_un_bundling	`tinyint(1) DEFAULT NULL`	—
16	st_advance	`tinyint(1) DEFAULT NULL`	—
17	st_downloads	`tinyint(1) DEFAULT NULL`	—
18	st_terms_and_condtion	`tinyint(1) DEFAULT NULL`	—
19	st_extra_image	`tinyint(1) DEFAULT NULL`	—
20	unique_id_auto	`tinyint(1) DEFAULT NULL`	—
21	unique_id_manual	`tinyint(1) DEFAULT NULL`	—
22	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
23	brand_state	`tinyint(1) DEFAULT NULL`	—
24	web_url_name	`varchar(450) DEFAULT NULL`	—
25	web_seo_key_words	`varchar(4500) DEFAULT NULL`	—
26	web_submit_for_search_eng	`tinyint(1) DEFAULT NULL`	—
27	step_01	`tinyint(1) DEFAULT NULL`	—
28	step_02	`tinyint(1) DEFAULT NULL`	—
29	step_03	`tinyint(1) DEFAULT NULL`	—
30	step_04	`tinyint(1) DEFAULT NULL`	—
31	step_05	`tinyint(1) DEFAULT NULL`	—
32	step_06	`tinyint(1) DEFAULT NULL`	—
33	step_07	`tinyint(1) DEFAULT NULL`	—
34	step_08	`tinyint(1) DEFAULT NULL`	—
35	step_09	`tinyint(1) DEFAULT NULL`	—
36	step_10	`tinyint(1) DEFAULT NULL`	—
37	finish_state	`tinyint(1) DEFAULT NULL`	—
38	main_barcode_id	`varchar(45) DEFAULT NULL`	—
39	selling_price_avarage	`double DEFAULT NULL`	—
40	buy_price_avarage	`double DEFAULT NULL`	—
41	is_printed_MRP	`tinyint(1) DEFAULT NULL`	—
42	is_base_currency	`tinyint(1) DEFAULT NULL`	—
43	is_other_currency	`tinyint(1) DEFAULT NULL`	—
44	currency_name	`varchar(45) DEFAULT NULL`	—
45	active_state	`tinyint(1) DEFAULT NULL`	—
46	no_of_salse	`double DEFAULT NULL`	—
47	not_of_reviews	`double DEFAULT NULL`	—

#11

item_serivice_list_downloads_list

9 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	download_data_url	`text`	—
5	download_name	`varchar(45) DEFAULT NULL`	—
6	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
8	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
9	description	`varchar(450) DEFAULT NULL`	—

#12

item_serivice_list_has_item_serivice_tags

5 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
2	item_serivice_tags_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_tags.id`)	FK
3	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
4	ast	`tinyint(1) DEFAULT NULL`	—
5	sdt	`timestamp NULL DEFAULT NULL`	—

#13

item_serivice_list_info_data

45 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	item_service_sub_name	`varchar(450) DEFAULT NULL`	—
5	last_update_buy_price	`double DEFAULT NULL`	—
6	last_update_sel_price	`double DEFAULT NULL`	—
7	barcode_or_item_code_id	`varchar(450) DEFAULT NULL`	—
8	item_state	`tinyint(1) DEFAULT NULL`	—
9	service_state	`tinyint(1) DEFAULT NULL`	—
10	production_state	`tinyint(1) DEFAULT NULL`	—
11	min_margin_value	`double DEFAULT NULL`	—
12	min_margin_value_state	`tinyint(1) DEFAULT NULL`	—
13	min_margin_persontage_state	`tinyint(1) DEFAULT NULL`	—
14	is_avb_variable_list	`tinyint(1) DEFAULT NULL`	—
15	is_avb_unique_id	`tinyint(1) DEFAULT NULL`	—
16	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
17	branch_id	`int(11) NOT NULL` (Foreign Key -> `branch.id`)	FK
18	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
19	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
20	base_currency	`varchar(45) DEFAULT NULL`	—
21	base_currency_state	`tinyint(1) DEFAULT NULL`	—
22	ex_currency_name	`varchar(45) DEFAULT NULL`	—
23	ex_currency_state	`tinyint(1) DEFAULT NULL`	—
24	re_order_level	`double DEFAULT NULL`	—
25	noti_sms_state	`tinyint(1) DEFAULT NULL`	—
26	noti_email_state	`tinyint(1) DEFAULT NULL`	—
27	sms_done_reminder	`tinyint(1) DEFAULT NULL`	—
28	email_done_reminder	`tinyint(1) DEFAULT NULL`	—
29	re_order_state	`tinyint(1) DEFAULT NULL`	—
30	is_unbudling	`tinyint(1) DEFAULT NULL`	—
31	function_stock	`double DEFAULT NULL`	—
32	opeing_balance	`double DEFAULT NULL`	—
33	stock_item_qty	`double DEFAULT NULL`	—
34	measureing_unit	`varchar(45) DEFAULT NULL`	—
35	active_state	`tinyint(1) DEFAULT NULL`	—
36	package_weight	`double DEFAULT NULL`	—
37	discount_state	`tinyint(1) DEFAULT NULL`	—
38	discount_value_state	`tinyint(1) DEFAULT NULL`	—
39	discount_persontage_state	`tinyint(1) DEFAULT NULL`	—
40	discount_value	`varchar(45) DEFAULT NULL`	—
41	discount_promotion_key_state	`tinyint(1) DEFAULT NULL`	—
42	discount_cutomer_vise_state	`tinyint(1) DEFAULT NULL`	—
43	opening_balance_img	`varchar(4500) DEFAULT NULL`	—
44	is_main_unit_bundle	`tinyint(1) DEFAULT NULL`	—
45	is_sub_unit_unbundle	`tinyint(1) DEFAULT NULL`	—

#14

item_serivice_list_review_data

9 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	name	`varchar(45) DEFAULT NULL`	—
3	rate	`int(11) DEFAULT NULL`	—
4	message	`varchar(4500) DEFAULT NULL`	—
5	ast	`tinyint(1) DEFAULT NULL`	—
6	show_all	`tinyint(1) DEFAULT NULL`	—
7	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
8	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
9	sdt	`timestamp NULL DEFAULT NULL`	—

#15

item_serivice_list_terms_and_condtion

7 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	dis	`varchar(4500) DEFAULT NULL`	—
5	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
6	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
7	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#16

item_serivice_list_unique_id_name_list

7 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	name_unique_id	`varchar(45) DEFAULT NULL`	—
5	auto_genreate_state	`tinyint(1) DEFAULT NULL`	—
6	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#17

item_serivice_list_unique_id_name_list_data_list

14 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	unique_id	`varchar(4500) DEFAULT NULL`	—
5	in_state	`tinyint(1) DEFAULT NULL`	—
6	in_sdt	`timestamp NULL DEFAULT NULL`	—
7	out_state	`tinyint(1) DEFAULT NULL`	—
8	out_sdt	`timestamp NULL DEFAULT NULL`	—
9	dis	`varchar(450) DEFAULT NULL`	—
10	item_serivice_list_unique_id_name_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_unique_id_name_list.id`)	FK
11	main_user_login_id_item_in_data	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
12	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
13	item_serivice_list_info_data_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_info_data.id`)	FK
14	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK

#18

item_serivice_list_variable_answer_list

14 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	variable_name	`varchar(45) DEFAULT NULL`	—
5	answer_value	`text`	—
6	is_text	`tinyint(1) DEFAULT NULL`	—
7	is_number	`tinyint(1) DEFAULT NULL`	—
8	is_selector_text	`tinyint(1) DEFAULT NULL`	—
9	is_selector_image	`tinyint(1) DEFAULT NULL`	—
10	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
11	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
12	item_serivice_list_info_data_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_info_data.id`)	FK
13	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
14	is_date	`tinyint(1) DEFAULT NULL`	—

#19

item_serivice_list_variable_name_list

15 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
5	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
6	name	`varchar(45) DEFAULT NULL`	—
7	is_text	`tinyint(1) DEFAULT NULL`	—
8	is_number	`tinyint(1) DEFAULT NULL`	—
9	is_selector_text	`tinyint(1) DEFAULT NULL`	—
10	is_selector_image	`tinyint(1) DEFAULT NULL`	—
11	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
12	is_date	`tinyint(1) DEFAULT NULL`	—
13	is_time	`tinyint(1) DEFAULT NULL`	—
14	placeholder_msg	`varchar(45) DEFAULT NULL`	—
15	is_required	`tinyint(1) DEFAULT NULL`	—

#20

item_serivice_list_variable_selector_image_or_text_list

8 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	img_pth	`text`	—
5	alt_value	`varchar(45) DEFAULT NULL`	—
6	item_serivice_list_variable_name_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_variable_name_list.id`)	FK
7	item_serivice_list_variable_heading_list_id	`int(11) NOT NULL`	—
8	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK

#21

item_serivice_list_variable_selector_image_variable_answer_list

5 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	item_serivice_list_variable_selector_image_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_variable_selector_image_or_text_list.id`)	FK
2	item_serivice_list_variable_answer_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_variable_answer_list.id`)	FK
3	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	ast	`tinyint(1) DEFAULT NULL`	—

#22

item_serivice_list_variable_selector_img_value_list

8 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	text_value	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	img_pth	`varchar(405) DEFAULT NULL`	—
6	item_serivice_list_variable_name_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_variable_name_list.id`)	FK
7	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
8	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#23

item_serivice_list_variable_selector_text_value_list

7 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	text_value	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	item_serivice_list_variable_name_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_variable_name_list.id`)	FK
6	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#24

item_serivice_tags

7 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	tag_name	`varchar(45) DEFAULT NULL`	—
5	active_state	`tinyint(1) DEFAULT NULL`	—
6	active_state_sdt	`timestamp NULL DEFAULT NULL`	—
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#25

item_service_barnd_list

7 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
5	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
6	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
7	item_service_branding_list_id	`int(11) NOT NULL` (Foreign Key -> `item_service_branding_list.id`)	FK

#26

item_service_branding_list

13 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	brand_name	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	dis	`varchar(4500) DEFAULT NULL`	—
6	img_pth	`varchar(4500) DEFAULT NULL`	—
7	url_name	`varchar(450) DEFAULT NULL`	—
8	seo_key_words	`varchar(4500) DEFAULT NULL`	—
9	show_on_web	`tinyint(1) DEFAULT NULL`	—
10	submit_for_search_eng	`tinyint(1) DEFAULT NULL`	—
11	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
12	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
13	imge_log_pth	`varchar(4500) DEFAULT NULL`	—

#27

item_service_measuring_unit

9 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	main_unit_qty	`int(11) DEFAULT NULL`	—
5	main_unit_measurement	`varchar(45) DEFAULT NULL`	—
6	sub_unit_qty	`int(11) DEFAULT NULL`	—
7	sub_unit_measurement	`varchar(45) DEFAULT NULL`	—
8	item_serivice_list_info_data_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_info_data.id`)	FK
9	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK

#28

v_selector_img_val_list_has_item_serivice_list_v_ans_list

5 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key Component)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	item_serivice_list_variable_selector_img_value_list_id	`int(11) NOT NULL` (Foreign Key, Primary Key Component)	PK FK
5	item_serivice_list_variable_answer_list_id	`int(11) NOT NULL` (Foreign Key, Primary Key Component)	PK FK

#29

v_selector_text_val_list_has_item_serivice_list_v_ansr_list

5 Columns Dev 3

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL DEFAULT '0'` (Primary Key Component)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	item_serivice_list_variable_selector_text_value_list_id	`int(11) NOT NULL` (Foreign Key, Primary Key Component)	PK FK
5	item_serivice_list_variable_answer_list_id	`int(11) NOT NULL` (Foreign Key, Primary Key Component)	PK FK

#30

company

2 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—

#31

branch

1 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK

#32

cus_sup_list

38 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	name	`varchar(450) DEFAULT NULL`	—
3	short_name	`varchar(45) DEFAULT NULL`	—
4	email	`varchar(45) DEFAULT NULL`	—
5	phone_no	`varchar(45) DEFAULT NULL`	—
6	moble_no_for_sms	`varchar(45) DEFAULT NULL`	—
7	ast	`tinyint(1) DEFAULT NULL`	—
8	sdt	`timestamp NULL DEFAULT NULL`	—
9	sup_credit_limit	`double DEFAULT NULL`	—
10	cus_credit_limit	`double DEFAULT NULL`	—
11	cus_state	`tinyint(1) DEFAULT NULL`	—
12	sup_state	`tinyint(1) DEFAULT NULL`	—
13	cus_credit_state	`tinyint(1) DEFAULT NULL`	—
14	sup_credit_state	`tinyint(1) DEFAULT NULL`	—
15	sup_opening_bal	`double DEFAULT NULL`	—
16	cus_opening_bal	`double DEFAULT NULL`	—
17	cus_PD_chque	`double DEFAULT NULL`	—
18	sup_PD_chque	`double DEFAULT NULL`	—
19	self_account	`tinyint(1) DEFAULT NULL`	—
20	active	`tinyint(1) DEFAULT NULL`	—
21	email_sent_form	`tinyint(1) DEFAULT NULL`	—
22	personal_account	`tinyint(1) DEFAULT NULL`	—
23	coperate_account	`tinyint(1) DEFAULT NULL`	—
24	company_id	`int(11) DEFAULT NULL` (Foreign Key -> `company.id`)	FK
25	cheque_amount_cus	`double DEFAULT NULL`	—
26	cheque_amount_sup	`double DEFAULT NULL`	—
27	logo	`varchar(4500) DEFAULT NULL`	—
28	approve_state	`tinyint(1) DEFAULT NULL`	—
29	cus_credit_period	`int(11) DEFAULT NULL`	—
30	sup_cridet_period	`int(11) DEFAULT NULL`	—
31	cus_credit_request	`tinyint(1) DEFAULT NULL`	—
32	self_ac_submition_state	`tinyint(1) DEFAULT NULL`	—
33	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
34	sms_sent_form	`tinyint(1) DEFAULT NULL`	—
35	verify_sms	`tinyint(1) DEFAULT NULL`	—
36	verify_email	`tinyint(1) DEFAULT NULL`	—
37	default_customer_bock	`tinyint(1) DEFAULT NULL`	—
38	cus_self_credit_from	`tinyint(1) DEFAULT NULL`	—

#33

cus_sup_address_list

20 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	a_line_01	`varchar(45) DEFAULT NULL`	—
3	a_line_02	`varchar(45) DEFAULT NULL`	—
4	a_line_03	`varchar(45) DEFAULT NULL`	—
5	street	`varchar(45) DEFAULT NULL`	—
6	city	`varchar(45) DEFAULT NULL`	—
7	ast	`tinyint(1) DEFAULT NULL`	—
8	sdt	`timestamp NULL DEFAULT NULL`	—
9	shipping_ast	`tinyint(1) DEFAULT NULL`	—
10	billing_ast	`tinyint(1) DEFAULT NULL`	—
11	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`)	FK
12	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
13	default_shipping_state	`tinyint(1) DEFAULT NULL`	—
14	default_billing_state	`tinyint(1) DEFAULT NULL`	—
15	delivary_city_and_changers_id	`varchar(45) DEFAULT NULL`	—
16	contact_01	`varchar(45) DEFAULT NULL`	—
17	contact_02	`varchar(45) DEFAULT NULL`	—
18	state	`varchar(60) DEFAULT NULL`	—
19	country	`varchar(60) DEFAULT NULL`	—
20	zip_code	`varchar(45) DEFAULT NULL`	—

#34

cus_sup_address_list_has_cart_main_data_list

5 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	cus_sup_address_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_address_list.id`)	FK
2	cart_main_data_list_id	`int(11) NOT NULL` (Foreign Key -> `cart_main_data_list.id`)	FK
3	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
4	ast	`tinyint(1) DEFAULT NULL`	—
5	sdt	`timestamp NULL DEFAULT NULL`	—

#35

cus_sup_bank_account

13 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	bank_name	`varchar(45) DEFAULT NULL`	—
3	branch_name	`varchar(45) DEFAULT NULL`	—
4	bank_code	`varchar(45) DEFAULT NULL`	—
5	branch_code	`varchar(45) DEFAULT NULL`	—
6	account_no	`varchar(45) DEFAULT NULL`	—
7	account_type	`varchar(45) DEFAULT NULL`	—
8	ast	`tinyint(1) DEFAULT NULL`	—
9	sdt	`timestamp NULL DEFAULT NULL`	—
10	active_state	`tinyint(1) DEFAULT NULL`	—
11	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
12	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`)	FK
13	ac_name	`varchar(450) DEFAULT NULL`	—

#36

cus_sup_contact_person

8 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	name	`varchar(45) DEFAULT NULL`	—
3	email	`varchar(45) DEFAULT NULL`	—
4	phone_no	`varchar(45) DEFAULT NULL`	—
5	ast	`tinyint(1) DEFAULT NULL`	—
6	sdt	`timestamp NULL DEFAULT NULL`	—
7	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`)	FK
8	company_id	`int(11) DEFAULT NULL` (Foreign Key -> `company.id`)	FK

#37

cus_sup_form_type_variable

6 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	cus_sup_variable_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_variable_list.id`)	FK
2	cus_sup_from_type_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_from_type.id`)	FK
3	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
4	ast	`tinyint(1) DEFAULT NULL`	—
5	sdt	`timestamp NULL DEFAULT NULL`	—
6	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#38

cus_sup_from_type

8 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	from_type_name	`varchar(45) DEFAULT NULL`	—
3	cus_state	`tinyint(1) DEFAULT NULL`	—
4	sup_state	`tinyint(1) DEFAULT NULL`	—
5	ast	`tinyint(1) DEFAULT NULL`	—
6	sdt	`timestamp NULL DEFAULT NULL`	—
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
8	main_user_login_id1	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#39

cus_sup_special_condtion

8 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	dis	`varchar(450) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	sup_data	`tinyint(1) DEFAULT NULL`	—
6	cus_daat	`tinyint(1) DEFAULT NULL`	—
7	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`)	FK
8	company_id	`int(11) DEFAULT NULL` (Foreign Key -> `company.id`)	FK

#40

cus_sup_type

5 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`)	FK
5	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#41

cus_sup_variable_answers

7 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	variable_answer	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	cus_sup_variable_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_variable_list.id`)	FK
6	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`)	FK
7	company_id	`int(11) DEFAULT NULL` (Foreign Key -> `company.id`)	FK

#42

cus_sup_variable_answers_big_text

7 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	variable_answer	`text`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	cus_sup_variable_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_variable_list.id`)	FK
6	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`)	FK
7	company_id	`int(11) DEFAULT NULL` (Foreign Key -> `company.id`)	FK

#43

cus_sup_variable_list

16 Columns Dev 4

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	cus_need	`tinyint(1) DEFAULT NULL`	—
3	sup_need	`tinyint(1) DEFAULT NULL`	—
4	variable_name	`varchar(45) DEFAULT NULL`	—
5	variable_type	`varchar(45) DEFAULT NULL`	—
6	credit_doc	`tinyint(1) DEFAULT NULL`	—
7	requird_state	`tinyint(1) DEFAULT NULL`	—
8	personal_ac_only	`tinyint(1) DEFAULT NULL`	—
9	cooperate_only	`tinyint(1) DEFAULT NULL`	—
10	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
11	order_num	`int(11) DEFAULT NULL`	—
12	ast	`tinyint(1) DEFAULT NULL`	—
13	company_id	`int(11) DEFAULT NULL` (Foreign Key -> `company.id`)	FK
14	remove_all_record	`tinyint(1) DEFAULT NULL`	—
15	placeholder_message	`varchar(450) DEFAULT NULL`	—
16	process_from_variable_state	`tinyint(1) DEFAULT NULL`	—

#44

cart_cook_list_customer_data

10 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	cook_id	`text`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	setup_for_login_account	`tinyint(1) DEFAULT NULL`	—
6	customer_name	`varchar(45) DEFAULT NULL`	—
7	email	`varchar(45) DEFAULT NULL`	—
8	country	`varchar(450) DEFAULT NULL`	—
9	visit_count	`int(11) DEFAULT NULL`	—
10	is_user	`tinyint(1) DEFAULT NULL`	—

#45

cart_cook_list_customer_data_has_cart_main_data_list

5 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	cart_cook_list_customer_data_id	`int(11) NOT NULL` (Foreign Key -> `cart_cook_list_customer_data.id`)	FK
2	cart_main_data_list_id	`int(11) NOT NULL` (Foreign Key -> `cart_main_data_list.id`)	FK
3	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
4	ast	`tinyint(1) DEFAULT NULL`	—
5	sdt	`timestamp NULL DEFAULT NULL`	—

#46

cart_cook_list_customer_data_has_main_user_login

5 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	cart_cook_list_customer_data_id	`int(11) NOT NULL` (Foreign Key -> `cart_cook_list_customer_data.id`)	FK
2	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
3	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
4	ast	`tinyint(1) DEFAULT NULL`	—
5	sdt	`timestamp NULL DEFAULT NULL`	—

#47

cart_is_user

5 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
5	cart_main_data_list_id	`int(11) NOT NULL` (Foreign Key -> `cart_main_data_list.id`)	FK

#48

cart_item_service_list

13 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	qty	`double DEFAULT NULL`	—
5	finalize_unit_selling_price	`double DEFAULT NULL`	—
6	total_amount	`double DEFAULT NULL`	—
7	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
8	cart_main_data_list_id	`int(11) NOT NULL` (Foreign Key -> `cart_main_data_list.id`)	FK
9	item_serivice_list_info_data_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list_info_data.id`)	FK
10	per_unit_disount	`double DEFAULT NULL`	—
11	total_discount	`double DEFAULT NULL`	—
12	per_unit_weight	`double DEFAULT NULL`	—
13	total_weight	`double DEFAULT NULL`	—

#49

cart_main_data_list

26 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	cook_id_M	`text`	—
5	is_account_state	`tinyint(1) DEFAULT NULL`	—
6	check_out_state	`tinyint(1) DEFAULT NULL`	—
7	check_out_sdt	`timestamp NULL DEFAULT NULL`	—
8	net_amount	`double DEFAULT NULL`	—
9	total_discount	`double DEFAULT NULL`	—
10	total_weight	`double DEFAULT NULL`	—
11	is_delivery_state	`tinyint(1) DEFAULT NULL`	—
12	is_pickup_state	`tinyint(1) DEFAULT NULL`	—
13	cash_on_delviery	`tinyint(1) DEFAULT NULL`	—
14	visa_card_payment	`tinyint(1) DEFAULT NULL`	—
15	bank_deposit	`tinyint(1) DEFAULT NULL`	—
16	pay_by_collction	`tinyint(1) DEFAULT NULL`	—
17	is_process_invoice_created	`tinyint(1) DEFAULT NULL`	—
18	is_process_ready_goods	`tinyint(1) DEFAULT NULL`	—
19	is_process_packed	`tinyint(1) DEFAULT NULL`	—
20	is_process_hadover_to_delivery_parnter	`tinyint(1) DEFAULT NULL`	—
21	is_process_customer_recive	`tinyint(1) DEFAULT NULL`	—
22	is_process_final_payment_done	`tinyint(1) DEFAULT NULL`	—
23	tracking_number	`varchar(450) DEFAULT NULL`	—
24	traking_parnter_details	`varchar(450) DEFAULT NULL`	—
25	traking_patern_url	`varchar(450) DEFAULT NULL`	—
26	process_customer_recive_sdt	`timestamp NULL DEFAULT NULL`	—

#50

cart_wish_list_item_service

5 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
5	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#51

cus_sup_list_has_cart_main_data_list

5 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`)	FK
2	cart_main_data_list_id	`int(11) NOT NULL` (Foreign Key -> `cart_main_data_list.id`)	FK
3	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
4	ast	`tinyint(1) DEFAULT NULL`	—
5	sdt	`timestamp NULL DEFAULT NULL`	—

#52

blog

6 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	dis	`varchar(200) DEFAULT NULL`	—
5	name	`varchar(70) DEFAULT NULL`	—
6	img_pth	`varchar(4500) DEFAULT NULL`	—

#53

blog_images

6 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	alt	`varchar(45) DEFAULT NULL`	—
5	img_pth	`varchar(4500) DEFAULT NULL`	—
6	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#54

blog_list

13 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	heading	`varchar(450) DEFAULT NULL`	—
5	infomation_data	`longtext`	—
6	is_pic_available	`tinyint(1) DEFAULT NULL`	—
7	url_data	`varchar(450) DEFAULT NULL`	—
8	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
9	key_words	`varchar(450) DEFAULT NULL`	—
10	seo_dis	`text`	—
11	image_path	`varchar(4500) DEFAULT NULL`	—
12	type_of_blog	`varchar(45) DEFAULT NULL`	—
13	show_on_all_blogs	`tinyint(1) DEFAULT NULL`	—

#55

blog_type_list

6 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	type_of_blog	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
6	active_state	`tinyint(1) DEFAULT NULL`	—

#56

testimonials

6 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	name	`varchar(60) DEFAULT NULL`	—
5	dis	`varchar(450) DEFAULT NULL`	—
6	rate	`int(11) DEFAULT NULL`	—

#57

employee_list

14 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	name_in_full	`varchar(4500) DEFAULT NULL`	—
3	name_in_initials	`varchar(450) DEFAULT NULL`	—
4	display_name	`varchar(45) DEFAULT NULL`	—
5	email	`varchar(450) DEFAULT NULL`	—
6	phone_no	`varchar(45) DEFAULT NULL`	—
7	variable_data_state	`tinyint(1) DEFAULT NULL`	—
8	verify_email_state	`tinyint(1) DEFAULT NULL`	—
9	verify_phone_state	`tinyint(1) DEFAULT NULL`	—
10	self_account_state	`tinyint(1) DEFAULT NULL`	—
11	verify_state	`tinyint(1) DEFAULT NULL`	—
12	user_account_avable	`tinyint(1) DEFAULT NULL`	—
13	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
14	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#58

emp_supporting_doc_list

6 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	doc_name	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	state_of_req	`tinyint(1) DEFAULT NULL`	—
6	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#59

emp_support_doc_img_pth_list

7 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	pth	`varchar(4500) DEFAULT NULL`	—
5	employee_list_id	`int(11) NOT NULL` (Foreign Key -> `employee_list.id`)	FK
6	emp_supporting_doc_list_id	`int(11) NOT NULL` (Foreign Key -> `emp_supporting_doc_list.id`)	FK
7	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#60

emp_variable_anwer_list

7 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	answer	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	employee_list_id	`int(11) NOT NULL` (Foreign Key -> `employee_list.id`)	FK
6	emp_variable_list_id	`int(11) NOT NULL` (Foreign Key -> `emp_variable_list.id`)	FK
7	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#61

emp_variable_list

6 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	variable_name	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	state_of_req	`tinyint(1) DEFAULT NULL`	—
6	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#62

main_user_account_access_level_list

8 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	type_of_access	`varchar(45) DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	url_home	`varchar(4500) DEFAULT NULL`	—
6	dis	`varchar(4500) DEFAULT NULL`	—
7	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
8	job_role	`varchar(45) DEFAULT NULL`	—

#63

main_user_login

30 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	user_name	`varchar(450) DEFAULT NULL`	—
3	password	`varchar(450) DEFAULT NULL`	—
4	account_active_state	`tinyint(1) DEFAULT NULL`	—
5	ast	`tinyint(1) DEFAULT NULL`	—
6	sdt	`timestamp NULL DEFAULT NULL`	—
7	last_login	`timestamp NULL DEFAULT NULL`	—
8	name_show	`varchar(45) DEFAULT NULL`	—
9	email_verify	`tinyint(1) DEFAULT NULL`	—
10	moible_verfiy	`tinyint(1) DEFAULT NULL`	—
11	very_first_login	`tinyint(1) DEFAULT NULL`	—
12	cook_key	`varchar(4500) DEFAULT NULL`	—
13	ref_key	`varchar(45) DEFAULT NULL`	—
14	temp_lock	`tinyint(1) DEFAULT NULL`	—
15	full_block	`tinyint(1) DEFAULT NULL`	—
16	ac_type	`varchar(45) DEFAULT NULL`	—
17	control_account_state	`tinyint(1) DEFAULT NULL`	—
18	main_user_account_access_level_list_id	`int(11) NOT NULL` (Foreign Key -> `main_user_account_access_level_list.id`)	FK
19	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
20	image_url	`varchar(450) DEFAULT NULL`	—
21	google_id	`varchar(450) DEFAULT NULL`	—
22	google_authentication_secret	`varchar(4500) DEFAULT NULL`	—
23	is_google_authentication_enable	`tinyint(1) DEFAULT NULL`	—
24	microsoft_id	`varchar(450) DEFAULT NULL`	—
25	first_name	`varchar(450) DEFAULT NULL`	—
26	last_name	`varchar(450) DEFAULT NULL`	—
27	dis	`varchar(450) DEFAULT NULL`	—
28	phone_number	`varchar(45) DEFAULT NULL`	—
29	is_two_factor_auth_enable	`tinyint(1) DEFAULT NULL`	—
30	wrong_login_count	`int(11) DEFAULT NULL`	—

#64

main_user_login_device

13 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	device_type	`varchar(45) DEFAULT NULL`	—
5	browser	`varchar(45) DEFAULT NULL`	—
6	os	`varchar(45) DEFAULT NULL`	—
7	ip_address	`varchar(45) DEFAULT NULL`	—
8	last_activity	`datetime DEFAULT NULL`	—
9	login_time	`datetime DEFAULT NULL`	—
10	is_active	`tinyint(4) DEFAULT NULL`	—
11	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
12	session_token	`text`	—
13	location	`varchar(450) DEFAULT NULL`	—

#65

main_user_login_email_list

8 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	email_steate	`tinyint(1) DEFAULT NULL`	—
3	key_of_email	`text`	—
4	ast	`tinyint(1) DEFAULT NULL`	—
5	sdt	`timestamp NULL DEFAULT NULL`	—
6	type_email	`varchar(45) DEFAULT NULL`	—
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
8	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#66

audit_trail_report

6 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	dis	`varchar(4500) DEFAULT NULL`	—
5	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
6	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#67

department_email_history

6 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	subject_value	`varchar(4500) DEFAULT NULL`	—
3	message_body	`text`	—
4	ast	`tinyint(1) DEFAULT NULL`	—
5	sdt	`timestamp NULL DEFAULT NULL`	—
6	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#68

department_email_notification

6 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	dpt_name	`varchar(45) DEFAULT NULL`	—
3	email	`varchar(450) DEFAULT NULL`	—
4	ast	`tinyint(1) DEFAULT NULL`	—
5	sdt	`timestamp NULL DEFAULT NULL`	—
6	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#69

department_email_notification_has_email_history

4 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	sdt	`timestamp NULL DEFAULT NULL`	—
2	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
3	department_email_notification_id	`int(11) NOT NULL` (Foreign Key -> `department_email_notification.id`)	FK
4	department_email_history_id	`int(11) NOT NULL` (Foreign Key -> `department_email_history.id`)	FK

#70

downloads

7 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	description	`varchar(450) DEFAULT NULL`	—
5	file_path	`varchar(450) DEFAULT NULL`	—
6	item_serivice_list_id	`int(11) NOT NULL` (Foreign Key -> `item_serivice_list.id`)	FK
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK

#71

email_sms_link_manament

11 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	state_of_view	`tinyint(1) DEFAULT NULL`	—
3	on_short_lock	`tinyint(1) DEFAULT NULL`	—
4	key_of_encript	`varchar(450) DEFAULT NULL`	—
5	url_after_process	`text`	—
6	id_of_value	`text`	—
7	view_count	`int(11) DEFAULT NULL`	—
8	state_email	`tinyint(1) DEFAULT NULL`	—
9	state_sms	`tinyint(1) DEFAULT NULL`	—
10	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK
11	branch_id	`int(11) NOT NULL` (Foreign Key -> `branch.id`)	FK

#72

email_sms_link_view_history

4 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	sdt	`timestamp NULL DEFAULT NULL`	—
3	ast	`tinyint(1) DEFAULT NULL`	—
4	Email_SMS_link_manament_id	`int(11) NOT NULL` (Foreign Key -> `email_sms_link_manament.id`)	FK

#73

usefull_url_list

10 Columns Dev 1

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	url_name	`varchar(4500) DEFAULT NULL`	—
3	show_on_public	`tinyint(1) DEFAULT NULL`	—
4	sdt	`timestamp NULL DEFAULT NULL`	—
5	ast	`tinyint(1) DEFAULT NULL`	—
6	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
7	resion_of_url	`varchar(45) DEFAULT NULL`	—
8	priority_count	`double DEFAULT NULL`	—
9	page_cat	`varchar(450) DEFAULT NULL`	—
10	state_of_cat	`tinyint(1) DEFAULT NULL`	—

#74

banner_img

10 Columns Dev 2

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	img_pth	`varchar(4500) DEFAULT NULL`	—
5	name	`varchar(45) DEFAULT NULL`	—
6	is_about_hero	`tinyint(1) DEFAULT NULL`	—
7	is_about_core	`tinyint(1) DEFAULT NULL`	—
8	is_main_hero	`tinyint(1) DEFAULT NULL`	—
9	is_offer	`tinyint(1) DEFAULT NULL`	—
10	is_shop	`tinyint(1) DEFAULT NULL`	—

#75

statement_list_of_currency

9 Columns Dev 5

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	ast	`tinyint(1) DEFAULT NULL`	—
3	sdt	`timestamp NULL DEFAULT NULL`	—
4	code_of_currency	`varchar(45) DEFAULT NULL`	—
5	currencty_name	`varchar(45) DEFAULT NULL`	—
6	base_rate	`double DEFAULT NULL`	—
7	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
8	last_update	`timestamp NULL DEFAULT NULL`	—
9	company_id	`int(11) NOT NULL` (Foreign Key -> `company.id`)	FK

#76

statement_doc_payment_listing

8 Columns Dev 5

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	statement_doc_id	`int(11) NOT NULL` (Main parent statement tracking code)	—
3	amount	`double DEFAULT 0`	—
4	date	`date DEFAULT NULL`	—
5	time	`time DEFAULT NULL`	—
6	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
7	ast	`tinyint(1) DEFAULT 1`	—
8	sdt	`timestamp NULL DEFAULT CURRENT_TIMESTAMP`	—

#77

statement_doc_payment_listing_cus_sup_data

5 Columns Dev 5

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	statement_doc_payment_listing_id	`int(11) NOT NULL` (Foreign Key -> `statement_doc_payment_listing.id`)	FK
3	cus_sup_list_id	`int(11) NOT NULL` (Foreign Key -> `cus_sup_list.id`)	FK
4	ast	`tinyint(1) DEFAULT 1`	—
5	sdt	`timestamp NULL DEFAULT CURRENT_TIMESTAMP`	—

#78

statement_doc_payment_listing_user_account

5 Columns Dev 5

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	statement_doc_payment_listing_id	`int(11) NOT NULL` (Foreign Key -> `statement_doc_payment_listing.id`)	FK
3	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
4	ast	`tinyint(1) DEFAULT 1`	—
5	sdt	`timestamp NULL DEFAULT CURRENT_TIMESTAMP`	—

#79

statement_doc_payment_settlment_hisorty

8 Columns Dev 5

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	statement_doc_id	`int(11) NOT NULL` (Parent statement code reference)	—
3	amount	`double DEFAULT 0`	—
4	date	`date DEFAULT NULL`	—
5	time	`time DEFAULT NULL`	—
6	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
7	ast	`tinyint(1) DEFAULT 1`	—
8	sdt	`timestamp NULL DEFAULT CURRENT_TIMESTAMP`	—

#80

statement_doc_payment_settlment_hisorty_user_account

5 Columns Dev 5

Index	Column Name	Type / Properties	Key Designation
1	id	`int(11) NOT NULL` (Auto-Increment, Primary Key)	PK
2	statement_doc_payment_settlment_hisorty_id	`int(11) NOT NULL` (Foreign Key -> `statement_doc_payment_settlment_hisorty.id`)	FK
3	main_user_login_id	`int(11) NOT NULL` (Foreign Key -> `main_user_login.id`)	FK
4	ast	`tinyint(1) DEFAULT 1`	—
5	sdt	`timestamp NULL DEFAULT CURRENT_TIMESTAMP`	—

Laravel 11 Scaffolding Code Explorer

migrations/1_core_infrastructure.php

Project Roadmap & Integration Schedule

Gantt Milestone Schedule

Modernization Statistics

80

5

100%

Laravel 11

5-Developer Work Assignment Scopes

Developer 1

Key Milestones

Owned Tables (19)

Developer 2

Key Milestones

Owned Tables (14)

Developer 3

Key Milestones

Owned Tables (29)

Developer 4

Key Milestones

Owned Tables (12)

Developer 5

Key Milestones

Owned Tables (6)

Developer 6

Key Milestones

Owned Tables (0)

Database Directory & Columns

No matching tables found

about_us_text_content

allowance

item_rating

item_serivice_advacne_details

item_serivice_category

item_serivice_category_list

item_serivice_category_variable_list

item_serivice_category_variable_list_answer_list

item_serivice_images

item_serivice_list

item_serivice_list_downloads_list

item_serivice_list_has_item_serivice_tags

item_serivice_list_info_data

item_serivice_list_review_data

item_serivice_list_terms_and_condtion

item_serivice_list_unique_id_name_list

item_serivice_list_unique_id_name_list_data_list

item_serivice_list_variable_answer_list

item_serivice_list_variable_name_list

item_serivice_list_variable_selector_image_or_text_list

item_serivice_list_variable_selector_image_variable_answer_list

item_serivice_list_variable_selector_img_value_list

item_serivice_list_variable_selector_text_value_list

item_serivice_tags

item_service_barnd_list

item_service_branding_list

item_service_measuring_unit

v_selector_img_val_list_has_item_serivice_list_v_ans_list

v_selector_text_val_list_has_item_serivice_list_v_ansr_list

company

branch

cus_sup_list

cus_sup_address_list

cus_sup_address_list_has_cart_main_data_list

cus_sup_bank_account

cus_sup_contact_person

cus_sup_form_type_variable

cus_sup_from_type

cus_sup_special_condtion

cus_sup_type

cus_sup_variable_answers

cus_sup_variable_answers_big_text

cus_sup_variable_list

cart_cook_list_customer_data

cart_cook_list_customer_data_has_cart_main_data_list

cart_cook_list_customer_data_has_main_user_login

cart_is_user

cart_item_service_list

cart_main_data_list

cart_wish_list_item_service

cus_sup_list_has_cart_main_data_list

blog