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