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