KopoHRResource
Tables (5)
EQ (학력)
- EQ_ID (PK) — Long — Primary key — NOT NULL
- HR_ID (FK) — Long — Foreign key → HR.HR_ID — NOT NULL
- school (Field) — String
- degree (Field2) — String
- grade (Field3) — String
- acceptedDate (Field4) — Date
- graduatedDate (Field5) — Date
- location (Field6) — String
HR (기본내역)
- HR_ID (PK) — Long — Primary key — NOT NULL
- jumin (Field) — String
- hiredDate (Field2) — Date
- resignedDate (Field3) — Date
- bankId (Field4) — String
- bankName (Field5) — String
- nationality (Field6) — String
- position (Field7) — String
- married (Field8) — String
LIC (자격)
- LIC_ID (PK) — Long — Primary key — NOT NULL
- HR_ID (FK) — Long — Foreign key → HR.HR_ID — NOT NULL
- code (Field) — String
- entity (Field2) — String
- date (Field3) — Date
PE (경력)
- PE_ID (PK) — Long — Primary key — NOT NULL
- HR_ID (FK) — Long — Foreign key → HR.HR_ID — NOT NULL
- company (Field) — String
- position (Field2) — String
- department (Field3) — String
- hiredDate (Field4) — Date
- resignedDate (Field5) — Date
- Content (Field6) — String
User
- USER_ID (PK) — Long — Primary key — NOT NULL
- HR_ID (FK) — Long — Foreign key → HR.HR_ID — NOT NULL
- username (Field) — String
- tel (Field2) — String
- birth (Field3) — date
- gender (Field4) — String
- address (Field5) — String
- zipcode (Field6) — String
- email (Field7) — String
- created (Field8) — Date
- password (Field9) — String
- userHrId (UNI) — String