Military AI Mentoring

Tables (6)

Copy Of MIL_ORGS (CopyOfMIL_ORGS)

  • 멘토ID (MENTOR_ID) — NUMBER — Primary key — NOT NULL — PRIMARY..key
  • 군 부대 이름 (ORG_NAME) — VARCHAR2(200)
  • 육/해/공/해병대 등등 (ORG_TYPE) — VARCHAR2(100)
  • 지역 (REGION) — VARCHAR2(100)
  • NOTE — VARCHAR2(4000)
  • CREATED_AT (CREATE_AT) — DATE
  • CREATED_BY — NUMBER
  • UPDATED_AT — DATE
  • UPDATED_BY — NUMBER

Copy Of MIL_ORGS2 (CopyOfMIL_ORGS2)

  • 군 부대 ID (ORG_ID) — NUMBER — Primary key — NOT NULL
  • 군 부대 이름 (ORG_NAME) — VARCHAR2(200)
  • 육/해/공/해병대 등등 (ORG_TYPE) — VARCHAR2(100)
  • 지역 (REGION) — VARCHAR2(100)
  • NOTE — VARCHAR2(4000)
  • CREATED_AT (CREATE_AT) — DATE
  • CREATED_BY — NUMBER
  • UPDATED_AT — DATE
  • UPDATED_BY — NUMBER

MENTEE_PROFILE

  • MENTEE_ID — NUMBER
  • USER_ID — NUMBER — NOT NULL
  • ORG_ID — NUMBER — NOT NULL
  • RANK — VARCHAR2(50)
  • POSITION — VARCHAR2(100)
  • NOTE — VARCHAR2(4000)
  • CREATED_AT — DATE
  • CREATED_BY — NUMBER
  • UPDATED_AT — DATE
  • UPDATED_BY — NUMBER

MIL_ORGS

  • 군 부대 ID (ORG_ID) — NUMBER — Primary key — NOT NULL
  • 군 부대 이름 (ORG_NAME) — VARCHAR2(200)
  • 육/해/공/해병대 등등 (ORG_TYPE) — VARCHAR2(100)
  • 지역 (REGION) — VARCHAR2(100)
  • NOTE — VARCHAR2(4000)
  • CREATED_AT (CREATE_AT) — DATE
  • CREATED_BY — NUMBER
  • Field
  • UPDATED_BY — NUMBER

RESULT_REPORT

  • REPORT_ID — NUMBER
  • REQUEST_ID — NUMBER — NOT NULL
  • REPORT_TYPE — VARCHAR2(20) — NOT NULL
  • TITLE — VARCHAR2(300) — NOT NULL
  • CONTENT — CLOB
  • SUBMITTED_BY — NUMBER
  • SUBMITTED_AT — DATE
  • CONFIRMED_BY — NUMBER
  • CONFIRMED_AT — DATE
  • VERSION_NO — VARCHAR2(20)
  • IS_FINAL — CHAR(1)
  • CREATED_AT — DATE
  • CREATED_BY — NUMBER
  • UPDATED_AT — DATE
  • UPDATED_BY — NUMBER

USERS

  • Key — Primary key — NOT NULL
  • 유저 ID (USER_ID) — NUMBER — Primary Key
  • 로그인 ID (LOGIN_ID) — VARCHA2(50) — 로그인 계정 ID
  • 비밀번호 (PASSWORD) — VARCHAR2(100)
  • 이름 (NAME) — VARCHAR2(100)
  • 이메일 (EMAIL) — VARCHAR2(200)
  • 폰 (PHONE) — VARCHAR2(30)
  • 사용자 역할 (ROLE_CODE) — VARCHAR2(20)
  • 사용자 계정 상태 (STATUS) — VARCHAR2(20)
  • CREATED_AT — DATE
  • CREATED_BY — NUMBER
  • UPDATED_AT — NUMBER
  • UPDATED_BY — NUMBER