미니프로젝트
테이블 (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