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