dd

Tables (5)

dm_category_trn

  • TRN_SEQ — bigint — Foreign key → dm_trn_info.TRN_SEQ — NOT NULL — 훈련 번호
  • sec_category_seq (sec_category_seq2) — bigint — Foreign key → dm_child_category.sec_category_seq — NOT NULL
  • sec_category_seq — bigint
  • trn_seq — bigint
  • reg_dttm — timestamp
  • trn_name — varchar(50)
  • delete_dttm — timestamp

dm_child_category

  • sec_category_seq — bigint — Primary key — NOT NULL
  • c_cate_name — varchar(20)
  • c_cate_thumbnail_img — mediumtext
  • c_open_at — int
  • reg_dttm — timestamp
  • upt_dttm — timestamp
  • c_description — varchar(500)
  • c_cate_main_img — mediumtext
  • dttm — timestamp

dm_child_to_parent_category

  • sec_category_seq (sec_category_seq2) — bigint — Foreign key → dm_child_category.sec_category_seq — NOT NULL
  • fst_category_seq (fst_category_seq2) — bigint — Foreign key → dm_parent_category.fst_category_seq — NOT NULL
  • fst_category_seq — bigint
  • sec_category_seq — bigint
  • reg_dttm — timestamp
  • delete_dttm — timestamp

dm_parent_category

  • fst_category_seq — bigint — Primary key — NOT NULL
  • p_cate_name — varchar(20)
  • p_open_at — int
  • reg_dttm — timestamp
  • upt_dttm — timestamp
  • dttm — timestamp

dm_trn_info

  • TRN_SEQ — bigint — Primary key — NOT NULL — 훈련 번호
  • TRN_NAME — varchar(50) — 훈련명
  • TRN_DESC — mediumtext — 훈련 설명
  • TRN_LEVEL — int — 훈련 난이도
  • TRN_SHOW_YN — char(1) — NOT NULL — 훈련 노출 여부
  • TRN_THUMBNAIL_IMG — varchar(2048) — 훈련 썸네일 이미지
  • TRN_TIP_1 — mediumtext — 훈련 팁1
  • TRN_TIP_2 — mediumtext — 훈련 팁2
  • TRN_TIP_3 — mediumtext — 훈련 팁3
  • TRN_TIP_4 — mediumtext — 훈련 팁4
  • TRN_TIP_5 — mediumtext — 훈련 팁5
  • TRN_DEFAULT_LOCK_YN — char(1) — 훈련 잠금
  • TRN_EXP — int — 훈련 경험치
  • TRN_REG_DTTM — timestamp(6) — 훈련 등록 일시