정주행

테이블 (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`