서비스포털

테이블 (20)

? (Untitled4)

  • AP_ID (Key) — 기본 키 — NOT NULL

COMT_ATTACHMENT (Untitled12)

  • ATTACHMENT_ID (Key) — 기본 키 — NOT NULL
  • ATTACHMENT_GROUP_ID (Key3) — 외래 키 → COMT_ATTCHMENT_GROUP.ATTACHMENT_GROUP_ID — NOT NULL — SINGLE_FILE_GROUP_ID로 기재되기도 함
  • FILE_NM (Field)
  • FILE_CN (Field2)
  • CONTENT_TYPE (Field3)
  • FILE_SIZE (Field4)
  • DOWNLOAD_CNT (Field5)
  • FILE_DELETED (Field6) — C
  • USER_ID (CREATOR_ID) — 외래 키 → COMT_USER.USER_ID — NOT NULL
  • CREATED_DT (Field8)

COMT_ATTACHMENT (Untitled8)

  • ATTACHMENT_ID (Key) — 기본 키 — NOT NULL
  • ATTACHMENT_GROUP_ID (Key2) — 외래 키 → COMT_ATTACHMENT_GROUP.ATTACHMENT_GROUP_ID — NOT NULL — GROUP이 아니면 SINGLE_FILE_GROUP_ID 라고 기재
  • FILE_NM (Field)
  • FILE_CN (Field2)
  • CONTENT_TYPE (Field3)
  • FILE_SIZE (Field4)
  • SAVED_FILE_NM (Field5) — 경로
  • DOWNLOAD_CNT (Field6)
  • FILE_DELETED (Field7)
  • USER_ID (CREATOR_ID) — 외래 키 → COMT_USER.USER_ID — NOT NULL — user_난수 형태
  • CREATED_DT (Field8)

COMT_ATTACHMENT_GROUP (Untitled9)

  • ATTACHMENT_GROUP_ID (Key) — 기본 키 — NOT NULL
  • USER_ID (CREATOR_ID) — 외래 키 → COMT_USER.USER_ID — NOT NULL — user_난수 형태
  • CREATED_DT (Field)

COMT_ATTCHMENT_GROUP (Untitled13)

  • ATTACHMENT_GROUP_ID (Key) — 기본 키 — NOT NULL
  • USER_ID (CREATOR_ID) — 외래 키 → COMT_USER.USER_ID — NOT NULL
  • CREATED_DT (Field2)

COMT_CST_ENTER_APLY (경진대회 참가 신청)

  • CST_APPLICATION_ID (Key) — 기본 키 — NOT NULL — 신청 ID
  • USER_ID (Key4) — 외래 키 → COMT_USER.USER_ID — NOT NULL — 팀장만
  • CST_YEAR (Field)
  • CST_NM (Field2)
  • CST_TITLE (Field4)
  • CST_TITLE_DETAIL (Field5)
  • CST_TEAM (Field6) — 0 OR 1
  • CST_TEAM_MEMBER_1 (Field7)
  • CST_TEAM_MEMBER_2 (Field8)
  • CST_TEAM_MEMBER_3 (Field9)
  • CST_TEAM_MEMBER_4 (Field10)
  • CST_TEAM_MEMBER_5 (Field11)
  • CST_TEAM_MEMBER_6 (Field12)
  • CST_ENTER_STATUS (Field13) — 01 OR 02
  • CST_ENTER_STATUS_DT (Field14)
  • CST_ENTER_CENTER (Field15) — 001~008
  • CST_INFLOW_ROUTE (Field16) — 유입경로 선택
  • CST_APPLICANT_DT (Field17)
  • CREATOR_ID (Field18)
  • CREATED_DT (Field19)
  • UPDATER_ID (Field20)
  • UPDATED_DT (Field21)
  • ATTACHMENT_ID (IDEA_DESIGN_FILE_ID) — 외래 키 → COMT_ATTACHMENT.ATTACHMENT_ID — NOT NULL
  • ATTACHMENT_ID (ENTER_AGRE_FILE_ID) — 외래 키 → COMT_ATTACHMENT.ATTACHMENT_ID — NOT NULL — 개인정보수집동의
  • CST_AWARD_RANK (Field23)

COMT_CST_PVSN_DATA (경진대회용 데이터 리스트)

  • DATA_ID (CST_DATA_ID) — 외래 키 → Meta.COMT_DATA.DATA_ID — NOT NULL
  • CST_DATA_NM (Field)
  • CST_INSTITUTION (Field2)
  • CST_INSTITUTION_NM (Field3)
  • CST_FILE_TYPE (Field4)
  • CST_YEAR (Field5)

COMT_CST_USE_DATA (경진대회 활용 데이터)

  • CST_APPLICATION_ID (Key) — 외래 키 → COMT_CST_ENTER_APLY.CST_APPLICATION_ID — NOT NULL — 신청 ID
  • USER_ID (CREATOR_ID) — 외래 키 → COMT_CST_ENTER_APLY.USER_ID — NOT NULL — 팀장만
  • DATA_ID (CST_DATA_ID) — 외래 키 → COMT_CST_PVSN_DATA.DATA_ID — NOT NULL
  • CREATED_DT (Field)
  • CST_YEAR (Field2)

COMT_DATA (Untitled14)

    COMT_TAKEIN (Untitled10)

    • ORDER_NUMBER (Key2) — 기본 키 — NOT NULL — 반입 파일 여러개일 경우 INDEX
    • APPLICATION_ID (Key) — 외래 키 → COMT_USE.APPLICATION_ID — NOT NULL
    • USER_ID (CREATOR_ID) — 외래 키 → COMT_USER.USER_ID — NOT NULL — user_난수 형태
    • TAKEIN_STATUS (APPLICATION, END)
    • TAKEIN_STATUS_DT (Field3)
    • APPLICATION_DT (Field4)
    • APPLICATION_REASON (Field5)
    • CANCLE_DT (Field6)
    • CANCLE_REASON (Field7)
    • APPROVAL (Field8) — 1, NULL, 0 (반려)
    • APPROVAL_REASON (Field9)
    • CREATED_DT (Field10)
    • UPDATED_ID (Field11)
    • UPDATED_DT (Field12)

    COMT_TAKEIN_FILE (Untitled11)

    • ORDER_NUMBER (Key2) — 외래 키 → COMT_TAKEIN.ORDER_NUMBER — NOT NULL — 반입 파일 여러개일 경우 INDEX
    • APPLICATION_ID (Key) — 외래 키 → COMT_TAKEIN.APPLICATION_ID — NOT NULL
    • ATTACHMENT_ID (Key3) — 외래 키 → COMT_ATTACHMENT.ATTACHMENT_ID — NOT NULL
    • DE;ETED_REASON (Field)

    COMT_TAKEOUT (Untitled6)

    • AP_ID (Key2) — 외래 키 → ?.AP_ID — NOT NULL
    • APPLICATION_ID (Key) — 외래 키 → COMT_USE.APPLICATION_ID — NOT NULL
    • USER_ID (Key3) — 외래 키 → COMT_USER.USER_ID — NOT NULL — user_난수 형태
    • AP_ID (API 신호)
    • AP_TITLE (Field) — 반출신청타이틀
    • AP_CONTENT (Field2)
    • AP_REQUEST_DE (Field3) — 반출 요청일
    • AP_PROCESS_DE (Field4)
    • TAKEOUT_STATUS (Field5) — (RECEIPT, REVIEW_REQUEST, REVIEW_END, REQUEST_CANCLE)
    • TAKEOUT_STATUS_DT (Field6)
    • APPLICATION_DT (Field7)
    • REVIEW_REQ_DT (Field8) — 심의 요청일
    • REVIEW_END_DT (Field9)
    • CANCLE_DT (Field10)
    • CANCLE_REASONAPI (Field11)
    • CREATED_DT (Field12)
    • UPDATER_ID (Field13)
    • UPDATED_DT (Field14)
    • DATA_IDS (Field15) — 대부분 NULL
    • APPLICATION_TAKEOUT (Field16) — APPLICATIONUSE01~06?
    • TAKEOUT_PURPOSE (Field17)

    COMT_TAKEOUT_FILE (Untitled7)

    • APPLICATION_ID (Key) — 외래 키 → COMT_TAKEOUT.APPLICATION_ID — NOT NULL
    • AP_ID (Key2) — 외래 키 → COMT_TAKEOUT.AP_ID — NOT NULL
    • ATTACHMENT_ID (Key3) — 외래 키 → COMT_ATTACHMENT.ATTACHMENT_ID — NOT NULL
    • AP_FILE_TITLE (Field)
    • APPROVAL_REASON (Field2)
    • DELETED_REASON (Field3)

    COMT_USE (이용관리 > 이용신청 관리)

    • APPLICATION_ID (Key) — 기본 키 — NOT NULL
    • USER_ID (Key2) — 외래 키 → COMT_USER.USER_ID — NOT NULL — user_난수 형태
    • TITLE (Field)
    • TEAM (Field2) — NOT NULL — (1 or 0)
    • USE_STATUS (Field3) — NOT NULL — (SAVE, USE, REVIEW_END, REQUEST_CANCLE,,,)
    • USE_STATUS_DT (Field4)
    • MODIFY_REQUEST_REASON (Field5)
    • LINK_INSTITUTION_ID (Field6)
    • PSTINST_NM (Field8) — 소속명
    • OFFICIAL_POSITION (Field9) — 직급
    • PURPOSE (Field10) — 자료이용 목적
    • SECURITY_PLEDGE_ID (Field11) — 뭔가 Attachment로 되어있음.
    • TAKEN_FILE_GROUP_ID (Field12) — 반입자료
    • REFERNCE_FILE_GROUP_ID (Field13) — 참고자료
    • USE_BEGIN_DE (Field14) — 이용 시작일
    • USE_SEND_DE (Field15) — 이용 종료일
    • USE_END_REASON (Field16)
    • APPLICATION_DT (Field17)
    • REVIEW_REQ_DT (Field18)
    • REVIEW_END_DT. (Field19)
    • CANCLE_DT (Field20)
    • CANCLE_REASON (Field21)
    • APPROVAL (Field22)
    • APPROVAL_REASON (Field23)
    • REJECT_REASON_CD (Field24)
    • USE_GPU (Field25)
    • TABLEAU (Field26) — TABLEAU
    • CREATOR_ID (USER_ID) — 사용자 ID
    • CREATED_DT (Field28)
    • UPDATER_ID (Field29)
    • UPDATED_DT (Field30)
    • POS_CD (Field31) — (서울센터 11, 대전센터 25)
    • USE_GBN (Field32) — (대부분 CENTER)
    • SUPPORT (Field33) — 분석지원요청 여부
    • SUP_LEV (Field34) — 사용자 분석수준
    • LEVEL_PURPOSE (Field35) — 분석지원 내용
    • APPLICATION_USE (Field36)
    • APP_USE_PURPOSE (Field37)
    • LIFENOTICE_FILE_GROUP_ID (Field38) — 기관생명윤리위원회자료

    COMT_USER (Untitled3)

    • USER_ID (Key) — 기본 키 — NOT NULL — user_난수 형태
    • SYSTEM_CD (Field) — 대부분 FRONT, 혹은 ADMIN
    • LOGIN_ID (Field2) — 회원가입 ID
    • PASSWD (Field3) — PW
    • PASSWD_UPDATED_DT (Field4)
    • PASSWD_INIT (Field5) — NULL OR 0
    • USER_STATUS (Field6) — NORMAL, SECESSION
    • USER_STATUS_DT (Field7)
    • ROLE_CODE (Field8) — ROLE_USER, ROLE_ADMIN
    • LAST_LOGIN (Field9)
    • LAST_LOGIN_DT (Field10)
    • LOGIN_SESSION_KEY (Field11)
    • PSTINST_CL (Field12) — 코드
    • PSTINST_NM (Field13) — 소속
    • USER_NM (Field14) — 유저 이름
    • ENC_PHONE (Field15)
    • ENC_BIRTHDAY (Field16)
    • CI (Field17)
    • DI (Field18)
    • ENC_EMAIL (Field19)
    • BAD_MBR (Field20)
    • BAD_MBR_END_YMD (Field21)
    • MARKETING_AGREE (Field22)
    • EVENT_MAIL_RCV (Field23)
    • COUNCIL_SMS_RCV (Field24)
    • COUNCIL_EMAIL_RCV (Field25)
    • SECESSION_REASON (Field26)
    • SECESSION_DT (Field27)
    • INSTITUTION_ID (Field28)
    • CREATOR_ID (USER_ID)
    • CREATOR_DT (Field30)
    • UPDATER_ID (Field31)
    • UPDATED_DT (Field32)
    • PASSWORD_ERR_CNT (Field33)
    • CTPV_CD (Field34)
    • SGG_CD (Field35)

    COMT_USE_DATA (Untitled)

    • APPLICATION_ID (Key) — 외래 키 → COMT_USE.APPLICATION_ID — NOT NULL
    • DATA_ID (Key2) — 외래 키 → Meta.COMT_DATA.DATA_ID — NOT NULL
    • ENABLED (Field) — NOT NULL — 0 OR 1
    • CREATED_DT (Field2)

    COMT_USE_USER (Untitled5)

    • APPLICATION_ID (Key) — 외래 키 → COMT_USE.APPLICATION_ID — NOT NULL
    • USER_ID (Key2) — 외래 키 → COMT_USER.USER_ID — NOT NULL — user_난수 형태
    • APPLICANT (Field) — NOT NULL — 0 OR 1 (팀장 여부)
    • SEAT_TYPE (Field2)
    • SEAT_NUMBER (Field3)
    • SECURITY_PLEDGE_AGREED_YN (Field4) — 0 OR 1
    • SECURITY_PLEDGE_ARTICLE_ID (Field5)
    • CREATOR_ID (Field6)
    • CREATED_DT (Field7)

    COMT_VISIT_HIST (이용관리 > 출입관리)

    • APPLICATION_ID (Key) — 외래 키 → COMT_USE.APPLICATION_ID — NOT NULL
    • USER_ID (Key2) — 외래 키 → COMT_USER.USER_ID — NOT NULL — user_난수 형태
    • VISIT_DE (Field) — NOT NULL — 방문일자. 20241220
    • TEAM (Field2) — NOT NULL — 0 OR 1
    • APPLICANT (Field3) — NOT NULL — 0 OR 1 (팀장 여부)
    • COREASEARCHER (Field4) — NOT NULL — 0 OR 1 (없어짐)
    • ENTER_DT (Field5)
    • LEAVE_DT (Field6)

    Meta.COMT_DATA (TIBERO)

    • DATA_ID (Key) — 기본 키 — NOT NULL

    USER (Untitled2)

    • USER_ID (Key) — 기본 키 — NOT NULL — user_난수 형태