PPND

Tables (3)

Board (Untitled2)

  • BoardID (boardId) — PK — Primary key — NOT NULL
  • Writer (id) — FK — Foreign key → User.ID — NOT NULL
  • ReWriter (writer) — FK
  • Title (title)
  • Date (date)
  • ReDate (reDate)
  • Content (content)
  • Available (available)

BoardFile (Untitled3)

  • BoardID (boardId) — FK — Foreign key → Board.BoardID — NOT NULL
  • FileName (fileName)
  • FileRealName (fileRealName)
  • Available (available) — BOOLEAN

User (Untitled)

  • ID (id) — PK — Primary key — NOT NULL
  • Password (password)
  • Name (name)
  • PhoneNumber (phoneNumber)
  • Authority (authority)
  • JoinDate (joinDate)
  • EndDate (endDate)
  • Available (available)