ms

Tables (10)

TADMIN

  • ID — VARCHAR2(20) — NOT NULL
  • ID_GB — CHAR(1) — NOT NULL
  • NAME — VARCHAR2(20)
  • PASSWORD — VARCHAR2(250)
  • EMAIL — VARCHAR2(50)
  • SALES_CD — VARCHAR2(2)
  • WORK_GB — CHAR(2)
  • AUTH_TYPE — CHAR(2)
  • MEMB_TYPE — CHAR(2)
  • SORT_TYPE — NUMBER(22)
  • GRP_TYPE — CHAR(2)
  • DIVISION — VARCHAR2(20)
  • PART — VARCHAR2(20)
  • POSITION — VARCHAR2(20)
  • POS_GB — VARCHAR2(1)
  • IMG_DIR — VARCHAR2(20)
  • FCM_TOKEN — VARCHAR2(255)

TBL_MS_CODE

  • CODE_GROUP — VARCHAR2(50) — NOT NULL
  • CODE — VARCHAR2(50) — NOT NULL
  • CODE_NAME — VARCHAR2(100) — NOT NULL
  • USE_YN — CHAR(1)
  • SORT_ORDER — NUMBER(5,0)

TBL_MS_CODE_GROUP

  • CODE_GROUP — VARCHAR2(50) — NOT NULL
  • GROUP_NAME — VARCHAR2(100) — NOT NULL
  • USE_YN — CHAR(1)
  • SORT_ORDER — NUMBER(5,0)

TBL_MS_ISSUES

  • ID — NUMBER(19,0) — NOT NULL
  • PROJECT_ID — NUMBER(22) — NOT NULL
  • TITLE — VARCHAR2(200) — NOT NULL
  • STATUS_GROUP — VARCHAR2(50)
  • STATUS — VARCHAR2(30)
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE
  • START_DATE — DATE — NOT NULL
  • DUE_DATE — DATE
  • USE_YN — VARCHAR2(1) — NOT NULL
  • DESCRIPTION — VARCHAR2(500)
  • CREATED_BY — VARCHAR2(50)
  • ASSIGNED_TO — VARCHAR2(50)
  • PINNED_YN — CHAR(1) — NOT NULL

TBL_MS_ISSUES_SERVICE

  • ISSUE_ID — NUMBER(19,0) — NOT NULL
  • PROJECT_ID — NUMBER(22) — NOT NULL
  • PROJECT_NAME — VARCHAR2(100)
  • TITLE — VARCHAR2(200) — NOT NULL
  • DESCRIPTION — VARCHAR2(500)
  • STATUS — VARCHAR2(30)
  • STATUS_NAME — VARCHAR2(100)
  • ASSIGNED_TO — VARCHAR2(50)
  • ASSIGNED_TO_NAME — VARCHAR2(50)
  • CREATED_BY — VARCHAR2(50)
  • CREATED_BY_NAME — VARCHAR2(50)
  • START_DATE — DATE — NOT NULL
  • DUE_DATE — DATE
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_AT — DATE
  • USE_YN — VARCHAR2(1) — NOT NULL

TBL_MS_ISSUE_LOGS

  • ID — NUMBER(19,0) — NOT NULL
  • ISSUE_ID — NUMBER(19,0)
  • STATUS_GROUP — VARCHAR2(50)
  • STATUS — VARCHAR2(30) — NOT NULL
  • CHANGED_BY — NUMBER(19,0)
  • CHANGED_AT — DATE

TBL_MS_PROJECTS

  • ID — NUMBER(19,0) — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL
  • START_DATE — DATE — NOT NULL
  • END_DATE — DATE
  • CREATED_AT — DATE
  • UPDATED_AT — DATE
  • USE_YN — VARCHAR2(1)
  • PROPOSAL_DOC — VARCHAR2(500)
  • DESCRIPTION — VARCHAR2(500)
  • STATUS — VARCHAR2(30)
  • PROGRESS — VARCHAR2(50)
  • PM_ID — VARCHAR2(100) — NOT NULL

TBL_MS_PROJECT_COMMENTS

  • ID — NUMBER(19,0) — NOT NULL
  • PROJECT_ID — NUMBER(19,0) — NOT NULL
  • ROOT_ID — NUMBER(19,0) — NOT NULL
  • PARENT_ID — NUMBER(19,0)
  • CONTENT — CLOB — NOT NULL
  • PINNED_YN — CHAR(1) — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL
  • CREATED_BY — VARCHAR2(50)
  • CREATED_AT — DATE — NOT NULL
  • UPDATED_BY — VARCHAR2(50)
  • UPDATED_AT — DATE

TBL_MS_PROJECT_FILES

  • ID — NUMBER(22) — NOT NULL
  • PROJECT_ID — NUMBER(22) — NOT NULL
  • FILE_NAME — VARCHAR2(255) — NOT NULL
  • FILE_PATH — VARCHAR2(500) — NOT NULL
  • MIME_TYPE — VARCHAR2(100)
  • USE_YN — CHAR(1)
  • CREATED_BY — VARCHAR2(50)
  • CREATED_AT — DATE — NOT NULL
  • FILE_SCOPE — CHAR(1) — NOT NULL
  • COMMENT_ID — NUMBER(19,0)

TBL_MS_PROJECT_MEMBERS

  • PROJECT_ID — NUMBER(19,0)
  • MEMBER_ID — VARCHAR2(100)