EvolvedRecord

Table Name: evolved_records

Columns

Name	Type	Nullable	Primary Key	Default
`id`	`UUID`	False	Yes	CallableColumnDefault(<function uuid4 at 0x74c88c648540>)
`cycle_id`	`INTEGER`	False	No	None
`category`	`VARCHAR(50)`	False	No	None
`function_code`	`VARCHAR(50)`	True	No	None
`agreement_no`	`VARCHAR(100)`	True	No	None
`due_date`	`DATE`	True	No	None
`status`	`VARCHAR(50)`	True	No	ScalarElementColumnDefault('pending')
`record_key`	`VARCHAR(255)`	False	No	None
`core_data`	`JSONB`	False	No	None
`derived_fields`	`JSONB`	True	No	CallableColumnDefault(<function dict at 0x74c88c648720>)
`summary_data`	`JSONB`	True	No	CallableColumnDefault(<function dict at 0x74c88c6487c0>)
`payout_data`	`JSONB`	True	No	CallableColumnDefault(<function dict at 0x74c88c648860>)
`template_execution_ids`	`JSONB`	True	No	CallableColumnDefault(<function list at 0x74c88c648900>)
`payout_cycle_id`	`INTEGER`	True	No	None
`processing_metadata`	`JSONB`	True	No	CallableColumnDefault(<function dict at 0x74c88c648ae0>)
`created_at`	`DATETIME`	False	No	None
`updated_at`	`DATETIME`	False	No	None

Data Filters

Active Filters:

Data Records

id	cycle_id	category	function_code	agreement_no	due_date	status	record_key	core_data	derived_fields	summary_data	payout_data	template_execution_ids	payout_cycle_id	processing_metadata	created_at	updated_at

Showing 1-0 of 0

Relationships

Relationship Name	Target Model	Direction
`cycle`	ingestion_cycle_record	MANYTOONE

© SimSol Technologies and Services Private Limited