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

ChatGroup (Untitled6)

  • Field2
  • Field3

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