nomarlize
Tables (9)
Untitled (member)
- id — int — Primary key — NOT NULL
- name — varchar
Untitled (phonebook)
- phone — varchar
- id — int — Foreign key → Untitled.id — NOT NULL
Untitled (student_lecture)
- no — int — Primary key — NOT NULL
- lecture — varchar — Primary key — NOT NULL
- campus — varchar
- grade — varchar
Untitled (student)
- no — int — Primary key — NOT NULL
- campus — varchar
Untitled (worldcup)
- year — int — Primary key — NOT NULL
- winner — varchar
- coach — varchar
Untitled (winnerList)
- year — int — Primary key
- nation — varchar
Untitled2 (score)
- lecture — varchar
- grade — varchar
- no — int — Foreign key → Untitled.no — NOT NULL
profile
- id — int — Primary key — NOT NULL
- name — varchar
- phone1 — varchar
- phone2 — varchar
teams (world-coach)
- nation (coach) — varchar
- coach (nation) — varchar
- year — int — Foreign key → Untitled.year