BucketMaster

Table Name: bucket_master

Columns

Name	Type	Nullable	Primary Key	Default
`id`	`UUID`	False	Yes	CallableColumnDefault(<function uuid4 at 0x74c88cc26520>)
`name`	`VARCHAR(100)`	False	No	None
`product_code`	`VARCHAR(20)`	False	No	None
`mapping`	`JSON`	False	No	None
`bucket_names`	`JSON`	True	No	ScalarElementColumnDefault({'0': 'Current', '1': 'X', '2': 'FE', '3': '1-30', '4': '31-60', '5': '61-90', '6': '91-120', '7': '121-180', '8': '181-360', '9': '360+', '10': 'WO'})
`emi_codes`	`JSON`	True	No	ScalarElementColumnDefault({'current': 1, 'frontend': 1, 'backend': 2})
`fields_used`	`VARCHAR(100)`	True	No	None
`has_been_used`	`BOOLEAN`	True	No	ScalarElementColumnDefault(False)
`is_authorized`	`BOOLEAN`	True	No	ScalarElementColumnDefault(False)
`active_status`	`BOOLEAN`	True	No	ScalarElementColumnDefault(True)
`checker_status`	`JSON`	True	No	ScalarElementColumnDefault({'approve': False, 'reject': False, 'returned': False})
`created_at`	`DATETIME`	True	No	CallableColumnDefault(<function datetime.utcnow at 0x74c88cc26980>)
`created_by`	`VARCHAR(100)`	True	No	None
`created_by_id`	`UUID`	True	No	None
`checked_at`	`DATETIME`	True	No	None
`checked_by`	`VARCHAR(100)`	True	No	None
`checked_by_id`	`UUID`	True	No	None
`updated_at`	`DATETIME`	True	No	CallableColumnDefault(<function datetime.utcnow at 0x74c88cc26a20>)

Data Filters

Active Filters:

Data Records

id	name	product_code	mapping	bucket_names	emi_codes	fields_used	has_been_used	is_authorized	active_status	checker_status	created_at	created_by	created_by_id	checked_at	checked_by	checked_by_id	updated_at

Showing 1-0 of 0

Relationships

This model has no defined relationships.

© SimSol Technologies and Services Private Limited