정주행
테이블 (27)
bookmark
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- customer_id — BIGINT(20) — 외래 키 → customer.id
- timeline_id — BIGINT(20) — 외래 키 → timeline.id
- topic_id — BIGINT(20) — 외래 키 → topic.id
- INDEX — `FKljchtkfqya9ylbxqu101hlkwd`
- INDEX — `FK1mss0e0420bvr008f7nh4u1y6`
- INDEX — `FK9klf7m5ue88fan7ere4m99yh0`
category
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
chapter
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- content — LONGTEXT
- number — INT(11) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- date_comment — VARCHAR(255)
- jjh_list_number — INT(11)
choice
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- comment — VARCHAR(255)
- content — VARCHAR(255) — NOT NULL
- number — INT(11)
- type — VARCHAR(255)
- exam_question_id — BIGINT(20) — 외래 키 → exam_question.id
- topic_id — BIGINT(20) — 외래 키 → topic.id
- INDEX — `FKbjivn98yo4pjrclvcy1m65a6b`
- INDEX — `FKki2l9yfg8s4p1h0ccx17dri1n`
choice_keyword
- id — BIGINT(20) — 기본 키 — NOT NULL
- choice_id — BIGINT(20) — 외래 키 → choice.id
- keyword_id — BIGINT(20) — 외래 키 → keyword.id
- INDEX — `FKfkarw4cxsd0urn243vqdof7av`
- INDEX — `FK7bg5v5w61hvbkylt8ib6ty3u5`
customer
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- age — INT(11)
- code — BINARY(16)
- expertise — INT(11)
- is_subscribed — TINYINT(1)
- nick_name — VARCHAR(255) — NOT NULL
- o_auth_id — VARCHAR(1000)
- password — VARCHAR(255)
- provider — VARCHAR(255)
- roles — VARCHAR(255)
- solved_num — INT(11)
- is_validated — BIT(1) — NOT NULL
- is_new — BIT(1) — NOT NULL
description
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- comment — VARCHAR(255)
- content — LONGTEXT
- exam_question_id — BIGINT(20) — 외래 키 → exam_question.id
- topic_id — BIGINT(20) — 외래 키 → topic.id
- INDEX — `FKjigvq1juvanc1cseupvxg9ncs`
- INDEX — `FK9oe6w5v2482vmrll0eyw9pd8b`
description_keyword
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- description_id — BIGINT(20) — 외래 키 → description.id
- keyword_id — BIGINT(20) — 외래 키 → keyword.id
- INDEX — `FKy1w71fm78xnfri5mss7myjiq`
- INDEX — `FKkr7y4bgq96q3l79f10ru5ygnr`
era
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
exam_question
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- answer — INT(11)
- choice_type — VARCHAR(255)
- number — INT(11)
- score — INT(11)
- round_id — BIGINT(20) — 외래 키 → round.id
- INDEX — `FKlm6src8s0x34jjhl9yp5vnr7u`
exam_question_learning_record
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- answer_noted — BIT(1)
- checked_number — INT(11)
- first_solve — BIT(1)
- score — INT(11)
- customer_id — BIGINT(20) — 외래 키 → customer.id
- exam_question_id — BIGINT(20) — 외래 키 → exam_question.id
- is_removed_answer_note — BIT(1)
- solved — BIT(1)
- INDEX — `FKkuwp418bvfodix9b55arm5cb5`
- INDEX — `FKn3keysi5dy2ggc7xvpr8ujtwo`
jjh_content
- id — BIGINT(20) — 기본 키 — NOT NULL
- content — VARCHAR(255)
- number — INT(11)
- chapter_id — BIGINT(20) — 외래 키 → chapter.id
- jjh_list_id — BIGINT(20) — 외래 키 → jjh_list.id
- timeline_id — BIGINT(20) — 외래 키 → timeline.id
- topic_id — BIGINT(20) — 외래 키 → topic.id
- INDEX — `FK3j3rqjse936alhj79loofnys1`
- INDEX — `FKsxi7irygd557vd38igu952c59`
- INDEX — `FKmshc6oi5lx7w18aegpso4c9fd`
- INDEX — `FK9bvmo31t81t8s9ymupby2s1xh`
jjh_content_progress
- id — BIGINT(20) — 기본 키 — NOT NULL
- state — VARCHAR(255)
- customer_id — BIGINT(20) — 외래 키 → customer.id
- jjh_content_id — BIGINT(20) — 외래 키 → jjh_content.id
- INDEX — `FK1g6x8wgm16e0nr75u4s8dqljk`
jjh_list
- id — BIGINT(20) — 기본 키 — NOT NULL
- number — INT(11)
- chapter_id — BIGINT(20) — 외래 키 → chapter.id
- timeline_id — BIGINT(20) — 외래 키 → timeline.id
- INDEX — `FK6equywp7ecmtuarj0wf5qqli`
- INDEX — `FKikim96w7drb9i500vsl0hvv18`
jjh_list_progress
- id — BIGINT(20) — 기본 키 — NOT NULL
- progress — VARCHAR(255)
- state — VARCHAR(255)
- customer_id — BIGINT(20) — 외래 키 → customer.id
- jjh_list_id — BIGINT(20) — 외래 키 → jjh_list.id
- INDEX — `FKqm4r2oy8is21pwia04d4iph2p`
keyword
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- comment — VARCHAR(255)
- image_url — VARCHAR(255)
- name — VARCHAR(255) — NOT NULL
- topic_id — BIGINT(20) — 외래 키 → topic.id
- date_comment — VARCHAR(255)
- number — INT(11)
- question_prob — INT(11)
- INDEX — `FK1v2igx1h39903r5i9ht5ox00d`
keyword_learning_record
- id — BIGINT(20) — 기본 키 — NOT NULL
- wrong_count — INT(11)
- customer_id — BIGINT(20) — 외래 키 → customer.id
- keyword_id — BIGINT(20) — 외래 키 → keyword.id
- answer_count — INT(11)
- INDEX — `FKhavhq8lsse4usaxr7blyjdre7`
- INDEX — `FKgfalkoiu0vaaqfhni9xu5jvmc`
keyword_primary_date
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- extra_date — INT(11)
- extra_date_comment — VARCHAR(255)
- INDEX — `FK2g1p681fk7bimwnm57dyxpcea`
question_category
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- title — VARCHAR(255)
- category_id — BIGINT(20) — 외래 키 → category.id
- era_id — BIGINT(20) — 외래 키 → era.id
- number — INT(11)
- total_question_prob — INT(11)
- INDEX — `FK8am7a16ooqygccfeff0csl6ed`
- INDEX — `FKp25xu4j32i23s8i267ybb604h`
question_category_learning_record
- id — BIGINT(20) — 기본 키 — NOT NULL
- answer_count — INT(11)
- wrong_count — INT(11)
- customer_id — BIGINT(20) — 외래 키 → customer.id
- question_category_id — BIGINT(20) — 외래 키 → question_category.id
- score — INT(11)
- INDEX — `FKf5j41ams9hnwv4frx6qtokbri`
- INDEX — `FKl7motc9kglq7f22lecu9v0t0h`
round
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- date — INT(11)
- number — INT(11) — NOT NULL
round_learning_record
- id — BIGINT(20) — 기본 키 — NOT NULL
- customer_id — BIGINT(20) — 외래 키 → customer.id
- round_id — BIGINT(20) — 외래 키 → round.id
- score — INT(11)
- INDEX — `FKqgkt9hyyhpnkc52u7qwsigjyt`
- INDEX — `FK1jntsqi74d41d3srlgssumwt3`
timeline
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- end_date — INT(11)
- jjh_list_number — INT(11)
- start_date — INT(11)
- era_id — BIGINT(20) — 외래 키 → era.id
- title — VARCHAR(255)
- count — INT(11)
- INDEX — `FKbkj9e9vcwg9s35ovnh2dxsjxp`
timeline_learning_record
- id — BIGINT(20) — 기본 키 — NOT NULL
- answer_count — INT(11)
- wrong_count — INT(11)
- customer_id — BIGINT(20) — 외래 키 → customer.id
- timeline_id — BIGINT(20) — 외래 키 → timeline.id
- score — INT(11)
- INDEX — `FK43ya8se4y2amn2vy3rfakpuio`
- INDEX — `FKd37ioqh0iu3g9mtreyobm0a11`
topic
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- choice_num — INT(11) — NOT NULL
- detail — LONGTEXT
- number — INT(11)
- question_num — INT(11) — NOT NULL
- title — VARCHAR(255)
- chapter_id — BIGINT(20) — 외래 키 → chapter.id
- date_comment — VARCHAR(255)
- question_category_id — BIGINT(20) — 외래 키 → question_category.id
- INDEX — `FKmh77bkcy1533rp2b1o30qk05o`
- INDEX — `FK3q69qrf3skw7pcyeaq8fyk0mr`
topic_learning_record
- id — BIGINT(20) — 기본 키 — NOT NULL
- answer_count — INT(11)
- wrong_count — INT(11)
- customer_id — BIGINT(20) — 외래 키 → customer.id
- topic_id — BIGINT(20) — 외래 키 → topic.id
- is_bookmarked — BIT(1)
- INDEX — `FKscxloqhwoe7r05uyutt2k9tca`
- INDEX — `FK91rpbopsrtag8qc52q0a1cuno`
topic_primary_date
- id — BIGINT(20) — 기본 키 — NOT NULL
- created_time — VARCHAR(255)
- modified_time — VARCHAR(255)
- extra_date — INT(11)
- extra_date_comment — VARCHAR(255)
- INDEX — `FK7w3m5j13y7c9axbt00a3j0doq`