ERD

Tables (5)

Untitled (USER)

  • Key (userID) — Primary key — NOT NULL
  • Field (userPW)
  • Field2 (userName)
  • Field3 (userNickName)
  • Field (userEmail)

Untitled (BOARD)

  • Key (Board ID) — Primary key — NOT NULL
  • Key (userID) — Foreign key → Untitled.Key — NOT NULL
  • Key (Video ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (Board Title)
  • Field (Contents)
  • Field (Write Time)

Untitled (RANK)

  • Key (Rank) — Primary key — NOT NULL
  • Key (userID) — Foreign key → Untitled.Key — NOT NULL
  • Field (Go Score)
  • Field (Omok Score)

Untitled (Game Room)

  • Key (Game ID) — Primary key — NOT NULL
  • Key (userID) — Foreign key → Untitled.Key — NOT NULL
  • Field (Room Title)
  • Field (Owner)

Untitled (Education Video)

  • Key (Video ID) — Primary key — NOT NULL
  • Field (Comments)