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