테스트

테이블 (16)

ADMIN_ACTIVITY_LOGS

  • LOG_ID — INT
  • ADMIN_ID — INT
  • ACTION — TEXT
  • ACTION_DATE — DATE

CERTIFICATION

  • CERT_ID — INT
  • MEMBER_ID — INT
  • CERT_NAME — VARCHAR(100)
  • ISSUE_DATE — DATE
  • EXPIRY_DATE — DATE

COMMENTS

  • COMMENT_ID — INT
  • POST_ID — INT
  • MEMBER_ID — INT
  • CONTENT — TEXT
  • COMMENT_DATE — DATE

DAILY_POSTS

  • POST_ID — INT
  • MEMBER_ID — INT
  • CONTENT — TEXT
  • POST_DATE — DATE

DEBUG_POSTS

  • POST_ID — INT
  • MEMBER_ID — INT
  • CONTENT — TEXT
  • POST_DATE — DATE
  • DEBUG_LEVEL — VARCHAR(50)

EXAM_SCHEDULES

  • EXAM_ID — INT
  • MEMBER_ID — INT
  • EXAM_NAME — VARCHAR(100)
  • EXAM_DATE — DATE

FILES

  • FILE_ID — INT
  • POST_ID — INT
  • FILE_PATH — VARCHAR(255)
  • UPLOAD_DATE — DATE

LIKES

  • LIKE_ID — INT
  • POST_ID — INT
  • MEMBER_ID — INT

MEMBERS

  • MEMBER_ID — INT
  • NAME — VARCHAR(100)
  • EMAIL — VARCHAR(255)
  • PASSWORD — VARCHAR(255)
  • JOIN_DATE — DATE

PAYMENTS

  • PAYMENT_ID — INT
  • MEMBER_ID — INT
  • AMOUNT — DECIMAL(10, 2)
  • PAYMENT_DATE — DATE

POINT_HISTORIES

  • POINT_ID — INT
  • MEMBER_ID — INT
  • POINT_CHANGE — INT
  • REASON — TEXT
  • DATE — DATE

PROFILE

  • PROFILE_ID — INT
  • MEMBER_ID — INT
  • BIO — VARCHAR(255)
  • PROFILE_PICTURE — VARCHAR(255)

REPORTS

  • REPORT_ID — INT
  • MEMBER_ID — INT
  • POST_ID — INT
  • REASON — TEXT
  • REPORT_DATE — DATE

STUDY_GOALS

  • GOAL_ID — INT
  • PLANNER_ID — INT
  • DESCRIPTION — TEXT
  • IS_COMPLETED — BOOLEAN

STUDY_PLANNERS

  • PLANNER_ID — INT
  • MEMBER_ID — INT
  • TITLE — VARCHAR(100)
  • START_DATE — DATE
  • END_DATE — DATE

VISIT_LOGS

  • LOG_ID — INT
  • MEMBER_ID — INT
  • VISIT_DATE — DATE