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