trader_subcription_tracker

This table includes Bolbhav Plus subscription details and their expiry date. This table is used to track bolbhav plus user's subscription

Model

Field	Type	Nullable	Constraints
id	int4	No
user_id	int4	No	Foreign Key
transaction_id	text	No
subscription_plan	text	No
subscription_purchased_at	timestamp	No
subscription_expire_on	timestamp	No
is_active	boolean	No
transaction_data	json	No
created_at	timestamp	No
updated_at	timestamp	No
mandi_id	int4	Yes

Description of Fields

id

user_id - Unique Identifier of user

transaction_id - unique transaction id of payment done by user

subscription_plan - plan purchased by user

subscription_purchased_at - subscription purchased time

subscription_expire_on - subscription expiry date

is_active - status of plan is active or expired

trasaction_data - transaction data received from payment gateway

created_at -

updated_at -

mandi_id: this field is used when a user unlock access to a single mandi. This field stores the id of the mandi for which the access in unlocked. If access is unlocked for all mandis then this field remains null.