시퀀스

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