ang

Tables (6)

ANSER (Untitled)

  • 고유ID (Key) — NULL — Primary key — NOT NULL
  • 고유 ID (QUESTION) — NULL — Foreign key → QUESTION.고유 ID — NOT NULL
  • 고유 ID (QUIZ-ID) — NULL — Foreign key → QUESTION.고유 ID — NOT NULL
  • ID (ID2) — NULL — Foreign key → QUESTION.ID — NOT NULL
  • 고유 ID (Key2) — NULL — Foreign key → QUESTION.고유 ID — NOT NULL
  • ID (ID3) — NULL — Foreign key → QUESTION.ID — NOT NULL
  • 정답 (Field) — NOT NULL

QUESTION (퀴즈 내용)

  • 고유 ID (QUESTION) — NULL — Primary key — NOT NULL
  • 고유 ID (QUIZ-ID) — NULL — Foreign key → QUIZ.고유 ID — NOT NULL
  • ID (ID2) — NULL — Foreign key → QUIZ.ID — NOT NULL
  • 고유 ID (Key) — NULL — Foreign key → QUIZ.고유 ID — NOT NULL
  • ID (ID3) — NULL — Foreign key → QUIZ.ID — NOT NULL
  • 퀴즈 내용 (CONTENT) — NOT NULL

QUIZ (퀴즈)

  • 고유 ID (QUIZ-ID) — NULL — Primary key — NOT NULL
  • ID (ID2) — NULL — Foreign key → USER.ID — NOT NULL
  • 고유 ID (Key) — NULL — Foreign key → USER-QUIZ.고유 ID — NOT NULL
  • ID (ID3) — NULL — Foreign key → USER-QUIZ.ID — NOT NULL
  • 퀴즈 제목 (TITLE) — NOT NULL
  • 퀴즈 설명 (DESCRIPTION) — NOT NULL
  • 생성 날짜 (CREATED) — NOT NULL
  • 댓글 (REPLE) — NOT NULL

RESULT (Untitled3)

  • 고유ID (Key2) — NULL — Primary key — NOT NULL
  • 고유 ID (Key) — NULL — Foreign key → USER-QUIZ.고유 ID — NOT NULL
  • ID — NULL — Foreign key → USER-QUIZ.ID — NOT NULL
  • 결과 (Field) — NOT NULL

USER (회원가입)

  • ID — NULL — Primary key — NOT NULL
  • 비밀번호 (PASSWARD) — NOT NULL
  • 이름 (NAME) — NOT NULL
  • 이메일 (E-MAIL) — NOT NULL
  • 도메인 (DOMAIN) — NOT NULL

USER-QUIZ (Untitled2)

  • 고유 ID (Key) — NULL — Primary key — NOT NULL
  • ID — NULL — Foreign key → USER.ID — NOT NULL
  • 생정 정보 (Field) — NOT NULL
  • 퀴즈를 푼 유저 정보 (Field2) — NOT NULL