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