normailze

Tables (14)

Untitled (Normal Form)

  • Field (id) — int — Primary key
  • Field2 (name) — varchar
  • Field3 (phone1) — varchar
  • Field (phone2) — varchar

Untitled (member)

  • Field — int — Primary key
  • Field2 (name) — varchar

Untitled (phonebook)

  • Field (phone) — varchar
  • Field — int — Foreign key → Untitled.Field

Untitled (student_lecture)

  • Key (no) — int — Primary key — NOT NULL
  • Key (lecture) — varchar — Primary key — NOT NULL
  • Field (campus) — varchar
  • Field (grade) — varchar

Untitled (student)

  • Key (no) — int — Primary key — NOT NULL
  • Field (campus) — varchar

Untitled (lecture)

  • Field (lecture) — varchar
  • Field2 (grade) — varchar
  • Key (no) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (worldcup)

  • Key (year) — int — Primary key — NOT NULL
  • Field (winner) — varchar
  • Field (coach) — varchar

Untitled (year_worldcup)

  • Key (year) — int — Primary key — NOT NULL
  • Field (nation) — varchar

Untitled (coach_worldcup)

  • Field (nation) — varchar
  • Field (coach) — varchar
  • Key (year) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Login)

  • Key (ID) — int — Primary key — NOT NULL
  • Field (Password) — int
  • Field (Email) — varchar
  • Field (Name) — varchar

Untitled (Profile)

  • Key (ID) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (College) — varchar
  • Field (Company) — varchar

Untitled (Write_comment)

  • Key (ID) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (Write) — varchar
  • Field2 (Comment) — varchar

Untitled (Reply)

  • Key (Count) — int — Primary key — NOT NULL
  • Key (ID) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (Now) — date
  • Field (like) — int

Untitled (Like)

  • Key (ID) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (Count) — int — Foreign key → Untitled.Key — NOT NULL