외청

테이블 (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)