ㅅㄷㄴㅅㅁㅁㅁ
Tables (15)
ACTIVITY_RECOMMEND
- ACTNO — NUMBER(10) — Primary key — NOT NULL
- EMOTION_TAG — VARCHAR2(50)
- ACTIVITY_DESC — VARCHAR2(300)
BOOKMARK
- BOOKMARKNO — NUMBER(10) — Primary key — NOT NULL
- USERNO — NUMBER(10) — Foreign key → user.USERNO — NOT NULL
- TARGET_TYPE — VARCHAR2(20)
- TARGET_ID — NUMBER(10)
- CREATED_DATE — DATE
COMMUNITY_POST
- POSTNO — NUMBER(10) — Primary key — NOT NULL
- USERNO — NUMBER(10) — Foreign key → user.USERNO — NOT NULL
- GROUP_TAG — VARCHAR2(50)
- TITLE — VARCHAR2(200)
- CONTENTS — VARCHAR2(2000)
- CREATED_DATE — DATE
COMMUNITY_REPLY
- REPLYNO — NUMBER(10) — Primary key — NOT NULL
- POSTNO — NUMBER(10) — Foreign key → COMMUNITY_POST.POSTNO — NOT NULL
- USERNO — NUMBER(10) — Foreign key → user.USERNO — NOT NULL
- CONTENT — VARCHAR2(1000)
- CREATED_DATE — DATE
COUNSELOR
- COUNSELORNO — NUMBER(10) — Primary key — NOT NULL
- USERNO — NUMBER(10) — Foreign key → user.USERNO — NOT NULL
- FIELD — VARCHAR2(50)
- LOCATION — VARCHAR2(50)
- CAREER — VARCHAR2(200)
COUNSEL_HISTORY
- COUNSELNO — NUMBER(10) — Primary key — NOT NULL
- COUNSELORNO — NUMBER(10) — Foreign key → COUNSELOR.COUNSELORNO — NOT NULL
- USERNO — NUMBER(10) — Foreign key → user.USERNO — NOT NULL
- COUNSEL_DATE — DATE
- CONTENT — VARCHAR2(2000)
- PROGRESS — VARCHAR2(100)
- TAGS — VARCHAR2(200)
DIAG_QUESTION
- QUESTIONNO — NUMBER(10) — Primary key — NOT NULL
- QUESTION — VARCHAR2(300) — NOT NULL
- TAG — VARCHAR2(100)
DIAG_RESULT
- RESULTNO — NUMBER(10) — Primary key — NOT NULL
- USERNO — NUMBER(10) — Foreign key → user.USERNO — NOT NULL
- TOTAL_SCORE — NUMBER(10)
- RESULT_TAG — VARCHAR2(100)
- CREATED_DATE — DATE
DIARY
- DIARYNO — NUMBER(10) — Primary key — NOT NULL
- USERNO — NUMBER(10) — Foreign key → user.USERNO — NOT NULL
- TITLE — VARCHAR2(200)
- CONTENTS — VARCHAR2(2000)
- CREATED_DATE — DATE
EMOTION_SCORE
- SCORENO — NUMBER(10) — Primary key — NOT NULL
- DIARYNO — NUMBER(10) — Foreign key → DIARY.DIARYNO — NOT NULL
- SCORE — NUMBER(10)
- EMOTION_TAG — VARCHAR2(50)
- SCORE_DATE — DATE
LLM_CHAT_LOG
- CHATLOGNO — NUMBER(10) — Primary key — NOT NULL
- USERNO — NUMBER(10) — Foreign key → user.USERNO — NOT NULL
- PURPOSE — VARCHAR2(50)
- SESSION_START — DATE
- SESSION_END — DATE
LLM_MESSAGE
- MSGNO — NUMBER(10) — Primary key — NOT NULL
- CHATLOGNO — NUMBER(10) — Foreign key → LLM_CHAT_LOG.CHATLOGNO — NOT NULL
- ROLE — VARCHAR2(20)
- CONTENT — VARCHAR2(2000)
- EMOTION_DETECTED — VARCHAR2(50)
- CREATED_DATE — DATE
POSITIVE_NEWS
- NEWSNO — NUMBER(10) — Primary key — NOT NULL
- TITLE — VARCHAR2(200)
- CONTENTS — VARCHAR2(2000)
- URL — VARCHAR2(300)
- CREATED_DATE — DATE
RESERVATION
- RESVNO — NUMBER(10) — Primary key — NOT NULL
- USERNO — NUMBER(10) — Foreign key → user.USERNO — NOT NULL
- COUNSELORNO — NUMBER(10) — Foreign key → COUNSELOR.COUNSELORNO — NOT NULL
- RESV_DATE — DATE
- STATUS — VARCHAR2(20)
user (USERS)
- USERNO — NUMBER(10) — Primary key — NOT NULL
- ID — VARCHAR2(30) — NOT NULL
- PASSWORD — VARCHAR2(200) — NOT NULL
- MNAME — VARCHAR2(50) — NOT NULL
- PHONE — VARCHAR2(20)
- RDATE — DATE
- GRADE — NUMBER(2)
- SDATE — DATE
- Ddate — date