contents

Tables (15)

content_groups (Untitled12)

  • content_group_id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar

content_tags (Untitled6)

  • contents_id (Key1) — bigint — Foreign key → contents.contents_id — NOT NULL
  • tag_id (Key2) — bigint — Foreign key → tag.tag_id — NOT NULL

contents (Untitled)

  • contents_id (Key) — bigint — Primary key — NOT NULL
  • content_group_id (Key2) — bigint — Foreign key → content_groups.content_group_id — NOT NULL
  • title (Field) — varchar
  • description (Field2) — varchar
  • completed (Field3) — boolean
  • Field4

recommand_category (Untitled14)

  • recommand_category_id (Key) — bigint — Primary key — NOT NULL
  • recommand_category (Field)
  • activated (Field2) — boolean
  • weght (Field3) — int

recommand_content (Untitled15)

  • recommand_content_id (Key) — bigint — Primary key — NOT NULL
  • recommand_category_id (Key2) — bigint — Foreign key → recommand_category.recommand_category_id — NOT NULL
  • content_id (Field) — bigint
  • sort_order (Field2) — bigint

review (Untitled3)

  • review_id (Key) — bigint — Primary key — NOT NULL
  • contents_id (Key2) — bigint — Foreign key → contents.contents_id — NOT NULL
  • user_id (Field3) — bigint
  • review (Field) — varchar
  • spoiler (Field4) — boolean
  • Field5

review_count (Untitled4)

  • review_count_id (Key) — bigint — Primary key — NOT NULL
  • contents_id (Key2) — bigint — Foreign key → contents.contents_id — NOT NULL
  • review_count (Field) — bigint

review_like (Untitled8)

  • review_like_id (Key) — bigint — Primary key — NOT NULL
  • review_id (Key2) — bigint — Foreign key → review.review_id — NOT NULL
  • user_id (Field) — bigint

review_like_count (Untitled9)

  • review_like_count_id (Key) — bigint — Primary key — NOT NULL
  • review_id (Key2) — bigint — Foreign key → review.review_id — NOT NULL
  • review_like_count (Field) — bigint

star_points (Untitled10)

  • star_points_id (Key) — bigint — Primary key — NOT NULL
  • contents_id (Key2) — bigint — Foreign key → contents.contents_id — NOT NULL
  • user_id (Field) — bigint

star_points_average (Untitled11)

  • star_points_average_id (Key) — bigint — Primary key — NOT NULL
  • contents_id (Key2) — bigint — Foreign key → contents.contents_id — NOT NULL
  • star_points_count (Field) — bigint
  • total_star_points (Field2) — bigint

tag (Untitled5)

  • tag_id (Key) — bigint — Primary key — NOT NULL
  • tag_name (Field) — varchar
  • Field2

thumb_nail (Untitled2)

  • thumb_nail_id (Key) — bigint — Primary key — NOT NULL
  • contents_id (Key2) — bigint — Foreign key → contents.contents_id — NOT NULL
  • img_url (Field2) — varchar
  • type (Field3) — varfchar

user_watch_history (Untitled13)

  • user_watch_history_id (Key) — bigint — Primary key — NOT NULL
  • vod_id (Key2) — bigint — Foreign key → vod.vod_id — NOT NULL
  • user_id (Field) — bigint
  • start_play_second (Field2) — int
  • end_play_second (Field3) — int

vod (Untitled7)

  • vod_id (Key) — bigint — Primary key — NOT NULL
  • contents_id (Key2) — bigint — Foreign key → contents.contents_id — NOT NULL
  • title (Field) — varchar
  • description (Field2) — varchar
  • vod_url (Field3) — varchar
  • running_time (Field4) — int