invoice_items


Columns

Column Type Size Nulls Auto Default Children Parents Comments
invoice_id VARCHAR 36 null
invoices.id invoice_items_ibfk_1 C
description VARCHAR 255 null
quantity INT 10 null
unit_price DECIMAL 10,2 null
total DECIMAL 10,2 null

Indexes

Constraint Name Type Sort Column(s)
idx_invoice_id Performance Asc invoice_id

Relationships