DBP_0418

Tables (10)

Career (Untitled5)

  • career_id (Key) — Long — Primary key — NOT NULL
  • person_id (Key2) — Long — Foreign key → Person.person_id — NOT NULL
  • start_period (Field) — Date
  • end_period (Field2) — Date
  • company_name (Field3) — String
  • spot (Field4) — String
  • part (Field5) — String
  • reason (Field6) — String

Category (Untitled2)

  • resume_id (Key) — Foreign key → Resume.resume_id — NOT NULL
  • person_id (Key2) — Long — Foreign key → Resume.person_id — NOT NULL
  • career (Field) — Boolean
  • part (Field2) — String
  • salary (Field3) — Long

ETC (Untitled9)

  • etc_id (Key) — Long — Primary key — NOT NULL
  • person_id (Key2) — Long — Foreign key → Person.person_id — NOT NULL
  • length (Field) — Float
  • weight (Field2) — Float
  • Field3 — Float
  • hobby (Field4) — String
  • specialty (Field5) — String
  • religion (Field6) — String
  • program_id (Field7) — Program

Family (Untitled8)

  • family_id (Key) — Long — Primary key — NOT NULL
  • person_id (Key2) — Long — Foreign key → Person.person_id — NOT NULL
  • family_relation (Field) — String
  • birth (Field2) — Date
  • School (Field3) — String
  • job (Field4) — String
  • company (Field5) — String
  • position (Field6) — String

Military (Untitled6)

  • military_id (Key) — Long — Primary key — NOT NULL
  • person_id (Key2) — Long — Foreign key → Person.person_id — NOT NULL
  • military_status (Field) — Military_Status
  • start_period (Field2) — Date
  • end_period (Field3) — Date
  • military_type (Field4) — String
  • military_rank (Field5) — String

Military_Status (Untitled7)

  • military_id (Key) — Long — Foreign key → Military.military_id — NOT NULL
  • person_id (Key2) — Long — Foreign key → Military.person_id — NOT NULL
  • COMPLETE (Field) — ENUM
  • NOT_COMPLETE (Field2) — ENUM
  • EXEMPTION (Field3) — ENUM
  • ETC (Field4) — String

Person (Untitled3)

  • person_id (Key) — Long — Primary key — NOT NULL
  • image (Field) — String
  • name_kor (Field2) — String
  • name_eng (Field3) — String
  • birth (Field4) — Date
  • email (Field5) — String
  • phone (Field6) — String

Program (Untitled10)

  • program_id (Key) — Long — Primary key — NOT NULL
  • etc_id (Key2) — Long — Foreign key → ETC.etc_id — NOT NULL
  • person_id (Key22) — Long — Foreign key → ETC.person_id — NOT NULL
  • program_title (Field) — String
  • Usability (Field2) — String
  • certificate_status (Field3) — String

Resume (Untitled)

  • resume_id (Key) — Primary key — NOT NULL
  • person_id (Key2) — Long — Foreign key → Person.person_id — NOT NULL
  • category (Field)
  • person_id (Field2)

School (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • person_id (Key2) — Long — Foreign key → Person.person_id — NOT NULL
  • school_name (Field2) — String
  • major (Field3) — String
  • graduate (Field4) — Boolean
  • gradu_date (Field) — Date
  • location (Field5) — String
  • report (Field6) — String