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)