FailLog
Tables (25)
TBL_AI_CHAT
- ID — NUMBER
- AI_CHAT_CONTENT — VARCHAR2(255) — NOT NULL
- AI_CHAT_CREATE_AT — TIMESTAMP
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
TBL_CATEGORY
- ID — NUMBER
- CATEGORY_NAME — VARCHAR2(255) — NOT NULL
TBL_CHECKLIST
- ID — NUMBER
- CHECKLIST_TITLE — VARCHAR2(255) — NOT NULL
- CHECKLIST_MEMO — VARCHAR2(255)
- CHECKLIST_COMPLETED — CHAR(1)
- CHECKLIST_FAILED — CHAR(1)
- CHECKLIST_PRIORITY — CHAR(2) — NOT NULL
- PROJECT_ID — NUMBER — Foreign key → TBL_PROJECT.ID — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
TBL_EMAIL_VERIFICATION
- ID — NUMBER
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- EMAIL_VERIFICATION_EMAIL — VARCHAR2(255) — NOT NULL
- EMAIL_VERIFICATION_CODE — VARCHAR2(255) — NOT NULL
- EMAIL_VERIFICATION_PURPOSE — VARCHAR2(50) — NOT NULL
- EMAIL_VERIFICATION_IS_VERIFIED — NUMBER(1)
- EMAIL_VERIFICATION_CREATED_AT — TIMESTAMP
- EMAIL_VERIFICATION_END_AT — TIMESTAMP
- EMAIL_VERIFICATION_VERIFIED_AT — TIMESTAMP
TBL_FAILLOG_LIKE
- ID — NUMBER
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- LOG_ID — NUMBER — Foreign key → TBL_LOG.ID — NOT NULL
TBL_LOG
- ID — NUMBER
- LOG_TITLE — VARCHAR2(255) — NOT NULL
- VISION_TITLE — VARCHAR2(255) — NOT NULL
- LOG_CONTENT — VARCHAR2(255) — NOT NULL
- LOG_CREATE_AT — TIMESTAMP
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- CATEGOTY_ID — NUMBER — Foreign key → TBL_CATEGORY.ID — NOT NULL
TBL_LOG_ACTION_PLAN
- ID — NUMBER
- LOG_ACTION_PLAN_TYPE — VARCHAR2(20) — NOT NULL
- LOG_ACTION_PLAN_TITLE — VARCHAR2(255) — NOT NULL
- LOG_ACTION_PLAN_CONTENT — VARCHAR2(255)
- LOG_ACTION_PLAN_CURRENT_PATTERN — VARCHAR2(255)
- LOG_ACTION_PLAN_CURRENT_CONTENT — VARCHAR2(255)
- LOG_ACTION_PLAN_IMPROVED_PATTERN — VARCHAR2(255)
- LOG_ACTION_PLAN_IMPROVED_CONTENT — VARCHAR2(255)
- LOG_RESULT_ID — NUMBER — Foreign key → TBL_LOG_RESULT.ID — NOT NULL
TBL_LOG_PATTERN
- ID — NUMBER
- PATTERN_TYPE — VARCHAR2(255) — NOT NULL
- PATTERN_TITLE — VARCHAR2(255) — NOT NULL
- PATTERN_CONTENT — VARCHAR2(255) — NOT NULL
- LOG_RESULT_ID — NUMBER — Foreign key → TBL_LOG_RESULT.ID — NOT NULL
TBL_LOG_RESULT
- ID — NUMBER
- FAILLOG_ID — NUMBER — Foreign key → TBL_LOG.ID — NOT NULL
- LOG_RESULT_FAILURE_TYPE — VARCHAR2(255) — NOT NULL
- LOG_RESULT_FAILURE_TITLE — VARCHAR2(255) — NOT NULL
- LOG_RESULT_FAILURE_DESC — VARCHAR2(1000) — NOT NULL
- LOG_RESULT_ONE_LINE_SUMMARY — VARCHAR2(500) — NOT NULL
- LOG_RESULT_ONE_LINE_SUB — VARCHAR2(500) — NOT NULL
- LOG_RESULT_EXTERNAL_RATIO — NUMBER — NOT NULL
- LOG_RESULT_INTERNAL_RATIO — NUMBER — NOT NULL
- LOG_RESULT_FLOW_SITUATION — VARCHAR2(255) — NOT NULL
- LOG_RESULT_FLOW_DECISION — VARCHAR2(255) — NOT NULL
- LOG_RESULT_FLOW_RESULT — VARCHAR2(255) — NOT NULL
- LOG_RESULT_LOG_KEY_DECISION — VARCHAR2(255) — NOT NULL
- LOG_RESULT_LOG_EXTERNAL_FACTOR — VARCHAR2(255) — NOT NULL
- LOG_RESULT_LOG_INTERNAL_FACTOR — VARCHAR2(255) — NOT NULL
TBL_MEMBER
- ID — NUMBER
- MEMBER_EMAIL — VARCHAR2(255) — NOT NULL
- MEMBER_PASSWORD — VARCHAR2(255)
- MEMBER_NAME — VARCHAR2(255) — NOT NULL
- MEMBER_PHONE — VARCHAR2(255) — NOT NULL
- MEMBER_NICKNAME — VARCHAR2(255) — NOT NULL
- MEMBER_CREATE_AT — TIMESTAMP
- MEMBER_PROFILE_IMAGE_URL — VARCHAR2(255)
- MEMBER_EMAIL_VERIFIED_AT — TIMESTAMP
- MEMBER_PHONE_VERIFIED_AT — TIMESTAMP
TBL_PHONE_VERIFICATION
- ID — NUMBER
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- PHONE_VERIFICATION_PHONE_NUMBER — VARCHAR2(255) — NOT NULL
- PHONE_VERIFICATION_CODE — VARCHAR2(255) — NOT NULL
- PHONE_VERIFICATION_IS_VERIFIED — NUMBER(1)
- PHONE_VERIFICATION_CREATED_AT — TIMESTAMP
- PHONE_VERIFICATION_END_AT — TIMESTAMP
- PHONE_VERIFICATION_VERIFIED_AT — TIMESTAMP
TBL_POST
- ID — NUMBER
- POST_TITLE — VARCHAR2(255) — NOT NULL
- POST_CONTENT — VARCHAR2(255)
- POST_CREATE_AT — TIMESTAMP
- POST_READCOUNT — NUMBER — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- CATEGORY_ID — NUMBER — Foreign key → TBL_CATEGORY.ID — NOT NULL
TBL_POST_LIKE
- ID — NUMBER
- POST_ID — NUMBER — Foreign key → TBL_POST.ID — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
TBL_POST_PICTURE
- ID — NUMBER
- POST_PICTURE_SEQUENCE — NUMBER — NOT NULL
- POST_PICTURE_ADDRESS — VARCHAR2(255) — NOT NULL
- POST_PICTURE_NAME — VARCHAR2(255) — NOT NULL
- POST_ID — NUMBER — Foreign key → TBL_POST.ID — NOT NULL
TBL_POST_REPORT
- ID — NUMBER
- POST_REPORT_CONTENT — VARCHAR2(255) — NOT NULL
- POST_REPORT_CREATE_AT — TIMESTAMP
- REPORT_REASON_CATEGORY_ID — NUMBER — Foreign key → TBL_REPORT_REASON_CATEGORY.ID — NOT NULL
- POST_ID — NUMBER — Foreign key → TBL_POST.ID — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
TBL_PROJECT
- ID — NUMBER
- PROJECT_TITLE — VARCHAR2(255) — NOT NULL
- PROJECT_CONTENT — VARCHAR2(255) — NOT NULL
- PROJECT_START_DATE — TIMESTAMP — NOT NULL
- PROJECT_END_DATE — TIMESTAMP — NOT NULL
- PROGRESS_DAY — VARCHAR2(255) — NOT NULL
- PROJECT_CREATE_AT — TIMESTAMP
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- LOG_ID — NUMBER — Foreign key → TBL_LOG.ID — NOT NULL
TBL_RADAR_SCORE
- ID — NUMBER
- RADAR_COMPONENT — VARCHAR2(255) — NOT NULL
- RADAR_SCORE — NUMBER — NOT NULL
- LOG_RESULT_ID — NUMBER — Foreign key → TBL_LOG_RESULT.ID — NOT NULL
TBL_REPLY
- ID — NUMBER
- REPLY_CONTENT — VARCHAR2(255)
- REPLY_CREATE_AT — TIMESTAMP
- POST_ID — NUMBER — Foreign key → TBL_POST.ID — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
TBL_REPLY_LIKE
- ID — NUMBER
- REPLY_ID — NUMBER — Foreign key → TBL_REPLY.ID — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
TBL_REPLY_REPORT
- ID — NUMBER
- REPLY_REPORT_CONTENT — VARCHAR2(255) — NOT NULL
- REPLY_REPORT_CREATE_AT — TIMESTAMP
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- REPLY_ID — NUMBER — Foreign key → TBL_REPLY.ID — NOT NULL
- REPORT_REASON_CATEGORY_ID — NUMBER — Foreign key → TBL_REPORT_REASON_CATEGORY.ID — NOT NULL
TBL_REPORT_REASON_CATEGORY
- ID — NUMBER
- REPORT_REASON_CATEGORY_NAME — VARCHAR2(255) — NOT NULL
TBL_REREPLY
- ID — NUMBER
- REREPLY_CONTENT — VARCHAR2(255)
- REREPLY_CREATE_AT — TIMESTAMP
- REPLY_ID — NUMBER — Foreign key → TBL_REPLY.ID — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
TBL_REREPLY_REPORT
- ID — NUMBER
- REREPLY_REPORT_CONTENT — VARCHAR2(255) — NOT NULL
- REREPLY_REPORT_CREATE_AT — TIMESTAMP
- REPORT_REASON_CATEGORY_ID — NUMBER — Foreign key → TBL_REPORT_REASON_CATEGORY.ID — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- REREPLY_ID — NUMBER — Foreign key → TBL_REREPLY.ID — NOT NULL
TBL_SUGGESTION
- ID — NUMBER
- SUGGESTION_TITLE — VARCHAR2(255) — NOT NULL
- IS_ADDED_LIST — CHAR(1)
- CHECKLIST_ID — NUMBER — Foreign key → TBL_CHECKLIST.ID — NOT NULL
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- PROJECT_ID — NUMBER — Foreign key → TBL_PROJECT.ID — NOT NULL
TBL_USER_OAUTH
- ID — NUMBER
- MEMBER_ID — NUMBER — Foreign key → TBL_MEMBER.ID — NOT NULL
- USER_OAUTH_SOCIAL_TYPE — VARCHAR2(20) — NOT NULL
- USER_OAUTH_SOCIAL_ID — VARCHAR2(255) — NOT NULL
- USER_OAUTH_CREATED_AT — TIMESTAMP