test

Tables (10)

Copy Of Untitled2 (Review)

  • Key (review_id) — Primary key — NOT NULL
  • Field (content)
  • Key (contents_id) — Foreign key → Untitled.Key — NOT NULL

ReplyList (VideoReply)

  • Key (video_reply_id) — Primary key — NOT NULL
  • Field (content) — NOT NULL
  • Field (reg_data_time) — NOT NULL
  • Field (mod_data_time) — NOT NULL
  • Key (video_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (User_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (User)

  • Key (User_id) — Primary key — NOT NULL
  • Field (User_name) — NOT NULL

Untitled (Contents)

  • Key (contents_id) — Primary key — NOT NULL
  • Key (User_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (contents_title) — NOT NULL
  • Field (category) — NOT NULL
  • Field (introduce) — NOT NULL
  • Field (price) — NOT NULL
  • Field (reg_date) — NOT NULL
  • Field (mod_date) — NOT NULL
  • Field (thumbnailId) — NOT NULL

Untitled (Video)

  • Key (video_id) — Primary key — NOT NULL
  • Field (video_title) — NOT NULL
  • Field (video_path) — NOT NULL
  • Field (thumbnail_path)
  • Key (contents_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (Section)

  • Key (section_id) — Primary key — NOT NULL
  • Field (section_title) — NOT NULL
  • Key (contents_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (SubSection)

  • Key (sub_section_id) — Primary key — NOT NULL
  • Field (sub_section_title) — NOT NULL
  • Key (section_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (Inquiry)

  • Key (inquiry_id) — Primary key — NOT NULL
  • Field (title)
  • Field (content)
  • Key (contents_id) — Foreign key → Untitled.Key — NOT NULL

Untitled (Comment)

  • Key (comment_id) — Primary key — NOT NULL
  • Key (inquiry_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (contnet) — NOT NULL

countTable (CountView)

  • Key (contents_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (view_count)
  • Field (report_count)
  • Field (reply_count)
  • Field2 (like_count)
  • Field3 (share_count)