LifeSenior

Tables (9)

Answer (질문에 대한 답변)

  • id — PK — Primary key — NOT NULL
  • question (questionFK) — ForeignKey — Foreign key → Question.id — NOT NULL
  • autor (작성자) — ForeignKey — Foreign key → User.id — NOT NULL
  • content (답변 내용) — TextField
  • image (이미지) — ImageField — NOT NULL
  • recommend (추천) — PositiveIntegerField

Choice (보기)

  • id — PK — Primary key — NOT NULL
  • quiz (quizFK) — ForeingKey — Foreign key → Quiz.Key — NOT NULL
  • text (보기글) — CharField

Comment (댓글)

  • id — PK — Primary key — NOT NULL
  • autor (작성자) — ForeignKey — Foreign key → User.id — NOT NULL
  • question (질문) — ForeignKey — Foreign key → Question.id — NOT NULL
  • content (댓글 내용) — CharField
  • date (작성 날짜) — DateTimeField

CorrectByDate (날짜별 퀴즈 맞춘 개수)

  • id — PK — Primary key — NOT NULL
  • user (유저) — ForeignKey — Foreign key → User.id — NOT NULL
  • date (날짜) — DateTimeField
  • count (맞춘 개수) — PositiveIntegerField

Profile (User 세부)

  • Key — Primary key — NOT NULL
  • user (유저) — OneToOneField — Foreign key → User.id — NOT NULL
  • name (이름) — CharField
  • description (한줄 소개) — CharField
  • image (프로필 사진) — ImageField
  • total (전체 문제) — PositiveIntegerField
  • realty (부동산) — PositiveIntegerField
  • economy (경제) — PositiveIntegerField
  • Selfdevelopement (자기개발) — PositiveIntegerFIeld
  • discount (할인) — PositiveIntegerField
  • commonSense (시사상식) — PositiveIntegerField
  • etc (기타) — PositiveIntegerField
  • answerCount (답변한 횟수) — PositiveIntegerFIeld
  • recommendCount (답변 추천 횟수) — PositiveIntegerField
  • questionCount (질문한 횟수) — PositiveInterField

Question (질문)

  • id (Key) — PK — Primary key — NOT NULL
  • autor (작성자) — ForeignKey — Foreign key → User.id — NOT NULL
  • title (제목) — CharField
  • content (내용) — TextField
  • date (작성 날짜) — DateTImeFIeld
  • recommend (추천) — PositiveIntegerFIeld
  • category (키워드) — CharField
  • views (조회수) — PositiveIntegerFIeld
  • answerd (답변이 됐는지 확인) — BooleanField

Quiz (퀴즈)

  • Key — PK — Primary key — NOT NULL
  • text (질문 문항) — CharField
  • description (카테고리 요약글) — CharField
  • category (카테고리) — CharField
  • difficulty (난이도) — PositiveIntegerField
  • total (전체 정답 시도 수) — PositiveIntegerFIeld
  • incorrect (문제 오답 수) — PositiveIntegerField
  • correct (정답) — CharField
  • content (오답노트) — TextField

User (유저)

  • id — PK — Primary key — NOT NULL
  • username (아이디)
  • password (비밀번호) — CharField

term (Untitled4)

  • id — PK — Primary key — NOT NULL
  • title (제목) — CharFIeld
  • description (요약 한줄 정리) — CharField
  • content (내용) — TextField
  • category (분류) — CharField