동아ST
테이블 (4)
parent_vod (부모영상)
- parent_id (parent_idx) — bigint — 기본 키 — NOT NULL
- parent_category (category) — string
- parent_tag (tag) — string
- parent_title — string
- parent_total (total_episode) — int
user (회원)
- user_idx — bigint — 기본 키 — NOT NULL
- user_name — string
- user_join_date — date
- user_log_date — date
- user_authority — string
- user_status (status) — int
- user_out_date — date
- user_age — int
- user_sex — int
- user_medical (Field) — string
vod1 (영상)
- vod_idx — bigint — 기본 키 — NOT NULL
- parent_idx — bigint — 외래 키 → parent_vod.parent_id — NOT NULL
- vod_title — string
- vod_date (vod_regdate) — date
- vod_hit — int
- vod_islive (vod_live) — int
vod2 (영상2)
- vod_idx — bigint — 기본 키 — NOT NULL
- vod_parent — bigint
- vod_title — string
- vod_category (category) — string
- vod_ta (tag) — string
- vod_parent_title (parent_title) — string
- vod_total (total_episode) — int
- vod_date (vod_regdate) — date
- vod_hit — int
- vod_islive (vod_live) — int