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