youtube

Tables (5)

advertise (광고)

  • advertise_idx (Key) — int — Primary key — NOT NULL
  • advertise_name (Field) — varchar(200)
  • advertise_count (Field2) — int

category (카테고리)

  • category_idx (Key) — int — Primary key — NOT NULL
  • category_name (Field) — varchar(100)
  • category_detail (Field2) — varchar(40)

comment (댓글)

  • comment_idx (Key) — int — Primary key — NOT NULL
  • video_idx (Key2) — int — Foreign key → video.video_idx — NOT NULL
  • comment_author (Field) — int
  • comment_content (Field2) — varchar(200)
  • comment_createdAt (Field3) — datetime
  • user_idx (Key3) — int — Foreign key → user.user_idx — NOT NULL
  • comment_updatedAt (Field4) — datetime

user (사용자)

  • user_idx (Key) — int — Primary key — NOT NULL
  • user_id (Field) — varchar(20)
  • user_password (Field2) — varchar(20
  • user_createdAt (Field3) — datetime

video (비디오)

  • video_idx (Key) — int — Primary key — NOT NULL
  • video_url (Field) — varchar(200)
  • category_idx (Key2) — int — Foreign key → category.category_idx — NOT NULL
  • video_title (Field2) — varchar(200)
  • video_detail (Field3) — varchar(200)
  • user_idx (Key3) — int — Foreign key → user.user_idx — NOT NULL
  • video_createdAt (Field4) — datetime
  • Field5