TABLES
36
VIEWS
0
COLUMNS
227
Constraints
15
Anomalies
0
Routines
1
Database Properties
Database Type: MySQL - 8.0.37
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| mail_auth | 0 | 0 | 6 | 4 | Table | |
| sponsor_styles | 0 | 0 | 7 | 0 | Table | |
| purchase_orders | 0 | 0 | 7 | 0 | Table | |
| divisions | 2 | 1 | 5 | 4 | Table | |
| purchase_reports | 0 | 0 | 10 | 0 | Table | |
| receipts | 0 | 0 | 8 | 0 | Table | |
| departments | 1 | 0 | 4 | 13 | Table | |
| festival_items | 2 | 1 | 6 | 7 | Table | |
| sources | 0 | 0 | 4 | 0 | Table | |
| expenses | 0 | 0 | 6 | 10 | Table | |
| bureaus | 0 | 0 | 4 | 6 | Table | |
| purchase_items | 0 | 0 | 10 | 11 | Table | |
| activity_styles | 0 | 0 | 5 | 4 | Table | |
| room_teacher | 0 | 2 | 5 | 0 | Table | |
| fund_informations | 0 | 0 | 10 | 2 | Table | |
| user_groups | 0 | 2 | 5 | 3 | Table | |
| activity_informations | 0 | 0 | 9 | 0 | Table | |
| floors | 1 | 1 | 5 | 0 | Table | |
| building_units | 1 | 1 | 5 | 3 | Table | |
| financial_records | 1 | 1 | 5 | 2 | Table | |
| activities | 0 | 0 | 11 | 2 | Table | |
| budgets | 0 | 0 | 6 | 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 | |
| years | 1 | 0 | 4 | 2 | Table | |
| roles | 0 | 0 | 4 | 0 | Table | |
| buy_reports | 2 | 1 | 7 | 7 | Table | |
| payment_receipts | 0 | 1 | 8 | 3 | Table | |
| users | 1 | 0 | 7 | 2 | Table | |
| teachers | 1 | 1 | 9 | 2 | Table | |
| password_reset_tokens | 0 | 0 | 5 | 0 | Table | |
| buildings | 1 | 0 | 4 | 27 | Table |