페이브

테이블 (31)

AR_Quiz (ar_quiz)

  • id — PK — 기본 키 — NOT NULL
  • Title (title) — NOTNULL
  • Quiz (quiz) — NOTNULL
  • Answer (answer) — NOTNULL

Admin (admin)

  • id — PK — 기본 키 — NOT NULL
  • UserName (username) — NOTNULL
  • PassWord (password) — NOTNULL

Default_Result (default_result)

  • ID (id) — PK — 기본 키 — NOT NULL
  • Type (type) — NOTNULL
  • Mbti_Result (mbti_result) — 외래 키 → MBTI_result.id — NOT NULL
  • Holland_Result (holland_result) — 외래 키 → Holland_result.id — NOT NULL
  • Egogram_Result (egogram_result) — 외래 키 → Egogram_result.id — NOT NULL
  • Okgram_Result (okgram_result) — 외래 키 → OKgram_result.id — NOT NULL
  • Recovery_Result (recovery_result) — 외래 키 → Recovery_result.id — NOT NULL
  • StromgPoint_Result (strongpoint_result) — 외래 키 → StrongPoint_result.id — NOT NULL

Department (department)

  • id — PK — 기본 키 — NOT NULL
  • Department (department) — NOTNULL
  • Color (color) — NOTNULL

Egogram_Card (egogram_card)

  • id — PK — 기본 키 — NOT NULL
  • Question (question) — NOTNULL
  • QusetionNum (questionNumi) — NOTNULL

Egogram_Data (egogram_data)

  • id — PK — 기본 키 — NOT NULL
  • EgogramType (egogramType) — NOTNULL
  • Explain (explain) — NOTNULL

Egogram_Test (egogram_test)

  • id — PK — 기본 키 — NOT NULL
  • Type (type) — NOTNULL
  • Questions (questions) — 외래 키 → Egogram_Card.id — NOT NULL

Egogram_result (egogram_result)

  • id — PK — 기본 키 — NOT NULL
  • TesterId (testerId) — PK — 외래 키 → User.id — NOT NULL
  • Scores (scores) — NOTNULL
  • RowData (rowdata) — NOTNULL
  • QuestionNums (questionNums) — NOTNULL

Holland_Card (holland_card)

  • id — PK — 기본 키 — NOT NULL
  • Question (question) — NOTNULL
  • QusetionNum (questionNumi) — NOTNULL

Holland_Data (holland_data)

  • id — PK — 기본 키 — NOT NULL
  • HollandType (hollandType) — NOTNULL
  • Explain (explain) — NOTNULL
  • Majors (majors) — 외래 키 → Major_Card.id — NOT NULL

Holland_Test (holland_test)

  • id — PK — 기본 키 — NOT NULL
  • Type (type) — NOTNULL
  • Subject (subject) — NOTNULL
  • Questions (questions) — 외래 키 → Holland_Card.id — NOT NULL

Holland_result (holland_result)

  • id — PK — 기본 키 — NOT NULL
  • TesterId (testerId) — PK — 외래 키 → User.id — NOT NULL
  • Scores (scores) — NOTNULL
  • RowData (rowdata) — NOTNULL
  • QustionNums (qustionNums) — NOTNULL
  • Results (results) — 외래 키 → Holland_Data.id — NOT NULL

MBTI_Card (mbti_card)

  • id — PK — 기본 키 — NOT NULL
  • TrueAnswer (trueAnswer) — NOTNULL
  • FalseAnswer (falseAnswer) — NOTNULL
  • QuestionNum (questionNum) — NOTNULL

MBTI_Data (mbti_data)

  • id — PK — 기본 키 — NOT NULL
  • MBTIType (mbtiType) — NOTNULL
  • Explain (explain) — NOTNULL
  • Majors (majors) — 외래 키 → Major_Card.id — NOT NULL

MBTI_Test (mbti_test)

  • id — PK — 기본 키 — NOT NULL
  • Type (type) — NOTNULL
  • Questions (questions) — 외래 키 → MBTI_Card.id — NOT NULL

MBTI_result (mbti_result)

  • id — PK — 기본 키 — NOT NULL
  • TesterId (testerId) — PK — 외래 키 → User.id — NOT NULL
  • Scores (scores) — NOTNULL
  • RowData (rowdata) — NOTNULL
  • QustionNums (QusetionNums) — NOTNULL
  • Result (result) — 외래 키 → MBTI_Data.id — NOT NULL

Major_Card (major_card)

  • id — PK — 기본 키 — NOT NULL
  • Major (majors) — NOTNULL
  • Explain (explain) — NOTNULL
  • CardFront (cardFront) — NOTNULL
  • CardBack (cardBack) — NOTNULL
  • Department (department) — 외래 키 → Department.id — NOT NULL
  • ARQuiz (arquiz) — 외래 키 → AR_Quiz.id — NOT NULL

OKgram_Card (okgram_card)

  • id — PK — 기본 키 — NOT NULL
  • Question (question) — NOTNULL
  • QusetionNum (questionNumi) — NOTNULL

OKgram_Data (okgram_data)

  • id — PK — 기본 키 — NOT NULL
  • OkgramType (okgramType) — NOTNULL
  • Explain (explain) — NOTNULL

OKgram_Test (okgram_test)

  • id — PK — 기본 키 — NOT NULL
  • Type (type) — NOTNULL
  • Questions (questions) — 외래 키 → OKgram_Card.id — NOT NULL

OKgram_result (okgram_result)

  • id — PK — 기본 키 — NOT NULL
  • TesterId (testerId) — PK — 외래 키 → User.id — NOT NULL
  • Scores (scores) — NOTNULL
  • RowData (rowdata) — NOTNULL
  • QuestionNums (questionNums) — NOTNULL

Recovery_Card (recovery_card)

  • id — PK — 기본 키 — NOT NULL
  • Question (question) — NOTNULL
  • QusetionNum (questionNumi) — NOTNULL
  • Reverse (reverse) — NOTNULL

Recovery_Data (Recovery_data)

  • id — PK — 기본 키 — NOT NULL
  • RecoveryType (recoveryType) — NOTNULL
  • Explain (explain) — NOTNULL

Recovery_Test (recovery_test)

  • id — PK — 기본 키 — NOT NULL
  • Type (type) — NOTNULL
  • Questions (questions) — 외래 키 → Recovery_Card.id — NOT NULL

Recovery_result (recovery_result)

  • id — PK — 기본 키 — NOT NULL
  • TesterId (testerId) — PK — 외래 키 → User.id — NOT NULL
  • Scores (scores) — NOTNULL
  • RowData (rowdata) — NOTNULL
  • QuestionNums (questionNums) — NOTNULL
  • Results (results) — 외래 키 → Recovery_Data.id — NOT NULL

School (school)

  • id — PK — 기본 키 — NOT NULL
  • SchoolName (schoolName) — NOTNULL
  • Area (area) — NOTNULL
  • Level (level) — NOTNULL

StrongPoint_Card (strongpoint_card)

  • id — PK — 기본 키 — NOT NULL
  • Question (question) — NOTNULL
  • QusetionNum (questionNumi) — NOTNULL

StrongPoint_Data (strongpoint_data)

  • id — PK — 기본 키 — NOT NULL
  • StrongPointType (strongpointType) — NOTNULL
  • Explain (explain) — NOTNULL

StrongPoint_Test (strongpoint_test)

  • id — PK — 기본 키 — NOT NULL
  • Type (type) — NOTNULL
  • SubType (subType) — NOTNULL
  • Questions (questions) — 외래 키 → StrongPoint_Card.id — NOT NULL

StrongPoint_result (strongpoint_result)

  • id — PK — 기본 키 — NOT NULL
  • TesterId (testerId) — PK — 외래 키 → User.id — NOT NULL
  • Scores (scores) — NOTNULL
  • RowData (rowdata) — NOTNULL
  • QuestionNums (questionNums) — NOTNULL
  • Results (results) — 외래 키 → StrongPoint_Data.id — NOT NULL

User (user)

  • id — PK — 기본 키 — NOT NULL
  • Username (username) — NOTNULL
  • PassWord (password) — NOTNULL
  • Name (name) — NOTNULL
  • Birth (birth) — NOTNULL
  • Gender (gender) — NOTNULL
  • Phone (phone)
  • Major (major)
  • SchoolId (schoolId) — PK — 외래 키 → School.id — NOT NULL
  • Grade (grade)
  • Field