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) — 훈련 등록 일시