동아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