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