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