담당자업무관리
테이블 (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)