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