Playground

Tables (19)

TBL_ADMINISTRATOR

  • ID — NUMBER
  • ADMINISTRATOR_ID — VARCHAR2(255) — NOT NULL
  • ADMINISTRATOR_PASSWORD — VARCHAR2(255)
  • ADMINISTRATOR_LOGIN_TIME — DATE
  • ADMINISTRATOR_LOGOUT_TIME — DATE
  • ADMINISTRATOR_EMAIL — VARCHAR2(500)
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_CONSULTING_POST

  • ID — NUMBER
  • USER_ID — NUMBER

TBL_CONSULTING_POST_ATTACHMENT

  • ID — NUMBER
  • ATTACHMENT_NAME — VARCHAR2(1000)
  • ATTACHMENT_CONTENT — VARCHAR2(1000)
  • ATTACHMENT_PATH — VARCHAR2(1000)
  • CONSULTING_POST_ID — NUMBER
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_CONSULTING_POST_LIKE

  • ID — NUMBER
  • STATUS — NUMBER
  • USER_ID — NUMBER
  • POST_ID — NUMBER
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_CONSULTING_POST_REPLY

  • ID — NUMBER
  • POST_ID — NUMBER
  • USER_ID — NUMBER

TBL_CONSULTING_POST_REPLY_LIKE

  • ID — NUMBER
  • USER_ID — NUMBER
  • REPLY_ID — NUMBER
  • STATUS — NUMBER

TBL_EXPECTED_PROBLEM

  • ID — NUMBER
  • EXPECTED_PROBLEM_TITLE — VARCHAR2(1000)
  • EXPECTED_PROBLEM_CONTENT — VARCHAR2(3000)
  • EXPECTED_PROBLEM_LEVEL — NUMBER
  • SUBJECT — VARCHAR2(255)
  • USER_ID — NUMBER
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_EXPECTED_PROBLEMREPLY

  • ID — NUMBER
  • EXPECTED_REPLY_CONTENT — VARCHAR2(3000)
  • EXPECTED_PROBLEM_ID — NUMBER
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_FREE_POST

  • ID — NUMBER
  • USER_ID — NUMBER

TBL_FREE_POST_ATTACHMENT

  • ID — NUMBER
  • ATTACHMENT_NAME — VARCHAR2(1000)
  • ATTACHMENT_CONTENT — VARCHAR2(1000)
  • ATTACHMENT_PATH — VARCHAR2(1000)
  • FREE_POST_ID — NUMBER
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_FREE_POST_LIKE

  • ID — NUMBER
  • STATUS — NUMBER
  • USER_ID — NUMBER
  • POST_ID — NUMBER

TBL_FREE_POST_REPLY

  • ID — NUMBER
  • POST_ID — NUMBER
  • USER_ID — NUMBER

TBL_FREE_POST_REPLY_LIKE

  • ID — NUMBER
  • USER_ID — NUMBER
  • REPLY_ID — NUMBER
  • STATUS — NUMBER

TBL_INQUIRE_POST

  • ID — NUMBER
  • INQUIRE_POST_TITLE — VARCHAR2(1000)
  • INQUIRE_POST_CONTENT — VARCHAR2(3000)
  • INQUIRE_POST_ANSWER — VARCHAR2(255)
  • USER_ID — NUMBER
  • ADMINISTRATOR_ID — NUMBER
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_INQUIRE_POST_ATTACHMENT

  • ID — NUMBER
  • ATTACHMENT_NAME — VARCHAR2(1000)
  • ATTACHMENT_CONTENT — VARCHAR2(1000)
  • ATTACHMENT_PATH — VARCHAR2(1000)
  • INQUIRE_POST_ID — NUMBER
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_NOTICE

  • ID — NUMBER
  • NOTICE_TITLE — VARCHAR2(1000)
  • NOTICE_CONTENT — VARCHAR2(3000)
  • NOTICE_DIVISION — VARCHAR2(255)
  • ADMINISTRATOR_ID — NUMBER
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_POST

  • ID — NUMBER
  • POST_TITLE — VARCHAR2(1000) — NOT NULL
  • POST_CONTENT — VARCHAR2(3000)
  • CATEGORY — VARCHAR2(255) — NOT NULL
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_REPLY

  • ID — NUMBER
  • REPLY_CONTENT — VARCHAR2(3000)
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE

TBL_USER

  • ID — NUMBER
  • USER_NAME — VARCHAR2(255)
  • USER_EMAIL — VARCHAR2(500)
  • USER_PASSWORD — VARCHAR2(500)
  • USER_PHONE — VARCHAR2(255)
  • USER_SCHOOL — VARCHAR2(255)
  • USER_DIVISION — NUMBER
  • USER_SNS — NUMBER
  • USER_GENDER — VARCHAR2(255)
  • USER_AGE — NUMBER
  • USER_PROFILE_NAME — VARCHAR(255)
  • USER_PROFILE_PATH — VARCHAR(255)
  • USER_STATUS — NUMBER
  • USER_LOGIN_CODE — VARCHAR(255)
  • USER_NICKNAME — VARCHAR(255)
  • USER_KAKAO_EMAIL — VARCHAR(255)
  • USER_KAKAO_PROFILE_URL — VARCHAR(255)
  • CREATE_DATE — DATE
  • UPDATE_DATE — DATE