cuberun_department
테이블 (4)
감사 정보 (revinfo)
- Key (rev) — NOT NULL — 기본 키 — NOT NULL
- stmp (revstmp) — NULL
부서 (Department)
- Key (department_key) — NOT NULL — 기본 키 — NOT NULL
- Department (parent_department_key) — NULL — 외래 키 → 부서.Key — NOT NULL
- Member (head_of_department_key) — NULL — 외래 키 → 사용자.Key — NOT NULL
- id — NOT NULL
- name — NOT NULL
- effective date (effective_date) — NOT NULL
- availability — NOT NULL
- description — NOT NULL
- reason — NOT NULL
- modifier (modified_by) — NOT NULL
- modifiedAt (modified_at) — NOT NULL
부서 히스토리 (Department_aud)
- Key (department_key) — NOT NULL — 외래 키 → 부서.Key — NOT NULL
- Key (rev) — NOT NULL — 외래 키 → 감사 정보.Key — NOT NULL
- id — NULL
- name — NULL
- effective date (effective_date) — NULL
- availability — NULL
- description — NULL
- reason — NULL
- modifier (modified_by) — NULL
- modifiedAt (modified_at) — NULL
- Department (parent_department_key) — NULL — NOT NULL
- Member (head_of_department_key) — NULL — NOT NULL
사용자 (Member)
- Key (member_key) — NOT NULL — 기본 키 — NOT NULL
- id — NOT NULL
- email — NOT NULL
- password — NOT NULL
- name — NULL