미니프로젝트

테이블 (12)

approvednumber (Untitled4)

  • id (Key) — int — 외래 키 → registeruser.id — NOT NULL
  • approvedNumber (Field) — int

awardsHistory (Untitled11)

  • no (Key3) — int — 기본 키 — NOT NULL
  • resumeId (Key2) — int — 외래 키 → resume.resumeId — NOT NULL
  • id (Key) — int — 외래 키 → resume.id — NOT NULL
  • no_index (Field) — int
  • awardsHistoryCode (Field2) — varchar(20)
  • acquisitionDate (Field3) — date
  • awardName (Field5) — varchar(200)
  • Field6

board (Untitled6)

  • boardId (Key2) — int — 기본 키 — NOT NULL
  • id (Key) — int — 외래 키 → registeruser.id — NOT NULL
  • email (Field) — varchar(100)
  • nickname (Field2) — varchar(100)
  • content (Field4) — LONGTEXT
  • boardRegisterDate (Field6) — Date
  • views (Field7) — int

commonCode (Untitled9)

  • code_id (Key) — int — 기본 키 — NOT NULL
  • code_name (Field) — varchar(100)
  • useYn (Field2) — varchar(1)
  • code_preFix (Field3) — varchar(2)

companyHistory (Untitled8)

  • no (Field7) — int — 기본 키
  • id (Key) — int — 외래 키 → resume.id — NOT NULL
  • resumeId (Key2) — int — 외래 키 → resume.resumeId — NOT NULL
  • no_index (Key3) — int — NOT NULL
  • companyHistoryCode (Field) — varchar(20)
  • companyName (Field2) — varchar(100)
  • enterDate (Field3) — Date
  • endDate (Field4) — Date
  • LastPosition (Field5) — varchar(2)
  • description (Field6) — LONGTEXT

prpjectHistory (Untitled10)

  • no (Key3) — int — 기본 키 — NOT NULL
  • resumeId (Key2) — int — 외래 키 → resume.resumeId — NOT NULL
  • id (Key) — int — 외래 키 → resume.id — NOT NULL
  • no_index (Field) — int
  • projectHistoryCode (Field2) — varchar(20)
  • enterDate (Field3) — Date
  • endDate (Field4) — Date
  • LastPosition (Field5) — varchar(2)
  • description (Field6) — LONGTEXT
  • pjName (Field7) — varchar(100)

registeruser (Untitled)

  • id (Key) — int — 기본 키 — NOT NULL
  • email (Field2) — varchar(100)
  • password (Field3) — varchar(1000)
  • enabled (Field4) — varchar(1)

resume (Untitled7)

  • resumeId (Key2) — int — 기본 키 — NOT NULL
  • id (Key) — int — 외래 키 → registeruser.id — NOT NULL
  • companyHistoryCode (Field) — varchar(20)
  • projectHistoryCode (Field2) — varchar(20)
  • prjoectDetailText (Field3) — LONGTEXT
  • introduceText (Field4) — LONGTEXT
  • awardsHistoryCode (Field5) — varchar(20)
  • Field7

resumeImage (Untitled12)

  • no (Key3) — int — 기본 키 — NOT NULL
  • resumeId (Key2) — int — 외래 키 → resume.resumeId — NOT NULL
  • id (Key) — int — 외래 키 → resume.id — NOT NULL
  • filePath (Field2) — varchar(1000)
  • fileName (Field3) — varchar(1000)
  • originFileName (Field4) — varchar(1000)
  • registerDate (Field5) — Date
  • expire (Field6) — varchar(1)

role (Untitled2)

  • role_code (Key) — int — 기본 키 — NOT NULL
  • role_name (Field) — varchar(200)

userdetail (Untitled5)

  • id (Key) — int — 외래 키 → registeruser.id — NOT NULL
  • nickname (Field) — varchar(100)
  • postnumber (Field2) — varvhar(20)
  • address (Field3) — varchar(1000)
  • address2 (Field4) — varchar(1000)
  • age (Field5) — int
  • registerDate (Field6) — Date
  • updateDate (Field7) — Date
  • lockCount (Field8) — int

userrole (Untitled3)

  • id (Key) — int — 외래 키 → registeruser.id — NOT NULL
  • role_code (Key2) — int — 외래 키 → role.role_code — NOT NULL