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