This shows you the differences between two versions of the page.
— |
kurs:diagramme_maps_etc [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{kurs:mer-_2_mini.png}} | ||
+ | |||
+ | TABELLEN | ||
+ | (FK) ; Foreign Key | ||
+ | |||
+ | ____ Primary Key | ||
+ | |||
+ | |||
+ | ADM_admin | ||
+ | ADM_ID | ||
+ | ADM_name | ||
+ | ADM_password | ||
+ | |||
+ | USR_user | ||
+ | USR_ID | ||
+ | USR_password | ||
+ | USR_name | ||
+ | USR_email | ||
+ | USR_mitglieds_datum | ||
+ | USR_is_freigeschaltet | ||
+ | USR_is_deaktiviert | ||
+ | |||
+ | |||
+ | MNN_mannschaft | ||
+ | MNN_ID | ||
+ | MNN_name | ||
+ | |||
+ | |||
+ | WET_wette | ||
+ | WET_ID | ||
+ | WET_anfangzeit | ||
+ | WET_endzeit | ||
+ | WET_quote_tipp_1 | ||
+ | WET_quote_tipp_2 | ||
+ | WET_quote_tipp_3 | ||
+ | WET_ergebnis | ||
+ | WET_is_begonnen | ||
+ | WET_is_beenden | ||
+ | WET_is_processed | ||
+ | WET_MNN_erste_ID (FK) | ||
+ | WET_MNN_zweite_ID (FK) | ||
+ | |||
+ | GWT_gespieltewetten | ||
+ | GWT_ID | ||
+ | GWT_WET_ID (FK) | ||
+ | GWT_USR_ID (FK) | ||
+ | |||
+ | |||
+ | KNT_konto | ||
+ | KNT_ID | ||
+ | KNT_USR_ID (FK) | ||
+ | KNT_kontostand | ||
+ | |||
+ | |||
+ | |||
+ | KBW_kontobewegung | ||
+ | KBW_ID | ||
+ | KBW_KNT_ID (FK) | ||
+ | KBW_gewinn | ||
+ | KBW_verlust | ||
+ | KBW_einzahlung | ||
+ | KBW_auszahlung | ||
+ | KBW_bewegungs_datum | ||
+ | | ||
+ | SSN_session | ||
+ | SSN_ID | ||
+ | SSN_USR_ID (FK) | ||
+ | |||
+ | |||
+ | |||
+ | == thx Valeria == | ||