SearchModel
Tables (19)
Untitled (PERSON)
- Key (perID) — int — Primary key — NOT NULL
- Field (perName) — char
- Field (perDetail) — text
Untitled (RECOMMEND_SEARCH)
- Key (rankID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (seaID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (keyID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (RECOMMEND_KWD)
- Key (recommend_KWD) — char — Primary key — NOT NULL
- Key (keyID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (rankID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (EVALUATE)
- Key (rankID) — int — Primary key — NOT NULL
- Field (rankOrder) — int
- Field (areaID) — int — Foreign key → Untitled.Field
- Key (couID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (majID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (SEARCH)
- Key (seaID) — int — Primary key — NOT NULL
- Key (keyID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (seaKWD) — char
- Field (seaDetail) — text
- Field (dbID) — int — Foreign key → Untitled.Field
Untitled (USER_MAJOR)
- Key (majID) — int — Primary key — NOT NULL
- Field (majKWD) — char
- Field (majTitle) — char
- Field (majSubject) — char
Untitled (USER_COURSE)
- Key (couID) — int — Primary key — NOT NULL
- Field (couKWD) — char
- Field (couTitle) — char
- Field (couSubject) — char
Untitled (USER_AREA)
- Field (areaID) — int — Primary key
- Field (areaKWD) — char
- Field (areaTitle) — char
- Field (areaSubject) — char
Untitled (PUBLISHER)
- Key (pubID) — int — Primary key — NOT NULL
- Field (pubName) — char
- Field (pubAddress) — text
- Field (pubEmail) — text
- Field (pubPhone) — int
- Field (pubDetail) — text
Untitled (EVENT)
- Key (eveID) — int — Primary key — NOT NULL
- Field (eveName) — char
- Field (eveDetail) — text
Untitled (KEYWORD)
- Key (keyID) — int — Primary key — NOT NULL
- Field (keyKWD) — char
- Field (keyTitle) — char
- Field (keyDate) — date
- Field (keyAuthor) — char
- Field (keySubject) — char
- Field (keyEvent) — char
- Field (keyPerson) — char
- Field (keyPublisher) — char
Untitled (AUTHOR)
- Key (autID) — int — Primary key — NOT NULL
- Field (autName) — char
- Field (autEmail) — char
- Field (autEtc) — text
Untitled (SUBJECT)
- Key (subID) — int — Primary key — NOT NULL
- Field (subHead) — char
- Field (subDetail) — text
Untitled (ARTICLE_PUBLISHER)
- Key (pubID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (dbID) — int — Foreign key → Untitled.Field
Untitled (ARTICLE_EVENT)
- Key (eveID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (dbID) — int — Foreign key → Untitled.Field
Untitled (ARTICLE_PERSON)
- Key (perID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (dbID) — int — Foreign key → Untitled.Field
Untitled (ARTICLE_AUTHOR)
- Key (autID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (dbID) — int — Foreign key → Untitled.Field
Untitled (ARTICLE_SUBJECT)
- Key (subID) — int — Foreign key → Untitled.Key — NOT NULL
- Field (dbID) — int — Foreign key → Untitled.Field
Untitled (ARTICLE)
- Field (dbID) — int — Primary key
- Field (dbTitle) — char
- Field (dbURL) — text
- Field (dbKWD) — char
- Field (dbCON) — text