bubble
Tables (35)
ABC_Type_Q
- ABC_Type_Q_id (Key) — Primary key — NOT NULL
- ABC_Type_Test_id (Key3) — Foreign key → ABC_Type_Test.ABC_Type_Test_id — NOT NULL
- ABC_Type_USER_Result_id (Key2) — Foreign key → ABC_Type_Test.ABC_Type_USER_Result_id — NOT NULL
- User_id (Key22) — Foreign key → ABC_Type_Test.User_id — NOT NULL
- ABC_Type_user_choice_id (Key4) — Foreign key → ABC_Type_user_choice.ABC_Type_user_choice_id — NOT NULL
- ABC_Type_USER_Result_id (Key23) — Foreign key → ABC_Type_user_choice.ABC_Type_USER_Result_id — NOT NULL
- User_id (Key222) — Foreign key → ABC_Type_user_choice.User_id — NOT NULL
- image — IMAGE
- max — NUMBER
- min — NUMBER
- Options — TEXT
- Q_detail — TEXT
- Q_title — TEXT
- 도움말 — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
ABC_Type_Result
- ABC_Type_Result_id (Key) — Primary key — NOT NULL
- ABC_Type_Test_id (Key3) — Foreign key → ABC_Type_Test.ABC_Type_Test_id — NOT NULL
- ABC_Type_USER_Result_id (Key2) — Foreign key → ABC_Type_Test.ABC_Type_USER_Result_id — NOT NULL
- User_id (Key22) — Foreign key → ABC_Type_Test.User_id — NOT NULL
- range_End — TEXT
- range_End_num — NUMBER
- range_Start — NUMBER
- Result_text — TEXT
- Title — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
ABC_Type_Test
- ABC_Type_Test_id (Key3) — Primary key — NOT NULL
- ABC_Type_USER_Result_id (Key) — Foreign key → ABC_Type_USER_Result.ABC_Type_USER_Result_id — NOT NULL
- User_id (Key2) — Foreign key → ABC_Type_USER_Result.User_id — NOT NULL
- Completion_status — BOOLEAN
- info_detail — TEXT
- max_score — NUMBER
- Questions — TEXT
- Results — TEXT
- short_info — TEXT
- Thumbnail_img — IMAGE
- Title — TEXT
- 대표_img — IMAGE
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
ABC_Type_USER_Result
- ABC_Type_USER_Result_id (Key) — Primary key — NOT NULL
- User_id (Key2) — Foreign key → User.User_id — NOT NULL
- ABC_Test — TEXT
- result_Text — TEXT
- result_Title — TEXT
- Score_user — NUMBER
- User — USER
- user_choice_list — TEXT
- 최종제출 — BOOLEAN
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
ABC_Type_option
- ABC_Type_option_id (Key) — Primary key — NOT NULL
- ABC_Type_user_choice_id (Key2) — Foreign key → ABC_Type_user_choice.ABC_Type_user_choice_id — NOT NULL
- ABC_Type_USER_Result_id (Key22) — Foreign key → ABC_Type_user_choice.ABC_Type_USER_Result_id — NOT NULL
- User_id (Key222) — Foreign key → ABC_Type_user_choice.User_id — NOT NULL
- Option_txt — TEXT
- Score — NUMBER
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
ABC_Type_user_choice
- ABC_Type_user_choice_id (Key) — Primary key — NOT NULL
- ABC_Type_USER_Result_id (Key2) — Foreign key → ABC_Type_USER_Result.ABC_Type_USER_Result_id — NOT NULL
- User_id (Key22) — Foreign key → ABC_Type_USER_Result.User_id — NOT NULL
- ABC_type_option — TEXT
- ABC_type_Q — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
DE_Type_Q
- DE_Type_Q (Key2) — Primary key — NOT NULL
- DE_Type_USER_Result_id (Key22) — Foreign key → DE_Type_user_choice.DE_Type_USER_Result_id — NOT NULL
- User_id (Key) — Foreign key → DE_Type_user_choice.User_id — NOT NULL
- D_type_options — TEXT
- image — IMAGE
- Q_detail — TEXT
- Q_title — TEXT
- 도움말 — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
DE_Type_Test
- DE_Type_Test_id (Key) — Primary key — NOT NULL
- DE_Type_USER_Result_id (Key2) — Foreign key → DE_Type_USER_Result.DE_Type_USER_Result_id — NOT NULL
- User_id (Key3) — Foreign key → DE_Type_USER_Result.User_id — NOT NULL
- Completion_status — BOOLEAN
- info_detail — TEXT
- Questions — TEXT
- short_info — TEXT
- Thumbnail_img — IMAGE
- Title — TEXT
- Type — TEXT
- 대표_img — IMAGE
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
DE_Type_USER_Result
- DE_Type_USER_Result_id (Key2) — Primary key — NOT NULL
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- DE_type_test — TEXT
- DE_type_user_ans — JSON
- Expert_answer — TEXT
- User — TEXT
- 최종제출 — BOOLEAN
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
DE_Type_user_choice
- DE_Type_USER_Result_id (Key2) — Foreign key → DE_Type_USER_Result.DE_Type_USER_Result_id — NOT NULL
- User_id (Key) — Foreign key → DE_Type_USER_Result.User_id — NOT NULL
- DE_type_Q — TEXT
- user_answer_d — JSON
- user_answer_op — JSON
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
D_Type_option
- DE_Type_Q (Key2) — Foreign key → DE_Type_Q.DE_Type_Q — NOT NULL
- DE_Type_USER_Result_id (Key22) — Foreign key → DE_Type_Q.DE_Type_USER_Result_id — NOT NULL
- User_id (Key) — Foreign key → DE_Type_Q.User_id — NOT NULL
- option — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
Lecture
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- admin_id (Key2) — Foreign key → admin.admin_id — NOT NULL
- introduction — TEXT
- lecture_steps — JSON
- thumbnail — BLOB
- title — TEXT
- video_id — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
User
- User_id (Key) — Primary key — NOT NULL
- ABC_Type_Result — JSON
- birth_year — INTEGER
- blocks_emotion — JSON
- blocks_factor — JSON
- DE_Type_Result — JSON
- diary_emotion — JSON
- diary_thanks — JSON
- gender — TEXT
- kakao — TEXT
- message_list — JSON
- name — TEXT
- nickname — TEXT
- profile_image — BLOB
- record_challenge — JSON
- record_todo — JSON
- sai_level — TEXT
- sai_level_score — INTEGER
- tel — TEXT
- wish_lecture — JSON
- 오늘기분기록 — JSON
- email — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
admin
- admin_id (Key) — Primary key — NOT NULL
- development_Roadmap — TEXT
- lecture_list — TEXT
- mind_learning_list — TEXT
- noti — TEXT
- user_suggestions — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
block_emotion
- block_emotion_id (Key2) — Primary key — NOT NULL
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- default — BOOLEAN
- emoji_x — IMAGE
- emojis — TEXT
- emotion_name — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
block_emotion_emoji
- User_id (Key) — Foreign key → daily_emotion.User_id — NOT NULL
- emoji — IMAGE
- name — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
block_factor
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- default — BOOLEAN
- emojis — TEXT
- factor_name — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
block_factor_emoji
- User_id (Key) — Foreign key → daily_emotion.User_id — NOT NULL
- emoji — IMAGE
- name — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
challenge
- User_id (Key) — Foreign key → challenge_list.User_id — NOT NULL
- content — TEXT
- done_date — TEXT
- done_date_txt — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
challenge_list
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- done_date — TEXT
- done_date_txt — TEXT
- icon — IMAGE
- list — TEXT
- repeat — TEXT
- title — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
challenge_임시
- content — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
daily_emotion
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- block_e_e — TEXT
- block_f_e — TEXT
- ddd — TEXT
- emotion — TEXT
- plus_e_content — TEXT
- plus_e_title — TEXT
- plus_f_content — TEXT
- plus_f_title — TEXT
- Creator — USER
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
diary_emotion
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- content — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
diary_thanks
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- content — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
lecture_step
- User_id (Key) — Foreign key → Lecture.User_id — NOT NULL
- admin_id (Key2) — Foreign key → Lecture.admin_id — NOT NULL
- link — TEXT
- title — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
message
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- message_user — TEXT
- reply_admin — TEXT
- reply_Y_N — BOOLEAN
- title — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
mind_learning
- admin_id (Key) — Foreign key → admin.admin_id — NOT NULL
- thumbnail — BLOB
- title — TEXT
- 다루기 — TEXT
- 예방하기 — TEXT
- 이해하기 — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
noti
- admin_id (Key) — Foreign key → admin.admin_id — NOT NULL
- content — TEXT
- title — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
sol_expert
- address — TEXT
- image — BLOB
- info — TEXT
- name — TEXT
- sort — TEXT
- tel — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
sol_tool_method
- content — TEXT
- title — TEXT
- video_id — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
test
- num_list — JSON
- num_list2 — JSON
- text_list — JSON
- txt — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
test_결과용_감정_db
- count — INTEGER
- emoji — BLOB
- emoji_name — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
test_결과용_요인_db
- count — INTEGER
- emoji — BLOB
- emoji_name — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
todo
- User_id (Key) — Foreign key → User.User_id — NOT NULL
- done_date — JSON
- done_date_txt — JSON
- icon — BLOB
- repeat — TEXT
- title — TEXT
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT
user_suggestions
- admin_id (Key) — Foreign key → admin.admin_id — NOT NULL
- text — JSON
- Creator — TEXT
- Modified_Date — DATE
- Created_Date — DATE
- Slug — TEXT