테스트
테이블 (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