ㅏㅏㅏㅏ

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) — 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) — 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) — NOT NULL
  • USERNO — NUMBER(10) — NOT NULL
  • CONTENT — VARCHAR2(1000)
  • CREATED_DATE — DATE

COUNSELOR

  • COUNSELORNO — NUMBER(10) — Primary key — NOT NULL
  • USERNO — NUMBER(10) — NOT NULL
  • FIELD — VARCHAR2(50)
  • LOCATION — VARCHAR2(50)
  • CAREER — VARCHAR2(200)

COUNSEL_HISTORY

  • COUNSELNO — NUMBER(10) — Primary key — NOT NULL
  • COUNSELORNO — NUMBER(10) — NOT NULL
  • USERNO — NUMBER(10) — 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) — NOT NULL
  • TOTAL_SCORE — NUMBER(10)
  • RESULT_TAG — VARCHAR2(100)
  • CREATED_DATE — DATE

DIARY

  • DIARYNO — NUMBER(10) — Primary key — NOT NULL
  • USERNO — NUMBER(10) — NOT NULL
  • TITLE — VARCHAR2(200)
  • CONTENTS — VARCHAR2(2000)
  • CREATED_DATE — DATE

EMOTION_SCORE

  • SCORENO — NUMBER(10) — Primary key — NOT NULL
  • DIARYNO — NUMBER(10) — 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) — NOT NULL
  • PURPOSE — VARCHAR2(50)
  • SESSION_START — DATE
  • SESSION_END — DATE

LLM_MESSAGE

  • MSGNO — NUMBER(10) — Primary key — NOT NULL
  • CHATLOGNO — NUMBER(10) — 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) — NOT NULL
  • COUNSELORNO — NUMBER(10) — NOT NULL
  • RESV_DATE — DATE
  • STATUS — VARCHAR2(20)

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