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