CT_교육플랫폼

테이블 (15)

config (Untitled2)

  • id (Key) — int — 기본 키 — NOT NULL
  • version_code (Field) — varchar
  • term_use (Field2) — text
  • term_private (Field3) — text

lesson (Untitled9)

  • id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → user.id — NOT NULL
  • language_type (Field2) — enum
  • title (Field3) — varchar
  • description (Field4) — varchar
  • start_dt (Field5) — timestamp
  • end_dt (Field6) — timestamp
  • main_img_path (Field7) — varchar
  • main_img_name (Field8) — varchar
  • main_thumb_path (Field9) — varchar
  • main_thumb_name (Field10) — varchar

lesson_activity (Untitled10)

  • id (Key) — int — 기본 키 — NOT NULL
  • lesson_id (Key2) — int — 외래 키 → lesson.id — NOT NULL
  • user_id (Key22) — int — 외래 키 → lesson.user_id — NOT NULL
  • lesson_type (Field4) — enum
  • title (Field) — varchar
  • resource_path (Field2) — varchar
  • resource_time (Field3) — varchar
  • main_img_path (Field5) — varchar
  • main_img_name (Field6) — varchar
  • main_thumb_path (Field7) — varchar
  • main_thumb_name (Field8) — varchar

lesson_activity_finish (Untitled15)

  • id (Key) — int — 기본 키 — NOT NULL
  • la_id (Key2) — int — 외래 키 → lesson_activity.id — NOT NULL
  • user_id (Key3) — int — 외래 키 → lesson_subscribe.id — NOT NULL

lesson_qna (Untitled12)

  • id (Key) — int — 기본 키 — NOT NULL
  • lession_id (Key2) — int — 외래 키 → lesson.id — NOT NULL
  • user_id (Key3) — int — 외래 키 → lesson_subscribe.id — NOT NULL
  • title (Field) — varchar
  • contents (Field2) — text
  • view_cnt (Field3) — int

lesson_qna_answer (Untitled13)

  • id (Key) — int — 기본 키 — NOT NULL
  • lq_id (Key2) — int — 외래 키 → lesson_qna.id — NOT NULL
  • user_id (Key3) — int — 외래 키 → user.id — NOT NULL
  • contents (Field) — varchar
  • photoUrl_path (Field2) — varchar
  • photoUrl_name (Field3) — varchar
  • photoThumb_path (Field4) — varchar
  • photoThumb_name (Field5) — varchar

lesson_review (Untitled11)

  • id (Key) — int — 기본 키 — NOT NULL
  • lesson_id (Key2) — int — 외래 키 → lesson.id — NOT NULL
  • user_id (Key3) — int — 외래 키 → user.id — NOT NULL
  • star_score (Field) — int
  • contents (Field2) — varchar

lesson_subscribe (Untitled14)

  • id (Key) — int — 기본 키 — NOT NULL
  • lesson_id (Key2) — int — 외래 키 → lesson.id — NOT NULL
  • user_id (Key3) — int — 외래 키 → user.id — NOT NULL

notice (Untitled4)

  • id (Key) — int — 기본 키 — NOT NULL
  • title (Field) — varchar
  • contents (Field2) — text
  • view_cnt (Field3) — int

notification (Untitled3)

  • id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key3) — int — 외래 키 → user.id — NOT NULL
  • type (Field) — enum
  • title (Field3) — varchar
  • contents (Field4) — varchar
  • readYN (Field2) — enum

study_group (Untitled5)

  • id (Key) — int — 기본 키 — NOT NULL
  • type (Field) — enum
  • name (Field2) — varchar
  • description (Field3) — varchar
  • new_flag (Field4) — enum

study_group_board (Untitled7)

  • id (Key) — int — 기본 키 — NOT NULL
  • sg_id (Key2) — int — 외래 키 → study_group.id — NOT NULL
  • user_id (Key3) — int — 외래 키 → user.id — NOT NULL
  • type (Field3) — enum
  • title (Field) — varchar
  • contents (Field2) — text

study_group_board_reply (Untitled8)

  • id (Key) — int — 기본 키 — NOT NULL
  • sgb_id (Key2) — int — 외래 키 → study_group_board.id — NOT NULL
  • user_id (Key3) — int — 외래 키 → user.id — NOT NULL
  • contents (Field) — varchar
  • photoUrl_path (Field2) — varchar
  • photoUrl_name (Field3) — varchar
  • photoThumb_path (Field4) — varchar
  • photoThumb_name (Field5) — varchar

user (Untitled)

  • id (Key) — int — 기본 키 — NOT NULL
  • user_type (Field21) — enum
  • status (Field) — enum
  • account_type (Field8) — enum
  • email (Field2) — varchar
  • password (Field3) — varchar
  • name (Field4) — varchar
  • phone (Field5) — varchar
  • gender (Field6) — enum
  • is_term_yn (Field7) — enum
  • access_token (Field9) — text
  • refresh_token (Field10) — text
  • sns_id (Field11) — varchar
  • alarm_all (Field12) — enum
  • alarm_study_group (Field13) — enum
  • alarm_new_write (Field14) — enum
  • alarm_new_reply (Field15) — enum
  • alarm_sg_approval (Field16) — enum
  • profile_img_path (Field17) — varchar
  • profile_img_name (Field18) — varchar
  • profile_thumb_path (Field19) — varchar
  • profile_thumb_name (Field20) — varchar

user_study_group (Untitled6)

  • id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → user.id — NOT NULL
  • sg_id (Key3) — int — 외래 키 → study_group.id — NOT NULL
  • user_type (Field3) — enum
  • status (Field4) — enum