Rsupport-assignent

Tables (5)

Board (board)

  • Board ID (boardID) — Number — Primary key — NOT NULL
  • Title (title) — VARCHAR(255)
  • Content (content) — TEXT

File (file)

  • File ID (fileID) — Number — Primary key — NOT NULL
  • Path (path) — VARCHAR(255)
  • Orginal File Name (originalName) — VARCHAR(255)
  • UUID — VARCHAR(255)

Member (member)

  • Member ID (memeberID) — VARCHAR(255) — Primary key — NOT NULL
  • Password (password) — VARCHAR(255)
  • Nickname (nickname) — VARCHAR(255)

Save (save)

  • Save ID (saveID) — Number — Primary key — NOT NULL
  • Board ID (boardID) — Number — Foreign key → Board.Board ID — NOT NULL
  • File ID (fileID) — Number — Foreign key → File.File ID — NOT NULL

Write (write)

  • Write ID (writeID) — Number — Primary key — NOT NULL
  • Member ID (memeberID) — VARCHAR(255) — Foreign key → Member.Member ID — NOT NULL
  • Board ID (boardID) — Number — Foreign key → Board.Board ID — NOT NULL
  • Created Date (createdDate) — TIMESTAMP
  • Updated Date (updatedDate) — TIMESTAMP