KSManagement
Tables (5)
Resource (Untitled)
- ID (Key) — BIGINT — Primary key — NOT NULL
- first_name (Field2) — VARCHAR
- last_name (Field3) — VARCHAR
- kr_name (Field4) — VARCHAR
- account (Field5) — VARCHAR
- dob (Field6) — DATE
- nationality (Field7) — VARCHAR
- gender (Field8) — ENUM
- department (Field) — ENUM
- joined_date (Field9) — DATE
- position (Field10) — ENUM
- level (Field11) — ENUM
- is_allocated (Field12) — BOOL
- status (Field13) — ENUM
- Field14
certificate (Untitled3)
- ID (Key) — BIGINT — Primary key — NOT NULL
- certificate_name (Field) — VARCHAR
- issuer (Field2) — VARCHAR
- issue_date (Field3) — DATE
- resource_id (Key2) — BIGINT — Foreign key → Resource.ID — NOT NULL
education (Untitled2)
- ID (Key) — BIGINT — Primary key — NOT NULL
- school_name (Field) — VARCHAR
- degree (Field2) — ENUM
- start_date (Field3) — DATE
- end_date (Field4) — DATE
- resource_id (Key2) — BIGINT — Foreign key → Resource.ID — NOT NULL
language (Untitled4)
- ID (Key) — BIGINT — Primary key — NOT NULL
- language (Field) — ENUM
- level (Field2) — ENUM
- resource_id (Key2) — BIGINT — Foreign key → Resource.ID — NOT NULL
technical_skill (Untitled5)
- ID (Key) — BIGINT — Primary key — NOT NULL
- skill (Field) — VARCHAR
- level (Field2) — ENUM
- resource_id (Key2) — BIGINT — Foreign key → Resource.ID — NOT NULL