FMD_v.1
Tables (6)
DM_PROJECT_MASTER (프로젝트)
- PRJ_ID (Key) — INT — Primary key — NOT NULL
- PRJ_CD (Key2) — VARCHAR(100) — NOT NULL
- PRJ_NM (Field) — VARCHAR(100)
- PRJ_DESC (Field2) — VARCHAR(1000)
- PRJ_START_DATE (Field3) — DATE
- PRJ_END_DATE (Field4) — DATE
- PRJ_TYPE (Field5) — VARCHAR(30)
- PRJ_STATUS (Field6) — VARCHAR(20)
- PRJ_MANAGER (Field7) — INT
- PRJ_CHARGE (Field8) — INT
- REMARKS (Field16) — VARCHAR(1000)
- USE_FLAG (Field9) — CHAR(1)
- DELETE_FLAG (Field10) — CHAR(1)
- CREATED_BY (Field11) — VARCHAR(30)
- CREATED_DATE (Field12) — DATETIME
- UPDATED_BY (Field13) — VARCHAR(30)
- UPDATED_DATE (Field14) — DATETIME
- LAST_UPDATED_LOGIN (Field15) — NVARCHAR(100)
DM_PROJECT_MEMBER (프로젝트 구성원)
- USER_ID (Key2) — INT — Primary key — NOT NULL
- PRJ_ID (Key3) — INT — Foreign key → DM_PROJECT_MASTER.PRJ_ID — NOT NULL
- USER_ROLE (Field) — VARCHAR(20)
- ROLE_DESC (Field2) — VARCHAR(1000)
- START_DATE (Field3) — DATE
- END_DATE (Field4) — DATE
- REMARKS (Field5) — VARCHAR(100)
- USE_FLAG (Field6) — CHAR(1)
- DELETE_FLAG (Field7) — CHAR(1)
- CREATED_BY (Field8) — VARCHAR(30)
- CREATED_DATE (Field9) — DATETIME
- UPDATED_BY (Field10) — VARCHAR(30)
- UPDATED_DATE (Field11) — DATETIME
- LAST_UPDATED_LOGIN (Field12) — NVARCHAR(100)
DM_REQUEST (요청 테이블)
- REQ_ID (Key) — INT — Primary key — NOT NULL
- TASK_ID (Field15) — INT
- REQUESTER (Field) — VARCHAR(20)
- MANAGER_ID (Field2) — INT
- CHARGER_ID (Field3) — INT
- REQUEST_DESC (Field4) — VARCHAR(1000)
- REQ_DATE (Field5) — DATE
- COMPLETABLE_DATE (Field6) — DATE
- COMPLETED_DATE (Field7) — DATE
- REQ_STATUS (Field8) — VARCHAR(10)
- REMARKS (Field14) — VARCHAR(1000)
- CREATED_BY (Field9) — INT
- CREATED_DATE (Field10) — DATE
- UPDATED_BY (Field11) — INT
- UPDATED_DATE (Field12) — DATE
- LAST_UPDATED_LOGIN (Field13) — NVARCHAR(100)
DM_REQUEST_ACTION (요청 처리 테이블)
- REQ_ID (Key) — INT — Primary key — NOT NULL
- ACTION_ID (Key2) — INT — Primary key — NOT NULL
- TASK_ID (Field18) — INT
- ACTION_TYPE (Field3) — VARCHAR(20)
- APPLY_SYSTEM (Field4) — VARCHAR(30)
- MENU_NM_K (Field5) — VARCHAR(300)
- MENU_NM_E (Field6) — VARCHAR(300)
- FD_NM (Field7) — VARCHAR(300)
- REQUEST (Field8) — VARCHAR(1000)
- ACTION_PLAN (Field9) — VARCHAR(1000)
- ACTION_RESULT (Field10) — VARCHAR(1000)
- DB_OBJECT (Field11) — VARCHAR(1000)
- ACTION_TYPE (Field12) — VARCHAR(20)
- ACTION_STATE (Field13) — VARCHAR(20)
- IMPORTANCE (Field14) — VARCHAR(10)
- PRIORITY (Field15) — VARCHAR(10)
- LEVEL (Field16) — VARCHAR(10)
- NAMESPACE (Field17) — VARCHAR(100)
- DEVELOPER (Field20) — INT
- REQUESTER (Field21) — VARCHAR(30)
- CHARGER_ID (Field22) — INT
- REQUEST_DATE (Field23) — DATE
- EXPECT_DAY (Field25) — VARCHAR(10)
- SVN_ID (Field2) — INT
- DEVELOP_DATE (Field24) — DATE
- APPLY_DATE (Field26) — DATE
- COMPLETABLE_DATE (Field27) — DATE
- COMPLETED_DATE (Field28) — DATE
- USE_FLAG (Field29) — CHAR(1)
- DELETE_FLAG (Field30) — CHAR(1)
- CREATED_BY (Field31) — INT
- CREATED_DATE (Field32) — DATETIME
- UPDATED_BY (Field33) — INT
- UPDATED_DATE (Field34) — DATETIME
- LAST_UPDATED_LOGIN (Field35) — NVARCHAR(100)
- APP_OBJECT (Field)
DM_TASK_MASTER (Task 마스터)
- TASK_ID (Key) — INT — Primary key — NOT NULL
- PRJ_ID (Key2) — INT
- PROCESS_CODE (Field2) — VARCHAR(30)
- PROCESS_NM (Field) — VARCHAR(100)
- TASK_CODE (Field11) — VARCHAR(30) — NOT NULL
- TASK_NM (Field3) — VARCHAR(100)
- USE_FLAG (Field4) — CHAR(1)
- DELETE_FLAG (Field5) — CHAR(1)
- CREATED_BY (Field6) — VARCHAR(30)
- CREATED_DATE (Field7) — DATETIME
- UPDATED_BY (Field8) — VARCHAR(30)
- UPDATED_DATE (Field9) — DATETIME
- LAST_UPDATED_LOGIN (Field10) — NVARCHAR(100)
OP_ATTACH_FILE (첨부문서)
- ID (Field) — INT
- ATT_MENU_ID (Field2) — NVARCHAR(50)
- ATT_OBJECT_ID (Field4) — NVARCHAR(200)
- ATT_KEY (Field3) — NVARCHAR(200)
- FILE_PATH (Field5) — NVARCHAR(200)
- FILE_NAME (Field7) — NVARCHAR(200)
- FILE_TYPE (Field6) — NVARCHAR(50)
- SIZE (Field8) — INT
- CREATED_ID (Field9) — INT
- CREATED_DATE (Field10) — DATE
- UPDATED_ID (Field11) — INT
- UPDATED_DATE (Field12) — DATE