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