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