ㅁ

Tables (4)

company

  • id — BIGINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

department

  • id — BIGINT — NOT NULL
  • company_id — BIGINT — NOT NULL
  • parent_id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

employee

  • id — BIGINT — NOT NULL
  • company_id — BIGINT — NOT NULL
  • employee_number — VARCHAR(50) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

job_role

  • id — BIGINT — NOT NULL
  • company_id — BIGINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL