youtube

Tables (4)

SUBSCRIPTION (Untitled3)

  • SUBSCRIPTION_ID (Key) — BIGINT — Primary key — NOT NULL
  • USER_ID (PK) — BIGINT — Foreign key → user.USER_ID — NOT NULL

VIDEO (Untitled2)

  • VIDEO_ID (Key) — BIGINT — Primary key — NOT NULL
  • CATEGORY_ID (Key2) — BIGINT — Foreign key → category.CATEGORY_ID — NOT NULL
  • USER_ID (PK) — BIGINT — Foreign key → user.USER_ID — NOT NULL
  • TITLE (Field) — VARCHAR — NOT NULL
  • CONTENT (Field2) — VARCHAR

category (Untitled)

  • CATEGORY_ID (Key) — BIGINT — Primary key — NOT NULL
  • NAME (Field) — VARCHAR — NOT NULL — UNIQUE

user (사용자)

  • USER_ID (PK) — BIGINT — Primary key — NOT NULL
  • EMAIL (Field) — VARCHAR — NOT NULL — UNIQUE
  • PASSWORD (Field2) — VARCHAR — NOT NULL — UNIQUE
  • NICKNAME (Field3) — VARCHAR — NOT NULL — UNIQUE
  • PHONE_NUMBER (Field4) — VARCHAR — NOT NULL — UNIQUE