|
id
|
int(11)
|
|
|
|
|
date
|
date
|
|
|
|
|
vendor
|
varchar(255)
|
|
|
|
|
payment_method
|
enum
|
-- |
|
other
|
|
category
|
varchar(255)
|
|
|
|
|
description
|
text
|
|
|
|
|
amount
|
decimal(15,2)
|
|
|
|
|
status
|
enum
|
-- |
|
pending
|
|
receipt_url
|
varchar(500)
|
|
|
|
|
notes
|
text
|
|
|
|
|
project_id
|
int(11)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
share_with
|
longtext
|
|
|
son_array('fuad','fatin'
|