123

Tables (6)

KEYWORD (Untitled4)

  • keywordID (Key) — int(20) — Primary key — NOT NULL
  • keyword (Field) — char(20)
  • count (Field2) — int(50)
  • creationdate (Field3) — int(10)
  • lastupdateddate (Field4) — int(10)

KEYWORD_MATERIAL (Untitled6)

  • keywordID (Key) — int(20) — Foreign key → KEYWORD.keywordID — NOT NULL
  • meterialID (Key2) — int(10) — Foreign key → MATERIAL.meterialID — NOT NULL

MATERIAL (Untitled3)

  • meterialID (Key) — int(10) — Primary key — NOT NULL
  • title (Field) — char(10)
  • type (Field2) — char(10)
  • academic (Field3) — char(20)

SEARCH LOG (Untitled2)

  • logID (Key) — int(10) — Primary key — NOT NULL
  • userID (Key2) — int(10) — Foreign key → USER.userID — NOT NULL
  • term (Field) — char(20)
  • time (Field2) — int(5)
  • meterialID (Key3) — int(10) — Foreign key → MATERIAL.meterialID — NOT NULL

USER (Untitled)

  • userID (Key) — int(10) — Primary key — NOT NULL
  • name (Field) — char(3)
  • grade (Field2) — int(4)
  • major (Field3) — chat(10)
  • affiliatione (Field4) — char(10)

USER_KEYWORD (Untitled5)

  • userID (Key) — int(10) — Foreign key → USER.userID — NOT NULL
  • keywordID (Key2) — int(20) — Foreign key → KEYWORD.keywordID — NOT NULL