담당자업무관리

테이블 (7)

FixRegulations (Untitled2)

  • ID (Key) — 기본 키 — NOT NULL
  • Title (Field)
  • Regulation (Field2)
  • RevisionDate (Field3)
  • SortNo (Field4)

OfficeList (Untitled3)

  • ID (Key) — 기본 키 — NOT NULL
  • OfficeCode (Field)
  • OfficeName (Field2)

SignedList (Untitled6)

  • ID (Key) — 기본 키 — NOT NULL
  • ID (Key2) — 외래 키 → TaskAdminManagement.ID — NOT NULL
  • ID (Key22) — 외래 키 → TaskAdminManagement.ID — NOT NULL
  • ID (Key3) — 외래 키 → WorkerList.ID — NOT NULL
  • ID (Key32) — 외래 키 → TaskAdminManagement.ID — NOT NULL
  • ID (Key4) — 외래 키 → OfficeList.ID — NOT NULL
  • Order (Field)
  • SignListStatus (Field6)
  • MessageSendTimes (Field7)
  • Signature (Field8)

TaskAdminManagement (Untitled5)

  • ID (Key) — 기본 키 — NOT NULL
  • ID (Key2) — 외래 키 → TaskList.ID — NOT NULL
  • ID (Key22) — 외래 키 → TaskList.ID — NOT NULL
  • ID (Key4) — 외래 키 → OfficeList.ID — NOT NULL
  • ID (Key3) — 외래 키 → WorkerList.ID — NOT NULL
  • Order (Field)
  • TaskName (Field5)
  • TaskPosition (Field6)
  • AssignedDate (Field7)
  • SignedDate (Field8)
  • EndDate (Field9)
  • TaskAdminMgmtStatus (Field10)

TaskList (Untitled4)

  • ID (Key) — 기본 키 — NOT NULL
  • ID (Key2) — 외래 키 → FixRegulations.ID — NOT NULL
  • ID (Key3) — 외래 키 → OfficeList.ID — NOT NULL
  • TaskListName (Field2)
  • TaskListStatus (Field3)

TaskRegulationList (Untitled7)

  • ID (Key) — 기본 키 — NOT NULL
  • ID (Key2) — 외래 키 → TaskList.ID — NOT NULL
  • ID (Key4) — 외래 키 → OfficeList.ID — NOT NULL
  • Order (Field)
  • RegulationContent (Field4)
  • RGManager (Field5)
  • CreatedDate (Field6)
  • IsVisible (Field7)

WorkerList (Untitled)

  • ID (Key) — 기본 키 — NOT NULL
  • OfficeCode (Field)
  • OfficeName (Field2)
  • EmployeeID (Field3)
  • EmployeeName (Field4)
  • Position (Field5)