시퀀스
테이블 (8)
Copy Of Copy Of Experience (QualificationPrizeHistory)
- Key (id) — 기본 키 — NOT NULL
- Key (myProfileId) — 외래 키 → MyProfile.Key — NOT NULL
- Field (type) — Enum — NOT NULL
- Field (startDate) — Date — NOT NULL
- Field (endDate) — Date — NOT NULL
- Field (contents) — String
Copy Of Experience (Work history)
- Key (id) — 기본 키 — NOT NULL
- Key (myProfileId) — 외래 키 → MyProfile.Key — NOT NULL
- Field (type) — Enum — NOT NULL
- Field (startDate) — Date — NOT NULL
- Field (endDate) — Date — NOT NULL
- Field (contents) — String
Experience (ExperienceHistory)
- Key (id) — 기본 키 — NOT NULL
- Key (myProfileId) — 외래 키 → MyProfile.Key — NOT NULL
- Field (type) — Enum — NOT NULL
- Field (startDate) — Date — NOT NULL
- Field (endDate) — Date — NOT NULL
- Field (contents) — String
Major
- id — 기본 키 — NOT NULL
- majorName
- Key — 외래 키 → School.id — NOT NULL
MyProfile
- Key (id) — 기본 키 — NOT NULL
- userId — 외래 키 → User.id — NOT NULL — 자동 부여
- Field
- schoolId — 외래 키 → School.id — NOT NULL
- entryYear
- graduateyear (graduateYear)
- studentStatus — NOT NULL — 재학상태
- hopeJob — NOT NULL — 희망직무
- Field2 (portfolioFile)
- Field2 (portfolioUrl)
- Field2 (greeting) — 자기소개
- Field2 (birth)
School
- id — 기본 키 — NOT NULL
- schoolName
Untitled (Skill)
- Key (myProfileId) — 외래 키 → MyProfile.Key — NOT NULL
- Field (skillName) — Enum — NOT NULL
User
- id — 기본 키 — NOT NULL — 자동 부여
- userId — NOT NULL — userID(로그인)
- name — NOT NULL — 유저이름
- password — NOT NULL — 비밀번호
- gender — NOT NULL — 성별
- address — NOT NULL — 주소
- phoneNumber — NOT NULL — 전화번호
- email