DB

Tables (5)

AcademicInfo

  • InfoID (정보아이디) — NUMBER — Primary key — NOT NULL
  • UserID (아이디2) — NUMBER — Foreign key → Users.UserID — NOT NULL
  • Title (제목) — VARCHAR2(255)
  • Description (설명) — VARCHAR2(500)
  • Author (저자) — VARCHAR2(100)
  • PubDate (게시일) — DATE
  • DocType (구분) — VARCHAR2(50)
  • Keywords (키워드) — VARCHAR2(255)

CitationHistory

  • CitationID (인용아이디) — NUMBER — Primary key — NOT NULL
  • UserID (아이디2) — NUMBER — Foreign key → Users.UserID — NOT NULL
  • UserID (유저아이디) — NUMBER
  • InfoID — NUMBER
  • CitationDate — DATE

SearchHistory

  • SearchID (검색아이디) — NUMBER — Primary key — NOT NULL
  • UserID (아이디2) — NUMBER — Foreign key → Users.UserID — NOT NULL
  • UserID (유저아이디) — NUMBER
  • SearchDate (검색날짜) — DATE

Team

  • TeamID (팀아이디) — NUMBER — Primary key — NOT NULL
  • UserID (아이디2) — NUMBER — Foreign key → Users.UserID — NOT NULL
  • UserID (유저아이디) — NUMBER
  • TeamName (팀이름) — VARCHAR2(100)

Users

  • UserID (아이디) — NUMBER — Primary key — NOT NULL
  • Name (이름) — VARCHAR2(100)
  • Email (이메일) — VARCHAR2(100)
  • Password (비밀번호) — VARCHAR2(100)
  • ResearchField (연구주제) — VARCHAR2(100)
  • InterestTopic (관심주제) — VARCHAR2(100)
  • RegiDate (가입일) — DATE