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