TABLES
41
VIEWS
0
COLUMNS
255
Constraints
23
Anomalies
0
Routines
0
Database Properties
Database Type: MySQL - 8.0.42
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| mail_auth | 0 | 0 | 6 | 4 | Table | |
| sponsor_styles | 0 | 0 | 7 | 9 | Table | |
| purchase_orders | 0 | 0 | 7 | 8 | Table | |
| divisions | 2 | 1 | 5 | 4 | Table | |
| purchase_reports | 0 | 0 | 10 | 6 | Table | |
| campus_donations | 0 | 1 | 11 | 2 | Table | |
| receipts | 0 | 0 | 8 | 0 | Table | |
| departments | 0 | 0 | 4 | 13 | Table | |
| festival_items | 2 | 1 | 6 | 7 | Table | |
| sources | 0 | 0 | 4 | 0 | Table | |
| bureaus | 0 | 0 | 4 | 6 | Table | |
| purchase_items | 0 | 0 | 10 | 11 | Table | |
| activity_styles | 0 | 0 | 5 | 4 | Table | |
| user_groups | 0 | 2 | 5 | 3 | Table | |
| activity_informations | 0 | 0 | 9 | 0 | Table | |
| incomes | 1 | 0 | 4 | 0 | Table | |
| buy_report_income_expenditure_managements | 0 | 2 | 5 | 7 | Table | |
| floors | 1 | 1 | 5 | 0 | Table | |
| building_units | 1 | 1 | 5 | 0 | Table | |
| financial_records | 1 | 1 | 5 | 2 | Table | |
| activities | 1 | 0 | 11 | 2 | Table | |
| budgets | 0 | 0 | 6 | 0 | Table | |
| income_income_expenditure_managements | 0 | 2 | 5 | 0 | Table | |
| item_budgets | 0 | 1 | 5 | 7 | Table | |
| session | 0 | 0 | 6 | 0 | Table | |
| sponsors | 0 | 0 | 8 | 0 | Table | |
| year_periods | 0 | 0 | 6 | 0 | Table | |
| buy_statuses | 0 | 1 | 6 | 7 | Table | |
| rooms | 1 | 1 | 5 | 0 | Table | |
| spot_sponsor_names | 0 | 1 | 5 | 0 | Table | |
| years | 3 | 0 | 4 | 3 | Table | |
| income_expenditure_managements | 4 | 1 | 8 | 9 | Table | |
| room_teachers | 0 | 2 | 5 | 0 | Table | |
| roles | 0 | 0 | 4 | 4 | Table | |
| buy_reports | 3 | 1 | 7 | 7 | Table | |
| sponsor_activity_balance_managements | 0 | 2 | 5 | 0 | Table | |
| payment_receipts | 0 | 1 | 8 | 3 | Table | |
| teachers | 1 | 0 | 10 | 0 | Table | |
| users | 1 | 0 | 7 | 4 | Table | |
| password_reset_tokens | 0 | 0 | 5 | 0 | Table | |
| buildings | 1 | 0 | 4 | 0 | Table |