ㅁ
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