Invoices

Service: subscription-api Table: invoices

Fields

Field	Type	Required	Default	Notes
id	uuid	no	-	-
subscription_id	uuid	yes	-	-
account_id	uuid	yes	-	-
invoice_number	string	no	-	unique
status	enum	no	-	enum: draft, open, paid, void, uncollectible
currency	string	no	-	-
subtotal	integer	no	-	-
tax	integer	no	-	-
total	integer	no	-	-
amount_paid	integer	no	-	-
amount_due	integer	no	-	-
line_items	jsonb	no	-	-
period_start	timestamp	no	-	-
period_end	timestamp	no	-	-
due_date	timestamp	no	-	-
paid_at	timestamp	no	-	-
metadata	jsonb	no	-	-
created_at	timestamp	no	-	-
updated_at	timestamp	no	-	-