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