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