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