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