외청
테이블 (6)
Answer (answer)
- Answer (answer) — VARCHAR(1000) — 외래 키 → Opinion.Answer
- Title (title) — VARCHAR(1000)
- Body (body) — VARCHAR(1000)
Category (category)
- Category (category) — VARCHAR(500) — 기본 키 — NOT NULL
- Facility (facility) — VARCHAR(100)
- Cafeteria (cafeteria) — VARCHAR(100)
- Lecture (lecture) — VARCHAR(100)
- Etc (etc) — VARCHAR(100)
My page (my_page)
- ContextId (context_Id) — INT(11) — 외래 키 → User.ContextId — NOT NULL
- MyOpinion (my_opinion) — VARCHAR(1000)
- MyInterest (my_interest) — VARCHAR(1000)
Opinion (opinion)
- SharingLink (sharing_link) — 기본 키
- Tag (tag) — VARCHAR(100) — 기본 키
- Answer (answer) — VARCHAR(1000) — 기본 키
- Category (category) — VARCHAR(500) — 외래 키 → Category.Category — NOT NULL
- ContextId (context_Id) — INT(11) — 외래 키 → User.ContextId — NOT NULL
- Title (title) — VARCHAR(1000)
- Body (body) — VARCHAR(1000)
- Like (like) — INT(1000)
- Date (date) — INT(1000)
- Deadline (deadline) — INT(1000)
- Comments (comments) — VARCHAR(1000)
Opinions
- Category (category) — VARCHAR(500) — 외래 키 → Opinion.Category — NOT NULL
- Tag (tag) — VARCHAR(100) — 외래 키 → Opinion.Tag
- Answer (answer) — VARCHAR(1000) — 외래 키 → Opinion.Answer
- HotOpinion (hot_opinion) — VARCHAR(100)
- RecentOpinion (recent_opinion) — VARCHAR(100)
- SearchOpinion (search_opinion) — VARCHAR(100)
User (user)
- ContextId (context_Id) — INT(11) — 기본 키 — NOT NULL
- Lastname (last_name) — VARCHAR(10) — NOT NULL
- FirstName (first_name) — VARCHAR(10) — NOT NULL
- Studentnumber (s_number) — INT(10)
- Email (email) — VARCHAR((100)
- Password (password) — VARCHAR(10)