MINGW
Tables (8)
Bulletin_Board (Untitled5)
- BoardPK (Primary) — NUM — Primary key — NOT NULL
- Category (Unique) — Varchar — Primary key — NOT NULL
- Title (Field2) — Varchar
- ContentLog (Field3) — Varchar
- Key — Foreign key → User.Student_ID — NOT NULL
Calender (Untitled2)
- Day (Primary) — Date — Primary key — NOT NULL
- Event_Name (Field) — Varchar
- Student_ID (Field3) — NUM — Foreign key → User.Student_ID — NOT NULL
- Category (Field2) — Varchar
Chat (Untitled4)
- Key — Foreign key → Contacts.Key — NOT NULL
- OtherUser (Field) — Varchar
- ChatLog (Field2) — Varchar
Comment (Untitled8)
- BoardPK (Primary) — NUM — Foreign key → Bulletin_Board.BoardPK — NOT NULL
- Key — Foreign key → Bulletin_Board.Key — NOT NULL
- C_Username (Field2) — Varchar
- C_Content (Field) — Varchar
Contacts (Untitled3)
- Key — Foreign key → User.Student_ID — NOT NULL
- Friend (Field2) — Varchar
Email (Untitled7)
- EmailPK (Primary) — NUM — Primary key — NOT NULL
- EmailFrom (Field2) — Varchar
- EmailTitle (Field3) — Varchar
- EmailLog (Field4) — Varchar
- Email (Foreign) — Varchar — Foreign key → User.Email — NOT NULL
- Key — Foreign key → User.Student_ID — NOT NULL
User (Untitled)
- Email (Unique) — Varchar — Primary key — NOT NULL
- Student_ID (Primary) — NUM — Primary key — NOT NULL
- Password (]) — Varchar
- Phone (.) — Varchar