PSI
Tables (15)
dbo.SUGGEST (SUGGEST)
- SUGGEST_ID — char(36) — Primary key — NOT NULL
- SUGGEST_SUBJECT — nvarchar(200)
- 등록ID (CREATE_ID) — varchar(50)
- 등록이름 (CREATE_NM) — nvarchar(50)
- 등록일 (CREATE_DT) — datetime
- 등록부서ID (CREATE_DEPT_ID) — varchar(50)
- 등록부서이름 (CREATE_DEPT_NM) — nvarchar(50)
- CREATE_TITLE_ID — varchar(50)
- CREATE_TITLE_NM — nvarchar(50)
- CREATE_HQ_ID — varchar(50)
- CREATE_HQ_NM — nvarchar(50)
- CREATE_WL_ID — varchar(50)
- CREATE_WL_NM — nvarchar(50)
- CREATE_WP_ID — varchar(50)
- CREATE_WP_NM — nvarchar(50)
- CREATE_FN_TYPE — char(1)
- UPDATE_ID — varchar(50)
- UPDATE_NM — nvarchar(50)
- UPDATE_DT — datetime
- USAGE_YN — char(1)
- CO_WP_ID — varchar(50)
- CO_WP_NM — nvarchar(50)
- SUGGEST_AS_IS — nvarchar(MAX)
- SUGGEST_TO_BE — nvarchar(MAX)
- SUGGEST_TYPE_ID — varchar(50)
- SUGGEST_TYPE_NM — nvarchar(50)
- SCHEDULE_DATE — datetime
- SCHEDULE_TYPE — char(1)
- COMPLETE_DATE — datetime
- WORKER_ID — varchar(50)
- WORKER_NM — nvarchar(50)
- WORKER_DEPT_NM — nvarchar(50)
- IMPROVE_TYPE_ID — varchar(50)
- IMPROVE_TYPE_NM — nvarchar(50)
- CONC_EFFECT — nvarchar(MAX)
- INTG_EFFECT — nvarchar(MAX)
- SUGGEST_STATUS — nvarchar(50)
- SUGGEST_STATUS_ID — char(1)
- READ_CHK — char(1)
- SUGGEST_DOC_ID — nvarchar(50)
- MOBILE_YN — nchar(2)
- CONC_EFFECT_MONEY — bigint
- PATENT_ID — char(36)
- PATENT_SUBJECT — nvarchar(200)
dbo.SUGGEST_APPROVAL (SUGGEST_APPROVAL)
- APPROVAL_ID — char(36) — Primary key — NOT NULL
- SUGGEST_ID — char(36) — Primary key — NOT NULL
- 부서코드 (DEPT_CD) — varchar(50)
- 부서이름 (DEPT_NM) — nvarchar(50)
- 사용자ID (USER_ID) — varchar(50)
- 사용자이름 (USER_NM) — nvarchar(50)
- 제목코드 (TITLE_CD) — varchar(50)
- 제목이름 (TITLE_NM) — nvarchar(50)
- APPR_DT — datetime
- APPR_DEPTH — int
- APPR_STATE — char(1)
- APPR_TYPE — char(1)
- FINAL_DT — datetime
- SUGGEST_ID (SUGGEST_ID2) — char(36) — Foreign key → dbo.SUGGEST.SUGGEST_ID — NOT NULL
dbo.SUGGEST_ATTACH (SUGGEST_ATTACH)
- FILE_ID — varchar(50) — Primary key — NOT NULL
- SUGGEST_ID — char(36) — Primary key — NOT NULL
- FILE_SORT — char(1)
- FILE_SIZE — bigint
- FILE_TYPE — varchar(20)
- FILE_NAME — nvarchar(200)
- FILE_PATH — varchar(MAX)
- DIRECTORY_NAME — varchar(50)
- USAGE_YN — char(1)
- IMAGE_TYPE — char(1)
- SUGGEST_ID (SUGGEST_ID2) — char(36) — Foreign key → dbo.SUGGEST.SUGGEST_ID — NOT NULL
dbo.SUGGEST_CMN (SUGGEST_CMN)
- SUGGEST_ID — char(36) — Primary key — NOT NULL
- CMN_USER_ID — varchar(50) — Primary key — NOT NULL
- CMN_DEPT_CD — varchar(50)
- CMN_DEPT_NM — nvarchar(50)
- CMN_TITLE_CD — varchar(50)
- CMN_TITLE_NM — nvarchar(50)
- CMN_INFLUENCE — int
- CMN_CONTENTS — nvarchar(200)
- CMN_TYPE — char(1)
- USAGE_STATE — char(1)
- SUGGEST_ID (SUGGEST_ID2) — char(36) — Foreign key → dbo.SUGGEST.SUGGEST_ID — NOT NULL
dbo.SUGGEST_COMMITTEE (SUGGEST_COMMITTEE)
- COMMITTEE_ID — char(36) — Primary key — NOT NULL
- HEAD_QUARTERS_ID — varchar(50)
- HEAD_QUARTERS_NM — nvarchar(50)
- COMMITTEE_USER_ID — varchar(50)
- COMMITTEE_USER_NM — nvarchar(50)
- COMMITTEE_USER_DEPT — nvarchar(50)
- COMMITTEE_USER_TITLE — nvarchar(50)
- COMMITTEE_ETC — nvarchar(MAX)
- CREATE_ID — varchar(50)
- CREATE_NM — nvarchar(50)
- CREATE_DT — datetime
- UPDATE_ID — varchar(50)
- UPDATE_NM — nvarchar(50)
- UPDATE_DT — datetime
- USAGE_YN — char(1)
dbo.SUGGEST_DOC_NO (SUGGEST_DOC_NO)
- DOC_NO_SQ — int
- DOC_TYPE — nvarchar(50)
- DOC_REGION — nvarchar(50)
- DOC_NO_YEAR — nvarchar(50)
- DOC_CONTENTS — nvarchar(50)
dbo.SUGGEST_NONADOPTION (SUGGEST_NONADOPTION)
- NA_ID — char(36) — Primary key — NOT NULL
- NA_REASON — nvarchar(200)
- NA_ETC — nvarchar(200)
- CREATE_ID — varchar(50)
- CREATE_NM — nvarchar(50)
- CREATE_DT — datetime
- UPDATE_ID — varchar(50)
- UPDATE_NM — nvarchar(50)
- UPDATE_DT — datetime
- USAGE_YN — char(1)
- NA_ORDER — nvarchar(50)
dbo.SUGGEST_RESULT (SUGGEST_RESULT)
- SUGGEST_ID — char(36) — Primary key — NOT NULL
- RESULT_ID — char(36)
- ACCEPT_FLAG — char(1)
- NON_ACCEPT_CD — char(36)
- NON_ACCEPT_REASON — nvarchar(200)
- EFFECT_MONEY — bigint
- NON_CALC_EFFECT_REASON — nvarchar(4000)
- AVERAGE_POINT — int
- SUGGEST_GRADE — nvarchar(50)
- SUGGEST_MONEY — bigint
- EXAM_RESULT — nvarchar(4000)
- EXAM_RESULT_SECOND — nvarchar(4000)
- SUGGEST_SCORE_TYPE — nvarchar(20)
- SUGGEST_ID (SUGGEST_ID2) — char(36) — Foreign key → dbo.SUGGEST.SUGGEST_ID — NOT NULL
dbo.SUGGEST_REWARD (SUGGEST_REWARD)
- REWARD_ID — char(36) — Primary key — NOT NULL
- REWARD_GRADE — nvarchar(200)
- REWARD_LOW_POINT — int
- REWARD_HIGH_POINT — int
- REWARD_MONEY — bigint
- REWARD_ETC — nvarchar(MAX)
- REWARD_ORDER — nvarchar(50)
- USAGE_YN — char(1)
- CREATE_ID — varchar(50)
- CREATE_NM — nvarchar(50)
- CREATE_DT — datetime
- UPDATE_ID — varchar(50)
- UPDATE_NM — nvarchar(50)
- UPDATE_DT — datetime
dbo.SUGGEST_SCOREBASE (SUGGEST_SCOREBASE)
- SCORE_TYPE_ID — char(36) — Primary key — NOT NULL
- SCORE_TYPE_NM — nvarchar(50) — Primary key — NOT NULL
- SCORE_BASE_POINT — int — Primary key — NOT NULL
- SCORE_BASE_ORDER — nvarchar(50)
- SCORE_BASE_ETC — nvarchar(200)
- USAGE_YN — char(1)
- CREATE_ID — varchar(50)
- CREATE_NM — nvarchar(50)
- CREATE_DT — datetime
- UPDATE_ID — varchar(50)
- UPDATE_NM — nvarchar(50)
- UPDATE_DT — datetime
- SCORE_ID — char(36) — Foreign key → dbo.SUGGEST_SCORECARD.SCORE_ID — NOT NULL
dbo.SUGGEST_SCORECARD (SUGGEST_SCORECARD)
- SCORE_ID — char(36) — Primary key — NOT NULL
- SCORE_FLAG_ID — nvarchar(50)
- SCORE_FLAG_NM — nvarchar(50)
- SCORE_TYPE_ID — char(36)
- SCORE_TYPE_NM — nvarchar(50)
- SCORE_BASE_POINT — int
- SCORE_CONTENTS — nvarchar(200)
- SCORE_POINT — int
- SCORE_ORDER — nvarchar(50)
- USAGE_YN — char(1)
- CREATE_ID — varchar(50)
- CREATE_NM — nvarchar(50)
- CREATE_DT — datetime
- UPDATE_ID — varchar(50)
- UPDATE_NM — nvarchar(50)
- UPDATE_DT — datetime
dbo.SUGGEST_USERSCORE (SUGGEST_USERSCORE)
- USER_SCORE_ID — char(36) — Primary key — NOT NULL
- USER_SCORE_TYPE — nvarchar(20)
- USER_SCORE_TYPE_NM — nvarchar(50)
- SUGGEST_ID — char(36)
- SCORE_ID — char(36)
- SCORE_TYPE_ID — char(36)
- SCORE_TYPE_NM — nvarchar(50)
- SCORE_CONTENTS — nvarchar(200)
- SCORE_POINT — int
- WRITE_USER_ID — nvarchar(20)
- WRITE_USER_NM — nvarchar(50)
- WRITE_APPR_TYPE — nvarchar(50)
dbo.USER_ADDITIONALJOB (USER_ADDITIONALJOB)
- AJ_ID — char(36) — Primary key — NOT NULL
- TITLE_CODE — varchar(256)
- TITLE_NAME — varchar(64)
- PSTN_CODE — varchar(256)
- PSTN_NAME — varchar(64)
- USER_ID — varchar(50)
- DEPT_CD — varchar(20)
- DEPT_NM — varchar(256)
dbo.USER_INFO (USER_INFO)
- USER_ID — varchar(50) — Primary key — NOT NULL
- USER_NM — varchar(200)
- PWD — varchar(200)
- PWD_HINT — varchar(100)
- PWD_CNSR — varchar(100)
- JOB_CD — varchar(50)
- POSITION_CD — varchar(50)
- TITLE_CD — varchar(50)
- EMP_NO — varchar(200)
- HIRE_DT — datetime
- PROMOTION_DT — datetime
- DEPT_CD — varchar(50)
- EMAIL — varchar(100)
- ZIP_CD — varchar(10)
- ADR1 — nvarchar(100)
- ADR2 — nvarchar(100)
- ADR3 — nvarchar(100)
- MOBILE_NO — varchar(50)
- TEL_NO — varchar(50)
- COM_TEL_NO — varchar(50)
- FAX_NO — varchar(50)
- USER_ORDER — int
- USAGE_YN — char(1)
- USER_ST — USER_ST
- CREATE_DT — datetime
- CREATE_ID — varchar(128)
- UPDATE_DT — datetime
- UPDATE_ID — varchar(128)
- COMPANY_CD — varchar(20)
- MEM_TYPE_CD — varchar(100)
- DISTRIBUTION_ID — char(36)
- DISTRIBUTION_NM — nvarchar(50)
- CHEIF_FLAG — char(1)
- QUARTER_ID — varchar(20)
- QUARTER_NM — nvarchar(50)
- TEAM_ID — varchar(50)
- TEAM_NM — nvarchar(50)
- LINE_ID — varchar(50)
- LINE_NM — nvarchar(50)
- EMP_TYPE — varchar(20)
dbo.USER_ROLE (USER_ROLE)
- ROLE_CD — varchar(30) — Primary key — NOT NULL
- TARGET_ID — varchar(20) — Primary key — NOT NULL
- TARGET_TYPE — char(1) — Primary key — NOT NULL
- CREATE_ID — varchar(20)
- CREATE_DT — datetime
- UPDATE_ID — varchar(20)
- UPDATE_DT — datetime