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