유튜브

테이블 (3)

Channels (Untitled)

  • Channel_ID (Key) — VARCHAR — 기본 키 — NOT NULL
  • Channel_Title (Field) — VARCHAR
  • Subscribers (Field2) — INTEGER
  • Video_Count (Field3) — INTEGER
  • Channel_View_Count (Field4) — INTEGER

Comments (Untitled3)

  • Comment_ID (Key3) — VARCHAR — 기본 키 — NOT NULL
  • Video_ID (Key) — VARCHAR — 외래 키 → Videos.Video_ID — NOT NULL
  • Is_Channel_Author (Field) — BOOLEAN
  • Comment_Like_Count (Field2) — INTEGER
  • Comment_Published_At (Field3) — DATE
  • Text (Field4) — VARCHAR

Videos (Untitled2)

  • Video_ID (Key) — VARCHAR — 기본 키 — NOT NULL
  • Channel_ID (Key2) — VARCHAR — 외래 키 → Channels.Channel_ID — NOT NULL
  • Title (Field) — VARCHAR
  • View_Count (Field2) — INTEGER
  • Upload_Date (Field3) — DATE
  • Is_Short (Field4) — BOOLEAN