| Lucidchart | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Database tables and references
Expand the link below to see a table of the primary and foreign keys for each table.
| Expand | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Registration
Description of the database :
Target apps : Reg, Cal
Table | Description |
|---|---|
League Refs
Description of the database :
Target apps : Reg, Cal
Table | Description |
|---|---|
Cal & Reservation
Description of the database :
Target apps : Reg, Cal
Table | Description |
|---|---|
Receipt
Description of the database :
Target apps : Reg, Cal
Table | Description |
|---|---|
Contacts
Description of the database :
Target apps : Reg, Cal
Table | Description |
|---|---|
Tournaments
Description of the database :
Target apps : Reg, Cal
Table | Description |
|---|---|
Photo
Description of the database :
Target apps : Reg, Cal
Table | Description |
|---|---|
Tech
Description of the database : the data related to the info needed to integrate with Moodle. Tech is taking care of the login with Moodle. In tech You have 4 type of la federation, regions, clubs and directors. On the Moodle side you have 2 types : Teachers (Instructional Designer) and Students.
Target apps : Reg, Cal
Table | Description |
|---|---|