income_expenditure_managements

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
buy_report_income_expenditure_managements.income_expenditure_management_id buy_report_income_expenditure_managements_ibfk_2 C
income_income_expenditure_managements.income_expenditure_id income_income_expenditure_managements_ibfk_1 C
sponsor_activity_balance_managements.income_expenditure_management_id sponsor_activity_balance_managements_ibfk_2 C
spot_sponsor_names.income_expenditure_id spot_sponsor_names_ibfk_1 C
amount INT 10 null
log_category enum('income', 'expenditure', 'sponsor''s income') 16 null
year_id INT UNSIGNED 10 null
years.id income_expenditure_managements_ibfk_1 C
receive_option enum('transfer', 'hand') 8 √ null
is_checked BIT 1 0
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
year_id_foreign_key Performance Asc year_id

Relationships

Close relationships within degrees of separation