Bitcoin & Transfers | Fold Schema

+ Entity Relationship Diagram

Scroll to zoom Drag to pan Double-click to fit 100%

erDiagram BitgoTransferBatch { string id PK string name string status string address string fortress_transfer_id } RewardWithdrawalBatch { string id PK int status datetime created string fulfillment_method int payment FK }

BitgoTransferBatch

Table: fold_bitgo_transfer_batch Extends: BaseModelMixin

Field	Type	Constraints
`id`	BigAutoField	PK
`name`	CharField(255)	unique
`status`	TextField	choices default=value
`address`	TextField	nullable
`fortress_transfer_id`	TextField	nullable

Referenced By (1 tables)

BitgoAccount N:1 .transfer_batch

Sample Queries (click to expand)

Get all records

BitgoTransferBatch.objects.all()

SELECT * FROM fold_bitgo_transfer_batch;

Get by ID

BitgoTransferBatch.objects.get(id=1)

SELECT * FROM fold_bitgo_transfer_batch WHERE id = 1;

RewardWithdrawalBatch

Table: fold_rewardwithdrawalbatch Extends: SaveHooks

Field	Type	Constraints
`id`	BigAutoField	PK
`status`	SmallIntegerField	choicesSTATUSES
`created`	DateTimeField	default=now()
`fulfillment_method`	CharField(40)	choices
`payment`	FK → Payment	nullable

Relationships

.payment N:1 Payment

Referenced By (1 tables)

RewardWithdrawalRequest N:1 .batch

Sample Queries (click to expand)

Get all records

RewardWithdrawalBatch.objects.all()

SELECT * FROM fold_rewardwithdrawalbatch;

Get by ID

RewardWithdrawalBatch.objects.get(id=1)

SELECT * FROM fold_rewardwithdrawalbatch WHERE id = 1;

With related Payment

RewardWithdrawalBatch.objects.select_related("payment")

SELECT * FROM fold_rewardwithdrawalbatch t JOIN payment r ON t.payment_id = r.id;

Filter by created (last 7 days)

RewardWithdrawalBatch.objects.filter(created__gte=datetime.now()-timedelta(days=7))

SELECT * FROM fold_rewardwithdrawalbatch WHERE created >= NOW() - INTERVAL '7 days';