WanSoo

Tables (5)

Analysis (Untitled4)

  • id (PK) — Primary key — NOT NULL
  • score_id (FK) — Foreign key → Score.id — NOT NULL
  • university_id (Fk2) — Foreign key → University.Key — NOT NULL
  • base_score (Field2)
  • diff_score (Field) — myscore_basescore
  • analysis_result (Field3)

Recommendation (Untitled3)

  • id (PK) — Primary key — NOT NULL
  • University_id (FK2) — Foreign key → University.Key — NOT NULL
  • score_id (FK) — Foreign key → Score.id — NOT NULL
  • analysis_id (FK3) — Foreign key → Score.email — NOT NULL
  • name (Field)
  • Recommend_type (Field3) — (상향/적정/안정)

Score (Untitled2)

  • id (PK) — Primary key — NOT NULL
  • email (FK) — Foreign key → User.email — NOT NULL
  • Korean (Field)
  • Korean_type (Field2) — (화작,언매)
  • Math (Field3)
  • Math_type (Field4) — (확통,기벡,미적)
  • English (Field5)
  • History (Field6)
  • Science (Field7)
  • Science_type (Field8)
  • Sociality (Field9)
  • Sociality_type (Field10)

University (Untitled5)

  • Key (PK) — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • region (Field2)
  • major (Field3)
  • description (Field4)
  • url (Field5)

User (Untitled)

  • email (PK) — Primary key — NOT NULL
  • social_type (Field) — (naver , kakao)
  • name (Field2) — VARCHAR
  • Field3 — VARCHAR