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