KOALA

Tables (32)

algorithm

  • english_name — varchar(255) — NOT NULL
  • created_by — varchar(255)
  • created_time — datetime(6)
  • korean_name — varchar(255)
  • updated_by — varchar(255)
  • updated_time — datetime(6)

answer

  • id — bigint
  • confirmyn — char — NOT NULL
  • created_by — varchar(255)
  • created_time — datetime(6)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • application_id — bigint

api_request

  • module — varchar(255) — NOT NULL
  • last_request_time — datetime
  • created_by — varchar(255)
  • created_time — datetime(6)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • value — int — NOT NULL

application

  • id — bigint
  • confirmyn — char — NOT NULL
  • created_by — varchar(255)
  • created_time — datetime(6)
  • title — varchar(255) — NOT NULL
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • study_id — bigint

attendance

  • id — bigint
  • blogyn — char — NOT NULL
  • created_by — varchar(255)
  • created_time — datetime(6)
  • problemyn — char — NOT NULL
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • workbookyn — char — NOT NULL
  • study_member_id — bigint
  • week_id — bigint

attendance_request

  • id — bigint
  • blog_url — varchar(255)
  • created_by — varchar(255)
  • created_time — datetime(6)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • study_member_id — bigint
  • week_id — bigint

attendance_request_problem

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • problem_url — varchar(255) — NOT NULL
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • attendance_request_id — bigint

board

  • id — bigint
  • category — varchar(255)
  • content — text
  • created_by — varchar(255)
  • created_time — datetime(6)
  • delete_yn — char — NOT NULL
  • fix_yn — char — NOT NULL
  • save_yn — char — NOT NULL
  • title — varchar(255)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • view_count — int
  • member_id — bigint

board_file

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • file_url — varchar(255)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • board_id — bigint

board_like

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • board_id — bigint
  • member_id — bigint

curriculum

  • id — bigint
  • content — text
  • created_by — varchar(255)
  • created_time — datetime(6)
  • title — varchar(255)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • week — int
  • study_id — bigint
  • order_number — int

field

  • id — bigint
  • context — varchar(255)
  • created_by — varchar(255)
  • created_time — datetime(6)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • select_question_id — bigint

inquiry

  • id — bigint
  • category — varchar(255)
  • content — text
  • created_by — varchar(255)
  • created_time — datetime(6)
  • public_yn — char — NOT NULL
  • solved_yn — char — NOT NULL
  • title — varchar(255)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • view_count — int
  • member_id — bigint

inquiry_reply

  • id — bigint
  • content — varchar(1000)
  • created_by — varchar(255)
  • created_time — datetime(6)
  • delete_yn — char — NOT NULL
  • depth — int
  • parent_id — bigint
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • inquiry_id — bigint
  • member_id — bigint

institution

  • id — bigint
  • content — text
  • created_by — varchar(255)
  • created_time — datetime(6)
  • name — varchar(255)
  • type — varchar(255)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • view_count — int

interview

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • time — varchar(255) — NOT NULL
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • study_member_id — bigint

member

  • id — bigint
  • blockyn — char — NOT NULL
  • created_time — datetime(6)
  • email — varchar(255)
  • grade — int — NOT NULL
  • handle — varchar(255) — NOT NULL
  • major — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • phone_number — varchar(255) — NOT NULL
  • profile_url — varchar(255)
  • role — varchar(255)
  • updated_time — datetime(6)

problem

  • number — int — NOT NULL
  • created_by — varchar(255)
  • created_time — datetime(6)
  • language_list — varchar(255)
  • level — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • solved_count — int
  • updated_by — varchar(255)
  • updated_time — datetime(6)

problem_algorithm

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • algorithm_id — varchar(255)
  • problem_id — int

reply

  • id — bigint
  • content — varchar(1000)
  • created_by — varchar(255)
  • created_time — datetime(6)
  • delete_by_admin_yn — char — NOT NULL
  • delete_yn — char — NOT NULL
  • depth — int
  • parent_id — bigint
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • board_id — bigint
  • member_id — bigint

reply_like

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • member_id — bigint
  • reply_id — bigint

s3file

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • file_name — varchar(255) — NOT NULL
  • file_url — varchar(255) — NOT NULL
  • original_name — varchar(255) — NOT NULL
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • file_size — double — NOT NULL

select_answer

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime
  • updated_by — varchar(255)
  • updated_time — datetime
  • answer_id — bigint
  • select_question_id — bigint

select_answer_field

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime
  • updated_by — varchar(255)
  • updated_time — datetime
  • field_id — bigint
  • select_answer_id — bigint

select_question

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • is_multi_select — varchar(255)
  • is_required — varchar(255)
  • question — varchar(255) — NOT NULL
  • sequence — int — NOT NULL
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • application_id — bigint

study

  • id — bigint
  • content — text
  • created_by — varchar(255)
  • created_time — datetime(6)
  • name — varchar(255) — NOT NULL
  • profile_url — varchar(255)
  • type — varchar(255) — NOT NULL
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • generation_id — bigint
  • endyn — char — NOT NULL

study_member

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • role — varchar(255) — NOT NULL
  • status — varchar(255) — NOT NULL
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • member_id — bigint
  • study_id — bigint

text_answer

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • text — varchar(10000)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • answer_id — bigint
  • text_question_id — bigint

text_question

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • is_required — varchar(255)
  • question — varchar(255) — NOT NULL
  • sequence — int — NOT NULL
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • application_id — bigint

week

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • end_time — datetime(6)
  • start_time — datetime(6)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • value — int — NOT NULL
  • generation_id — bigint

workbook

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • name — varchar(255)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • institution_id — bigint
  • study_id — bigint
  • week_id — bigint

workbook_problem

  • id — bigint
  • created_by — varchar(255)
  • created_time — datetime(6)
  • updated_by — varchar(255)
  • updated_time — datetime(6)
  • problem_id — int
  • workbook_id — bigint