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